Pandas

1. Which method is used to select rows based on their labels in a pandas DataFrame?

• A) df.loc[]

• B) df.iloc[]

• C) df.at[]

• D) df.iat[]

2. To select data by integer location in a pandas DataFrame, which method should you use?

• A) df.loc[]

• B) df.iloc[]

• C) df.at[]

• D) df.iat[]

3. What does df[df['column'] > 5] return in pandas?

• A) All rows where 'column' values are greater than 5

• B) All columns where any value is greater than 5

• C) The original DataFrame unchanged

• D) An error message

4. Which method is used to combine two DataFrames along rows in pandas?

• • A) pd.merge()

• • B) df.append()

• • C) pd.join()

• • D) pd.concat()

5. What is the primary function of pd.merge() in pandas?

• • A) Concatenate DataFrames vertically

• • B) Merge DataFrames horizontally based on a key

• • C) Append one DataFrame to another

• • D) Stack DataFrames

6. Which parameter in df.groupby() specifies the aggregation function?

• • A) by

• • B) function

• • C) agg

• • D) as_index

7. When performing a pd.merge(), which parameter defines the type of merge to be performed?

• • A) on

• • B) how

• • C) left_on

• • D) right_on

8. Which method allows you to merge two DataFrames using their indexes?

• • A) pd.merge(df1, df2, on='index')

• • B) df1.join(df2)

• • C) pd.concat([df1, df2], axis=1)

• • D) pd.merge(df1, df2, left_index=True, right_index=True)

9. How do you set a column as the index of a DataFrame in pandas?

• • A) df.set_column('column_name')

• • B) df.set_index('column_name')

• • C) df.index = df['column_name']

• • D) df['column_name'].set_index()

10. Which method would you use to rename columns in a pandas DataFrame?

• • A) df.rename(columns={'old_name': 'new_name'})

• • B) df.columns = 'new_name'

• • C) df.set_columns('new_name')

• • D) df.rename_index({'old_name': 'new_name'})