Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.79 KB | None | 0 0
  1. import csv
  2. from tkinter.filedialog import askopenfilename
  3. import pandas
  4.  
  5. filename = ""
  6. while not filename.lower().endswith("csv"):
  7.     filename = askopenfilename() # show an "Open" dialog box and return the path to the selected file
  8.  
  9. ## get column letters from header name
  10. ## get column data from header name
  11.  
  12. with open(filename) as f:
  13.     spamreader = csv.reader(f, delimiter=' ', quotechar='|')
  14.     max_len = len(list(spamreader))
  15.  
  16.     def get_column_data(name):
  17.         da_list = []
  18.         for row in spamreader:
  19.             da_list.append(row[name])
  20.         return da_list
  21.  
  22.     print(get_column_data("Date"))
  23.  
  24. #colnames = ['Virtual Memory Commited [MB]']
  25. #data = pandas.read_csv(filename, names=colnames)
  26. #print(data)
  27.  
  28.        
  29.  
  30. ## for each column set warning conditions
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement