Savitribai Phule Pune University

A
Mini Project Report
on
“Covid Vaccine Dataset”
Submitted in partial fulfillment of the requirement for the award of the degree of

BACHELOR OF ENGINEERING IN
COMPUTER ENGINEERING
[T.E.Computer Engineering]

By

Parag Dilip Patil

At

Department of Computer Engineering

SANDIP FOUNDATION’S
SANDIP INSTITUTE OF ENGINEERING & MANAGEMENT
Mahiravani, Trimbak Road Nashik – 422213.
Academic Year 2024 - 2025
 SANDIP FOUNDATION’S
SANDIP INSTITUTE OF ENGINEERING & MANAGEMENT
Mahiravani, Trimbak Road Nashik - 422213.
Department of Computer Engineering

This is to certify that, the Mini Project report “Covid Vaccine Statewise Dataset”
submitted by Patil Parag Dilip for partial fulfillment of the requirement for the
award of the Bachelor Of Engineering in COMPUTER ENGINEERING at
Sandip Institute of Engineering Management,Nashik as laid down by the Sav-
itribai Phule Pune University. This is a record of the work carried out under my
supervision and guidance during academic year 2024 - 2025.

Place: - Nashik.
Date: - / / 2025

Prof. V. V. Mahale Prof. (Dr). K. C. Nalavade

Internal Guide HOD
Dept. Of Computer Engg. Dept. Of Computer Engg.

Prof. (Dr). D. P. Patil

Principal
Sandip Institute of Engineering and Management,Nashik
 Acknowledgment

The report would not have been completed without the encouragement and sup-
port of many people who gave their precious time and encouragement throughout the
period. I want to thank my advisers and everyone for their patience and assistance
during my on-site training. I would like to thank Prof. V. V. Mahale . Thanks to
their guidance, I was able to develop Clean Dataset and Visualization and learn
about Data Analytics.

I am also grateful to Head Computer Engineering Department, Prof. (Dr).

K. C. Nalavade, Sandip Institute of Engineering and Management for continuous
motivation, support in all aspects.

I am most grateful to our honorable Principal Prof.(Dr). D. P. Patil for giving

us the permission for internship. I sincerely thank to the entire team of staff members,
our college, company, our family and those who knowingly and unknowingly have
contributed in their own way in completion of this Mini project report.

Student name:Patil Parag Dilip

Roll No :- 27
Contents

Acknowledgment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . i
Abstract . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ii

1 INTRODUCTION 1
1.1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
1.2 Title . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
1.3 Objectives . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

2 Literature Survey 5
2.1 Literature Survey . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

3 METHODOLOGICAL DETAILS 7
3.1 Methodology . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
3.2 Dataset Description . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
3.3 Implementation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

4 Result and Discussion 12

4.1 Result and Discussion . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
4.2 Conclusion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
4.3 Future Scope . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16

5 REFERENCES 18

ii
 Covid Vaccine Statewise Dataset

Chapter 1

INTRODUCTION

1.1 Introduction
The outbreak of the COVID-19 pandemic in late 2019 created an unprecedented
global health crisis. In response, governments and health organizations around the
world initiated large-scale vaccination programs to immunize populations and curb the
spread of the virus. India, being one of the most populous countries in the world, un-
dertook a massive vaccination drive starting in January 2021.The dataset titled covid
vaccine statewise.csv from the Kaggle dataset “COVID-19 in India” provides compre-
hensive data about the COVID-19 vaccination campaign carried out across various
states and union territories of India.

This dataset serves as a critical resource for understanding how the vaccination efforts
unfolded across the Indian subcontinent. It contains valuable time-series information
detailing the number of vaccinations administered daily in each state, along with vari-
ous demographic distributions. By analyzing this dataset, one can evaluate the pace,
scale, and effectiveness of the vaccine rollout at the state level. It allows researchers,
policymakers, and data analysts to study regional disparities, identify trends, and un-
cover insights into public health responses

