modify string values in dataframe column

Question

I'm trying to modify the string values in a dataframe column. So far I have tried this:

def years(x):
    x = x.split(' ')[0]
    x = x[-2:]
    return x

df['Date'].apply(years)

When I run this and then take a look at the dataframe the actual df['Date'] column is unmodified.

For reference, I'm trying to change the column values from a string that looks like this, '12/21/15 20:30', into a string (or integer) that just includes the year, so in this case, '15'.

James · Accepted Answer · 2016-11-17 03:04:45Z

4

You need to assign the returned value to a new column. .apply does not operate in-place.

def years(x):
x = x.split(' ')[0]
x = x[-2:]
return x

df['NewDate'] = df['Date'].apply(years)

answered Nov 17, 2016 at 3:04

James

37k4 gold badges54 silver badges79 bronze badges

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

Collectives™ on Stack Overflow

modify string values in dataframe column

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