python_两个数据集_关联_拼接&join操作&merge
原创
文章标签 数据集 字段 python 文章分类 Python 后端开发
©著作权归作者所有：来自51CTO博客作者六mo神剑的原创作品，请联系作者获取转载授权，否则将追究法律责任
python_两个数据集拼接&join操作
t3 = dataset3[['user_id','coupon_id','date_received']]t3 = pd.merge(t3,t2,on=['user_id','coupon_id'],how='left')t3['this_month_user_receive_same_coupon_lastone'] = t3.max_date_received - t3.date_receivedt3['this_month_user_receive_same_coupon_firstone'] = t3.date_received - t3.min_date_received#根据多个字段就进行mergeother_feature3 = pd.merge(t1,t,on='user_id')other_feature3 = pd.merge(other_feature3,t3,on=['user_id','coupon_id'])other_feature3 = pd.merge(other_feature3,t4,on=['user_id','date_received'])other_feature3 = pd.merge(other_feature3,t5,on=['user_id','coupon_id','date_received'])other_feature3 = pd.merge(other_feature3,t7,on=['user_id','coupon_id','date_received'])other_feature3.to_csv('data/other_feature3.csv',index=None)#拼接数据集#两个数据框合并为一个df_train_stmt = pd.concat([df_train_stmt,df_train_stmt_test],axis = 0)
- 赞
- 收藏
- 评论
- *举报
下一篇：python_datafram两列拼接，中间加上特殊字符
Original: https://blog.51cto.com/u_10055401/5482234
Author: 六mo神剑
Title: python_两个数据集_关联_拼接&join操作&merge
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/513645/
转载文章受原作者版权保护。转载请注明原作者出处！