Pandas Dataframe indexing: KeyError:none of [columns] are in the [columns]

Question

I'm in datacamp's 'Intermediate Python for Data Science'.

>>> brics.loc[:]
          country     capital    area   population
BR         Brazil    Brasilia   8.516       200.40
RU         Russia      Moscow  17.100       143.50
IN          India   New Delhi   3.286      1252.00
CH          China     Beijing   9.597      1357.00
SA   South Africa    Pretoria   1.221        52.98
>>> brics.loc[:,['country','capital']]
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python3.5/dist-packages/pandas/core/indexing.py", line 1294, in __getitem__
    return self._getitem_tuple(key)
  File "/usr/local/lib/python3.5/dist-packages/pandas/core/indexing.py", line 789, in _getitem_tuple
    self._has_valid_tuple(tup)
  File "/usr/local/lib/python3.5/dist-packages/pandas/core/indexing.py", line 142, in _has_valid_tuple
    if not self._has_valid_type(k, i):
  File "/usr/local/lib/python3.5/dist-packages/pandas/core/indexing.py", line 1379, in _has_valid_type
    (key, self.obj._get_axis_name(axis)))
    KeyError: "None of [['country', 'capital']] are in the [columns]"

This is textbook indexing, and it worked last night but not today.

>>> brics.iloc[1,1]
' Moscow'
>>> brics.iloc[1,2]
17.100000000000001

It's like my only busted function is loc(); iloc() is selecting fine. The error messages are from pandas so I reinstalled with pip3; it didn't help, did apt-get update upgrade etc, no change.

Looks like for some reason pandas isn't parsing my strings right in the loc method.

What is brics.columns ? I think there is whitespace in column names. Then use brics.columns = brics.columns.str.strip() — jezrael
– jezrael, Commented Aug 31, 2016 at 8:29
@NickilMaveli - yes, it is another solution, but OP code is working nice too. — jezrael
– jezrael, Commented Aug 31, 2016 at 8:33
jezrael, you were right, thank you very much. There was white space in the column labels. — JCMontalbano
– JCMontalbano, Commented Aug 31, 2016 at 21:17

Sai Varun Kumar · Accepted Answer · 2021-10-08 13:43:39Z

1

Here I wrote simple code using .loc You can see below code

import pandas as pd
df = pd.DataFrame({'num_legs': [2, 4, 8, 0],'num_wings': [2, 0, 0, 0],'num_specimen_seen': [10, 2, 1, 8]},index=['falcon', 'dog', 'spider', 'fish'])
print(df.loc[:, 'num_legs':'num_wings'])

It worked in mycase, You can try this

answered Oct 8, 2021 at 13:43

Sai Varun Kumar

1071 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pandas Dataframe indexing: KeyError:none of [columns] are in the [columns]

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related