QMP4: Mini Project IV Use the following covid_vaccine_statewise.csv dataset and perform the following analytics on the given dataset. Dataset: https://www.kaggle.com/sudalairajkumar/covid19-inindia?select=covid_vaccine_statewise.csv a. Describe the dataset. b. Number of persons statewise vaccinated for first dose in India. c. Number of persons statewise vaccinated for second dose in India. d. Number of Males vaccinated. e. Number of Females vaccinated.

import pandas as pd # Load dataset df = pd.read_csv("covid_vaccine_statewise.csv") # Clean column names df.columns = df.columns.str.strip() # Convert date column df["Updated On"] = pd.to_datetime(df["Updated On"], dayfirst=True) # Sort values df = df.sort_values(by=["State", "Updated On"]) # Get latest data for each state latest = df.groupby("State").last().reset_index() # Remove India total row state_data = latest[latest["State"] != "India"] # First dose state-wise print("\nFirst Dose (State-wise):") print(state_data[["State", "First Dose Administered"]]) # Second dose state-wise print("\nSecond Dose (State-wise):") print(state_data[["State", "Second Dose Administered"]]) # Total males vaccinated total_male = state_data["Male (Doses Administered)"].sum() print("\nTotal Male Vaccinated:", int(total_male)) # Total females vaccinated total_female = state_data["Female (Doses Administered)"].sum() print("Total Female Vaccinated:", int(total_female))

Data Science Laboratory (ds) Codes

Group Mini Project

COVID Vaccine Statewise Analytics

Other Questions in Data Science Laboratory