Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
★★★★★
3.36 Rating (168 Votes )
There are 3 Steps involved in it
Step: 1
The detailed answer for the above question is provided below Ans Here is the Python code for the all ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started