python dataframe datetime condition

Question

I am trying to create a new dataframe from an existing one by conditioning holiday datetime. train dataframe is existing and I want to create train_holiday from it by taking day and month values of holiday dataframe, my purpose is similar below:

    date    values
2015-02-01  10
2015-02-02  20
2015-02-03  30
2015-02-04  40
2015-02-05  50
2015-02-06  60

    date
2012-02-02
2012-02-05

now first one is existing, and second dataframe shows holidays. I want to create a new dataframe from first one that only contains 2015 holidays similar below:

 date      values
2015-02-02  20
2015-02-05  50

I tried

train_holiday = train.loc[train["date"].dt.day== holidays["date"].dt.day]

but it gives error. could you please help me about this?

Raymond Kwok · Accepted Answer · 2022-02-04 06:23:39Z

2

In your problem you care only the month and the day components, and one way to extract that is by dt.strftime() (ref). Applying that extraction on both date columns and use .isin() to keep month-day in df1 that matches that in df2.

df1[
    df1['date'].dt.strftime('%m%d').isin(
    df2['date'].dt.strftime('%m%d')
    )
   ]

Make sure both date columns are in date-time format so that .dt can work. For example,

df1['date'] = pd.to_datetime(df1['date'])

answered Feb 4, 2022 at 6:23

Raymond Kwok

2,5512 gold badges11 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

python dataframe datetime condition

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