Python Study Group: Week 4

What function in pandas is typically used to remove duplicate rows?

• `drop_duplicates()`

• `unique()`

• `dropna()`

• `remove()`

What is the primary function of the `merge()` function in pandas?

• To concatenate two DataFrames vertically

• To perform element-wise operations

• To combine DataFrames using a common key

• To clean data by removing NaN values

What is the result of calling df.duplicated().sum() on a DataFrame df?

• The number of duplicate rows in df

• The number of unique rows in df

• The total number of rows in df

• The number of rows with missing values indf

What is the primary function of the dropna() method in pandas?

• 
  Fill missing values with a specified value

• Remove columns of a specific data type

• Remove rows with missing values

• Detect and remove outliers

Which method should be used to replace missing values with an aggregate of a column in a pandas DataFrame?

• replace()

• fillna()

• mean()

• transform()

When merging two DataFrames in pandas, what does the `how` parameter specify?

• The type of merge to perform (e.g., 'left', 'right', 'outer', 'inner')

• The key to join on

• How to sort the result

• How to handle missing values

Which of the following is NOT a correct way to filter a DataFrame `df` to keep all rows where the column 'age' is greater than 25?

• `df[df['age'] > 25]`

• `df.filter(df['age'] > 25)'

• `df.query('age > 25')`

What does the `inplace` parameter do when set to True in pandas functions like `dropna()`?

• It creates a new DataFrame with the operation applied

• It saves the changes to a file

• It modifies the original DataFrame

• It prints the result to the console

Which Python method is used to change the data type of a pandas DataFrame column?

• convert_dtype()

• change_type()

• astype()

• dtype()

How can you concatenate two pandas DataFrames vertically?

• Using the `concat()` function with the parameter `axis=0`

• Using the `merge()` function with the parameter `axis=0`

• Using the `join()` function with the parameter `axis=1`

• Using the `append()` method of a DataFrame