Aug-04-2021, 10:56 AM
hello, I tried to merge 2 csv file. the same column that to merge is 'sel' variable. But, I got error message. this is my code and the error message that i got.
import pandas as pd import numpy as np import networkx as nx import matplotlib.pyplot as plt dataWNT = pd.read_csv('WNT.csv') WNT = pd.DataFrame(dataWNT) dataMutasi = pd.read_csv('mutasi_sel_Oke.csv', error_bad_lines=False) Mutasi = pd.DataFrame(dataMutasi) joinWNT_Mutasi = WNT.merge(Mutasi,on='sel') print(joinWNT_Mutasi)and here the error message:
Error:KeyError Traceback (most recent call last)
<ipython-input-1-8f18d8599b3d> in <module>
10 Mutasi = pd.DataFrame(dataMutasi)
11
---> 12 joinWNT_Mutasi = WNT.merge(Mutasi,on='sel')
13
14 print(joinWNT_Mutasi)
~\anaconda3\lib\site-packages\pandas\core\frame.py in merge(self, right, how, on, left_on, right_on, left_index, right_index, sort, suffixes, copy, indicator, validate)
7944 from pandas.core.reshape.merge import merge
7945
-> 7946 return merge(
7947 self,
7948 right,
~\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)
72 validate=None,
73 ) -> "DataFrame":
---> 74 op = _MergeOperation(
75 left,
76 right,
~\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)
650 self.right_join_keys,
651 self.join_names,
--> 652 ) = self._get_merge_keys()
653
654 # validate the merge keys dtypes. We may need to coerce
~\anaconda3\lib\site-packages\pandas\core\reshape\merge.py in _get_merge_keys(self)
1016 right_keys.append(rk)
1017 if lk is not None:
-> 1018 left_keys.append(left._get_label_or_level_values(lk))
1019 join_names.append(lk)
1020 else:
~\anaconda3\lib\site-packages\pandas\core\generic.py in _get_label_or_level_values(self, key, axis)
1561 values = self.axes[axis].get_level_values(key)._values
1562 else:
-> 1563 raise KeyError(key)
1564
1565 # Check for duplicates
KeyError: 'sel'
please anyone help me.