Python Pandas 面试题与答案

问题 36. What is the purpose of the pd.to_numeric() function?

pd.to_numeric() is used to convert argument to a numeric type.

Example:

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

问题 37. Explain the use of the pd.cut() function with the `bins` parameter.

pd.cut() is used to segment and sort data values into bins. The `bins` parameter defines the bin edges.

Example:

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

问题 38. How can you merge two DataFrames based on multiple columns?

Use the on parameter with a list of column names. pd.merge(df1, df2, on=['column1', 'column2'])

问题 39. Explain the purpose of the nlargest() function in Pandas.

nlargest() returns the first n largest elements from a DataFrame or Series.

Example:

df.nlargest(5, 'column')

问题 40. How do you pivot a Pandas DataFrame using the pivot() function?

Use the pivot() function to reshape the DataFrame based on column values.

Example:

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