062. Extra Help

Complete the import statement to use a data frame

import ______

Complete the code to get the data from the "Sample Excel.xlsx" file

import pandas as pd

file = "Sample Excel.xlsx"

pd = ​ (a)   .​ (b)   (​ (c)   )

• df
• read_xlsx
• file

Complete the code to turn the "Names" column of "Sample Excel.xlsx" into a list

import pandas as pd

file = "Sample Excel.xlsx"

df = pd.read_xlsx(file)

colList = df["Names"]._______( )

Fill in the blank to remove blank rows from the data frame

import pandas as pd

file = "Sample Excel.xlsx"

df = pd.read_xlsx(file)

df = ______(in place = True)

Complete the code to replace all blank rows with "Joe"

import pandas as pd

file = "Sample Excel.xlsx"

df = pd.read_xlsx(file)

df.​ (a)   (​ (b)   , inplace = True)

• fillna
• "Joe"
• fill_blank
• Jow
• Joe
• fill