1. pandas实现sql row number功能
首先按id和msg_ts排序,然后按id topic分组,这样行编号功能就变得现实了
df [ ' row _ num ' ]=df.sort _ values (['id ',' msg_ts'],ascending=True ).groupby ) [ ' id ',' topic']
padans链接:
3359 pandas.py data.org/pandas-docs/stable/getting _ started/comparison/comparison _ with _ SQL.html