전체 글 (102) 썸네일형 리스트형 07_07_32. group별로 ts time series 한번에 만들기 # 일자 reindex datelist = pd.date_range( start = df.oper_dt.min(), end = df.oper_dt.max(), freq='D') df_01 = df.set_index('oper_dt').groupby(['origin_bizpl_cd', 'ctgr_cd']).apply(lambda x: x.reindex(datelist, fill_value=0)).drop(columns=['origin_bizpl_cd', 'ctgr_cd']).reset_index() # groupby reindex df_01 = df_01.rename(columns={'level_2':'oper_dt'}) 07_01_31. 데이터프레임 groupby 계산시 컬럼명(column) 변경 df_4w_ag = df_4w.groupby(["origin_bizpl_cd" , "goods_cd"] ).agg({"bg_purch_qty": [("sum_4w", "sum"), ("mean_4w", "mean"), ("max_4w", "max")], "bg_purch_qty_yn":[("count_4w", "sum")]}).droplevel(0, axis=1).reset_index() 07_01_30. convert multi index to single index (Series) # convert multi index to single index : reset_index s_roll_incdec = df_covid.groupby(["gubun"], group_keys=False)["incdec"].rolling(7).sum().reset_index(drop=True) 이전 1 ··· 18 19 20 21 22 23 24 ··· 34 다음