QS RANKINGS PROJECT
SUMMARY
summary(qsrankings)
## university year rank_display
## University of Dundee : 6 Min. :2017 801-1000: 954
## Western Sydney University : 6 1st Qu.:2018 651-700 : 308
## École Normale Supérieure de Lyon: 6 Median :2020 601-650 : 298
## Aalborg University : 6 Mean :2020 701-750 : 251
## Aalto University : 6 3rd Qu.:2021 1001 : 241
## Aarhus University : 6 Max. :2022 751-800 : 241
## (Other) :6446 (Other) :4189
## score
## Min. : 23.50
## 1st Qu.: 31.80
## Median : 40.60
## Mean : 46.60
## 3rd Qu.: 58.02
## Max. :100.00
## NA's :3662
## link
## https://www.topuniversities.com/universities/aalborg-university : 6
## https://www.topuniversities.com/universities/aalto-university : 6
## https://www.topuniversities.com/universities/aarhus-university : 6
## https://www.topuniversities.com/universities/abai-kazakh-national-pedagogical-university: 6
## https://www.topuniversities.com/universities/aberystwyth-university : 6
## https://www.topuniversities.com/universities/abo-akademi-university : 6
## (Other) :6446
## country city region
## United States : 968 : 178 Africa : 122
## United Kingdom : 497 London : 98 Asia :1834
## Germany : 278 Seoul : 87 Europe :2479
## China (Mainland): 263 Beijing: 68 Latin America: 653
## Japan : 262 Tokyo : 64 North America:1126
## France : 238 Moscow : 59 Oceania : 268
## (Other) :3976 (Other):5928
## logo
## https://www.topuniversities.com/sites/default/files/-university-of-dundee_592560cf2aeae70239af4b2c_small.jpg : 6
## https://www.topuniversities.com/sites/default/files/aalborg-university_1262_small.jpg : 6
## https://www.topuniversities.com/sites/default/files/aalto-university_261_small.jpg : 6
## https://www.topuniversities.com/sites/default/files/aarhus-university_592560cf2aeae70239af4a8a_small.jpg : 6
## https://www.topuniversities.com/sites/default/files/abai-kazakh-national-pedagogical-university_592560cf2aeae70239af55d7_small.jpg: 6
## https://www.topuniversities.com/sites/default/files/aberystwyth-university_8_small.jpg : 6
## (Other) :6446
## type research_output student_faculty_ratio international_students
## : 12 : 2 Min. : 1.00 Min. : 1.0
## Private:1186 High :1424 1st Qu.: 9.00 1st Qu.: 282.0
## Public :5284 Low : 46 Median :12.00 Median : 584.0
## Medium : 424 Mean :13.26 Mean : 584.2
## Very high: 28 3rd Qu.:17.00 3rd Qu.: 880.8
## Very High:4558 Max. :67.00 Max. :1183.0
## NA's :75
## size faculty_count
## : 2 Min. : 1.0
## L :3062 1st Qu.: 303.0
## M :1392 Median : 597.0
## S : 395 Mean : 597.9
## XL:1631 3rd Qu.: 898.0
## Max. :1177.0
##
STRUCTURE
str(qsrankings)
## 'data.frame': 6482 obs. of 15 variables:
## $ university : Factor w/ 1368 levels " Don State Technical University",..: 422 652 251 1077 114 1204 766 209 273 1085 ...
## $ year : int 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 ...
## $ rank_display : Factor w/ 518 levels "","1","10","100",..: 2 116 227 338 445 469 482 496 508 3 ...
## $ score : num 100 98.7 98.3 97.2 96.9 96.8 95.6 94.2 94.1 93 ...
## $ link : Factor w/ 1366 levels "https://www.topuniversities.com/universities/aalborg-university",..: 431 664 253 1049 109 1193 737 210 280 1057 ...
## $ country : Factor w/ 97 levels "Argentina","Armenia",..: 94 94 94 93 94 93 93 84 93 94 ...
## $ city : Factor w/ 867 levels "","A Coruña",..: 134 732 134 134 588 571 445 860 445 159 ...
## $ region : Factor w/ 6 levels "Africa","Asia",..: 5 5 5 3 5 3 3 3 3 5 ...
## $ logo : Factor w/ 1378 levels "https://www.topuniversities.com/sites/default/files/-don-state-technical-university_592560cf2aeae70239af5995_small.jpg",..: 443 667 266 1084 127 1207 776 223 288 1090 ...
## $ type : Factor w/ 3 levels "","Private","Public": 2 2 2 3 2 3 3 3 3 2 ...
## $ research_output : Factor w/ 6 levels "","High","Low",..: 6 6 6 5 6 6 6 6 6 6 ...
## $ student_faculty_ratio : int 4 3 5 4 2 3 5 7 5 6 ...
## $ international_students: num 578 586 857 1019 999 ...
## $ size : Factor w/ 5 levels "","L","M","S",..: 3 2 2 2 4 2 5 2 2 2 ...
## $ faculty_count : num 668 833 829 902 1163 ...
Top 5 count
head(qsrankings, 5)
## university year rank_display score
## 1 Massachusetts Institute of Technology (MIT) 2017 1 100.0
## 2 Stanford University 2017 2 98.7
## 3 Harvard University 2017 3 98.3
## 4 University of Cambridge 2017 4 97.2
## 5 California Institute of Technology (Caltech) 2017 5 96.9
## link
## 1 https://www.topuniversities.com/universities/massachusetts-institute-technology-mit
## 2 https://www.topuniversities.com/universities/stanford-university
## 3 https://www.topuniversities.com/universities/harvard-university
## 4 https://www.topuniversities.com/universities/university-cambridge
## 5 https://www.topuniversities.com/universities/california-institute-technology-caltech
## country city region
## 1 United States Cambridge North America
## 2 United States Stanford North America
## 3 United States Cambridge North America
## 4 United Kingdom Cambridge Europe
## 5 United States Pasadena North America
## logo
## 1 https://www.topuniversities.com/sites/default/files/massachusetts-institute-of-technology-mit_410_small.jpg
## 2 https://www.topuniversities.com/sites/default/files/stanford-university_573_small.jpg
## 3 https://www.topuniversities.com/sites/default/files/harvard-university_253_small.jpg
## 4 https://www.topuniversities.com/sites/default/files/university-of-cambridge_95_small.jpg
## 5 https://www.topuniversities.com/sites/default/files/california-institute-of-technology-caltech_94_small.jpg
## type research_output student_faculty_ratio international_students size
## 1 Private Very High 4 578 M
## 2 Private Very High 3 586 L
## 3 Private Very High 5 857 L
## 4 Public Very high 4 1019 L
## 5 Private Very High 2 999 S
## faculty_count
## 1 668
## 2 833
## 3 829
## 4 902
## 5 1163
Bottom 5 count
tail(qsrankings, 5)
## university year rank_display score
## 6478 Université de Tunis 2022 1201 NA
## 6479 Université de Tunis El Manar 2022 1201 NA
## 6480 Yarmouk University 2022 1201 NA
## 6481 Yildiz Technical University 2022 1201 NA
## 6482 Zagazig University 2022 1201 NA
## link
## 6478 https://www.topuniversities.com/universities/universite-de-tunis
## 6479 https://www.topuniversities.com/universities/universite-de-tunis-el-manar
## 6480 https://www.topuniversities.com/universities/yarmouk-university
## 6481 https://www.topuniversities.com/universities/yildiz-technical-university
## 6482 https://www.topuniversities.com/universities/zagazig-university
## country city region
## 6478 Tunisia Tunis Africa
## 6479 Tunisia Tunis Africa
## 6480 Jordan Irbid Asia
## 6481 Turkey Istanbul Asia
## 6482 Egypt Zagazig Africa
## logo
## 6478 https://www.topuniversities.com/sites/default/files/universit-de-tunis_592560cf2aeae70239af5470_small.jpg
## 6479 https://www.topuniversities.com/sites/default/files/universit-de-tunis-el-manar_592560cf2aeae70239af5472_small.jpg
## 6480 https://www.topuniversities.com/sites/default/files/yarmouk-university_592560cf2aeae70239af4e72_small.jpg
## 6481 https://www.topuniversities.com/sites/default/files/yildiz-technical-university_592560cf2aeae70239af5aa4_small.jpg
## 6482 https://www.topuniversities.com/sites/default/files/zagazig-university_592560cf2aeae70239af4f43_small.jpg
## type research_output student_faculty_ratio international_students size
## 6478 Public High 17 910 L
## 6479 Public Very High 8 916 L
## 6480 Public Medium 31 388 XL
## 6481 Public High 20 358 XL
## 6482 Public High 26 352 XL
## faculty_count
## 6478 49
## 6479 696
## 6480 32
## 6481 159
## 6482 903
Region plot
ggplot(qsrankings, aes(x= region, fill= "red"))+ geom_bar()
Region vs research output
ggplot(qsrankings, aes(x= region, fill=research_output))+ geom_bar()
Region vs type
Region vs size
Intr students vs faculty count
Year vs Research O/p
ggplot(qsrankings, aes(x= size, fill= type))+ geom_bar()
Size vs Research o/p
Research o/p vs intnl students
ggplot(qsrankings, aes(x= research_output, y= international_students, fill= type))+ geom_boxplot()
Year vs intnl students
ggplot(qsrankings, aes(x= year, y= (international_students)))+ geom_line()