Dataset Overview: The covid vaccine statewise.csv dataset includes the following
key fields: State: This column identifies the Indian state or union territory for which
the data has been recorded. It serves as a primary grouping variable for state-level
analysis.Updated On: This field records the date on which the vaccination data was
updated, enabling time-series analysis of the vaccination progress.Total Doses Ad-
ministered: This is a cumulative count of all COVID-19 vaccine doses given, both
first and second doses.First Dose Administered: The number of people who have
received their first dose of the COVID-19 vaccine.Second Dose Administered: The
count of individuals who have received the full dosage of the vaccine.Male (Doses),
Female (Doses), Transgender (Doses): These fields show gender-wise vaccina-
tion numbers, which help evaluate the inclusiveness and demographic coverage of the
vaccine rollout.Covaxin (Doses) and Covishield (Doses): India primarily used

Department of Computer Engineering, SIEM, Nashik 1

 Covid Vaccine Statewise Dataset

two vaccines during the early phase of its campaign — Covaxin (developed by Bharat
Biotech) and Covishield (developed by Serum Institute of India based on the Oxford-
AstraZeneca formula). These fields show the type of vaccine administered in each
state.AEFI: Adverse Events Following Immunization, if any, are recorded here. Moni-
toring AEFI is critical for ensuring vaccine safety.18-44 Years (Doses), 45-60 Years
(Doses), 60+ Years (Doses): These age-wise breakdowns provide insights into how
the vaccination strategy prioritized various age groups, particularly the elderly and
working-age adults.

This dataset is highly valuable for multiple stakeholders: Public Health Au-
thorities: By analyzing vaccination trends across states, authorities can measure the
success of the rollout and identify regions requiring more resources.Data Scientists and
Researchers: It provides a basis for statistical modeling, time-series forecasting, and
correlation analysis with infection rates or mortality.Policymakers: Enables evidence-
based decision-making regarding vaccine distribution, logistics planning, and awareness
campaigns.Academicians and Students: Useful for educational purposes in courses re-
lated to public health, epidemiology, data analytics, and statistics.

Challenges in the Dataset: Missing or Incomplete Data: Due to the evolving

nature of data collection, some fields might have null values or inconsistent records.
Temporal Gaps: Some states may not report daily updates, which can lead to data
gaps and inconsistencies in trends. Standardization: Differences in how states re-
ported data initially may cause challenges in comparative analysis.

The COVID-19 pandemic, caused by the novel coronavirus SARS-CoV-2, led to a

global public health emergency beginning in late 2019. Countries around the world
faced unprecedented challenges in terms of managing infection rates, minimizing fatal-
ities, and ensuring the continuity of healthcare systems. Vaccination quickly emerged
as one of the most promising tools to control the spread of the virus and mitigate its
impact. India, with a population of over 1.4 billion, initiated its COVID-19 vaccination
drive on January 16, 2021 — one of the largest immunization campaigns in the world.

This dataset is valuable for multiple fields including public health, data science, epi-
demiology, and public policy. It supports analysis at both granular (state-level) and
national levels, enabling researchers to study regional trends, measure performance,
and draw meaningful comparisons.

Department of Computer Engineering, SIEM, Nashik 2

 Covid Vaccine Statewise Dataset

1.2 Title
Data Analysis using python. Data analysis is the process of inspecting, cleaning,
transforming, and modeling data to discover useful information, conclude, and sup-
port decision-making. In today’s world, data is produced in enormous quantities every
second. As organizations, researchers, and analysts seek to leverage this vast amount
of information, efficient tools for analyzing and visualizing data have become critical.
Python, with its rich ecosystem of libraries, has emerged as a dominant tool in the field
of data science. Among these libraries, Pandas and Matplotlib stand out as essential
tools for data manipulation and visualization, respectively.

This introduction provides an overview of the role of Python, Pandas, and Matplotlib
in data analysis. It explores the fundamental concepts, their applications, and the pow-
erful functionalities they offer to make data analysis tasks more accessible, efficient,
and insightful.

The Role of Python in Data Analysis Python is a versatile, high-level program-

ming language known for its readability and simplicity. Over the years, it has gained
immense popularity within the data science community. One of the reasons for its
widespread adoption is the extensive collection of libraries and frameworks available
for various stages of data analysis.Python is an ideal language for data analysis for
several reasons: Easy to Learn and Use: Python has a simple syntax that makes it
accessible to both beginners and professionals. This makes it an attractive option for
people new to programming and data analysis.

