How to plot timestamps within a row?

  • Thread starter Thread starter msn009
  • Start date Start date
  • Tags Tags
    Plot Python Row
Click For Summary
The discussion centers on plotting timestamp data from a dataset where timestamps are embedded within each row. The original poster seeks guidance on how to visualize the distribution of these values using Python. Participants suggest that stripping off seconds and milliseconds from the timestamps should simplify the process. They recommend using spreadsheets, which offer various time display options and built-in plotting capabilities. For those familiar with programming, alternatives like C, VB.NET, or awk are mentioned as effective methods for processing the data. Specifically, awk is highlighted for its simplicity in extracting specific columns from the dataset, facilitating easier plotting afterward.
msn009
Messages
53
Reaction score
6
i have a dataset that has the timestamp data within each row and I am trying to plot the values to see the distribution but have no idea how to do it if the data is presented this way as attached. any ideas? thanks
 

Attachments

  • pic5.png
    pic5.png
    7.3 KB · Views: 402
Technology news on Phys.org
are you not able to strip off the seconds and milliseconds? Seems like this should be trivially easy. What language are you using?
 
phinds said:
What language are you using?
Several other threads by the OP show Python code.
 
Read it into a spreadsheet. Most spreadsheets include many ways to read or display time. The spreadsheet can also make the plots for you.
 
what he said (very small).jpg
 

Attachments

  • what he said (very small).jpg
    what he said (very small).jpg
    3.3 KB · Views: 407
  • Like
Likes jedishrfu
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.
 
msn009 said:
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.
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.
 
awk would be the easiest thing to use if you're on linux.
Code: 
awk '{print $2}' input filename_goes_here >outputfilename_goes_here
Awk processes each line and prints out only the second column and from there you can plot the data
 
  • Like
Likes anorlunda

Similar threads

Python Partial pivoting in getting the reduced row echelon form of a matrix
  • · Replies 2 ·
Replies
2
Views
2K
MySQL: Best way to warehouse older data
  • · Replies 9 ·
Replies
9
Views
2K
Python Updating a figure made using Plotly
  • · Replies 3 ·
Replies
3
Views
2K
Python Query runs fine in MySQL, but returns empty list in Python
  • · Replies 7 ·
Replies
7
Views
4K
Python Help with Histogram and Boxplot in Python
  • · Replies 3 ·
Replies
3
Views
2K
Python Graphing a piecewise function (Python)
  • · Replies 2 ·
Replies
2
Views
4K
3d plot of interference from 2 wave sources with 2d grid surface
  • · Replies 2 ·
Replies
2
Views
2K
Why does my loop run slower with larger lists in Python?
  • · Replies 11 ·
Replies
11
Views
946
Python How to plot timeseries data in Python
  • · Replies 1 ·
Replies
1
Views
1K
How do programs draw function graphs?
  • · Replies 14 ·
Replies
14
Views
2K