Python & Pandas:将多行合并为单个单元格

import pandas as pd

# 创建一个DataFrame对象
data = {'Name': ['Tom', 'Nick', 'John', 'Tom', 'Nick'],
        'Score': [90, 85, 92, 87, 80]}
df = pd.DataFrame(data)

# 使用groupby函数将数据按照Name列进行分组，并对Score列进行求和操作
result = df.groupby('Name')['Score'].sum()

print(result)

Name
John    92
Nick    165
Tom     177
Name: Score, dtype: int64

import pandas as pd

# 创建一个DataFrame对象
data = {'Name': ['Tom', 'Nick', 'John', 'Tom', 'Nick'],
        'Score': [90, 85, 92, 87, 80]}
df = pd.DataFrame(data)

# 使用agg函数将数据按照Name列进行分组，并对Score列应用sum和mean两个聚合函数
result = df.groupby('Name')['Score'].agg(['sum', 'mean'])

print(result)

      sum  mean
Name           
John   92  92.0
Nick  165  82.5
Tom   177  88.5