Análisis exploratorio de datos del padrón de instituciones educativas públicas interculturales.
library(dplyr)
##
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
library(ggplot2)
setwd("C:/Users/sant_/OneDrive - Universidad Adolfo Ibanez/Research/5 tics_intercultural")
base <- read.csv('ece_2016.csv', sep=";")
setwd("C:/Users/sant_/OneDrive - Universidad Adolfo Ibanez/Research/5 tics_intercultural")
padron_eib <- read.csv('padron_bilingues.csv', sep=";")
padron_eib <- mutate(padron_eib, interc=1)
Análisis por lengua de origen
eib_lengua = padron_eib %>%
group_by(Nivel.Ciclo, Lengua.originaria) %>%
summarise(Number = n())
eib_lengua_ini_jar = filter(eib_lengua, Nivel.Ciclo=="Inicial - Jardín")
eib_lengua_ini_cunjar = filter(eib_lengua, Nivel.Ciclo=="Inicial - Cuna-Jardín")
eib_lengua_pri = filter(eib_lengua, Nivel.Ciclo=="Primaria")
eib_lengua_sec = filter(eib_lengua, Nivel.Ciclo=="Secundaria")
library(ggplot2)
#Inicial jardin
ggplot(data=eib_lengua_ini_jar,aes(x=reorder(Lengua.originaria, Number),y=Number)) +
geom_bar(stat="identity",position=position_dodge()) + coord_flip()+theme_bw() +
ggtitle("Inicial Jardín: Nro. de escuelas interculturales por lengua de origen") + theme(plot.title = element_text(size = 9, face="bold", hjust=0.5))+
ylab("Nro. de escuelas") + theme(axis.title = element_text(size = 10),axis.text = element_text(size = 7, color="black"),axis.title.y = element_blank())+
theme(panel.grid.minor.y = element_blank(),panel.grid.major.y = element_blank())+
theme(legend.text = element_text(size=12),legend.title = element_blank(),legend.position = c(0.9,0.1))

#Inicial cuna jardin
ggplot(data=eib_lengua_ini_cunjar,aes(x=reorder(Lengua.originaria, Number),y=Number)) +
geom_bar(stat="identity",position=position_dodge()) + coord_flip()+theme_bw() +
ggtitle("Inicial Cuna Jardín: Nro. de escuelas interculturales por lengua de origen") + theme(plot.title = element_text(size = 9, face="bold", hjust=0.5))+
ylab("Nro. de escuelas") + theme(axis.title = element_text(size = 10),axis.text = element_text(size = 7, color="black"),axis.title.y = element_blank())+
theme(panel.grid.minor.y = element_blank(),panel.grid.major.y = element_blank())+
theme(legend.text = element_text(size=12),legend.title = element_blank(),legend.position = c(0.9,0.1))

#Primaria
ggplot(data=eib_lengua_pri,aes(x=reorder(Lengua.originaria, Number),y=Number)) +
geom_bar(stat="identity",position=position_dodge()) + coord_flip()+theme_bw() +
ggtitle("Primaria: Nro. de escuelas interculturales por lengua de origen") + theme(plot.title = element_text(size = 9, face="bold", hjust=0.5))+
ylab("Nro. de escuelas") + theme(axis.title = element_text(size = 10),axis.text = element_text(size = 7, color="black"),axis.title.y = element_blank())+
theme(panel.grid.minor.y = element_blank(),panel.grid.major.y = element_blank())+
theme(legend.text = element_text(size=12),legend.title = element_blank(),legend.position = c(0.9,0.1))

