3. Pandas Basic Quiz II

df = df.drop("B", axis=1)

Which of the following drops column "B" permanently?

• Yes, if inplace=True

• Yes, because reassigned to df

• No, needs df.drop(columns="B")

• No, drop doesn’t work for columns

Which method is used to sort dataframe by values in column "Age"

• df.sort("Age")

• df.sort_values("Age")

• df.sort_index("Age")

• df["age"].sort_values()

• df["age"].sort_index()

What does df.describe() do?

• Shows first 5 rows

• Returns summary statistics of numeric columns

• Returns summary statistics from all colums

• Prints schema of DataFrame

• error

What is the result of..

• Mean of each row

• Mean of each column

• Single scalar mean

• error

Which code groups DataFrame by column "Department" and takes mean?

• df.groupby("Department").mean()

• df.aggregate("Department", "mean")

• df.Department.mean()
  

• df.mean().groupby("Department")

• df["Department"].mean()

What will this output?

• Keeps NaN unchanged

• Replaces all NaN with 0

• Drops rows with NaN

• Error

Which method resets index back to default (0,1,2...)?

• df.drop_index()

• df.reset_index()

• df.rename_index()

• df.index.reset()

• df.set_index()

Lengkapi kode berikut untuk menampilkan pelanggan dengan jumlah pembelian lebih dari 3

Apa hasil dari kode tersebut?

• Error

• None

• 85

• 
  Menampilkan baris ke-3

• Hanya kolom 'Nama'

What will this code output?

• A grouped DataFrame with row counts

• Sum of B grouped by A

• Mean of B grouped by A

• Error