Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

Pandas read_excel Percentage and int

Hello I have an excel column with some data as Integers out of 100 and some are in percentage.

When I read those data with pandas.read_excel it converting % data to numbers (out of 1), thats wrong data. It should read them as out of 100.

Read % data out of 100 not 1 and other data as it is as they are out of 100. How I can do this??

original data:

57.136650
21.530386%
72.501617
59.000000
84.000000

read_excel reading it as:

57.136650
0.215304
72.501617
59.000000
84.000000

Expected output

57.136650
21.530386
72.501617
59.000000
84.000000

Adding that i cant add the rule if the value is below 1 then multiply it with 100 as some data are in real below 1 (not in percentage format).

Thank you.

Comments