Trying to convert a column with strings to float via Pandas

Question

Hi I have looked but on stackoverflow and not found a solution for my problem. Any help highly appeciated.

After importing a csv I noticed that all the types of the columns are object and not float.

My goal is to convert all the columns but the YEAR column to float. I have read that you first have to strip the columns for taking blanks out and then also convert NaNs to 0 and then try to convert strings to floats. But in the code below I'm getting an error.

My code in Jupyter notes is:

And I get the following error.

How do I have to change the code.

All the columns but the YEAR column have to be set to float.

If you can help me set the column Year to datetime that would be also very nice. But my main problem is getting the data right so I can start making calculations.

Thanks

Runy

Quang Hoang · Accepted Answer · 2020-03-12 19:39:37Z

2

Easiest would be

df = df.astype(float)
df['YEAR'] = df['YEAR'].astype(int)

Also, your code fails because you have two columns with the same name BBPWN, so when you do df['BBPWN'], you will get a dataframe with those two columns. Then, df['BBPWN'].str will fail.

answered Mar 12, 2020 at 19:39

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

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

Collectives™ on Stack Overflow

Trying to convert a column with strings to float via Pandas

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