Python获取在数据帧中出现最多的类别对

import pandas as pd

df = pd.DataFrame({'A': ['apple', 'banana', 'apple', 'banana', 'apple'],
                   'B': ['red', 'green', 'red', 'red', 'yellow']})

counts = df.groupby(['A', 'B']).size().reset_index(name='count')

most_common = counts.loc[counts['count'].idxmax()]

import pandas as pd

df = pd.DataFrame({'A': ['apple', 'banana', 'apple', 'banana', 'apple'],
                   'B': ['red', 'green', 'red', 'red', 'yellow']})

counts = df.groupby(['A', 'B']).size().reset_index(name='count')
most_common = counts.loc[counts['count'].idxmax()]

print('Most common category pair:', most_common['A'], '-', most_common['B'])
print('Count:', most_common['count'])

Most common category pair: apple - red
Count: 2