根据另一列获取最常用的值/将pandas系列序列转换为列表的字典

import pandas as pd

# 创建示例数据
data = {'col1': ['A', 'B', 'A', 'B', 'C'],
        'col2': [1, 2, 3, 4, 5]}
df = pd.DataFrame(data)

# 根据col1列获取col2列中最常用的值
most_common_value = df.groupby('col1')['col2'].apply(lambda x: x.value_counts().idxmax())

print(most_common_value)

col1
A    1
B    2
C    5
Name: col2, dtype: int64

import pandas as pd

# 创建示例数据
data = {'col1': ['A', 'B', 'C'],
        'col2': [1, 2, 3]}
series = pd.Series(data['col2'], index=data['col1'])

# 将Series对象转换为列表的字典
dict_list = series.to_dict()

print(dict_list)

{'A': 1, 'B': 2, 'C': 3}