Rich Ecosystem of Libraries: Python offers a comprehensive collection of libraries

that facilitate tasks such as data manipulation, cleaning, visualization, statistical anal-
ysis, and machine learning. Libraries like Pandas, Matplotlib, NumPy, SciPy, and
Scikitlearn offer powerful functionality that simplifies data analysis tasks

Community and Support: Python’s large and active community ensures that re-
sources,tutorials, and forums are readily available for anyone looking to learn or trou-
bleshoot issues.

Integration with Other Tools: Python seamlessly integrates with other tools and
databases, including SQL, Hadoop, Spark, and more, making it highly adaptable for
various data analysis workflows.

Department of Computer Engineering, SIEM, Nashik 3

 Covid Vaccine Statewise Dataset

1.3 Objectives
The primary objective of analyzing the covid vaccine statewise.csv dataset is to gain
comprehensive insights into the state-wise and demographic distribution of COVID-19
vaccinations across India. This dataset, compiled during one of the largest immuniza-
tion drives in the world, offers a rich and structured source of information that can
be used to assess the progress, performance, and equity of India’s vaccination strategy
during the COVID-19 pandemic.

Key Objectives of the dataset:

This study aims to examine how effectively vaccines were distributed across differ-
ent states and union territories, how well demographic groups such as different age
categories and genders were covered, and how the use of different vaccines (Covaxin
and Covishield) varied across regions. By breaking down the data on a temporal ba-
sis, the objective also includes identifying trends over time—such as acceleration or
stagnation of vaccination rates, which can offer insights into logistical efficiency, public
response, and policy effectiveness.

Another key objective is to understand the inclusiveness of the vaccine rollout. The
dataset provides gender-disaggregated and age-based data, which helps in analyzing
whether women, the elderly, and other vulnerable groups received adequate attention
during the campaign. Additionally, the dataset includes data on Adverse Events Fol-
lowing Immunization (AEFI), which can be used to evaluate vaccine safety and public
confidence.

Specifically, the objectives can be outlined as: To analyze the state-wise progress
of COVID-19 vaccine administration across India.To evaluate demographic distribu-
tion (gender and age) of vaccine recipients.To compare the usage of different vaccines
(Covaxin and Covishield) across states.To identify time-series trends in vaccine admin-
istration at the national and regional levels.To explore patterns in AEFI reports and
assess public health safety responses.To assess the equity and reach of the vaccination
drive in urban vs. rural or well-developed vs. under-developed states.To provide a
data-driven foundation for policy-making, resource allocation, and future immuniza-
tion campaigns.Overall, this analysis is intended not only to measure the numerical
success of the vaccination campaign but also to evaluate its inclusiveness, safety, and
effectiveness, thereby contributing valuable insights for future pandemic preparedness.

Department of Computer Engineering, SIEM, Nashik 4

 Covid Vaccine Statewise Dataset

Chapter 2

Literature Survey

2.1 Literature Survey

The COVID-19 pandemic posed an unprecedented challenge to global healthcare sys-
tems, prompting rapid research, vaccine development, and large-scale immunization
efforts. In India, the vaccination campaign began in January 2021 and has since been
a subject of extensive academic and policy-oriented studies. This literature review
highlights the key contributions from existing research related to COVID-19 vacci-
nation efforts, the use of state-wise data in public health analytics, and the role of
demographic analysis in assessing vaccine coverage and effectiveness.

1. COVID-19 Vaccination Rollout in India: Multiple studies have documented

the phases and structure of India’s COVID-19 vaccination program. According to
Kumar et al. (2021), India adopted a phased vaccination strategy, initially prioritiz-
ing healthcare and frontline workers, then expanding to include senior citizens and
individuals with comorbidities, and eventually all adults. The use of domestically pro-
duced vaccines, Covaxin and Covishield, allowed India to manage supply chains more
effectively, although regional disparities persisted due to logistical and administrative
differences (Ranjan et al., 2022).

2. Statewise Disparities and Public Health Infrastructure: State-level analysis

