Python Pandas Quiz

To create a new DataFrame

To pivot rows and columns in a DataFrame

To perform statistical operations on a DataFrame

To create a summary table

Use df.fillna(value) to replace missing values

Use df.dropna() to remove rows with missing values

Both A and B

Neither A nor B

Use the df.drop_duplicates() method

Use the df.remove_duplicates() method

Use the df.drop_duplicate_rows() method

Use the df.eliminate_duplicates() method

To melt a DataFrame into a longer format

To create a melted cheese plot

To melt a DataFrame into a wider format

To melt a DataFrame into a binary format

The number of non-null values

The number of unique values

The number of distinct groups

The number of unique rows

df.resample()

df.time_resample()

df.groupby("time_column").resample()

df.time_groupby().resample()

df.save_csv("filename.csv")

df.write_csv("filename.csv")

df.to_csv("filename.csv")

df.export_csv("filename.csv")

Returns the smallest values in a DataFrame

Returns the largest values in a DataFrame

Returns the smallest values in a column

Returns the largest values in a column

df.reset_index()

df.set_index()

df.index_reset()

df.index_reset()

To cut a DataFrame into smaller pieces

To categorize continuous data into discrete bins

To remove duplicate values from a DataFrame

To concatenate DataFrames along a particular axis