Day 6 and 7

Which method would you use to concatenate two DataFrames?

• pd.merge()

• pd.join()

• pd.concat()

• pd.append()

How can you check the first 5 rows of a DataFrame named df?

• df.head()

• df.first(5)

• df.rows(5)

• df.show(5)

How do you delete a column in a dataframe permanently?

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

• 1. df.drop('new_column', axis=1)

• 1. df.drop('new_column')

• 1. df.drop('new_column', axis=1, inplace=False)

Which is the correct way to select a column from a DataFrame named df?

• df.select('column_name')

• df['column_name']

• df.column_name

• Both B and C are correct.

Which method is used to replace missing values in a DataFrame df?

• df.fillna(value)

• df.replace_null(value)

• df.set_values(value)

• df.impute(value)

How can you set multiple columns as the index of a DataFrame df?

• df.set_index(['col1', 'col2'])

• df.index(['col1', 'col2'])

• df.primary_key(['col1', 'col2'])

• df.use_index(['col1', 'col2'])

What is the output of df.describe() where df is a DataFrame?

• A DataFrame summarizing the mean, median, and mode of each column

• A DataFrame showing the first, second, and third quartiles of each column

• A DataFrame providing descriptive statistics

• A DataFrame listing the maximum and minimum values of each column

Which method is used to sort a DataFrame df by the values of a column named 'col1'?

• df.sort_values(by='col1')

• df.order_by('col1')

• df.sort('col1')

• df.sort_by_column('col1')

How can you combine the data from two DataFrames, df1 and df2, based on a common column named 'key'?

• pd.join(df1, df2, using='key')

• pd.merge(df1, df2, on='key')

• pd.concat([df1, df2], key='key')

• df1.combine(df2, along='key')

Which of the following is true when using df.iloc[0]?

• It selects the first row of the DataFrame df based on index position.

• It selects the first column of the DataFrame df.

• It selects the first row of the DataFrame df based on index label.

• It raises an error if df is not indexed numerically.