Site icon Console Flare Blog

Comprehensive Data Analysis of Primary Health Centre Distribution in Indian States

Data Analysis has become a basic requirement of any country’s government to collect, track, and analyze data so that they can make data-dependent decisions that can be quick, accurate, and provide faster results. Governments of any country follow these steps in every sector. In the same manner, the government of India collects data for every sector and analyzes it from time to time, and also the data is available publicly. You can check it, download it, and perform analysis for learning purposes.

If you wish to learn more about Data Analysis and Data Science and have an in-depth knowledge of this field. Read this blog
What Is Data Science In Simple Words?

https://ndap.niti.gov.in/dataset/7035

In today’s blog, we are going to download a dataset from the healthcare sector

Data on district-wise healthcare infrastructure pertaining to the availability of healthcare centers in India is published in the annual Rural Health Statistics. Rural Health Statistics is an effort towards providing reliable and updated information on rural health infrastructure, which would cater to the basic needs of effective planning, monitoring, and management of health infrastructure.

Let us start the data analysis from the basics:

  1. Importing necessary libraries:
Copy
import pandas as pd
import seaborn as sns
import matplotlib.pyplot as plt
Python

Pandas is a library, used for analyzing the data
Plotly, Seaborn, and Matplotlib are the libraries used for data visualization

2. Read the file: We need to access the file with the help of pandas.

Copy
data=pd.read_csv('ndap-healthcare.csv')
Python
Comprehensive Data Analysis of Primary Health Centre Distribution in Indian States

3. Basic Information: Number of rows and columns the dataset has and data type of each column.

Copy
data = pd.read_csv('ndap-healthcare.csv')
rows,columns=data.shape

print(f'Number of rows:{rows}')
print(f'Number of columns:{columns}')

data_types = data.dtypes
print(data_types)

# Output
Number of rows: 716
Number of columns: 12


srcStateName                                                      object
srcDistrictName                                                   object
Functional Sub Centres                                           float64
Functional Primary Health Centres                                  int64
Functional Community Health Centres                                int64
Functional Health and Wellness Centres-Sub Centres               float64
Functional Health and Wellness Centres-Primary Health Centres    float64
Functional Sub Divisional Hospitals                              float64
Functional District Hospitals                                    float64
srcYear                                                           object
YearCode                                                           int64
Year                                                              object
Python

data is a variable that holds the data from the CSV file.
data.shape: This command provides the number of rows and columns present in the file.
data.dtypes: This command provides the data type of each column.

4. Statistical Description: What is the mean, median, percentile, and count for the columns?

Copy
data.desccribe()
Python
Comprehensive Data Analysis of Primary Health Centre Distribution in Indian States

5. Missing Values: Which columns have missing values, and how many missing values are there per column?

Copy
missing_values=data.isnull().sum()
print(missing_values)
Python

data.isnull().sum(): Provides the total number of missing values in each column.

For more such content and regular updates, follow us on FacebookInstagramLinkedIn

6. Which state has the highest number of functional sub-centers?

Copy
state_sub_centres = data.groupby('srcStateName')['Functional Sub Centres'].sum().idxmax()
print(f"The state with the highest number of functional sub-centres is {state_sub_centres}.")

# Output

The state with the highest number of functional sub-centres is Uttar Pradesh.
Python

Uttar Pradesh is the state with the highest number of functional sub-centers.

7. How many districts have zero functional health and wellness centers (sub-centers)?

Copy
zero_hwsc = data[data['Functional Health and Wellness Centres-Sub Centres'] == 0].shape[0]
print(f"The number of districts with zero functional health and wellness centres (sub-centres) is {zero_hwsc}.")

# Output

The number of districts with zero functional health and wellness centres (sub-centres) is 295.
Python

There are 295 districts in total with no functional health and wellness centers.

Comprehensive Data Analysis of Primary Health Centre Distribution in Indian States

8. Which district has the highest number of functional health and wellness centers (primary health centers)?

Copy
district_hwpc = data['Functional Health and Wellness Centres-Primary Health Centres'].idxmax()
highest_hwpc_district = data.loc[district_hwpc, 'srcDistrictName']
print(f"The district with the highest number of functional health and wellness centres (primary health centres) is {highest_hwpc_district}.")

