CODEWITHSUNDEEP
pythonpandas
Curious
Curious

Reputation: 133

Creating a new column based on filteration on datetime column in dataframe

I want to create a new column by filtering on another column in a dataset.

df.loc[df.APP_DATE >= '2016-01-01' & df.APP_DATE <= '2017-12-31', 'TAG_data'] = 'TRAIN'

for this daterange my new column 'TAG_data' should have value = TRAIN

Upvotes: 1

Views: 34

Answers (1)

jezrael
jezrael

Reputation: 862406

Add () because operator precedence:

df.loc[(df.APP_DATE >= '2016-01-01') & (df.APP_DATE <= '2017-12-31'), 'TAG_data'] = 'TRAIN'

Or use Series.between:

df.loc[df.APP_DATE.between('2016-01-01', '2017-12-31'), 'TAG_data'] = 'TRAIN'

Upvotes: 2

Related Questions