Keyerror: ID during adding of this line df4 = pd.read_csv('../input/riadd-dataset/RFMiD_Training_Labels.csv',sep='\t')

Question

When i am writing this line

df4 = pd.read_csv('../input/riadd-dataset/RFMiD_Training_Labels.csv',sep='\t')

this shows me the following error shown below.

    File "<ipython-input-11-2b86b3a98ba3>", line 14, in <module>
df = dataframe_creation()
File "<ipython-input-11-2b86b3a98ba3>", line 4, in dataframe_creation
df4['ID']="Training/"+df4['ID'].astype(str)+'.png'
File "C:\ProgramData\Anaconda\lib\site-packages\pandas\core\frame.py", line 2980, in >> 
 __getitem__
 indexer = self.columns.get_loc(key)
KeyError: 'ID'

Working fine in my pc. Do you really have `ID` column in your dataframe? Check for spelling mistake. — Adarsh Wase, Sep 20 '21 at 09:35
I have ID column in my data. same spelling. i am running in spyder — Bali Akanksha, Sep 20 '21 at 13:24
It is solved. In the above error we can ignore sep='\t'. by ignoring the sep, problem is ressolved — Bali Akanksha, Sep 20 '21 at 14:52

Bali Akanksha · Answer 1 · 2021-09-20T17:53:24.833

0

**In the above error ignore **sep='\t' write below line**.

` df4 = pd.read_csv('../input/riadd-dataset/RFMiD_Training_Labels.csv')

` < Write this code

edited Sep 20 '21 at 17:53

answered Sep 20 '21 at 15:53

Bali Akanksha

23
2
7

1

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-ask). – Community Sep 20 '21 at 16:18

Keyerror: ID during adding of this line df4 = pd.read_csv('../input/riadd-dataset/RFMiD_Training_Labels.csv',sep='\t')

1 Answers1