Subset of Dataframe based on substring (python)

Question

I have a pandas dataframe called Data filled with dates. An example date might look like: "2015-05-10 23:45:00". I want to look at the data in January only, so I want:

Data= Data[:][5:7]=="01"

This doesn't work though.

TDLR, wondering how to find get subset of a dataframe based on a substring.

Thanks!

Parfait · Accepted Answer · 2016-01-24 17:23:44Z

0

Consider using the bracketed filter with datetime's month value. But first, you will need to convert string dates to datetime which can be handled with panda's to_datetime():

import datetime as dt
...

Data['yourdatetimecolumn'] = pd.to_datetime(Data['yourdatetimecolumn'])
JanData = Data[Data['yourdatetimecolumn'].dt.month==1]

answered Jan 24, 2016 at 17:23

Parfait

108k19 gold badges103 silver badges138 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:16:01Z

0

since your query is with regards to Dates, want to start first by looking this up? and give it a try may be.. Parse a Pandas column to Datetime

edited May 23, 2017 at 12:16

CommunityBot

11 silver badge

answered Jan 24, 2016 at 17:08

Ashish Kumar

3474 silver badges12 bronze badges

Collectives™ on Stack Overflow

Subset of Dataframe based on substring (python)

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related