Skip to content
Spinner
DataFrameas
df
variable
SELECT * FROM 'Nigeria COVID 19 Data.csv';
import pandas as pd
df.head()
df.info()
df.describe()
print(df.dtypes)
missing_value_count = df.isnull().sum()
missing_value_count
df = df.set_index('Date')
df.head()
import matplotlib.pyplot as plt

df.boxplot(fontsize=6, vert=False)
plt.show()
print(df.describe())
#Only select numeric columns before calling mean(), std(), idxmax()
numeric_df = df.select_dtypes(include='number')

print(numeric_df.mean().idxmax())
print(numeric_df.std().idxmax())
df['Total No of Cases'].plot(figsize=(12, 6))
plt.title('Time Series Line Graph: Total Cases')
plt.xlabel('Date')
plt.ylabel('Values')
plt.legend(loc='best', fontsize=8)
plt.show()
df['Total No of Deaths'].plot(figsize=(12, 6))
plt.title('Time Series Line Graph: Total Deaths')
plt.xlabel('Date')
plt.ylabel('Values')
plt.legend(loc='best', fontsize=8)
plt.show()
df['Total No Discharged'].plot(figsize=(12, 6))
plt.title('Time Series Line Graph: Total Discharged Patients')
plt.xlabel('Date')
plt.ylabel('Values')
plt.legend(loc='best', fontsize=8)
plt.show()