Closed ZhuangHaoCheng closed 6 years ago
t7 = dataset3[['user_id','coupon_id','date_received']] t7 = pd.merge(t7,t6,on=['user_id','coupon_id'],how='left') t7['date_received_date'] = t7.date_received.astype('str') + '-' + t7.dates t7['day_gap_before'] = t7.date_received_date.apply(get_day_gap_before) t7['day_gap_after'] = t7.date_received_date.apply(get_day_gap_after) t7 = t7[['user_id','coupon_id','date_received','day_gap_before','day_gap_after']] 跑到这个位置的时候（大概155行左右）
出现了以下信息：
File "D:/Code/ali/O2O_data/readcode.py", line 89, in t7 = pd.merge(t7,t6,on=['user_id','coupon_id'],how='left')
File "D:\anaconda\lib\site-packages\pandas\core\reshape\merge.py", line 60, in merge validate=validate)
File "D:\anaconda\lib\site-packages\pandas\core\reshape\merge.py", line 554, in init self._maybe_coerce_merge_keys()
File "D:\anaconda\lib\site-packages\pandas\core\reshape\merge.py", line 980, in _maybe_coerce_merge_keys raise ValueError(msg)
ValueError: You are trying to merge on object and int64 columns. If you wish to proceed you should use pd.concat 求助，谢谢
t7 = dataset3[['user_id','coupon_id','date_received']] t7 = pd.merge(t7,t6,on=['user_id','coupon_id'],how='left') t7['date_received_date'] = t7.date_received.astype('str') + '-' + t7.dates t7['day_gap_before'] = t7.date_received_date.apply(get_day_gap_before) t7['day_gap_after'] = t7.date_received_date.apply(get_day_gap_after) t7 = t7[['user_id','coupon_id','date_received','day_gap_before','day_gap_after']] 跑到这个位置的时候（大概155行左右）
出现了以下信息：
File "D:/Code/ali/O2O_data/readcode.py", line 89, in
t7 = pd.merge(t7,t6,on=['user_id','coupon_id'],how='left')
File "D:\anaconda\lib\site-packages\pandas\core\reshape\merge.py", line 60, in merge validate=validate)
File "D:\anaconda\lib\site-packages\pandas\core\reshape\merge.py", line 554, in init self._maybe_coerce_merge_keys()
File "D:\anaconda\lib\site-packages\pandas\core\reshape\merge.py", line 980, in _maybe_coerce_merge_keys raise ValueError(msg)
ValueError: You are trying to merge on object and int64 columns. If you wish to proceed you should use pd.concat 求助，谢谢