如何使用测量权重在python中输出pd.crosstab函数?

2024-10-05 15:18:13 发布

您现在位置:Python中文网/ 问答频道 /正文

我尝试在pandas/python中运行加权交叉表,如下所示:

import pandas as pd
pd.crosstab(df.income1, df.benefits1, 
            values=df.survey_weight, aggfunc=sum)

但是,我收到以下错误消息:

pd.crosstab(df.income1, df.benefits1, 
            values=df.survey_weight, aggfunc=sum)
  File "<ipython-input-57-6e8cfb6762b2>", line 1
    pd.crosstab(df.income1, df.benefits1,
                                                            ^
SyntaxError: invalid character in identifier

有什么建议吗?我可以在运行括号内的前两个表达式时输出交叉表

df.info()
<class 'pandas.core.frame.DataFrame'>
Int64Index: 6471 entries, 0 to 11549
Data columns (total 3 columns):
survey_weight     6471 non-null float64
income1       3703 non-null float64
benefits1       588 non-null category
dtypes: category(1), float64(2)
memory usage: 467.8 KB

Tags: pandasdfnull交叉surveypdvaluessum