You are given a COVID-19 dataset that is a collection of the COVID-19 data maintained by...

Transcribed Image Text:

You are given a COVID-19 dataset that is a collection of the COVID-19 data maintained by Our World in Data ("covid_19.csv"). 1. Read COVID-19 dataset using pandas Dataframe. url='https://raw.githubusercontent.com/BushraAlhijawi/Data-Engineering-Course/main/Datasets Lab/covid_19.csv' 2. Define a function called DF_Info() the receives a dataframe and prints (1) shape of Dataframe; (2) columns; (3) index as follows: C Shape -> Number of rows: 6186 Number of Columns 15 Columns Lable: Index (['country', 'iso_code', 'date', 'total_vaccinations', 'people_vaccinated', 'people_fully_vaccinated', 'daily_vaccinations_raw', 'daily_vaccinations', 'total_vaccinations_per_hundred', 'people_vaccinated_per_hundred', 'people_fully_vaccinated_per_hundred', 'daily_vaccinations_per_million', 'vaccines', 'source_name', 'source_website'], dtype='object') RangeIndex(start=0, stop=6186, step=1) Index: Exercise Objectives: • Read CSV file with Pandas dataframe. • Explore the data. Problem Description: You are given a COVID-19 dataset that is a collection of the COVID-19 data maintained by Our World in Data ("covid_19.csv"). 1. Read COVID-19 dataset using pandas Dataframe. url='https://raw.githubusercontent.com/BushraAlhijawi/Data-Engineering-Course/main/Datasets Lab/covid_19.csv' 2. Define a function called DF_Info() the receives a dataframe and prints (1) shape of Dataframe; (2) columns; (3) index as follows: C Shape -> Number of rows: 6186 Number of Columns 15 Columns Lable: Index (['country', 'iso_code', 'date', 'total_vaccinations', 'people_vaccinated', 'people_fully_vaccinated', 'daily_vaccinations_raw', 'daily_vaccinations', 'total_vaccinations_per_hundred', 'people_vaccinated_per_hundred', 'people_fully_vaccinated_per_hundred', 'daily_vaccinations_per_million', 'vaccines', 'source_name', 'source_website'], dtype='object') RangeIndex(start=0, stop=6186, step=1) Index: Inline Question 1: Is there any null values in the dataset? If yes, mention the columns that contain missing column and count the number of rows with missing value per column. Answer: FILL THIS IN Inline Question 2: Mention the columns lables that you are not able to compute their statistics. Justify your answer (Why only those columns?) Answer: FILL THIS IN You are given a COVID-19 dataset that is a collection of the COVID-19 data maintained by Our World in Data ("covid_19.csv"). 1. Read COVID-19 dataset using pandas Dataframe. url='https://raw.githubusercontent.com/BushraAlhijawi/Data-Engineering-Course/main/Datasets Lab/covid_19.csv' 2. Define a function called DF_Info() the receives a dataframe and prints (1) shape of Dataframe; (2) columns; (3) index as follows: C Shape -> Number of rows: 6186 Number of Columns 15 Columns Lable: Index (['country', 'iso_code', 'date', 'total_vaccinations', 'people_vaccinated', 'people_fully_vaccinated', 'daily_vaccinations_raw', 'daily_vaccinations', 'total_vaccinations_per_hundred', 'people_vaccinated_per_hundred', 'people_fully_vaccinated_per_hundred', 'daily_vaccinations_per_million', 'vaccines', 'source_name', 'source_website'], dtype='object') RangeIndex(start=0, stop=6186, step=1) Index: Exercise Objectives: • Read CSV file with Pandas dataframe. • Explore the data. Problem Description: You are given a COVID-19 dataset that is a collection of the COVID-19 data maintained by Our World in Data ("covid_19.csv"). 1. Read COVID-19 dataset using pandas Dataframe. url='https://raw.githubusercontent.com/BushraAlhijawi/Data-Engineering-Course/main/Datasets Lab/covid_19.csv' 2. Define a function called DF_Info() the receives a dataframe and prints (1) shape of Dataframe; (2) columns; (3) index as follows: C Shape -> Number of rows: 6186 Number of Columns 15 Columns Lable: Index (['country', 'iso_code', 'date', 'total_vaccinations', 'people_vaccinated', 'people_fully_vaccinated', 'daily_vaccinations_raw', 'daily_vaccinations', 'total_vaccinations_per_hundred', 'people_vaccinated_per_hundred', 'people_fully_vaccinated_per_hundred', 'daily_vaccinations_per_million', 'vaccines', 'source_name', 'source_website'], dtype='object') RangeIndex(start=0, stop=6186, step=1) Index: Inline Question 1: Is there any null values in the dataset? If yes, mention the columns that contain missing column and count the number of rows with missing value per column. Answer: FILL THIS IN Inline Question 2: Mention the columns lables that you are not able to compute their statistics. Justify your answer (Why only those columns?) Answer: FILL THIS IN

Answer rating: 100% (QA)

The detailed answer for the above question is provided below Ans Here is the Python code for the all ... View the full answer