Dataframe数据处理
len(df)
df.columns
df['列名']
df['列名'].loc[i]
Dataframe关联
df_result_diff = pd.merge(data_frame_r1,qs,how='right',on=['level_4_faq','level_5_faq','level_6_faq'])
Dataframe筛选
df.loc[if_his = 1]
df_r2.query('if_his != 1')
Dataframe统计
df.groupby('level_1_faq').nunique('list_id')
df.groupby('team').describe()
df.groupby('team').sum()
df.groupby('team').count()
df.groupby('team').max()
df.groupby('team').min()
df.groupby('team').size()
df.groupby('team').mean()
df.groupby('team').median()
df.groupby('team').std()
df.groupby('team').var()
Dataframe复合
df_r2.query('type == "问题"')[['level_4_faq','level_5_faq','level_6_faq','week_begin_date_id','list_id']].groupby(['level_4_faq','level_5_faq','level_6_faq','week_begin_date_id']).nunique('list_id')