Pandas Interview Questions and Answers

Ques 11. How to select specific columns in a DataFrame?

You can select specific columns using double square brackets: df[['Column1', 'Column2']]

Ques 12. What is the purpose of the describe() function in Pandas?

describe() provides summary statistics of numeric columns in a DataFrame.

Example:

df.describe()

Ques 13. Explain the concept of broadcasting in Pandas.

Broadcasting allows operations between arrays of different shapes and sizes.

Example:

df['Column'] = df['Column'] * 2

Ques 14. How to filter rows in a DataFrame based on a condition?

You can use boolean indexing to filter rows based on a condition: df[df['Column'] > 10]

Ques 15. What is the purpose of the pivot_table() function?

pivot_table() is used to create a spreadsheet-style pivot table as a DataFrame.

Example:

pd.pivot_table(df, values='Value', index='Index', columns='Column', aggfunc=np.sum)