Chilean Universities Ranking September 2020
This project remains active, however, it was transferred to the Training Data Lab site in June 2023.
Precoding
## Packages
library(kableExtra)
library(tidyverse)
## Data
data <- read.csv("https://osf.io/mv9z8/download", fileEncoding = "UTF-8")
## Institutions Codification
usach <- subset(data, Affiliation == "USACH" | Affiliation == "OXF-USACH")
puc <- subset(data, Affiliation == "PUC" | Affiliation == "PUC-VDEM")
ua <- subset(data, Affiliation == "UA")
uach <-subset(data, Affiliation == "UACH")
uah <- subset(data, Affiliation == "UAH" | Affiliation == "UCHILE-UAH")
uai <- subset(data, Affiliation == "UAI")
uchile <- subset(data, Affiliation == "UCHILE" | Affiliation == "UCHILE-UAH")
uct <- subset(data, Affiliation == "UCT")
udd <- subset(data, Affiliation == "UDD")
udec <- subset(data, Affiliation == "UDEC")
udp <- subset(data, Affiliation == "UDP" | Affiliation == "UDP-COES" |
Affiliation == "UDP-NYU" | Affiliation == "UDP-Leiden")
ulagos <- subset(data, Affiliation == "ULAGOS")
umayor <- subset(data, Affiliation == "UMAYOR")
unab <- subset(data, Affiliation == "UNAB")
utalca <- subset(data, Affiliation == "UTALCA")
utem <- subset(data, Affiliation == "UTEM")
uvalpo <- subset(data, Affiliation == "UVALPO")
## Dataframe Construction
Name <- c("USACH", "PUC", "UA", "UACH", "UAI", "UCHILE", "UCT", "UDD",
"UDEC", "UDP", "ULAGOS", "UMAYOR", "UNAB", "UTALCA", "UTEM",
"UVALPO")
Cases <- c(nrow(usach), nrow(puc), nrow(ua), nrow(uach), nrow(uai),
nrow(uchile), nrow(uct), nrow(udd), nrow(udec), nrow(udp),
nrow(ulagos), nrow(umayor), nrow(unab), nrow(utalca), nrow(utem),
nrow(uvalpo))
Avg_Cites <- c(mean(usach$Cites), mean(puc$Cites), mean(ua$Cites), mean(uach$Cites),
mean(uai$Cites), mean(uchile$Cites), mean(uct$Cites), mean(udd$Cites),
mean(udec$Cites), mean(udp$Cites), mean(ulagos$Cites), mean(umayor$Cites),
mean(unab$Cites), mean(utalca$Cites), mean(utem$Cites),mean(uvalpo$Cites))
Cum_Cites <- c(sum(usach$Cites), sum(puc$Cites), sum(ua$Cites), sum(uach$Cites),
sum(uai$Cites), sum(uchile$Cites), sum(uct$Cites), sum(udd$Cites),
sum(udec$Cites), sum(udp$Cites), sum(ulagos$Cites), sum(umayor$Cites),
sum(unab$Cites), sum(utalca$Cites), sum(utem$Cites), sum(uvalpo$Cites))
Avg_H_Index <- c(mean(usach$H_Index), mean(puc$H_Index), mean(ua$H_Index),
mean(uach$H_Index), mean(uai$H_Index), mean(uchile$H_Index),
mean(uct$H_Index), mean(udd$H_Index), mean(udec$H_Index),
mean(udp$H_Index), mean(ulagos$H_Index), mean(umayor$H_Index),
mean(unab$H_Index), mean(utalca$H_Index), mean(utem$H_Index),
mean(uvalpo$H_Index))
Cum_H_Index <- c(sum(usach$H_Index), sum(puc$H_Index), sum(ua$H_Index),
sum(uach$H_Index), sum(uai$H_Index), sum(uchile$H_Index), sum(uct$H_Index),
sum(udd$H_Index), sum(udec$H_Index), sum(udp$H_Index), sum(ulagos$H_Index),
sum(umayor$H_Index), sum(unab$H_Index), sum(utalca$H_Index),
sum(utem$H_Index), sum(uvalpo$H_Index))
Inv_Avg_Index <- Avg_H_Index*-1
Inv_Cum_Index <- Cum_H_Index*-1Cumulative Ranking
Inst_Cum <- data.frame(Name, Cases, Cum_Cites, Cum_H_Index, Inv_Cum_Index)
Inst_Cum[is.na(Inst_Cum)] <- 0
Inst_Cum <- within(Inst_Cum, Quartile <- as.integer(cut(Inv_Cum_Index,
quantile(Inv_Cum_Index,
probs = 0:4/4),
include.lowest = TRUE)))
Inst_Cum$Inv_Cum_Index <- NULL
Inst_Cum <- Inst_Cum[order(-Inst_Cum$Cum_H_Index, -Inst_Cum$Cum_Cites), ]
Inst_Cum$Cum_Cites <- format(Inst_Cum$Cum_Cites, big.mark = ",")
rownames(Inst_Cum) <- NULL| Name | Cases | Cum_Cites | Cum_H_Index | Quartile |
|---|---|---|---|---|
| PUC | 26 | 16,505 | 235 | 1 |
| UCHILE | 21 | 11,098 | 208 | 1 |
| UDP | 17 | 15,996 | 184 | 1 |
| USACH | 13 | 7,771 | 112 | 1 |
| UDD | 7 | 1,389 | 43 | 2 |
| UDEC | 9 | 1,441 | 41 | 2 |
| UAI | 8 | 1,579 | 39 | 2 |
| UACH | 2 | 1,601 | 32 | 2 |
| UCT | 6 | 419 | 25 | 3 |
| UTALCA | 1 | 1,083 | 18 | 3 |
| UVALPO | 1 | 1,016 | 14 | 3 |
| UA | 3 | 131 | 8 | 3 |
| UNAB | 1 | 286 | 7 | 4 |
| ULAGOS | 2 | 182 | 7 | 4 |
| UMAYOR | 2 | 73 | 5 | 4 |
| UTEM | 1 | 78 | 4 | 4 |
| Note: | ||||
| Compiled using data from the CPS-Ranking. Data collected on September 5, 2020. |
Average Ranking
Inst_Avg <- data.frame(Name, Cases, Avg_Cites, Avg_H_Index, Inv_Avg_Index)
Inst_Avg[is.na(Inst_Avg)] <- 0
Inst_Avg <- within(Inst_Avg, Quartile <- as.integer(cut(Inv_Avg_Index,
quantile(Inv_Avg_Index,
probs = 0:4/4),
include.lowest = TRUE)))
Inst_Avg$Inv_Avg_Index <- NULL
Inst_Avg <- Inst_Avg[order(-Inst_Avg$Avg_H_Index, -Inst_Avg$Avg_Cites), ]
rownames(Inst_Avg) <- NULL
Avg_Cites <- format(round(Inst_Avg$Avg_Cites, 2), nsmall = 2, big.mark = ",")
Avg_H_Index <- format(round(Inst_Avg$Avg_H_Index, 2), nsmall = 2, big.mark = ",")
Quartile <- Inst_Avg$Quartile
Inst_Avg <- select(Inst_Avg, Name, Cases)
Inst_Avg <- data.frame(Inst_Avg, Avg_Cites, Avg_H_Index, Quartile)| Name | Cases | Avg_Cites | Avg_H_Index | Quartile |
|---|---|---|---|---|
| UTALCA | 1 | 1,083.00 | 18.00 | 1 |
| UACH | 2 | 800.50 | 16.00 | 1 |
| UVALPO | 1 | 1,016.00 | 14.00 | 1 |
| UDP | 17 | 940.94 | 10.82 | 1 |
| UCHILE | 21 | 528.48 | 9.90 | 2 |
| PUC | 26 | 634.81 | 9.04 | 2 |
| USACH | 13 | 597.77 | 8.62 | 2 |
| UNAB | 1 | 286.00 | 7.00 | 2 |
| UDD | 7 | 198.43 | 6.14 | 3 |
| UAI | 8 | 197.38 | 4.88 | 3 |
| UDEC | 9 | 160.11 | 4.56 | 3 |
| UCT | 6 | 69.83 | 4.17 | 3 |
| UTEM | 1 | 78.00 | 4.00 | 4 |
| ULAGOS | 2 | 91.00 | 3.50 | 4 |
| UA | 3 | 43.67 | 2.67 | 4 |
| UMAYOR | 2 | 36.50 | 2.50 | 4 |
| Note: | ||||
| Compiled using data from the CPS-Ranking. Data collected on September 5, 2020. |
Bastián González-Bustamante
Post-doctoral Researcher
Post-doctoral Researcher in Computational Social Science and a lecturer in Governance and Development at the Institute of Public Administration at the Faculty of Governance and Global Affairs at Leiden University, Netherlands. Lecturer at the School of Public Administration at Universidad Diego Portales and Research Associate in Training Data Lab, Chile.