我是pandas的新手。我有一个数据框,看起来像这样
sitename name date count
0 chess.com Autobiographer 2012-05-01 2
1 chess.com Autobiographer 2012-05-05 1
2 chess.com Autobiographer 2012-05-15 1
3 chess.com Autobiographer 2012-05-01 1
4 chess.com Autobiographer 2012-05-15 1
5 chess.com Autobiographer 2012-05-01 1
如何基于日期合并行并对相同日期的计数求和。就像在SQL中一样。
select sitename, name, date count(*) from table group by date
df = dataframe.groupby('date')
。但是出现了错误 pandas.core.groupby.DataFrameGroupBy object at 0x7f0d2de6f9d0> <pandas.core.groupby.DataFrameGroupBy object at 0x32bdb90>。 - user3527975