This blog explores data science and networking, combining theoretical concepts with practical implementations. Topics include routing protocols, network operations, and data-driven problem solving, presented with clarity and reproducibility in mind.
Visualizing COVID-19 Cases for December Using Python
Visualizing COVID-19 Cases for December Using Python
Data visualization is one of the most important parts of data analysis.
Raw data stored inside spreadsheets or CSV files can be difficult to understand without proper visualization.
Using Python libraries such as Pandas and Matplotlib, we can process large datasets and create meaningful visual representations.
In this tutorial, we will learn how to:
Read COVID-19 data from a CSV file
Preprocess the dataset
Convert date values into datetime format
Extract months from dates
Filter records for December
Create a line plot of COVID-19 cases
Save the visualization as an image
Key Learning Objective:
By the end of this tutorial, you will understand how time-series datasets are handled in Python and how to generate meaningful visualizations using Pandas and Matplotlib.
This formula helps analysts measure how rapidly infections increase or decrease.
6. Setting Date as Index
df.set_index('date', inplace=True)
The date column becomes the DataFrame index.
This improves time-series operations and plotting.
date
2020-12-01
2020-12-02
2020-12-03
7. Filtering Data for December
df[df['month']==12]['cases']
Explanation
df['month']==12 filters December rows.
['cases'] selects only the cases column.
This produces a dataset containing only December COVID-19 case numbers.
8. Creating the Line Plot
df[df['month']==12]['cases'].plot()
This creates a line graph showing daily COVID-19 cases for December.
Why Use a Line Plot?
Line plots are excellent for time-series data because they:
Show trends clearly
Display increases and decreases
Highlight spikes in cases
Reveal patterns over time
Understanding Graph Slopes
The slope of the graph indicates the rate of change.
Slope formula:
$$
m = \frac{y_2 - y_1}{x_2 - x_1}
$$
Where:
\(y\) represents cases
\(x\) represents days
A positive slope means increasing cases.
A negative slope means decreasing cases.
9. Saving the Plot
plt.savefig('plot.png')
This saves the visualization as an image file.
Benefits of Saving Plots
Easy sharing
Documentation
Report generation
Presentation usage
Research publication
10. Displaying the Plot
plt.show()
This displays the graph on the screen.
Important:
Without plt.show(), some environments may not display the graph visually.
Complete Python Program
import pandas as pd
import matplotlib.pyplot as plt
# Read CSV file
df = pd.read_csv("ca-covid.csv")
# Remove unnecessary column
df.drop('state', axis=1, inplace=True)
# Convert date column to datetime
df['date'] = pd.to_datetime(df['date'], format="%d.%m.%y")
# Extract month
df['month'] = df['date'].dt.month
# Set date as index
df.set_index('date', inplace=True)
# Plot December cases
df[df['month']==12]['cases'].plot()
# Save plot
plt.savefig('plot.png')
# Display plot
plt.show()
Expected Output
The output will include:
A line graph showing daily COVID-19 cases for December
A saved image file named plot.png
A visual display of the graph on screen
Conclusion
This tutorial demonstrated how Python can be used to preprocess and visualize COVID-19 data efficiently.
Using Pandas and Matplotlib together provides a powerful framework for handling time-series datasets and generating insightful visualizations.
The workflow included:
Reading CSV data
Cleaning unnecessary columns
Converting dates
Extracting month values
Filtering December records
Creating a line chart
Saving the plot as an image
These same techniques can be applied to:
Stock market analysis
Weather forecasting
Traffic analysis
Business analytics
Scientific research
Healthcare reporting
Final Takeaway:
Data visualization transforms raw information into understandable insights.
Learning Pandas and Matplotlib is a foundational step toward mastering data science and analytics.
