Mar-16-2020, 02:22 PM
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:
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'
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'