# Output
The district with the highest number of functional health and wellness centres (primary health centres) is East Godavari.
Python

East Godavari is the district with the highest number of functional health and wellness centers(primary health centers)

Comprehensive Data Analysis of Primary Health Centre Distribution in Indian States

9. What is the total number of functional district hospitals in the dataset?

Copy
total_district_hospitals = data['Functional District Hospitals'].sum()
print(f"The total number of functional district hospitals is {total_district_hospitals}.")

# Output
The total number of functional district hospitals is 756.0.
Python

There are 756 functional district hospitals in total.

10. How many states have more than 100 functional primary health centers?

Copy
states_with_100_phc = data.groupby('srcStateName')['Functional Primary Health Centres'].sum()
num_states_100_phc = (states_with_100_phc > 100).sum()
print(f"The number of states with more than 100 functional primary health centres is {num_states_100_phc}.")

# Output

The number of states with more than 100 functional primary health centres is 23.
Python

There are 23 states having more than 100 functional primary health centers.

Comprehensive Data Analysis of Primary Health Centre Distribution in Indian States

11. Which state has the least number of functional health and wellness centers (sub-centers)?

Copy
state_least_hwsc = data.groupby('srcStateName')['Functional Health and Wellness Centres-Sub Centres'].sum().idxmin()
print(f"The state with the least number of functional health and wellness centres (sub-centres) is {state_least_hwsc}.")


# Output
The state with the least number of functional health and wellness centres (sub-centres) is Chandigarh.
Python

Chandigarh has the least number of functional health and wellness centers as compared to others.

12. Which state has the most consistent number of functional sub-centers across its districts?

Copy
std_sub_centres = data.groupby('srcStateName')['Functional Sub Centres'].std()
most_consistent_state = std_sub_centres.idxmin()
print(f"The state with the most consistent number of functional sub-centres across its districts is {most_consistent_state}.")


# Output
The state with the most consistent number of functional sub-centres across its districts is A& N Islands.
Python

Andaman & Nicobar Islands is the state with the most consistent number of functional sub-centers across its districts.

Comprehensive Data Analysis of Primary Health Centre Distribution in Indian States

14. Which state has the highest and lowest number of functional district hospitals?

Copy
# States with highest and lowest functional district hospitals
district_hospitals_per_state = data.groupby('srcStateName')['Functional District Hospitals'].sum()
state_highest_district_hospitals = district_hospitals_per_state.idxmax()
state_lowest_district_hospitals = district_hospitals_per_state.idxmin()

state_highest_district_hospitals, state_lowest_district_hospitals

# Output

'Uttar Pradesh', 'Chandigarh'
Python

Uttar Pradesh is the state with the highest number of district hospitals while Chandigarh has the lowest number of district hospitals

13. Compare the number of functional community health centers between two states of your choice.

Copy
state1 = 'Andhra Pradesh'
state2 = 'Arunachal Pradesh'

comparison_chc = data[data['srcStateName'].isin([state1, state2])]
sns.boxplot(x='srcStateName', y='Functional Community Health Centres', data=comparison_chc)
plt.title(f'Comparison of Functional Community Health Centres between {state1} and {state2}')
plt.show()
Python

The above graph shows the comparison of Andhra Pradesh and Arunachal Pradesh on behalf of functional community health centers. In case you want to see for other states you can change the values in the variables state1 and state2.

Comprehensive Data Analysis of Primary Health Centre Distribution in Indian States

15. Comparison between states: How do the numbers of different types of functional health centers compare across states? Plot a comparison of the number of functional sub-centers, primary health centers, and community health centers for the top 5 states with the highest values.

Copy
# Comparison of different types of functional health centers across states
comparison_data = data.groupby('srcStateName').sum().reset_index()
top_5_states = comparison_data.nlargest(5, 'Functional Sub Centres')

# Plot comparison
fig = px.bar(top_5_states, x='srcStateName', y=['Functional Sub Centres', 'Functional Primary Health Centres', 'Functional Community Health Centres'], title='Comparison of Health Centers in Top 5 States')
fig.show()
Python

