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
Post a Comment