has been crucial in identifying disparities in vaccine accessibility. Research by Mishra
and Chakraborty (2021) indicates that states with robust public health infrastructure,
higher literacy rates, and better digital penetration achieved faster and broader vac-
cine coverage. On the other hand, states with rural populations, vaccine hesitancy, or
underdeveloped health systems experienced slower rollout. The dataset covid vaccine
statewise.csv captures this variability and supports further exploration of such findings.

3. Demographic Distribution and Equity: Studies such as those by Sahoo et

al. (2022) emphasize the importance of demographic equity in vaccine distribution.
Their research identified gaps in vaccine uptake among women and rural populations.
Furthermore, Singh et al. (2021) highlight that lower participation among transgender

Department of Computer Engineering, SIEM, Nashik 5

 Covid Vaccine Statewise Dataset

individuals and people with disabilities indicates the need for more inclusive vaccina-
tion policies. The dataset provides gender-wise and age-group specific data, making it
an important resource to examine the inclusiveness of India’s vaccination efforts.

4. Use of Data Analytics in Public Health: Data-driven decision-making played

a vital role in the pandemic response. Research by Sharma et al. (2021) demonstrates
how time-series analysis, clustering, and regression models can be used to forecast vac-
cine demand, identify high-risk zones, and evaluate policy effectiveness. Publicly avail-
able datasets like covid vaccine statewise.csv have been pivotal in enabling these stud-
ies. The ability to visualize trends, detect anomalies, and compare regional progress
has contributed significantly to the adaptability and responsiveness of public health
interventions.

5. Adverse Events Following Immunization (AEFI): The monitoring of AEFI is

critical to maintaining public trust and vaccine safety. Studies by Bhattacharya et al.
(2022) examined the correlation between reported AEFI and public vaccine hesitancy.
Their findings highlight the importance of transparent reporting and quick response
mechanisms to address concerns. The presence of AEFI data in the dataset allows
for safety surveillance and helps evaluate the integrity of post-vaccination monitoring
systems.

Department of Computer Engineering, SIEM, Nashik 6

 Covid Vaccine Statewise Dataset

Chapter 3

METHODOLOGICAL DETAILS

3.1 Methodology
The methodology followed for analyzing the covid vaccine statewise.csv dataset involves
a structured, multi-step approach to ensure comprehensive, accurate, and insightful
analysis. The steps include data collection, preprocessing, exploratory data analysis
(EDA), visualization, and interpretation of results. The aim is to extract meaningful
insights regarding the COVID-19 vaccination progress across different Indian states
and demographic groups.

1. Data Collection:The dataset was sourced from the publicly available “COVID-19
in India” dataset hosted on Kaggle, which is maintained by Sudalai Rajkumar. The
specific file used, covid vaccine statewise.csv, contains state-wise and time-series vac-
cination records from the beginning of the vaccine rollout in India.

2. Data Preprocessing:Before analysis, the dataset was cleaned and prepared for
use through the following steps: Handling Missing Values: Rows with missing or null
values in critical columns such as ”State”, ”Updated On”, or ”Total Doses Adminis-
tered” were either filled with appropriate estimates or removed based on context.Date
Formatting: The ”Updated On” column was converted into a datetime format to facil-
itate time-series analysis.Data Type Conversion: Columns representing numerical data
(e.g., doses administered) were converted from string/object types to numeric types
to support aggregation and plotting.Removal of Non-State Entries: Aggregated entries
like ”India” or test center data were excluded from state-level analysis.Deduplication:
Any duplicate records were identified and removed to ensure accuracy.

3. Exploratory Data Analysis (EDA): EDA was performed to understand the

structure, trends, and patterns within the data. This included: Descriptive Statis-
tics: Summarizing central tendencies (mean, median), range, and standard deviation
of vaccine doses by state. Distribution Analysis: Studying the distribution of first and
second doses across states and demographics. Trend Identification: Analyzing vacci-
nation trends over time using line charts and moving averages. Demographic Analysis:

Department of Computer Engineering, SIEM, Nashik 7

 Covid Vaccine Statewise Dataset

Comparing vaccine administration across age groups (18-44, 45-60, 60+) and genders
(male, female, transgender).

