Home

Structure

'data.frame':   36 obs. of  20 variables:
 $ Sl..No.                          : chr  "1" "2" "3" "4" ...
 $ STATE.U.T.                       : chr  "Andaman  Nicobar Islands" "Andhra Pradesh" "Arunachal Pradesh" "Assam" ...
 $ Enrolment.in.Class.I...Boys      : int  2163 558085 23412 341859 1780830 642 288516 3077 1093 12336 ...
 $ Enrolment.in.Class.I...Girls     : int  2065 540228 21262 333590 1671065 618 277597 2784 1054 11042 ...
 $ Enrolment.in.Class.I...Total     : int  4228 1098313 44674 675449 3451895 1260 566113 5861 2147 23378 ...
 $ Enrolment.in.Class.II...Boys     : int  2085 480903 18174 282068 1599825 669 264440 3014 980 12767 ...
 $ Enrolment.in.Class.II...Girls    : int  1963 477268 16273 277551 1514570 596 251810 3009 921 11999 ...
 $ Enrolment.in.Class.II...Total    : int  4048 958171 34447 559619 3114395 1265 516250 6023 1901 24766 ...
 $ Enrolment.in.Class.III...Boys    : int  2091 471083 16131 254896 1547705 752 260472 3205 959 12650 ...
 $ Enrolment.in.Class.III...Girls   : int  2041 467679 14679 253455 1445639 679 247334 2951 823 10887 ...
 $ Enrolment.in.Class.III...Total   : int  4132 938762 30810 508351 2993344 1431 507806 6156 1782 23537 ...
 $ Enrolment.in.Class.IV...Boys     : int  2175 460050 13894 236660 1288401 802 257981 2988 818 12209 ...
 $ Enrolment.in.Class.IV...Girls    : int  2055 458577 12821 238623 1156335 698 250089 2834 782 10645 ...
 $ Enrolment.in.Class.IV...Total    : int  4230 918627 26715 475283 2444736 1500 508070 5822 1600 22854 ...
 $ Enrolment.in.Class.V...Boys      : int  2150 459696 12467 229937 1078188 744 233733 2932 1020 11636 ...
 $ Enrolment.in.Class.V...Girls     : int  2151 457553 11108 232349 917265 684 226406 2758 878 9806 ...
 $ Enrolment.in.Class.V...Total     : int  4301 917249 23575 462286 1995453 1428 460139 5690 1898 21442 ...
 $ Enrolment.in.Class.I.to.V...Boys : int  10664 2429817 84078 1345420 7294949 3609 1305142 15216 4870 61598 ...
 $ Enrolment.in.Class.I.to.V...Girls: int  10275 2401305 76143 1335568 6704874 3275 1253236 14336 4458 54379 ...
 $ Enrolment.in.Class.I.to.V...Total: int  20939 4831122 160221 2680988 13999823 6884 2558378 29552 9328 115977 ...

Column Names

 [1] "Sl..No."                           "STATE.U.T."                       
 [3] "Enrolment.in.Class.I...Boys"       "Enrolment.in.Class.I...Girls"     
 [5] "Enrolment.in.Class.I...Total"      "Enrolment.in.Class.II...Boys"     
 [7] "Enrolment.in.Class.II...Girls"     "Enrolment.in.Class.II...Total"    
 [9] "Enrolment.in.Class.III...Boys"     "Enrolment.in.Class.III...Girls"   
[11] "Enrolment.in.Class.III...Total"    "Enrolment.in.Class.IV...Boys"     
[13] "Enrolment.in.Class.IV...Girls"     "Enrolment.in.Class.IV...Total"    
[15] "Enrolment.in.Class.V...Boys"       "Enrolment.in.Class.V...Girls"     
[17] "Enrolment.in.Class.V...Total"      "Enrolment.in.Class.I.to.V...Boys" 
[19] "Enrolment.in.Class.I.to.V...Girls" "Enrolment.in.Class.I.to.V...Total"

