Skip to content

Instantly share code, notes, and snippets.

@mrdwab

mrdwab/SO61605707.r

Last active May 8, 2020 05:48
Show Gist options
  • Save mrdwab/6fbf5a3ff75c38b793109a6f6ba63a9a to your computer and use it in GitHub Desktop.
Save mrdwab/6fbf5a3ff75c38b793109a6f6ba63a9a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SO61605707.r
library(pdftools)
library(tidyverse)
library(SOfun) # https://github.com/mrdwab/SOfun
data.loc = "https://ww2.amstat.org/misc/StatsPhD2003-MostRecent.pdf"
data.full =
pdf_text(data.loc) %>%
read_lines() %>%
head(-2) %>%
tail(-4)
data.full <- data.full[nzchar(data.full)]
l <- split(data.full, nchar(data.full))
out =
bind_rows(lapply(l, function(x) {
a <- tempfile()
writeLines(x, a)
fwf2csv(a, TRUE, header = FALSE, stringsAsFactors = FALSE, strip.white = TRUE)
})) %>%
arrange(V1)
out
## V1 V2 V3 V4 V5 V6 V7 V8 V9 V10 V11 V12 V13 V14 V15 V16 V17 V18 V19
## 1 1 North Carolina State University at Raleigh 15 9 12 13 22 15 32 19 14 20 12 17 19 20 19 25 283
## 2 2 Iowa State University 9 8 5 11 14 4 11 13 14 9 15 28 14 9 18 27 209
## 3 3 University of Wisconsin‐Madison 5 6 14 9 20 13 15 12 13 9 13 10 13 24 15 17 208
## 4 4 Stanford University* 10 12 14 6 9 10 5 9 13 7 13 10 4 9 23 6 160
## 5 5 Texas A & M University‐College Station 6 12 18 10 7 4 5 11 16 18 10 7 15 4 8 8 159
## 6 6 Pennsylvania State University 6 9 8 1 8 9 10 10 14 9 12 9 17 14 6 9 151
## 7 7 Ohio State University‐Main Campus 3 5 3 12 12 7 11 11 6 11 8 13 14 12 6 12 146
## 8 8 Purdue University‐Main Campus 6 5 12 8 8 7 10 12 9 9 5 10 14 8 9 13 145
## 9 9 University of Michigan‐Ann Arbor 8 5 3 3 8 9 12 11 7 11 13 9 8 11 13 9 140
## 10 10 University of California‐Los Angeles 2 2 2 6 9 7 9 8 7 11 11 8 6 12 13 10 123
## 11 11 University of North Carolina at Chapel Hill 5 5 3 6 1 12 4 5 8 14 9 8 10 14 11 8 123
## 12 12 Duke University 7 1 3 7 5 7 9 5 8 4 9 12 9 8 12 14 120
## 13 13 University of California‐Berkeley 5 5 8 7 7 5 11 6 10 4 13 7 6 5 7 7 113
## 14 14 Carnegie Mellon University 6 8 3 12 6 1 5 6 8 10 7 10 12 8 2 9 113
## 15 15 Florida State University 3 4 3 3 6 7 5 5 13 7 3 8 7 9 9 18 110
## 16 16 University of Minnesota‐Twin Cities 7 3 7 8 8 9 8 2 8 5 9 10 9 5 8 3 109
## 17 17 Virginia Polytechnic Institute 5 2 7 8 7 5 5 5 7 5 7 6 13 10 7 6 105
## 18 18 University of Florida 1 4 5 9 7 11 4 5 3 11 7 6 5 7 10 8 103
## 19 19 Rice University 3 3 5 11 4 7 7 11 2 6 4 6 3 8 7 7 94
## 20 20 Columbia University B55 3 4 6 9 3 3 4 5 9 2 9 8 5 6 7 11 94
## 21 21 Harvard University 4 5 3 4 2 2 8 4 6 7 8 7 9 8 6 11 94
## 22 22 University of Chicago 2 7 4 6 4 5 9 4 4 7 10 2 8 7 5 10 94
## 23 23 University of California‐Davis 4 3 10 4 8 4 8 3 3 6 5 5 8 3 8 11 93
## 24 24 University of Georgia 0 4 6 6 2 4 10 6 3 0 8 9 12 9 7 7 93
## 25 25 University of Connecticut 2 3 5 2 8 5 3 5 5 5 10 9 3 7 7 10 89
## 26 26 University of Pennsylvania 3 5 4 3 4 3 6 9 3 8 5 10 5 6 10 3 87
## 27 27 University of Missouri‐Columbia 2 4 5 5 6 3 6 8 3 2 12 8 7 6 4 6 87
## 28 28 University of Washington 4 3 1 4 5 5 9 7 7 5 5 6 6 6 8 5 86
## 29 29 Rutgers University‐New Brunswick 2 3 6 3 4 5 6 7 4 3 7 7 6 5 4 8 80
## 30 30 University of California‐Riverside 1 1 5 2 6 5 7 0 10 12 7 3 3 5 3 9 79
## 31 31 Baylor University 3 5 1 3 6 2 7 5 7 2 6 5 4 5 7 7 75
## 32 32 Southern Methodist University 2 6 7 1 4 3 5 3 3 3 6 6 6 5 8 3 71
## 33 33 Michigan State University 6 1 3 6 5 1 2 3 6 7 2 4 3 8 6 8 71
## 34 34 University of Illinois at Urbana‐Champaign 2 1 3 5 6 1 2 3 8 5 2 6 5 2 7 12 70
## 35 35 University of South Carolina‐Columbia 2 3 3 2 4 7 5 3 1 5 7 4 4 5 8 5 68
## 36 36 University of California‐Santa Barbara 4 2 2 6 3 4 5 2 5 2 6 2 7 7 2 9 68
## 37 37 University of Kentucky 0 5 6 4 4 5 2 5 2 3 1 3 4 6 10 6 66
## 38 38 University of Maryland‐College Park 0 0 5 3 1 7 4 4 6 4 10 2 8 2 3 5 64
## 39 39 Cornell University 3 5 4 2 6 0 3 3 4 4 7 3 6 5 6 2 63
## 40 40 Colorado State University‐Fort Collins 4 4 2 3 4 4 7 4 1 2 4 5 2 11 3 2 62
## 41 41 University of Maryland‐Baltimore County 3 0 5 6 2 2 2 2 4 1 6 5 5 7 4 5 59
## 42 42 University of Pittsburgh 2 4 5 2 4 3 5 2 7 5 3 2 4 5 2 4 59
## 43 43 Temple University 0 0 0 0 0 8 3 2 7 5 5 2 5 11 3 7 58
## 44 44 Western Michigan University 6 5 1 2 1 2 6 3 3 3 2 2 2 6 4 6 54
## 45 45 George Washington University 2 2 1 3 0 4 1 3 1 7 0 6 0 5 8 9 52
## 46 46 Kansas State University 2 5 2 4 1 3 2 5 2 5 3 4 5 1 0 7 51
## 47 47 University of Rochester 4 0 0 2 2 2 3 3 3 4 1 5 4 4 4 4 45
## 48 48 University of Iowa 4 2 1 0 7 5 3 4 1 6 2 1 3 1 4 1 45
## 49 49 The University of Texas at Dallas 0 2 0 3 4 1 0 3 4 2 4 1 4 5 6 3 42
## 50 50 University of Nebraska‐Lincoln 0 0 1 2 0 3 1 6 3 1 3 5 3 5 5 4 42
## 51 51 Yale University 4 5 1 1 2 1 4 1 3 3 3 2 4 2 1 4 41
## 52 52 Bowling Green State University 0 0 0 0 0 1 5 2 2 2 4 7 3 4 4 3 37
## [ reached 'max' / getOption("max.print") -- omitted 26 rows ]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment