How to concatenate string to python data frame values with where condition

Question

I want concatenate column: ['Time Period'] value and other string ('01-01') to new column: 'Date', with condition dt['Frequency']=='0'. Please help on this, I am new to python and learning scripting by some data processing.

dt.loc[dt['Frequency']=='0','Date']=dt['Time Period']+'01-01'

dt:
Frequency,Time Period,Date
0,2008
0,1961
2,2015Q1
3,2016M1

@Mohammed Yasin, No... Data frame having column 'Time Period' & I want to update it in another column as per condition + '01-01' — question.it
– question.it, Commented Jun 15, 2017 at 5:26
can you please show your DataFrame, that will help me to solve answer. — ammy
– ammy, Commented Jun 15, 2017 at 5:27

ammy · Accepted Answer · 2017-06-15 06:04:33Z

1

df["Date"] = df.loc[df['Frequency']==0, 'Time Period'] +"01-01"

Answer updated

edited Jun 15, 2017 at 6:04

answered Jun 15, 2017 at 5:48

ammy

6481 gold badge5 silver badges13 bronze badges

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

2 Comments

miriamsimone Over a year ago

hey ammy can you explain what you've done here and what the original bug was? also don't think you need/want the first dt["Date"] = '

question.it Over a year ago

@ammy, done it: "Thanks for the feedback! Votes cast by those with less than 15 reputation are recorded, but do not change the publicly displayed post score."

Collectives™ on Stack Overflow

How to concatenate string to python data frame values with where condition

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related