Original


Source: OGD PMU Team.(2021). State/UT-wise Still Births in India during 2019-20


Objective

The objective of this data visualization is to help the viewer identify the still birth count in India by States and Union Territories during the year 2019-2020 (April 2019 to March 2020).

The targeted audience of this visualization are:

  • Indian Government agencies like Ministry of health and Family Welfare, Indian Red Cross Society, Indian Medical Services etc

  • International Healthcare Organizations like World health Organization (WHO), International Red Cross and Red Crescent Organizations etc.

  • NGOs and general population of the country.

The original visualization displays a heatmap of India divided into 28 States and 8 Union Territories. Darker the red higher the count of Still birth.

The visualization chosen had the following main issues:

  • The labels of the State and Union Territory name and the counts of still birth are not visible properly –for example the labels of States and Union Territories like Goa, Daman and Diu and Delhi are not visible.

  • Difficulty in identifying the State or Union Territory with highest number of cases. For example- State with highest count of still birth is Uttar Pradesh with 45556 cases and second most cases of still birth were reported in the state of Rajasthan with 24775 cases which is almost half the count as Uttar Pradesh. There is a huge difference of count of still birth between two states but both the states are marked with same color in the heatmap which may lead to deception.

  • It is difficult to see the color of States and Union Territories with smaller geographical area like Lakshadweep Islands and Andaman and Nicobar Islands

Reference

OGD PMU Team.(2021). State/UT-wise Still Births in India during 2019-20. Retrived May 3, 2021, from Open Government Data (OGD) Platform India website: https://community.data.gov.in/state-ut-wise-still-births-in-india-during-2019-20/

Code

The following code was used to fix the issues identified in the original.

library(ggplot2)
library(tidyr)
library(dplyr)

data = read.csv("C:/Users/AKSHAY/Desktop/RMIT/DV/hmis-item-rpt-ind-for-2019-20.csv")


new = data.frame(State_Name=data$State,
                     Parameters=data$Parameters,
                     Total=data$Total...Total...A.B..or..C.D.. )


data1 = filter(new, Parameters == 'Still Birth')

stillbirth = na.omit(data1)


p1 <- ggplot(data = stillbirth, aes(x = State_Name, y = Total , fill = Total ))
p1 <- p1 + geom_bar(stat = "identity")+coord_flip() +theme_minimal()+
  theme(axis.text.x = element_text(angle = 90) )+
  labs(x = "States and Union Territories", 
       y = "Count" , 
       title = "Count of Still Birth by States and Union Territories of India", 
       caption = "Data from April 2019 to March 2020") +
  geom_text(aes(label=Total),hjust= 0, size =3)

Data Reference

OGD PMU Team.(2021). State/UT-wise Still Births in India during 2019-20. Retrived May 3, 2021, from Open Government Data (OGD) Platform India website: https://community.data.gov.in/state-ut-wise-still-births-in-india-during-2019-20/

Reconstruction

The following barchart fixes the main issues in the original visualization :-

The barchart is a better form of visualization for this type of data due to following reasons:-

  • The labels of the State name and Union Territories and the counts of still birth are visible properly.

  • Identification of States and Union Territories with highest and lowest number of still birth count made easier. Additionally, comparison among multiple State and Union Territory count of still birth made easier at one glance.

  • Visual analysis made easier- Darker the blue lower the still birth count or vice versa.