How to transform an entire colum with strings in numbers? [duplicate]

Question

what's up?

In excel i could transform an entire column of dates or string in number using number_value formula. Can I do something like this in Python with pandas at on my dataFrames?

Tks

yes, see pd.to_numeric or df[col].astype(int) or (float) — Umar.H
– Umar.H, Commented Jun 26, 2020 at 22:12

rhug123 · Accepted Answer · 2020-06-27 00:23:53Z

0

The code below should transform string values to a numeric value. The first line is only needed if you are transforming dates from a string to a number.

df['col'] = pd.to_datetime(df['col'])
df['col'] = pd.to_numeric(df['col'])

answered Jun 27, 2020 at 0:23

rhug123

8,8801 gold badge14 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

How to transform an entire colum with strings in numbers? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related