Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #98728

Plotting timeseries from a csv file using matplotlib

Show all headers | View raw

I have some csv data in the following format.

Ln	Dr	Tag	 Lab	   0:01   0:02  0:03  0:04   0:05  0:06  0:07  0:08  0:09	
L0	St  	 vT	 4R	     0	       0	 0	  0	    0      0	     0	      0       0		
L2	Tx 	 st	 4R	     8	       8	 8	  8	    8	    8	     8	      8       8	
L2	Tx 	 ss	 4R	     1	       1	 9	  6	    1	    0	     0	      6       7	

I want to plot a timeseries graph using the columns (`Ln` , `Dr`, `Tg`,`Lab`) as the keys and the `0:0n ` field as values on a timeseries graph.I want all the timeseries to be plotted on a single timeseries? 

I have the following code.

    #!/usr/bin/env python

    import matplotlib.pyplot as plt 
    import datetime
    import numpy as np
    import csv 
    import sys 
    
    
    with open("test.csv", 'r', newline='') as fin:
        reader = csv.DictReader(fin)
        for row in reader:
              key = (row['Ln'], row['Dr'], row['Tg'],row['Lab'])
              #code to extract the values and plot a timeseries.                                                                                                                                                                             
    ~  

How do I extract all the values in columns `0:0n` without induviduall specifying each one of them. 
                            

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Plotting timeseries from a csv file using matplotlib Karthik Sharma <karthik.sharma@gmail.com> - 2015-11-12 21:27 -0800
  Re: Plotting timeseries from a csv file using matplotlib Fabien <fabien.maussion@gmail.com> - 2015-11-13 12:51 +0100
  Re: Plotting timeseries from a csv file using matplotlib Denis McMahon <denismfmcmahon@gmail.com> - 2015-11-13 14:32 +0000

csiph-web