Plotting timeseries from a csv file using matplotlib

Karthik Sharma karthik.sharma at gmail.com
Fri Nov 13 00:27:58 EST 2015


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. 
                            



More information about the Python-list mailing list