df=pd.DataFrame()
a=[1,1,1,2,2,]
b=['red','red','green','red','blue']
df['a']=a
df['b']=b
df.groupby('a').agg(lambda x: x.value_counts().index[0]).reset_index()
df=pd.DataFrame()
a=[1,1,1,2,2,]
b=['red','red','green','red','blue']
df['a']=a
df['b']=b
df.groupby('a').agg(lambda x: x.value_counts().index[0]).reset_index()