4. Data Visualization: Various visualization techniques were used to represent

the findings effectively: Bar Charts: For comparing total doses across different states
and demographic groups. Line Graphs: To observe time-series trends in vaccination
rates. Pie Charts: For showing proportions of vaccine types (Covishield vs. Cov-
axin). Heatmaps: To identify geographic disparities in vaccine coverage. Stacked Bar
Graphs: To show gender or age-group distributions within total vaccinations. Visu-
alization tools such as Matplotlib, Seaborn, and Plotly in Python were used for this
purpose.

5. Comparative Analysis: After basic analysis and visualizations, comparisons

were made on the following fronts: State vs. National Trends: Comparing state-wise
vaccine administration to national averages. Vaccine Type Distribution: Analysis of
which vaccine was more commonly administered in each region. Adverse Events Analy-
sis (AEFI): Identifying regions or time periods with high AEFI reports and correlating
them with vaccine trends. Demographic Coverage: Evaluating if age groups or genders
were under- or over-represented in the vaccination effort.

6. Interpretation and Insights: Once the analysis and visualizations were com-
pleted, the data was interpreted to draw insights such as: Which states led or lagged
in vaccine administration? Was there gender disparity in vaccine access? Were certain
vaccines more prevalent in particular regions? Were elderly populations adequately
covered? How did the vaccination rates change over time?

7. Tools and Technologies Used Python: For data analysis and visualization
(libraries used: Pandas, NumPy, Matplotlib, Seaborn, Plotly).Jupyter Notebook /
Google Colab: For executing Python code and documenting the workflow.

Department of Computer Engineering, SIEM, Nashik 8

 Covid Vaccine Statewise Dataset

3.2 Dataset Description

The dataset used is titled covid vaccine statewise.csv, sourced from the publicly
available COVID-19 in India dataset on Kaggle. It provides comprehensive, day-wise
data on the COVID-19 vaccination campaign across Indian states and union territories.
The dataset captures both temporal and demographic dimensions of the vaccination
process, making it a valuable resource for public health analysis and policy evaluation.

1. Dataset Overview Name of Dataset: covid vaccine statewise.csv Source: Kag-

gle – COVID-19 in India Dataset Data Provider: Sudalai Rajkumar Geographical
Scope: All 28 Indian states and 8 union territories Time Period Covered: From the
beginning of the vaccination rollout (January 2021) onwards Format: CSV (Comma
Separated Values) Size: 6000+ records (may vary with updates)

2. Key Features (Columns) in the Dataset: Column Name Description State

Name of the Indian state or union territory Updated On Date on which the data was
recorded or updated (in DD/MM/YYYY format) Total Doses Administered Cumula-
tive number of all vaccine doses administered First Dose Administered Total number
of first vaccine doses given Second Dose Administered Total number of second doses
given Male(Individuals Vaccinated) Number of male individuals who received the vac-
cine Female(Individuals Vaccinated) Number of female individuals who received the
vaccine Transgender(Individuals Vaccinated) Number of transgender individuals vac-
cinated Total Covaxin Administered Total number of Covaxin doses administered Total
CoviShield Administered Total number of Covishield doses administered AEFI Adverse
Events Following Immunization reported 18-44 Years (Age) Number of individuals vac-
cinated in the age group 18–44 45-60 Years (Age) Number of individuals vaccinated
in the age group 45–60 60+ Years (Age) Number of individuals vaccinated in the age
group 60 and above

3. Notable Characteristics Temporal Dimension: The dataset is updated daily,

allowing for time-series analysis of vaccine rollout progress. Demographic Cover-
age: The data is broken down by gender (male, female, transgender) and age groups,
enabling equity and inclusion analysis. Vaccine Type: Includes vaccine-specific data
for the two major vaccines used in India — Covaxin and Covishield. State-Level
Granularity: Each record is state-specific, making it suitable for comparative analy-
sis across regions. Safety Monitoring: The inclusion of AEFI data provides insights
into vaccine safety and adverse reactions.

Department of Computer Engineering, SIEM, Nashik 9

 Covid Vaccine Statewise Dataset

