- #1
Click For Summary
Discussion Overview
The discussion revolves around how to plot timestamp data that is embedded within each row of a dataset. Participants explore various methods and programming languages to achieve this, focusing on practical approaches for visualizing the data distribution.
Discussion Character
- Exploratory
- Technical explanation
- Debate/contested
- Mathematical reasoning
Main Points Raised
- One participant seeks advice on plotting timestamp data that is formatted within rows of a dataset.
- Another participant suggests stripping off seconds and milliseconds as a potential simplification, questioning the complexity of the task.
- There is a request for clarification on the programming language being used, with indications that Python is involved based on previous threads.
- A suggestion is made to use a spreadsheet to read and visualize the timestamp data, highlighting the capabilities of spreadsheets for plotting.
- The original poster reiterates the challenge of having multiple timestamps within each row and expresses a preference for using Python to read the file and generate plots.
- One participant proposes using awk as a straightforward solution for processing the data on Linux, providing a command example to extract specific columns for plotting.
Areas of Agreement / Disagreement
Participants do not reach a consensus on the best method to plot the timestamps, with multiple suggestions and approaches being discussed. The discussion remains unresolved regarding the most effective solution.
Contextual Notes
There are limitations regarding the assumptions about the dataset structure and the specific requirements for plotting. The discussion does not clarify the format of the timestamps or the desired output of the plots.
- #2
- 19,378
- 15,614
are you not able to strip off the seconds and milliseconds? Seems like this should be trivially easy. What language are you using?
- #3
Mark44
Mentor
- 38,093
- 10,644
Several other threads by the OP show Python code.phinds said:
- #4
- 11,326
- 8,755
Read it into a spreadsheet. Most spreadsheets include many ways to read or display time. The spreadsheet can also make the plots for you.
- #5
- 19,378
- 15,614
- #6
msn009
- 53
- 6
sorry, i thought the tag would show python and yes it is in python. but these timestamps are within the row itself and i have several hundred rows with this data inside each. i thought of doing it in python so that i can read the file and plot a chart for each.
- #7
- 19,378
- 15,614
Then I ask again, can you not just strip off the seconds and milliseconds? I don't know Python but in C and VB.NET this is easy and doing your own plot would be reasonably easy.msn009 said:
- #8
jedishrfu
Mentor
- 15,639
- 10,439
awk would be the easiest thing to use if you're on linux.
Awk processes each line and prints out only the second column and from there you can plot the data
Code:
awk '{print $2}' input filename_goes_here >outputfilename_goes_hereSimilar threads
- · Replies 2 ·
- · Replies 9 ·
- · Replies 3 ·
- · Replies 7 ·
- · Replies 3 ·
- · Replies 2 ·
- · Replies 11 ·
- · Replies 1 ·
- · Replies 14 ·