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.