Concatenating specific strings in 2 columns in Python

Question

What I have:

Month|Year
 Jan |2019
 Feb |2019
 Jan |2020
 Feb |2020

What I want is to add another column:

Month|Year|month_yr
 Jan |2019|Jan19
 Feb |2019|Feb19
 Jan |2020|Jan20
 Feb |2020|Feb20

What I tried:

df2['month_yr']=df2.month + df2.year

But this is giving me Jan2019,Jan2020 etc. I do not want the full year but the last 2 digits like Jan19,Jan20 etc

Thank You

Imtinan Azhar · Accepted Answer · 2020-02-03 10:56:33Z

2

try

df2['month_yr']=df2.month + df2['Year'].str[-2:]

this should work

answered Feb 3, 2020 at 10:56

Imtinan Azhar

1,77314 silver badges27 bronze badges

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

1 Answer 1