Sunday, March 11, 2018

Analysing the employment data from Indian railways

Source data from GOI
Credits: Ramprasath

Here is an interesting data to analyse.

How was the employment generated by Indian railways in the past 15 years ? Here is the insights.
The code was developed in R
Data preparation:
The rows and column are transposed to make it easy and readable.

setwd('d:/suman')
job<-read.csv('railwayjob.csv')
typeof(job)

for (j in 2:15)
{
  maxval<-max(job[2:19,j],na.rm = TRUE)
  minval<-min(job[2:19,j],na.rm = TRUE)
  y<-which(maxval==job[,j])
  z<-which(minval==job[,j])
  ans<-job[y,1]
  ans2<-job[z,1]
  print(paste("sl = ",j,", min = ",ans2))
  print(paste("sl = ",j,", max = ",ans))

}

This is a simple data set  for a period of  15 years  and  20 rows.Each indicate the railway zone.

The results are interesting:
Northern zone are contributing more for the employment generation.
The least were the kolkata.  More visualization can be added to this.


3 comments: