[Python] Inquiries on how to prevent it from appearing as scientific notation

There is a Pandas data frame, and one column is timestamp.
The value is expressed as 1518586207202 I want to represent this divided by 1000 as an integer.

So if you try df1.timestamp/1000
This is 1.518586e+09. It's expressed like this Is there a way to express this in an integer?

jupyter notebook in use.
It's no use trying np.set_printoptions(suppress=True).

numpy pandas scientificnotation

2022-09-21 20:19

1 Answers

Wouldn't it be better to add a new column in the data frame that represents an integer value?

The simplest way is to utilize the // operator. This operator returns only the quotient (integer value) that discarded the remainder in the division. For example, the value of 7//3 is 2, and 5//2 is 2.

ts  = 1518586207202
sec = ts // 1000
print(ts)   # result: 1518586207202
print(sec)  # result: 1518586207

If you want to store the value of the sec variable as it is, and you want the output to be an integer, you can use string formatting as follows.

ts  = 1518586207202
sec = ts / 1000
print('{:d}'.format(sec))  # result: '1518586207'
print('%d'%(sec))          # result: '1518586207'

I hope it helps you.

2022-09-21 20:19

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656