Two type of variable types in One column & one is in suppressesed Scientific Notation: pandas

Asked Aug 25 '16 at 11:40

Active Aug 25 '16 at 12:49

Viewed 43 times

I have a column which can have two type of data types varchar and float. Now since my float is a long number such as 10154346483399200, which becomes lately like 1.01543E+16 and the other entry could be like UPDATE-c1038-6036456184586739712. How to bring the 'E' data entries in their original form

In[3] a= ['1.01543E+16', 'UPDATE-c1038-6036456184586739712']

answer should be something like

['10154346483399200', 'UPDATE-c1038-6036456184586739712']

Applying just to solve suppressing Scientific Notation gives me an error

 df.apply(lambda x: '%.3f' % x)

TypeError: float argument required, not str

Every help will be appreciating

edited Aug 25 '16 at 12:49

asked Aug 25 '16 at 11:40

Manu Sharma

1,593
4
25
48

Sorry are these strings or really float here? As it stands what you've shown is a string, there is no way to get back to the original value from that – EdChum Aug 25 '16 at 12:07
First one is float, I just made it up for creating an example – Manu Sharma Aug 25 '16 at 12:08
2

Possible duplicate of [Format / Suppress Scientific Notation from Python Pandas Aggregation Results](http://stackoverflow.com/questions/21137150/format-suppress-scientific-notation-from-python-pandas-aggregation-results) – shivsn Aug 25 '16 at 12:08
Since I have a two type of variables, so applying df.apply(lambda x: '%.3f' % x) gives me an error : TypeError: float argument required, not str – Manu Sharma Aug 25 '16 at 12:45
Does the columns contains values as list? – shivsn Aug 25 '16 at 14:00
Single column- that's a problem – Manu Sharma Aug 25 '16 at 14:03
Can you post a sample dataframe? – shivsn Aug 25 '16 at 14:36

Two type of variable types in One column & one is in suppressesed Scientific Notation: pandas

0 Answers0