docker-speedtest-analyser icon indicating copy to clipboard operation
docker-speedtest-analyser copied to clipboard

Published 20 hours ago • verified publisher icon roest01

timestamp

Open roman-tremmel opened this issue 4 years ago • 2 comments

Can you explain the timestamp so I'm able to load the data in statistic software e.g. R?

This is one value of the .csv data file. 1562792378103.6838

image

Thanks

roman-tremmel avatar Apr 17 '20 10:04 roman-tremmel

https://docs.python.org/3/library/time.html#module-time

owenleonard avatar Jul 26 '20 14:07 owenleonard

Checkout speedtestRunner.py, you will find this lines giving you the solution: timestamp = round(time.time() * 1000, 3) So the timestamp is multiplied by a thousand. Just do a division by 1000 and you have the "real timestamp" back. Now there you can re-use it as a native timestamp format. On timestamp format in general, see the comment above https://github.com/roest01/docker-speedtest-analyser/issues/43#issuecomment-663993330 Looks like you are using excel: https://exceljet.net/formula/convert-unix-time-stamp-to-excel-date

cosyd avatar Oct 27 '20 16:10 cosyd