4. Utility and Scope this dataset is instrumental for: Monitoring the progress
of the vaccination campaign Identifying regional disparities in vaccine access Analyzing
demographic trends and gender equity Evaluating vaccine safety through AEFI track-
ing Supporting data-driven public health decision-making

5. Limitations: The dataset may not include real-time updates if used offline. Some
entries may have missing or inconsistent data, requiring cleaning. AEFI data is limited
to numerical reports without qualitative detail (severity, type). No data on booster
doses or newer vaccines like Corbevax (depending on version/date).

Department of Computer Engineering, SIEM, Nashik 10

 Covid Vaccine Statewise Dataset

3.3 Implementation
The implementation of the COVID-19 vaccination dataset analysis was carried out
using Python, a powerful programming language well-suited for data science tasks.
Libraries such as Pandas, NumPy, Matplotlib, and Seaborn were used to process and
visualize the data.

The implementation involved the following key steps:

1. Setting Up the Environment

2. Loading the Dataset
3. Data Exploration and Cleaning
4. Data Aggregation and Analysis
5. Data Visualization
6. Time Series Analysis (Optional)
7. Adverse Events Analysis

This implementation provides a robust analysis of the COVID-19 vaccination campaign

across Indian states using the covid vaccine statewise.csv dataset. By combining de-
scriptive statistics with rich visualizations, the analysis offers insights into demographic
patterns, state-wise performance, vaccine type distribution, and potential safety con-
cerns.

Department of Computer Engineering, SIEM, Nashik 11

 Covid Vaccine Statewise Dataset

Chapter 4

Result and Discussion

4.1 Result and Discussion

As I reflect on my journey and the path I am taking as an aspiring data analyst, I re-
alize that data analysis is more than just a career—it’s a passion for me. Throughout
my academic years, as well as my recent internship experience, I have come to appre-
ciate the immense value that data brings to organizations, industries, and society as a
whole. What makes data analysis so exciting is its power to transform raw numbers
into actionable insights that can drive decisions, optimize processes, and create value.
This realization has fueled my motivation to pursue this field further, and I am eager
to continue learning, growing, and contributing to the success of organizations through
data-driven decision-making.

One of the key takeaways from my journey thus far is the importance of data in to-
day’s world. Businesses, governments, and institutions are increasingly reliant on data
to navigate complex problems, forecast trends, and achieve their objectives. Whether
it’s through improving customer experience, streamlining operations, or identifying
new growth opportunities, data analysis provides a foundation for informed decisions.
The ability to extract insights from large datasets and present them in a way that
is meaningful and actionable is a skill that holds tremendous value in virtually every
industry.

During my internship, I had the opportunity to experience firsthand how data analysis
can influence business strategies and decisions. The hands-on experience I gained from
working with real-world datasets taught me how critical it is to approach data with a
strategic mindset. It’s not just about knowing how to clean and analyze data; it’s about
understanding how to translate those findings into meaningful recommendations that
can directly impact a business. For example, during my internship, I worked with Ama-
zon India’s sales data for Q2 2022, and the analysis of product category performance,
sales trends, and customer behavior allowed me to offer actionable insights. Identifying
growth opportunities, uncovering underperforming areas, and recommending targeted

Department of Computer Engineering, SIEM, Nashik 12

 Covid Vaccine Statewise Dataset

strategies based on data is what makes the role of a data analyst so impactful.As I
continue to develop my skills in data analysis, I understand that the field is vast and
constantly evolving.

Department of Computer Engineering, SIEM, Nashik 13

 Covid Vaccine Statewise Dataset

4.2 Conclusion
The COVID-19 pandemic posed one of the most significant public health challenges
in modern history. In response, the development and deployment of vaccines played a
critical role in controlling the spread of the virus and reducing mortality rates. This
study focused on analyzing the state-wise COVID-19 vaccination data from India, using
the covid vaccine statewise.csv dataset sourced from Kaggle. Through data cleaning,
processing, visualization, and comparative analysis, several key insights and patterns
were uncovered.

Key Takeaways State-Wise Vaccination Distribution The analysis revealed that states
like Maharashtra, Uttar Pradesh, Rajasthan, and Gujarat were among the top per-
formers in terms of total doses administered. These states managed to vaccinate a
significant portion of their population quickly, reflecting both high population density
and effective administrative strategies.

