Interview Questions and Answers

Example:

df.groupby('column1').mean()

Example:

pd.merge(df1, df2, on='common_column')

Example:

pd.melt(df, id_vars=['id_column'], value_vars=['value_column'])

Example:

pd.concat([df1, df2], axis=1)

Example:

df['column'].nunique()

Example:

pd.cut(df['column'], bins=[0, 25, 50, 75, 100])

Example:

df.dropna().mean()

Example:

for index, row in df.iterrows():
    print(index, row['column'])

Example:

pd.get_dummies(df['column'])

Example:

df['column'] = pd.to_numeric(df['column'], errors='coerce')

Example:

pd.cut(df['column'], bins=[0, 25, 50, 75, 100])

Example:

df.pivot(index='index_column', columns='column_to_pivot', values='value_column')

Example:

pd.crosstab(df['factor1'], df['factor2'])

Example:

df.dropna().mean()