Cleaning in Python Quiz

Which Python library is most commonly used for data cleaning and manipulation?

• NumPy

• SciPy

• Pandas

• Matplotlib

What is the function used in Pandas to identify missing values in a DataFrame?

• isna()

• fillna()

• dropna()

• replace()

How do you remove duplicate rows from a Pandas DataFrame?

• DataFrame.drop_duplicates()

• DataFrame.dropna()

• DataFrame.remove_duplicates()

• DataFrame.fillna()

What method would you use to fill missing values in a DataFrame with the mean of a column?

• fillna(mean)

• fill(mean)

• replace(na,mean)

• fillna(DataFrame['column_name'].mean())

Which function in Pandas is used to detect and remove outliers in a dataset?

• DataFrame.describe()

• DataFrame.dropna()

• DataFrame.clip()

• There is no direct function; outliers are typically handled using custom methods like IQR or Z-score.

What function can you use in Pandas to rename the columns of a DataFrame?

• rename_columns()

• rename()

• columns_rename()

• change_columns()

How can you convert all string values in a DataFrame column to lowercase using Pandas?

• DataFrame['column_name'].lower()

• DataFrame['column_name'].apply(lower)

• DataFrame['column_name'].str.lower()

• DataFrame['column_name'].convert_lower()

Which of the following methods can be used to handle missing data in a DataFrame?

• fillna()

• dropna()

• interpolate()

• All of the above

How do you replace all occurrences of a specific value in a DataFrame column with another value?

• DataFrame.replace(value1,value2)

• DataFrame.update(value1,value2)

• DataFrame.fillna(value1,value2)

• DataFrame.substitute(value1,value2)

Which method in Pandas allows you to drop a specific column from a DataFrame?

• DataFrame.drop(columns=['column_name'])

• DataFrame.remove('column_name')

• DataFrame.delete('column_name')

• DataFrame.erase('column_name')