error merge csv file

[ainisyarifaah]

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.

[deanhystad]

The error says one of the dataframes does not contain the key (column) "sel". Print out WNT and Mutasi to verify that they both contain the key.

[ainisyarifaah]

thank you for the answer. I already correct it. and It works. But I got new error message.

Error:
Empty DataFrame
Columns: [sel, NILAI_RESPON, RESPON, NADK_ENST00000342348, CAMK1G, NTF3, ANKRD30A_ENST00000602533, SFRP5, CNTN5_ENST00000524871, MICAL2_ENST00000379612, FCRL2, OTOGL_ENST00000458043, LRRIQ1_ENST00000393217, LRRIQ1, HEATR1, ANKLE2, SLC11A2, KIAA1199, HAPLN3, UCP2, FRMD4A, TECPR2, TGM1, OR5A2, MS4A8B, C11orf66, PLEKHS1, TXNRD1_ENST00000378070, POSTN, ATP10A, RP11-578F21.5, PLEKHM2_ENST00000375799, PLEKHM2, PDE3B, NUCB2, OTOG, CLSTN3, HYOU1, CUBN, MAN2A2, PGPEP1L, TXNDC11, IPMK, ANK3_ENST00000395293, SLC29A3, CDC42BPG_ENST00000342711, CDC42EP2, HIVEP3, RASAL1, NOS1, CAMKK2, CAMKK2_ENST00000392473, TMEM120B_ENST00000449592, MAP1A, FAM179B, PPFIBP1_ENST00000318304, PPFIBP1, FLG, C15orf33, TCF12_ENST00000438423, TCF12_ENST00000343827, GPR19, TMEM132C_ENST00000435159, HNRNPCL1, PRDM2, ZNF692, SLC35F4, SLC35F4_ENST00000339762, MCF2L_ENST00000375608, LTK, ADAMTS18, MUC16, MUC16_ENST00000397910, CSRP2BP, UBE2M, TCEAL5, WDR81, WDR81_ENST00000437219, TP53_ENST00000269305, DNAH2_ENST00000570791, ZNF536, RHPN2, ALDH16A1, FCGRT, LILRB1, SIGLEC1_ENST00000202578, NFATC2, NDUFA5, CNTNAP3B, Q8N1G8_HUMAN, ADAM7, SLC7A13_ENST00000419776, SMG6, PHF12, RNF213_ENST00000319921, RNF213_ENST00000411702, PSMG1, ZNF717, UGT2B10_ENST00000265403, UGT2B10, ...]
Index: []

[0 rows x 20523 columns]

I tried to print the data and it's not empty.

Output:
 	sel 	NILAI_RESPON 	RESPON
0 	NCI-H1703 	0.0 	0
1 	RT4 	0.0 	0
2 	NCI-SNU-16 	665.128.619 	0

Output:
sel 	NADK_ENST00000342348 	CAMK1G 	NTF3 	ANKRD30A_ENST00000602533 	SFRP5 	CNTN5_ENST00000524871 	MICAL2_ENST00000379612 	FCRL2 	OTOGL_ENST00000458043 	... 	ZNF880 	C12orf74 	GDF5OS_ENST00000374375 	PSME1_ENST00000382708 	ICA1 	NUTM2B 	PRSS36 	GDF5OS 	SLC24A4_ENST00000532405 	SPANXN1
0 	HCC1806 	1 	1 	1 	1 	1 	1 	1 	1 	1 	... 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0
509 	NCI-H358 	0 	0 	0 	0 	0 	0 	0 	0 	0 	... 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0
1785 	NCI-H3122 	0 	0 	0 	0 	0 	0 	0 	0 	0 	... 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0
2161 	NCI-H747 	0 	0 	0 	0 	0 	0 	0 	0 	0 	... 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0
2435 	T-24 	0 	0 	0 	0 	0 	0 	0 	0 	0 	... 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0
... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	...
20316 	T47D 	0 	0 	0 	0 	0 	0 	0 	0 	0 	... 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0
20337 	NCI-H1437 	0 	0 	0 	0 	0 	0 	0 	0 	0 	... 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0
20373 	NCI-H23 	0 	0 	1 	0 	0 	0 	0 	0 	0 	... 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0
20462 	CAL-148 	0 	0 	0 	0 	0 	0 	0 	0 	0 	... 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0
20561 	NCI-H1299 	0 	0 	0 	1 	0 	0 	0 	0 	0 	... 	1 	1 	1 	1 	1 	1 	1 	1 	1 	1

85 rows × 20521 columns