mrdwab/SO61605707.r

## 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 ]
	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 ]