These 5 are the top states with the highest number of functional sub-centers, primary health centers, and community health centers.

16. Plot the total number of functional centers per state.

Copy
total_centres_per_state = data.groupby('srcStateName').sum()

plt.figure(figsize=(15, 8))
total_centres_per_state.plot(kind='bar', stacked=True)
plt.title('Total Number of Functional Centres per State')
plt.ylabel('Number of Centres')
plt.xlabel('State')
plt.xticks(rotation=90)
plt.show()
Python

This is the graphical representation of the functional centers for all the states.

Comprehensive Data Analysis of Primary Health Centre Distribution in Indian States

17. What is the average number of functional sub-divisional hospitals per state?

Copy
avg_sub_div_hospitals = data.groupby('srcStateName')['Functional Sub Divisional Hospitals'].mean()

plt.figure(figsize=(15, 8))
avg_sub_div_hospitals.plot(kind='bar')
plt.title('Average Number of Functional Sub Divisional Hospitals per State')
plt.ylabel('Average Number')
plt.xlabel('State')
plt.xticks(rotation=90)
plt.show()
Python

State-wise functional sub-divisional hospital on an average basis.

18. Plot the average number of functional community health centers per state.

Copy
state_avg_chc = data.groupby('srcStateName')['Functional Community Health Centres'].mean()

plt.figure(figsize=(15, 8))
state_avg_chc.plot(kind='bar')
plt.title('Average Number of Functional Community Health Centres per State')
plt.ylabel('Average Number')
plt.xlabel('State')
plt.xticks(rotation=90)
plt.show()
Python

19. What is the distribution of functional primary health centers across different states?

Copy
state_phc_counts = data.groupby('srcStateName')['Functional Sub Centres'].sum().sort_values()

# Plot the bar plot
plt.figure(figsize=(15, 10))
sns.barplot(x=state_phc_counts.values, y=state_phc_counts.index, palette='viridis')
plt.title('Distribution of Functional Sub Centres across States')
plt.xlabel('Number of Functional Sub Centres')
plt.ylabel('State')
plt.show()
Python
Comprehensive Data Analysis of Primary Health Centre Distribution in Indian States

Insights from this data analysis:

  1. Variability across states: There is significant variability in the number of functional primary health centers across different states. Some states have a considerably higher number of PHCs compared to others.
  2. Top States with high Primary Health Centers: States such as Andhra Pradesh, Uttar Pradesh, and Maharashtra appear to have a high number of functional primary health centers. This could be due to larger populations and greater demand for primary healthcare services in these states.
  3. States with low PHCs: On the other hand, states like Arunachal Pradesh, Nagaland, and Sikkim have relatively fewer functional primary health centers. This could be due to smaller populations, geographic challenges, or different healthcare infrastructure policies.
  4. Healthcare Infrastructure Disparity: The disparity in the number of PHCs across states indicates differences in healthcare infrastructure development and resource allocation. States with fewer PHCs might face challenges in providing accessible primary healthcare to their populations.
  5. Potential Areas for Improvement: States with a lower number of PHCs might need targeted interventions to improve their primary healthcare infrastructure. This could involve increasing the number of PHCs, improving existing facilities, and ensuring better resource distribution.
  6. Policy Implications: Policymakers can use this analysis to identify regions with inadequate primary healthcare facilities and prioritize them for healthcare infrastructure development. Ensuring equitable distribution of healthcare resources is essential for improving overall public health.

If you wish to learn data analysis and curve your career in the data science field feel free to join our free workshop on Masters in Data Science with PowerBI, where you will get to know how exactly the data science field works and why companies are ready to pay handsome salaries in this field.

In this workshop, you will get to know each tool and technology of data analysis from scratch that will make you skillfully eligible for any data science profile.

To join this workshop, register yourself on consoleflare and we will call you back.

Thinking, Why Console Flare?

Register yourself on consoleflare and we will call you back.

WE ARE CONSOLE FLARE

We can help you Switch your career to Data Science in just 6 months.

Exit mobile version