Summary

   Sl..No.           STATE.U.T.        Enrolment.in.Class.I...Boys
 Length:36          Length:36          Min.   :     360           
 Class :character   Class :character   1st Qu.:   12974           
 Mode  :character   Mode  :character   Median :  131302           
                                       Mean   :  642039           
                                       3rd Qu.:  465959           
                                       Max.   :11556702           
 Enrolment.in.Class.I...Girls Enrolment.in.Class.I...Total
 Min.   :     338             Min.   :     698            
 1st Qu.:   11587             1st Qu.:   24562            
 Median :  114994             Median :  246297            
 Mean   :  595620             Mean   : 1237659            
 3rd Qu.:  426372             3rd Qu.:  889494            
 Max.   :10721154             Max.   :22277856            
 Enrolment.in.Class.II...Boys Enrolment.in.Class.II...Girls
 Min.   :     388             Min.   :    388              
 1st Qu.:   11716             1st Qu.:  10871              
 Median :  120698             Median : 105120              
 Mean   :  574131             Mean   : 540027              
 3rd Qu.:  411533             3rd Qu.: 380673              
 Max.   :10334360             Max.   :9720491              
 Enrolment.in.Class.II...Total Enrolment.in.Class.III...Boys
 Min.   :     776              Min.   :     410             
 1st Qu.:   22588              1st Qu.:   11470             
 Median :  225818              Median :  119629             
 Mean   : 1114158              Mean   :  560495             
 3rd Qu.:  787542              3rd Qu.:  397269             
 Max.   :20054851              Max.   :10088910             
 Enrolment.in.Class.III...Girls Enrolment.in.Class.III...Total
 Min.   :    357                Min.   :     767              
 1st Qu.:  10050                1st Qu.:   21520              
 Median : 103758                Median :  223388              
 Mean   : 529705                Mean   : 1090200              
 3rd Qu.: 372402                3rd Qu.:  778641              
 Max.   :9534697                Max.   :19623607              
 Enrolment.in.Class.IV...Boys Enrolment.in.Class.IV...Girls
 Min.   :    420              Min.   :    458              
 1st Qu.:  11110              1st Qu.:   9966              
 Median : 120680              Median : 104168              
 Mean   : 523522              Mean   : 498059              
 3rd Qu.: 379781              3rd Qu.: 362486              
 Max.   :9423403              Max.   :8965065              
 Enrolment.in.Class.IV...Total Enrolment.in.Class.V...Boys
 Min.   :     878              Min.   :    518            
 1st Qu.:   21076              1st Qu.:  10260            
 Median :  224848              Median : 120476            
 Mean   : 1021582              Mean   : 493042            
 3rd Qu.:  743842              3rd Qu.: 364944            
 Max.   :18388468              Max.   :8874752            
 Enrolment.in.Class.V...Girls Enrolment.in.Class.V...Total
 Min.   :    598              Min.   :    1116            
 1st Qu.:   9036              1st Qu.:   19296            
 Median : 103891              Median :  224367            
 Mean   : 465158              Mean   :  958200            
 3rd Qu.: 342057              3rd Qu.:  707001            
 Max.   :8372849              Max.   :17247601            
 Enrolment.in.Class.I.to.V...Boys Enrolment.in.Class.I.to.V...Girls
 Min.   :    2096                 Min.   :    2139                 
 1st Qu.:   56528                 1st Qu.:   49914                 
 Median :  612785                 Median :  531932                 
 Mean   : 2793229                 Mean   : 2628570                 
 3rd Qu.: 2059364                 3rd Qu.: 1882617                 
 Max.   :50278127                 Max.   :47314256                 
 Enrolment.in.Class.I.to.V...Total
 Min.   :    4235                 
 1st Qu.:  106441                 
 Median : 1144716                 
 Mean   : 5421799                 
 3rd Qu.: 3953206                 
 Max.   :97592383

Visualization

Correlation

   Enrolment.in.Class.I...Boys Enrolment.in.Class.I...Total
