Error on merge - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: Data Science (https://python-forum.io/forum-44.html) +--- Thread: Error on merge (/thread-25032.html) |
Error on merge - DionisiO - Mar-16-2020 Hello all, I'm trying to merge or join two dataframes, the source files are CSV files. They both have a common column for me to join. I'm getting an error while trying to do the merge: merged_left = pd.merge(left=naeObj, right=minoff_19, how='left', left_on='key', right_on='key')Thanks!! This is the error message: KeyError Traceback (most recent call last) <ipython-input-41-e25f32e8e3cf> in <module> ----> 1 merged_left = pd.merge(left=naeObj, right=minoff_19, how='left', left_on='Pointname', right_on='Pointname') 2 3 #leftjoin = pd.merge(naeObj,minoff_19, how='left', on=['Pointname','Pointname']) 4 5 merged_left ~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\reshape\merge.py in merge(left, right, how, on, left_on, right_on, left_index, right_index, sort, suffixes, copy, indicator, validate) 84 copy=copy, 85 indicator=indicator, ---> 86 validate=validate, 87 ) 88 return op.get_result() ~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\reshape\merge.py in __init__(self, left, right, how, on, left_on, right_on, axis, left_index, right_index, sort, suffixes, copy, indicator, validate) 625 self.right_join_keys, 626 self.join_names, --> 627 ) = self._get_merge_keys() 628 629 # validate the merge keys dtypes. We may need to coerce ~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\reshape\merge.py in _get_merge_keys(self) 981 if not is_rkey(rk): 982 if rk is not None: --> 983 right_keys.append(right._get_label_or_level_values(rk)) 984 else: 985 # work-around for merge_asof(right_index=True) ~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\generic.py in _get_label_or_level_values(self, key, axis) 1690 values = self.axes[axis].get_level_values(key)._values 1691 else: -> 1692 raise KeyError(key) 1693 1694 # Check for duplicates KeyError: 'Pointname' |