Thursday, April 22, 2010

How I used R to create a new world university ranking

This website gives the 2010 world university ranking in the "Engineering and IT" category. I would like to see the ranking ordered by "Citations per Paper", as I felt that it tells more about the quality of the research in that university.

So I first copied the results from that website, save it to a txt file called "worldIT.txt". Then I used vim to add quotation marks around university and country names. Then I imported the file into R, and did the sorting as the following:

worldIT<-read.table("worldIT.txt")
worldIT.sorted<-worldIT[with(worldIT,order(worldIT$V5,decreasing=TRUE)),]
r<-c(1:100)
worldITnew<-cbind(r,worldIT.sorted)
worldITnew[,c("r","V2","V3","V5")]

This gives me the following ranking:
Rank                                                  Name  Country       Citations per Paper
1 Harvard University United States 4.8
2 California Institute of Technology (Caltech) United States 4.6
3 University of California, Berkeley United States 4.5
4 Princeton University United States 4.4
5 Massachusetts Institute of Technology (MIT) United States 4.2
6 Stanford University United States 4.2
7 University of California, Los Angeles (UCLA) United States 4.2
8 University of California, Santa Barbara United States 4.2
9 University of Pennsylvania United States 3.9
10 University of Washington United States 3.9
11 Cornell University United States 3.7
12 Yale University United States 3.7
13 Johns Hopkins University United States 3.6
14 ETH Zurich (Swiss Federal Institute of Technology) Switzerland 3.5
15 Columbia University United States 3.5
16 Brown University United States 3.5
17 University of Toronto Canada 3.4
18 University of Cambridge United Kingdom 3.3
19 University of Michigan United States 3.3
20 Carnegie Mellon University United States 3.1
21 ¨|cole Polytechnique F¨|d¨|rale de Lausanne Switzerland 3.1
22 University of Wisconsin-Madison United States 3.1
23 University of Oxford United Kingdom 3.0
24 University of California, San Diego United States 3.0
25 UCL (University College London) United Kingdom 3.0
26 Ecole Normale Sup¨|rieure, Paris France 3.0
27 Georgia Institute of Technology United States 2.9
28 National University of Singapore (NUS) Singapore 2.9
29 University of British Columbia Canada 2.9
30 University of Illinois, Urbana-Champaign United States 2.9
31 University of Texas at Austin United States 2.9
32 Pohang University of Science and Technology (POSTECH) Korea, South 2.9
33 Technical University of Denmark Denmark 2.9
34 Pennsylvania State University United States 2.9
35 University of Hong Kong Hong Kong 2.8
36 Rensselaer Polytechnic Institute United States 2.8
37 City University of Hong Kong Hong Kong 2.8
38 University of Bristol United Kingdom 2.8
39 Imperial College London United Kingdom 2.7
40 Hong Kong University of Science and Technology Hong Kong 2.7
41 Katholieke Universiteit Leuven Belgium 2.7
42 McMaster University Canada 2.7
43 University of Melbourne Australia 2.6
44 University of Manchester United Kingdom 2.6
45 Eindhoven University of Technology Netherlands 2.6
46 University of Birmingham United Kingdom 2.6
47 Purdue University United States 2.5
48 University of Alberta Canada 2.5
49 University of Queensland Australia 2.5
50 Technion - Israel Institute of Technology Israel 2.4
51 ¨|cole Polytechnique France 2.4
52 Australian National University Australia 2.4
53 Technische Universit?t M¨1nchen Germany 2.4
54 University of Southampton United Kingdom 2.4
55 McGill University Canada 2.3
56 University of Edinburgh United Kingdom 2.3
57 Chalmers University of Technology Sweden 2.3
58 Delft University of Technology Netherlands 2.2
59 Seoul National University Korea, South 2.2
60 Nanyang Technological University (NTU) Singapore 2.2
61 Virginia Polytechnic Institute (Virginia Tech) United States 2.2
62 The Chinese University of Hong Kong Hong Kong 2.2
63 KAIST - Korea Advanced Institute of Science & Technology Korea, South 2.1
64 University of Waterloo Canada 2.1
65 University of New South Wales Australia 2.1
66 National Taiwan University Taiwan 2.1
67 Monash University Australia 2.1
68 KTH, Royal Institute of Technology Sweden 2.1
69 Texas A&M University United States 2.1
70 Universit?t Stuttgart Germany 2.1
71 The Hong Kong Polytechnic University Hong Kong 2.1
72 University of Sydney Australia 2.0
73 Rheinisch-Westf?lische Technische Hochschule Aachen Germany 2.0
74 Tohoku University Japan 2.0
75 National Tsing Hua University Taiwan 2.0
76 University of Tokyo Japan 1.9
77 Kyoto University Japan 1.9
78 Indian Institute of Technology Bombay (IITB) India 1.9
79 Indian Institute of Technology Delhi (IITD) India 1.9
80 Indian Institute of Technology Kanpur (IITK) India 1.9
81 Technische Universit?t Berlin Germany 1.9
82 Universit?t Karlsruhe Germany 1.9
83 Helsinki University of Technology TKK Finland 1.9
84 Tokyo Institute of Technology Japan 1.8
85 Politecnico di Milano Italy 1.8
86 Vienna University of Technology Austria 1.8
87 Chulalongkorn University Thailand 1.8
88 Osaka University Japan 1.7
89 The University of Auckland New Zealand 1.7
90 Indian Institute of Technology Madras (IITM) India 1.7
91 Indian Institute of Technology Kharagpur (IITKGP) India 1.7
92 Fudan University China 1.7
93 University of Calgary Canada 1.7
94 Peking University China 1.6
95 University of Science and Technology of China China 1.6
96 Nagoya University Japan 1.6
97 RMIT University Australia 1.4
98 Tsinghua University China 1.2
99 Shanghai Jiao Tong University China 1.1
100 Bandung Institute of Technology (ITB) Indonesia 0.6

No comments:

Visitors