1                         2163                         4228
2                       558085                      1098313
3                        23412                        44674
4                       341859                       675449
5                      1780830                      3451895
6                          642                         1260
7                       288516                       566113
8                         3077                         5861
9                         1093                         2147
10                       12336                        23378
11                        5282                        10060
12                      440949                       829672
13                      213557                       400969
14                       55469                       106970
15                      110518                       210219
16                      540989                      1068958
17                      350222                       675598
18                      164098                       323154
19                         360                          698
20                      861132                      1685158
21                      672917                      1279983
22                       39790                        79421
23                       56257                       110719
24                       13187                        24956
25                       21088                        41208
26                      420571                       813077
27                        4662                         8997
28                      152087                       282375
29                      897283                      1683153
30                        7652                        14937
31                      298149                       584798
32                       37808                        74116
33                     2303324                      4383045
34                       95938                       183908
35                      781400                      1528389
36                    11556702                     22277856

                             Enrolment.in.Class.I...Boys
Enrolment.in.Class.I...Boys                    1.0000000
Enrolment.in.Class.I...Total                   0.9999902
                             Enrolment.in.Class.I...Total
Enrolment.in.Class.I...Boys                     0.9999902
Enrolment.in.Class.I...Total                    1.0000000

geompoint

Histogram

Box Plot

Bar Plot

Scatter plot

Download

Enrolled Student

count(Enrolled Students)

Download

---
title: "Untitled"
output: 
  flexdashboard::flex_dashboard:
    orientation: columns
    vertical_layout: fill
    theme: cosmo
    social: menu
    story_board: True
    source_code: embed
---

```{r setup, include=FALSE}
libraries = c("MASS", "lattice", "flexdashboard", "DT", "ggplot2", "dplyr", "tidyr","corrplot")
lapply(libraries,require,character.only=TRUE)
enrollment=read.csv(file.choose(""))
attach(enrollment)

```

# Home {.tabset}

### Structure

```{r}
str(enrollment)
```

### Column Names

```{r}
names(enrollment)
```

# Summary {.tabset}
### Summary

```{r}
summary(enrollment)
```

# Visualization {.tabset}

## Correlation

```{r}
dt=as.numeric(enrollment$Enrolment.in.Class.I...Total)
b=subset(enrollment,select = c(3,5))
b
cor(b)
corrplot(cor(b),method = "number",shade.col=NA, tl.col="black",tl.srt=45)
```

## geompoint

```{r}
ggplot(data = enrollment, aes(x = STATE.U.T., y = Enrolment.in.Class.I...Total)) +
  geom_point(label = "The total no of enrolment in class 1", color = "red")
```

## Histogram

```{r}
ggplot(enrollment, aes(x=Enrolment.in.Class.I.to.V...Total)) + 
  geom_histogram(color="blue", fill="pink")
```

## Box Plot

```{r}
ggplot(enrollment, aes(x=as.factor(Enrolment.in.Class.V...Total), y=enrollment$Enrolment.in.Class.I.to.V...Girls)) + 
  geom_boxplot(fill="cyan", alpha=0.2) +   xlab("5th Total Enrolments")
```

## Bar Plot

```{r}
ggplot(data=enrollment, aes(x=enrollment$STATE.U.T., y=enrollment$Enrolment.in.Class.I.to.V...Total)) +
  geom_bar(stat="identity")
```

## Scatter plot

```{r}
ggplot(enrollment, aes(x=enrollment$Enrolment.in.Class.I...Boys, y=enrollment$Enrolment.in.Class.I...Total)) +
  geom_point(size=2, shape=23, color="steelblue")
```

# Download {.tabset}

### Enrolled Student

```{r}
value=sum(enrollment$Enrolment.in.Class.I.to.V...Total)
valueBox("count(Enrolled Students)",value,icon="fa fa-user")
```


### Download

```{r}
datatable(enrollment,extensions="Buttons",options=list(dom="Bftrip",buttons=c("copy","print","pdf","csv")))
```