MCQs on CSV in DataFrame (Python)

Which Python library is commonly used for handling CSV files and DataFrames?

• numpy

• pandas

• matplotlib

• scipy

Which of the following commands is used to read a CSV file into a DataFrame in Python?

• pd.read_csv('file.csv')

• pd.read_file('file.csv')

• pd.load_csv('file.csv')

• pd.open_csv('file.csv')

What is the default delimiter used by the read_csv() function in pandas?

• Semicolon (;)

• Colon (:)

• Comma (,)

• Tab (\t)

How can you export a DataFrame to a CSV file named "output.csv"?

• df.export_csv('output.csv')

• df.write_csv('output.csv')

• df.save('output.csv')

• df.to_csv('output.csv')

Which parameter should you use in read_csv() to specify a different delimiter, such as a semicolon?

• delimiter=';'

• sep=';'

• separator=';'

• delim=';'

What does the following command do? df = pd.read_csv('data.csv', header=None)

• Reads the CSV file and sets the first row as the header.

• Reads the CSV file without using the first row as the header.

• Reads the CSV file and skips the first row.

• Reads only the header of the CSV file.

If you want to skip the first 3 rows while reading a CSV file, which parameter should you use?

• skiprows=3

• skipfirst=3

• skipheader=3

• skiplines=3

How can you prevent the to_csv() function from writing the DataFrame index to the output file?

• index=False

• no_index=True

• drop_index=True

• remove_index=False

Which of the following code snippets correctly reads a CSV file and assigns custom column names?

• pd.read_csv('file.csv', names=['A', 'B', 'C'])

• pd.read_csv('file.csv', columns=['A', 'B', 'C'])

• pd.read_csv('file.csv', header=['A', 'B', 'C'])

• pd.read_csv('file.csv', labels=['A', 'B', 'C'])

What is the purpose of the encoding parameter in the read_csv() function?

• To specify the delimiter used in the file

• To set the encoding format of the CSV file (e.g., UTF-8)

• To change the column names

• To filter rows based on a condition