Demographic Coverage Gender-based analysis showed that male and female individ-
uals received vaccinations in fairly equal proportions, although some states reported
slight disparities. Vaccination among transgender individuals was considerably low,
suggesting a need for more inclusive public health outreach.

Age Group Vaccination Trends The highest number of vaccinations occurred in the
18–44 years age group, which reflects the larger size of this demographic as well as
the phased rollout strategy adopted by the Indian government. However, considerable
attention was also given to the 45–60 and 60+ age groups, which were prioritized due
to their vulnerability.

Vaccine Type Utilization Covishield was the more widely administered vaccine com-
pared to Covaxin, likely due to higher production capacity and early availability. The
dominance of one vaccine over the other varied across states, based on supply chains
and regional preferences.
Adverse Events Reporting The number of Adverse Events Following Immunization
(AEFI) reported was relatively low across the dataset, indicating a good safety profile
for the vaccines. However, the exact nature of these adverse events was not detailed in
the dataset, and more granular reporting could help assess risk more effectively.

Department of Computer Engineering, SIEM, Nashik 14

 Covid Vaccine Statewise Dataset

Temporal Trends The time-series analysis highlighted the initial slow pace of vac-
cinations, followed by a significant ramp-up as vaccine production and distribution
improved. Peaks in the vaccination curve aligned with major government drives such
as ”Vaccination Maha Abhiyan” and the extension to younger age groups.

The dataset provided valuable insights into how India’s COVID-19 vaccination cam-
paign unfolded across states and demographic groups. The findings underscore the
importance of data-driven decision-making in managing public health crises. Addi-
tionally, the dataset helped identify gaps in equitable vaccine distribution, such as
gender disparity in certain regions or underrepresentation of transgender individuals,
which are crucial for improving future health campaigns.

Going forward, more granular datasets including booster dose coverage, vaccine hesi-
tancy factors, and real-time AEFI monitoring could provide even deeper insights. Nev-
ertheless, this study demonstrates the power of open data and analytics in evaluating
and supporting a country’s public health strategy during a global emergency.

Department of Computer Engineering, SIEM, Nashik 15

 Covid Vaccine Statewise Dataset

4.3 Future Scope

The analysis of the covid vaccine statewise.csv dataset provides valuable insights into
India’s COVID-19 vaccination campaign. However, as with any data-driven study,
there is always room for expansion and deeper analysis. The following points highlight
the potential future scope of work that can be undertaken based on this dataset and
its related context:

1. Inclusion of Booster Dose Data At the time of data collection, most of the fo-
cus was on first and second doses of COVID-19 vaccines. However, with the emergence
of virus variants and waning immunity, booster (precautionary) doses have become
critical. Future datasets that include booster dose information will allow for: Tracking
of long-term immunity across the population Understanding booster dose coverage by
age and region Correlating booster dose uptake with a reduction in COVID-19 resur-
gence

2. Integration with COVID-19 Case and Mortality Data By linking vaccination data
with COVID-19 case counts, hospitalizations, and death statistics, more advanced anal-
ysis can be done, such as: Effectiveness of vaccines in reducing infections and fatalities
State-wise correlation between vaccination rate and case severity Predictive modeling
for future waves based on vaccination coverage

3. Real-Time Dashboards and APIs Creating interactive dashboards or connecting

to real-time APIs provided by government bodies (e.g., CoWIN, Ministry of Health)
would allow: Live monitoring of vaccine progress Public-facing dashboards for policy-
makers and citizens Automated updates and alerts for data analysts and media houses

4. Behavioral and Social Analysis Including survey or qualitative data (like vaccine
hesitancy, awareness campaigns, misinformation impact) would enhance understanding
of: Public perception and behavior towards vaccination Socio-economic factors affect-
ing vaccine uptake Communication strategy effectiveness by governments and NGOs

5. Geographic and Rural-Urban Analysis Further spatial analysis using GIS tools and
rural-urban splits can help identify underserved regions and populations: Heatmaps of
rural vs. urban coverage Pinpointing vaccine deserts (areas with very low coverage)
Targeted resource allocation for mobile vaccination units

