Python how to replace a column's values in dataframe

Question

If there is a column called date in a pandas.DataFrame, For which the values are:

'2018-02-01', 
'2018-02-02',
 ...

How do I change all the values to integers? For example:

'20180201', 
'20180202',
 ...

.replace the dashes with empty strings.

DYZ
– DYZ

2018-03-30 00:54:15 +00:00
Commented Mar 30, 2018 at 0:54 — DYZ
– DYZ, Commented Mar 30, 2018 at 0:54

Stephen Rauch · Accepted Answer · 2018-03-30 01:27:52Z

4

You can use .str.replace() like:

Code:

df['newdate'] = df['date'].str.replace('-', '')

or if not using a regex, faster as a list comprehension like:

df['newdate'] = [x.replace('-', '') for x in df['date']]

Test Code:

df = pd.DataFrame(['2018-02-01', '2018-02-02'], columns=['date'])
print(df)

df['newdate'] = df['date'].str.replace('-', '')
print(df)

df['newdate2'] = [x.replace('-', '') for x in df['date']]
print(df)

Results:

         date
0  2018-02-01
1  2018-02-02

         date   newdate
0  2018-02-01  20180201
1  2018-02-02  20180202

         date   newdate  newdate2
0  2018-02-01  20180201  20180201
1  2018-02-02  20180202  20180202

edited Mar 30, 2018 at 1:27

answered Mar 30, 2018 at 0:57

Stephen Rauch♦

50.1k32 gold badges118 silver badges143 bronze badges

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

Collectives™ on Stack Overflow

Python how to replace a column's values in dataframe

1 Answer 1

Code:

Test Code:

Results:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Code:

Test Code:

Results:

Comments

Your Answer

Sign up or log in

Post as a guest

Related