Quiz on Pandas

What does df.to_csv('file.csv', index=False) do?

• Reads a CSV file

• Saves the DataFrame to CSV without row index

• Deletes the DataFrame

• Converts DataFrame to Excel

Which of the following creates an empty DataFrame?

• pd.empty()

• pd.createframe()

• pd.DataFrame()

• pd.frame()

What is the output of df.head(3)?

• Last 3 rows

• First 3 columns

• First 3 rows

• Summary statistics

What does df['Marks'] return?

• A list

• A NumPy array

• A Series object

• A DataFrame

How can you select multiple columns in pandas?

• df.column('A','B')

• df['A','B']

• df[['A','B']]

• df.select('A','B')

What will df.shape return?

• Column names

• Number of rows

• Tuple with (rows, columns)

• Data types

Which function returns summary statistics of numeric columns?

• df.info()

• df.describe()

• df.summary()

• df.status()

How do you filter rows where Marks > 80 in a DataFrame?

• df.Marks > 80

• df('Marks') > 80

• df[df['Marks'] > 80]

• df.filter(Marks > 80)

What is the use of df.groupby('Department')?

• Filters by department

• Groups rows based on the 'Department' column

• Deletes 'Department' column

• Creates a pivot table

Which function is used to sort rows by values in pandas?

• df.sort()

• df.sortby()

• df.sort_values()

• df.arrange()