import numpy as np
import pandas as pd
df = pd.DataFrame({
'a': [4, 5, 3, 1, 2],
'b': [20, 10, 40, 50, 30],
'c': [25, 20, 5, 15, 10]
})
def sort_value(column):
new_column = column.sort_values(ascending = False)
return new_column.iloc[1]
def second_largest(df):
return df.apply(sort_value)
print second_largest(df)
a 4
b 40
c 20
dtype: int64