Weeks 3-4 QUIZ Data Manipulation

Which function is used to read a CSV file into a pandas DataFrame?

• A. pd.read_csv()
  

• B. pd.read_file()
  

• C. pd.load_csv()
  

• D. pd.csv_read()

How can you write a pandas DataFrame to an Excel file?

• A. df.to_excel()

• B. df.save_excel()

• C. df.export_excel()

• D. df.write_excel()

Which argument in read_csv() is used to specify a column as the index of the DataFrame?

• A. index_col

• B. set_index

• C. column_index

• D. use_index

What does the header parameter in read_csv() control?

• A. Whether to read data in chunks

• B. The number of columns to read

• C. Which row to use as the header

• D. The data types of columns

Which method is used to check the first few rows of a DataFrame?

• A. head()

• B. first()

• C. top()

• D. preview()

What method would you use to handle missing values in a pandas DataFrame?

• A. dropna()

• B. fillna()

• C. Both A and B

• D. remove_na()

Which function removes duplicates from a DataFrame?

• A. drop_duplicates()

• B. clear_duplicates()

• C. remove_duplicates()

• D. discard_duplicates()

What does the replace() function do in pandas?

• A. Removes values

• B. Adds new values

• C. Replaces old values with new ones

• D. Converts data types

How can you reset the index of a DataFrame?

• A. reset_index()

• B. clear_index()

• C. remove_index()

• D. drop_index()

Which method is used to drop rows with missing values?

• A. dropna()

• B. remove_missing()

• C. clear_na()

• D. delete_na()