Pandas Proficiency Quiz for Students

What is a DataFrame in pandas?

• A one-dimensional array with axis labels

• A two-dimensional, size-mutable, potentially heterogeneous tabular data structure

• A three-dimensional array with fixed size

• A single value container

Which method is used to read a CSV file into a pandas DataFrame?

• read_excel()

• read_json()

• read_csv()

• read_html()

How can you select a column named 'Age' from a DataFrame `df`?

• df['Age']

• df.Age()

• df.select('Age')

• df.get('Age')

Which function is used to remove missing values from a DataFrame?

• fillna()

• dropna()

• replace()

• isnull()

What does the `head()` method do in pandas?

• Returns the last 5 rows of a DataFrame

• Returns the first 5 rows of a DataFrame

• Returns a summary of the DataFrame

• Returns the column names of a DataFrame

How can you add a new column 'Height' to a DataFrame `df` with all values set to 170?

• df['Height'] = 170

• df.add_column('Height', 170)

• df.insert('Height', 170)

• df.append('Height', 170)

Which method is used to plot a histogram of a DataFrame column?

• plot.hist()

• hist.plot()

• plot.bar()

• plot.line()

What is the purpose of the `groupby()` function in pandas?

• To sort the DataFrame

• To group data based on some criteria

• To filter data based on a condition

• To merge two DataFrames

Which of the following is a method to merge two DataFrames in pandas?

• join()

• append()

• concat()

• merge()

How can you convert a DataFrame to a NumPy array?

• df.to_numpy()

• df.to_array()

• df.as_matrix()

• df.to_list()