Pandas/Python

Question 1

What function is used to read a CSV file in pandas?

Answer 1

pd.read_csv()

Question 2

True or False: The function pd.DataFrame() is used to create a DataFrame in pandas.

Answer 2

True

Question 3

Fill in the blank: To display the first five rows of a DataFrame, you use the function ___.

Answer 3

df.head()

Question 4

Which method is used to calculate the mean of a DataFrame column?

Answer 4

mean()

Question 5

What is the syntax to filter a DataFrame ‘df’ for rows where the column ‘age’ is greater than 30?

Answer 5

df[df[‘age’] > 30]

Question 6

What is the primary purpose of the groupby() function in data analysis?

Answer 6

The primary purpose of the groupby() function is to split the data into groups based on some criteria and then apply a function to each group.

Question 7

True or False: The groupby() function can only be used with numerical data.

Answer 7

False

Question 8

Fill in the blank: The syntax for the groupby() function is ___.

Answer 8

dataframe.groupby(by=<column_name>)</column_name>

Question 9

Which method can be used after groupby() to aggregate data?

Answer 9

The agg() method can be used after groupby() to aggregate data.

Question 10

What does the ‘by’ parameter in the groupby() function specify?

Answer 10

The ‘by’ parameter specifies the column or columns to group the data by.

Question 11

What is the code to convert all column names to lowercase?

Answer 11

df.columns = df.columns.str.lower()