#Secundaria
ggplot(data=eib_lengua_sec,aes(x=reorder(Lengua.originaria, Number),y=Number)) +
geom_bar(stat="identity",position=position_dodge()) + coord_flip()+theme_bw() +
ggtitle("Secundaria: Nro. de escuelas interculturales por lengua de origen") + theme(plot.title = element_text(size = 9, face="bold", hjust=0.5))+
ylab("Nro. de escuelas") + theme(axis.title = element_text(size = 10),axis.text = element_text(size = 7, color="black"),axis.title.y = element_blank())+
theme(panel.grid.minor.y = element_blank(),panel.grid.major.y = element_blank())+
theme(legend.text = element_text(size=12),legend.title = element_blank(),legend.position = c(0.9,0.1))

Análisis por región
eib_region = padron_eib %>%
group_by(Nivel.Ciclo, Region) %>%
summarise(Number = n())
eib_region_ini_jar = filter(eib_region, Nivel.Ciclo=="Inicial - Jardín")
eib_region_ini_cunjar = filter(eib_region, Nivel.Ciclo=="Inicial - Cuna-Jardín")
eib_region_pri = filter(eib_region, Nivel.Ciclo=="Primaria")
eib_region_sec = filter(eib_region, Nivel.Ciclo=="Secundaria")
library(ggplot2)
#Inicial jardín
ggplot(data=eib_region_ini_jar,aes(x=reorder(Region, Number),y=Number)) +
geom_bar(stat="identity",position=position_dodge()) + coord_flip()+theme_bw() +
ggtitle("Inicial Jardín: Nro. de escuelas interculturales por región") + theme(plot.title = element_text(size = 9, face="bold", hjust=0.5))+
ylab("Nro. de escuelas") + theme(axis.title = element_text(size = 10),axis.text = element_text(size = 7, color="black"),axis.title.y = element_blank())+
theme(panel.grid.minor.y = element_blank(),panel.grid.major.y = element_blank())+
theme(legend.text = element_text(size=12),legend.title = element_blank(),legend.position = c(0.9,0.1))

#Inicial cuna jardín
ggplot(data=eib_region_ini_cunjar,aes(x=reorder(Region, Number),y=Number)) +
geom_bar(stat="identity",position=position_dodge()) + coord_flip()+theme_bw() +
ggtitle("Inicial Cuna Jardín: Nro. de escuelas interculturales por región") + theme(plot.title = element_text(size = 9, face="bold", hjust=0.5))+
ylab("Nro. de escuelas") + theme(axis.title = element_text(size = 10),axis.text = element_text(size = 7, color="black"),axis.title.y = element_blank())+
theme(panel.grid.minor.y = element_blank(),panel.grid.major.y = element_blank())+
theme(legend.text = element_text(size=12),legend.title = element_blank(),legend.position = c(0.9,0.1))

#Primaria
ggplot(data=eib_region_pri,aes(x=reorder(Region, Number),y=Number)) +
geom_bar(stat="identity",position=position_dodge()) + coord_flip()+theme_bw() +
ggtitle("Primaria: Nro. de escuelas interculturales por región") + theme(plot.title = element_text(size = 9, face="bold", hjust=0.5))+
ylab("Nro. de escuelas") + theme(axis.title = element_text(size = 10),axis.text = element_text(size = 7, color="black"),axis.title.y = element_blank())+
theme(panel.grid.minor.y = element_blank(),panel.grid.major.y = element_blank())+
theme(legend.text = element_text(size=12),legend.title = element_blank(),legend.position = c(0.9,0.1))

#Secundaria
ggplot(data=eib_region_sec,aes(x=reorder(Region, Number),y=Number)) +
geom_bar(stat="identity",position=position_dodge()) + coord_flip()+theme_bw() +
ggtitle("Secundaria: Nro. de escuelas interculturales por región") + theme(plot.title = element_text(size = 9, face="bold", hjust=0.5))+
ylab("Nro. de escuelas") + theme(axis.title = element_text(size = 10),axis.text = element_text(size = 7, color="black"),axis.title.y = element_blank())+
theme(panel.grid.minor.y = element_blank(),panel.grid.major.y = element_blank())+
theme(legend.text = element_text(size=12),legend.title = element_blank(),legend.position = c(0.9,0.1))
