Selecting Rows with DateTimeIndex without referring to date

Question

Is there a way to select rows with a DateTimeIndex without referring to the date as such e.g. selecting row index 2 (the usual Python default manner) rather than "1995-02-02"?

Thanks in advance.

dataista · Accepted Answer · 2018-11-23 02:09:03Z

1

Yes, you can use .iloc, the positional indexer:

df.iloc[2]

Basically, it indexes by actual position starting from 0 to len(df), allowing slicing too:

df.iloc[2:5]

It also works for columns (by position, again):

df.iloc[:, 0]  # All rows, first column
df.iloc[0:2, 0:2] # First 2 rows, first 2 columns

answered Nov 23, 2018 at 2:09

dataista

3,5471 gold badge19 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

Selecting Rows with DateTimeIndex without referring to date

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