064. Extra Help

Which 2 modules do you need for this assignment?

• pandas

• math

• matplotlib

• random

Fill in the blank to create a data frame from the CSV file

import pandas as pd

file = "Dogs.CSV"

df = pd. (a)   (file)

Fill in the blank to create a data frame from the XLSX file

import pandas as pd

file = "Dogs.XLSX"

df = pd. (a)   (file)

Fill in the blank to turn the column from the data frame into a list

import pandas as pd

df = read_csv("Dogs.csv")

column = df["Minimum Weight"]

colList = column. (a)   ( )

Match the method of creating a graph to each type of chart with data from a data frame read from a CSV

• histogram

• df[weight].plot(kind='hist')

• line

• df[weight].plot( )

• scatter plot

• df.plot(kind='scatter', x=weight, y=height)

To create a bar or pie chart which of the following do you need to do with the data in the list?

• Convert the list to a set to get the unique values, then convert it back to a list and then create a parallel list to perform a frequency analysis.

• Do a frequency analysis and then make the frequencies a list