Pandas interpretes string as scientific notation

Question

When I create a dataframe from a excel file, it has a string value '2098E10'. But pandas interpret the letter E on string as scientific notation converting the value to 20980000000000. How can I suppress this panda's behavior to keep the values '2098E10' as string?

I have tried to convert the values to string, but the value will be '20980000000000'.

Specify the dtype when using read_excel?

BigBen
– BigBen

2022-11-07 20:12:25 +00:00
Commented Nov 7, 2022 at 20:12 — BigBen
– BigBen, Commented Nov 7, 2022 at 20:12

ljaniec · Accepted Answer · 2022-11-07 20:20:21Z

1

You should use pandas.read_csv with the correct dtype argument (str for you), e.g.

pd.read_csv('data/data_7.csv',
                 dtype={
                     'Name': str,
                     'Grade': int
                 })

Hint taken from this blog post #5.

answered Nov 7, 2022 at 20:20

ljaniec

1411 silver badge6 bronze badges

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

Collectives™ on Stack Overflow

Pandas interpretes string as scientific notation

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