Convert dtype objecto to int Python Pandas

Question

Right now I'm working with a file containing scraped numbers, but whenever I try to do some calculations with them a ValueError (invalid literal for int() with base 10: '6,92') pops up.

The piece of code I use to get the numbers from the web looks like this:

numberX = driver.find_element_by_xpath('//*[@id="form1"]/div[3]/div/div/div[1]/div[2]/div/div/div[3]/span/i').text
number = ''
for i in numberX:
    if i in '0123456789,':
        number += i

'numberX' contains alphanumerical values, but 'number' does not. Still, the dtype of 'number' is object.

I have tried:

df['number'].astype(str).astype(int)

But the same ValueError pops up.

If I export the data to Excel, the column with the 'number' values appears in text format, and Excel gives me the possibility to convert them to numbers. Also, I have checked and the values only contain numbers and a commas (',').

A piece of the printed dataframe looks something like this:

Date  Amount  Number
0   11/04/2020   10000        6,92
1   11/04/2020   10000        6,77
2   11/04/2020   10000        6,66
3   11/04/2020   10000        6,59

Any idea of what could be happening?

Thanks in advance!

emiljoj · Accepted Answer · 2020-04-11 13:19:37Z

2

Would converting to floats first instead of int work for you?

df['number'] = df['number'].astype(str).astype(float)

and if you want to convert to int you can still go one extra step:

df['number'] = df['number'].astype(str).astype(float).astype(int)

You could have also come to this solutin through already answered questions: ValueError: invalid literal for int() with base 10: ''

Updated

need to replace the comma with a dot as well:

df['number'].apply(lambda x: x.replace(',','.')).astype(float)

edited Apr 11, 2020 at 13:19

answered Apr 11, 2020 at 12:03

emiljoj

4092 silver badges7 bronze badges

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

1 Comment

martifapa Over a year ago

Hey emiljoj, trying to convert to float (which would work for me) gives me another ValueError: could not convert string to float: '6,92'...

Sajan · Accepted Answer · 2020-04-11 13:33:31Z

1

I think you may want to replace the , and then convert it to int.

df['number'] = df['number'].str.replace(',','').astype(int)

answered Apr 11, 2020 at 13:33

Sajan

1,2671 gold badge7 silver badges13 bronze badges

Comments

Lovleen Kaur · Accepted Answer · 2020-04-11 12:27:09Z

0

You can do the following:-

df['number'] = df['number'].astype('int32')

answered Apr 11, 2020 at 12:27

Lovleen Kaur

3422 silver badges9 bronze badges

1 Comment

martifapa Over a year ago

Hey Lovleen Kaur, trying to convert to 'int32' gives me the following a ValueError: invalid literal for int() with base 10: '11,46'!

Collectives™ on Stack Overflow

Convert dtype objecto to int Python Pandas

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related