Contacts

For the following questions, the file contacts.csv is provided, with the following fields: email, first, last, phone. Data in the email field are

unique for each row and can be used as the index in a DataFrame.

Loading and getting information

a$)$ Use the pandas read$\_$csv$()$ function to load the data in contacts.csv into a DataFrame. Use the email column as the DataFrame

index. Display the data in the DataFrame.

b$)$ Use the info $()$ method to determine how many non$-$null values there are for each column and what each column's type is$.$

c$)$ Determine the number of rows and columns using the len $()$ function as well as the shape property.

d$)$ Display the first two and last two rows using head $()$ and tail $().$

Accessing rows, columns, and cells

e$)$ Display the phone column.

f$)$ Display the columns named first and last in a DataFrame.

g$)$ Display the phone number for the row with

email$=$smsmith@yahoo.com.