Batch -1 | 26-11-24 | Day-2 Data Analytics workshop Quiz

1. What does CSV stand for?

• a) Comma-Separated Values

• b) Compact System Variable

• c) Columnar Storage Values

• d) Commonly Stored Variables

2. Which of the following is NOT true about a CSV file?

• a) It is a plain text file.

• b) It uses commas to separate values.

• c) It cannot contain a header row.

• d) It is compatible with Excel.

3. Google Colab provides a Python environment with pre-installed libraries

• a) True

• b) False

• c) Sometimes

• d) Never

4. We cannot create one dataframe from another dataframe in Pandas

• a) True

• b) False

• c) Sometimes

• d) Never

5. What is the output of the following code?

import pandas as pd

data = pd.read_csv("students.csv")

print(data.head(2))

• a) First row of the CSV file

• b) First two rows of the CSV file

• c) All rows of the CSV file

• d) Last two rows of the CSV file

6. Which method in pandas is used to save a DataFrame to a CSV file?

• a) save_csv()

• b) write_csv()

• c) to_csv()

• d) export_csv()

7. What does the info() method in pandas do?

• a) Displays the first few rows of the dataset

• b) Provides summary statistics of numerical columns

• c) Gives a concise summary of the DataFrame, including column names and data types

• d) Deletes unnecessary columns from the dataset

8. How can you remove a column in a pandas DataFrame?

• a) df.drop(column_name, axis=0)

• b) df.delete(column_name)

• c) df.drop(column_name, axis=1)

• d) df.remove(column_name, axis=1)

9. Suppose you have a dataframe named df. The following command displays the column names of the dataframe.

• a) df[columns]

• b) df(columns)

• c) df.column

• d) df.columns

10. What is the purpose of the describe() method in pandas?

• a) To visualize the dataset

• b) To rename columns

• c) To display statistical summaries of numerical columns

• d) To save the dataset to a CSV file