I m working on a Summer dataset for practice in Python However I get the below error

Question

I'm working on a Summer dataset for practice in Python. I'm trying to find the duplicate values of the same name using the loc method and I get the below error:

I get this error when I run the below code:

summer.loc["PHELPS, Michael"]
KeyError                                  Traceback (most recent call last)
~\Anaconda3\lib\site-packages\pandas\core\indexes\base.py in get_loc(self, key, method, tolerance)
   2896             try:
-> 2897                 return self._engine.get_loc(key)
   2898             except KeyError:
pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()
pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()
pandas\_libs\index_class_helper.pxi in pandas._libs.index.Int64Engine._check_type()
KeyError: 'PHELPS, Michael'
During handling of the above exception, another exception occurred:
KeyError                                  Traceback (most recent call last)
<ipython-input-35-d83dc6ae2ea7> in <module>
----> 1 summer.loc["PHELPS, Michael"]
~\Anaconda3\lib\site-packages\pandas\core\indexing.py in __getitem__(self, key)
   1422
   1423             maybe_callable = com.apply_if_callable(key, self.obj)
-> 1424             return self._getitem_axis(maybe_callable, axis=axis)
   1425
   1426     def _is_scalar_access(self, key: Tuple):
~\Anaconda3\lib\site-packages\pandas\core\indexing.py in _getitem_axis(self, key, axis)
   1848         # fall thru to straight lookup
   1849         self._validate_key(key, axis)
-> 1850         return self._get_label(key, axis=axis)
   1851
   1852 
~\Anaconda3\lib\site-packages\pandas\core\indexing.py in _get_label(self, label, axis)
    158             raise IndexingError("no slices here, handle elsewhere")
    159
--> 160         return self.obj._xs(label, axis=axis)
    161
    162     def _get_loc(self, key: int, axis: int):
~\Anaconda3\lib\site-packages\pandas\core\generic.py in xs(self, key, axis, level, drop_level)
   3735             loc, new_index = self.index.get_loc_level(key, drop_level=drop_level)
   3736         else:
-> 3737             loc = self.index.get_loc(key)
   3738
   3739             if isinstance(loc, np.ndarray):
~\Anaconda3\lib\site-packages\pandas\core\indexes\range.py in get_loc(self, key, method, tolerance)
    377             except ValueError:
    378                 raise KeyError(key)
--> 379         return super().get_loc(key, method=method, tolerance=tolerance)
    380
    381     @Appender(_index_shared_docs["get_indexer"])
~\Anaconda3\lib\site-packages\pandas\core\indexes\base.py in get_loc(self, key, method, tolerance)
   2897                 return self._engine.get_loc(key)
   2898             except KeyError:
-> 2899                 return self._engine.get_loc(self._maybe_cast_indexer(key))
   2900         indexer = self.get_indexer([key], method=method, tolerance=tolerance)
   2901         if indexer.ndim > 1 or indexer.size > 1:
pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()
pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()
pandas\_libs\index_class_helper.pxi in pandas._libs.index.Int64Engine._check_type()
KeyError: 'PHELPS, Michael'

I request you to kindly help to resolve the issue.

Answer 1

Hi@Pratap,

I think to find duplicate values using loc function will not help. Pandas has a duplicate function itself, you can use this function to do your task. I have attached one example for your reference.

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

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

data1 = data[['Place','State']].duplicated()
data[data1]

Place	State
3	Kolkata	WestBengal
4	Delhi	Delhi