Stripping a value in Pandas to convert

Asked Apr 22 '20 at 14:08

Active Apr 22 '20 at 14:11

Viewed 56 times

I want to convert an entire column in pandas form a string to a float.

In my column there is one figure stopping the conversion '66s' I would like to take the 's' off so I can convert.

dfWeather['HOURLYDRYBULBTEMPF'].replace("s+", "")
dfWeather['HOURLYDewPointTempF'].replace("s+", "")
dfWeather = dfWeather.astype({"HOURLYDRYBULBTEMPF": float, "HOURLYDewPointTempF": float})

When I run this code I get

ValueError: could not convert string to float: '66s

I would like to strip the 's' delete the 's' or even just replace the '66s' with a '66'

asked Apr 22 '20 at 14:08

Jimmy_Jump

Use `dfWeather['HOURLYDRYBULBTEMPF'].replace("s+", "", regex=True)` instead – yatu Apr 22 '20 at 14:09
`replace` returns a copy. – Quang Hoang Apr 22 '20 at 14:09
What do you mean returns a copy? – Jimmy_Jump Apr 22 '20 at 14:18

Stripping a value in Pandas to convert

0 Answers0