pandas基础操作笔记

# python的pandas模块获取日期间隔
import pandas as pd
date_list = [d.strftime("%Y%m%d") for d in pd.date_range('2020-05-25', end='2020-06-07', freq="d")]
date_list

# pandas计算唯一值个数
dferr.groupby(by=['ds']).userid.nunique()
dferr.pivot_table(index=['ds'],columns=['user_level'],values=['userid'],aggfunc=lambda x:len(x.unique()),margins=True)

# pandas按照百分比展示
df2.div(df2.iloc[-1,-1],axis=0).applymap(lambda x:format(x,'.1%'))
df3.div(df3.iloc[:,-1],axis=0).applymap(lambda x:format(x,'.1%'))