Exercise 1:

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").

Read COVID-19 dataset using pandas Dataframe.

Define a function called DF_Info() the receives a dataframe and prints (1) shape of Dataframe; (2) columns; (3) index.

Print the datatype of each column.

Show the statistical summary (e.g., count, mean, std, min, max) of the Dataframe.

Print the values of the third column.

Print the rows from 5 to 25 and columns from 2 to 5.

Check and print if country column contains duplicate values.

Exercise 2:

Exercise Objectives:

Using basic shell commands in IPython.

Using output statement in shell commands.

Printing and listing the working directory and its contents.

Creating new directory.

Problem Description:

Use `DF_Info()` function that you implemented Exercise 1 (Copy it) and save that function as a script (DataFrameInfo.py) using the shell command. You are supposed to read covid_19 dataset using pandas dataframe and call `DF_Info()` in DataFrameInfo.py

Run "DataFrameInfo.py" using shell-related magic commands.

Print your name & Id using the print Shell command.

Print the working directory.

Print the contents of the working directory.

Create a new directory and name it as your Id.

Move "mnist_test.csv" from the sample_data directory to your new directory.

Change the working directory to be your new directory.

Print the contents of the working directory.