Allegiance and Data Source

I am writing this blog post as an entry for the Data Geek Challenge III.

The dataset for this has been taken from The version of Lumira used is SAP Lumira 1.20.0.

My allegiance is for the House of Spirits for I strongly believe that data and technology can make a huge difference in the quality of lives across the world.



Note: Click on the images to view a larger version which is quite readable.

The Prime Minister of India has launched a very ambitious project named ‘Swach Bharath’ or ‘Clean India’. A part of this is to provide sanitation facility to the entire country. Using SAP Lumira, let us try to understand where the maximum effort needs to go in to achieve this dream.

We shall start off with the statewise percentage of schools with toilets for boys.

Pic 1.JPG

The country’s average stands at 67.07. Highest is in Delhi and Chandigarh at 100 percent and the lowest is in Andhra Pradesh at a measly 20.15 percent. Delhi and Chandigarh being small UTs, it is not surprising that they are at a 100%. However, it is interesting to see two large states Karnataka and UP having 96% and 95% each. Lets add one more parameter – Percentage of boys toilets that are usable and see how the data changes.
Pic 2.JPG
Karnataka and UP still are in the top accompanied by Nagaland and Punjab. It is however sad to see states with low percentage of toilets like AP and Odisha having less percentage of toilets that are usable.
Pic 3.JPG
A lot of work needs to be done in these states where the already low percentage of toilets availability is made worse by the non functional toilets.

Moving on to the girls toilets, here is the statewise percentage of schools with toilets for girls.

Pic 4.JPG
This result is quite interesting. All the states have a very good percentage of schools with girls toilets. The country’s average is close to 90% and the lowest is in Meghalaya at 45%. Apart from the small states, AP features in the lowest list with 71.75%. Adding the information of usable toilets, we get this chart.

Pic 5.JPG

The picture changes again. The states which had a good percentage of toilets have a poor percent of toilets that are usable.

Pic 6.JPG

These are the states where the usable toilets percentage is quite low despite having a good amount of toilets. The amount of usable toilets for boys is close to 90% while for girls it is down at 75%. So in case of schools, more toilets  need to be built for boys and more toilets need to be fixed for girls.

Let us move further to the statistics in household. Here is the chart for households in rural parts.

Pic 7.JPG

Clearly a lot of work needs to be done. The country’s average itself is at 30 percent! A huge number of states and UTs have their rural parts with less than 80 percent of households with toilets including Delhi and Karnataka which were topping the list of schools with toilets.
Here is how we are doing in the urban areas.

Pic 8.JPG
Quite good to see. On an average, 80 percent of households in urban regions have toilets at home. The states with less urbanization have less than this average. This result is not surprising at all.

Is there any connect between literacy percentage and availability of toilets in the rural households? Lets find out.
Pic 9.JPG
Not surprising at all. States which the highest percentage of literacy rates have the highest percentage of rural households with toilets. There are some exceptions though. States such as Tamil Nadu, Gujarat, Maharastra and Pondicherry have above average literacy rates but poor availability of toilets.

From this data set, I can see that rural India needs a lot more households with toilets. Education and urbanization seem to have an effect on the availability of toilets. Maybe some lessons from states such as Manipur, Sikkim, Chandigarh, Mizoram, Lakshadweep and Kerala be adapted for the rest of the country.

Hopefully this has given you some insight into where the effort is required to provide sanitation to the entire country. Thank you for reading!

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply