Selecting a specific row and column within pandas data array

Question

Hopefully this is a quick and simple one. Having looked through the entirity of the pandas.DataFrame documentation I can't quite seem to find exactly what I need. I have a DataFrame as:

           StartDate          End Date
0   10/11/2014 00:00  10/12/2014 12:00
1   12/01/2015 08:00  31/01/2015 07:59
2   15/01/2015 00:00  19/02/2015 15:43

Say, for example, I want to access the value at StartDate column index value 2...i.e, 15/01/2015 00:00 how is this achieved?

jezrael · Accepted Answer · 2016-11-22 12:15:05Z

18

Use loc:

print (df.loc[2, 'StartDate'])
15/01/2015 00:00

or faster at:

print (df.at[2, 'StartDate'])
15/01/2015 00:00

In [199]: %timeit (df.loc[2, 'StartDate'])
10000 loops, best of 3: 147 µs per loop

In [200]: %timeit (df.at[2, 'StartDate'])
100000 loops, best of 3: 6.3 µs per loop

answered Nov 22, 2016 at 12:15

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Comments

phynfo · Accepted Answer · 2016-11-22 12:16:05Z

1

Try this solution:

df.loc[2, 'StartDate']

answered Nov 22, 2016 at 12:16

phynfo

4,9481 gold badge27 silver badges38 bronze badges

Collectives™ on Stack Overflow

Selecting a specific row and column within pandas data array

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