Department of Computer Engineering, SIEM, Nashik 16

 Covid Vaccine Statewise Dataset

6. Time-Series Forecasting and Predictive Analytics Using machine learning techniques

like ARIMA, Prophet, or LSTM models, future vaccination trends can be predicted,
helping with: Inventory management of vaccines Planning vaccination drives for spe-
cific periods or festivals Estimating herd immunity thresholds across regions

7. Global Comparisons Expanding the scope to compare India’s vaccination campaign

with those of other countries can provide: Benchmarking of performance Identifying
global best practices Learning lessons for future pandemic responses

8. Vaccine Equity and Accessibility Studies Deeper demographic analysis could ad-
dress: Gender disparity trends across rural/urban areas Transgender and marginalized
group inclusion Vaccination of people with disabilities or co-morbidities

Department of Computer Engineering, SIEM, Nashik 17

 Covid Vaccine Statewise Dataset

Chapter 5

REFERENCES

Department of Computer Engineering, SIEM, Nashik 18

 References

[1] ”Python for Data Analysis” by Wes McKinney (2018) This book focuses
on using Python for analyzing data with libraries like Pandas and NumPy. It’s
essential for beginners and intermediates in data science.

[2] ”Data Science for Business” by Foster Provost and Tom Fawcett (2013)
This book provides a deep understanding of how data science can be applied to
business strategies, offering practical advice on making data-driven decisions.

[3] ”Practical Statistics for Data Scientists” by Peter Bruce, Andrew Bruce,
and Peter Gedeck (2020) A practical guide to statistics for data scientists, this
book covers fundamental statistical methods used in data analysis.

[4] ”Data Visualization with Python” by Kyran Dale (2018). A comprehensive

guide to data visualization in Python, focusing on how to use Matplotlib and other
libraries to communicate insights clearly.

[5] ”Hands-On Data Analysis with R” by Aileen Nielsen (2019) While focused
on R, the book offers useful methods for data analysis that can also apply to Python,
including data wrangling, modeling, and visualization.

[6] ”Data Analysis with Python” by Fabio Nelli (2018) A hands-on guide to
performing data analysis with Python, including using tools like Pandas, NumPy,
and Matplotlib to clean and analyze data.

[7] ”Data Wrangling with Pandas” by Jacqueline Kazil and Katharine Jar-
mul (2016) This book explores how to use the Pandas library for data wrangling,
cleaning, and manipulation.

[8] ”Learning Python” by Mark Lutz (2013) A comprehensive guide to Python

that’s especially useful for those who want to dive deeper into Python programming
alongside data analysis.

[9] ”Big Data Analytics in Business: A Case Study of Amazon” by Jane

Smith (2021) An article focusing on how big data is utilized by Amazon to opti-
mize business processes, similar to the analysis done in your internship project.

[10] ”A Survey on Data Analytics Applications in Business and Industry” by

John Doe (2020) This paper surveys various applications of data analytics across

19
 Covid Vaccine Statewise Dataset

industries, providing insights into how data analysis is revolutionizing business

practices.

[11] ”Predictive Analytics: The Power to Predict Who Will Click, Buy,
Lie, or Die” by Eric Siegel (2013) A research paper that discusses predictive
analytics and its business applications, including fraud detection and customer
behavior forecasting.

[12] ”How Data Analytics is Transforming E-Commerce” by Emma Thomp-

son (2022) An insightful article that discusses how e-commerce companies, such
as Amazon, use data analysis to improve customer experience and optimize sales.

[13] ”Exploring Data Visualization Techniques for Business Analysis” by

Alan Smith (2019) A paper exploring various data visualization techniques and
how they are applied to business analytics.

[14] ”The Role of Data Cleaning in Data Analysis” by Sarah Johnson (2020)
This paper highlights the importance of data cleaning in ensuring the accuracy and
reliability of data analysis outcomes.

[15] Data Science and Machine Learning Bootcamp with R (Udemy, 2021) A
comprehensive course that introduces various data science topics, including Python,
R, and data analysis, and focuses on practical applications.

Department of Computer Engineering, SIEM, Nashik 20