Pandas Interview Questions and Answers

Ques 16. How to handle duplicate values in a DataFrame?

You can use drop_duplicates() to remove duplicate rows: df.drop_duplicates()

Ques 17. Explain the purpose of the iterrows() function in Pandas.

iterrows() is used to iterate over DataFrame rows as (index, Series) pairs.

Example:

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

Ques 18. How to rename columns in a DataFrame?

You can use the rename() method to rename columns: df.rename(columns={'OldName': 'NewName'})

Ques 19. Explain the concept of MultiIndex in Pandas.

MultiIndex allows you to have multiple index levels on an axis.

Ques 20. How to handle time series data in Pandas?

Pandas provides the Timestamp type and functions like resample() for time series analysis.

Example:

df['Date'] = pd.to_datetime(df['Date'])