如何根据索引选择对pandas列求和
'A' 'B''G9' 15 16'G10' 20 30'G9PRO' 1 11如果我选择'G9‘,我想得到这个dataFrame
'logs''A' 15'B' 16如果我选择'G9‘和'G10’,我想得到这个dataFrame
'logs''A' 35'B' 46以此类推,我尝试了sum函数,但它没有给出正确的结果
发布于 2021-09-22 00:32:45
您可以使用df.index.isin()和.sum()生成所需的结果
import pandas as pd
df = pd.DataFrame({
'A': [15, 20, 1],
'B': [16, 30, 11]
}, index=['G9', 'G10', 'G9PRO'])
df测试用例#1
selected = ['G9', 'G10']
sum_df = df[df.index.isin(selected)].sum()
A 35
B 46
dtype: int64测试用例#2
selected = ['G9']
sum_df = df[df.index.isin(selected)].sum()
A 15
B 16
dtype: int64https://stackoverflow.com/questions/69276726
复制相似问题