如何通过数据框向熊猫组添加“总和”列?我想对下面的groupby数据框的'看跌'和'看涨'内部栏目做一个'总和' .
然后我想添加另外两列:
%看跌=看跌/总和* 100
%看涨=看涨/总和* 100
group_df = df[['sentiment','message']].groupby([pd.TimeGrouper(freq='H'),'sentiment']).count()
group_df = group_df.unstack()
message
sentiment Bearish Bullish
created
2017-08-01 23:00:00 2.0 2.0
2017-08-02 00:00:00 1.0 3.0
2017-08-02 01:00:00 NaN 4.0
1 回答
您可以将concat与新
DataFrame
一起使用:如果需要GroupBy.size:
What is the difference between size and count in pandas?