pandas

DF的筛选方式

goodsdaily
data_date,goods_id,goods_click,cart_click,favorites_click,sales_uv,onsale_days
20170823,G8OeZY,72,2,3,0,6
20170823,Gjytr2,96,0,1,0,336
20170823,GR0SgC,15,0,0,0,98
20170823,GMkqxN,9,0,0,0,13

G8OeZY=goodsdaily.loc[goodsdaily["goods_id"]=="G8OeZY"]
G8OeZY1=goodsdaily.query('goods_id==["G8OeZY"]')
goodsdaily.filter(regex="",axis=0)//正则
goodsdaily.filter(like="",axis=0)//模糊

数据筛选后赋值

goodsdaily.loc[(goodsdaily.data_date <= pd.datetime(year=2018, month=4, day=7)) &
           (goodsdaily.data_date >= pd.datetime(year=2017, month=4, day=7)), "week"] = 1