KeyError Place not found in axis

Question

Hi Guys,

I have one DataFrame in pandas as given below.

import pandas as pd
df = pd.read_csv('my.csv')

Place	State
0	Kolkata	WestBengal
1	Delhi	Delhi
2	Bangalore	Karnataka
3	Kolkata	WestBengal
4	Delhi	Delhi

I am trying to drop the Place column from this DataFrame using drop() function. But it is showing me the below error.

df.drop('Place')
KeyError                                  Traceback (most recent call last)
<ipython-input-16-5010dfe7568c> in <module>
----> 1 df.drop('Place',axis=0)
~\anaconda3\envs\myenv\lib\site-packages\pandas\core\frame.py in drop(self, labels, axis, index, columns, level, inplace, errors)
   3995             level=level,
   3996             inplace=inplace,
-> 3997             errors=errors,
   3998         )
   3999
~\anaconda3\envs\myenv\lib\site-packages\pandas\core\generic.py in drop(self, labels, axis, index, columns, level, inplace, errors)
   3934         for axis, labels in axes.items():
   3935             if labels is not None:
-> 3936                 obj = obj._drop_axis(labels, axis, level=level, errors=errors)
   3937
   3938         if inplace:
~\anaconda3\envs\myenv\lib\site-packages\pandas\core\generic.py in _drop_axis(self, labels, axis, level, errors)
   3968                 new_axis = axis.drop(labels, level=level, errors=errors)
   3969             else:
-> 3970                 new_axis = axis.drop(labels, errors=errors)
   3971             result = self.reindex(**{axis_name: new_axis})
   3972
~\anaconda3\envs\myenv\lib\site-packages\pandas\core\indexes\base.py in drop(self, labels, errors)
   5015         if mask.any():
   5016             if errors != "ignore":
-> 5017                 raise KeyError(f"{labels[mask]} not found in axis")
   5018             indexer = indexer[~mask]
   5019         return self.delete(indexer)
KeyError: "['Place'] not found in axis"

How can I solve this error?

Answer 1

Hi@akhtar,

You need to provide the axis parameter in your drop function. By default, it will take axis=0, which means a row-wise operation. So you have to set axis=1 inside drop function to do a column-wise operation.

df.drop('Place',axis=1,inplace=True)

State
0	WestBengal
1	Delhi
2	Karnataka
3	WestBengal
4	Delhi

I hope this will help you.

Comments

I have the same problem. I set the axis=1, it doesn't help. Still KeyError ... not found in axis.

---

Hi@Nikolay,

Can you share your data frame schema and the command you have used to drop?

---

your problem is with your index,

try df.reindex() before the drop

---

Having similar issues. Even after adding the axis=1 I still am getting a KeyError

Answer 2

I think you had click on run command 2 times Check the data again  unwanted columns have been removed.