using loc(index) on pandas DataFrame in Python

Question

I think I miss something very basic in the Pandas DataFrame:

I have the following program:

array = {'A':[1, 2, 3, 4], 'B':[5, 6, 7, 8]}
index = pd.DatetimeIndex(
    [   '09:30',
        '09:31',
        '09:32',
        '09:33'     ])
data = pd.DataFrame(array, index=index)
data.index = data.index.strftime('%H:%M')
         
print(data)
print(data.loc('09:33'))

I get:

       A  B
09:30  1  5
09:31  2  6
09:32  3  7
09:33  4  8

Which is great, but I can not access a row using it's index '09:33' and I get:

ValueError: No axis named 09:33 for object type <class 'pandas.core.frame.DataFrame'>

What am I missing ?

Thank you, Ehood

Edgar Ramírez Mondragón · Accepted Answer · 2020-06-28 06:38:42Z

1

You need to use brackets [] instead: data.loc['09:33']

array = {'A':[1, 2, 3, 4], 'B':[5, 6, 7, 8]}
index = pd.DatetimeIndex(
    [   '09:30',
        '09:31',
        '09:32',
        '09:33'     ])
data = pd.DataFrame(array, index=index)
data.index = data.index.strftime('%H:%M')
         
print(data)
print(data.loc['09:33'])  # HERE!

Output:

       A  B
09:30  1  5
09:31  2  6
09:32  3  7
09:33  4  8
A    4
B    8
Name: 09:33, dtype: int64

answered Jun 28, 2020 at 6:38

Edgar Ramírez Mondragón

3,0613 gold badges23 silver badges36 bronze badges

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

Comments

hrokr · Accepted Answer · 2020-08-14 06:51:30Z

0

You're close. When using loc or iloc, its followed by square brackets, like this:

df.loc['viper']

In your case that ends up like this:

You can find the documentation for that here.

edited Aug 14, 2020 at 6:51

answered Jun 28, 2020 at 6:43

hrokr

3,6194 gold badges26 silver badges43 bronze badges

Collectives™ on Stack Overflow

using loc(index) on pandas DataFrame in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related