DataFrame Operations Quiz

How do you create a DataFrame from a dictionary?

• pd.DataFrame(dict)

• pd.DataFrame.from_dict()

• pd.DataFrame(data)

• pd.DataFrame.from_dict(data)

How do you read a CSV file into a DataFrame?

• pd.read_csv('file.csv')

• pd.read_file('file.csv')

• pd.read('file.csv')

• pd.DataFrame('file.csv')

How can you display the first 5 rows of a DataFrame?

• df.show(5)

• df.head(5)

• df.first(5)

• df.top(5)

How do you access a specific column in a DataFrame?

• df.column('Age')

• df.columns.Age

• df['Age']

• df.Age

How do you filter rows based on a condition?

• df.filter(df['Age'] >= 30)

• df.loc[df['Age'] >= 30]

• df[df['Age'] >= 30]

• df.select(df['Age'] >= 30)

How do you add a new column to the DataFrame?

• df.insert('Salary', [50000, 60000, 70000])

• df['Salary'] = [50000, 60000, 70000]

• df.set_column('Salary', [50000, 60000, 70000])

• df.add_column('Salary', [50000, 60000, 70000])

How do you rename a column in a DataFrame?

• df.rename_column('Age', 'Years', inplace=True)

• df.rename_column({'Age': 'Years'}, inplace=True)

• df.rename(columns={'Age': 'Years'}, inplace=True)

• df.rename({'Age': 'Years'}, inplace=True)

How do you remove a column from a DataFrame?

• df.remove('Salary', axis=1, inplace=True)

• df.drop('Salary', axis=1, inplace=True)

• df.delete('Salary', axis=1, inplace=True)

How can you check for missing values in a DataFrame?

• df.isna().sum()

• df.isnull().sum()

• df.is_empty().sum()

• df.missing().sum()

How do you group data by a specific column and calculate the mean?

• df.groupby('Name').mean()

• df.group_by('Name').mean()

• df.group('Name').mean()

• df.aggregate('Name').mean()