import csv
import numpy as np
import matplotlib.pyplot as plt
import pylab
import pandas as pd
from Tkinter import*
import tkFileDialog as filedialog
root=Tk()
root.fileName=filedialog.askopenfilename(filetypes=(("csv files","*csv"),("All files","*.*" )))
k=root.fileName
print(k)
root.destroy()
pd.read_csv(k).mul(0.8).to_csv('minitest.csv', index=False)

with open('minitest.csv', 'rb') as input, open('temp.csv', 'w') as output:
    reader = csv.reader(input, delimiter = ',')
    writer = csv.writer(output, delimiter = ',')

    all = []
    row = next(reader)
    row.insert(0, '0')
    all.append(row)
    for k, row in enumerate(reader):
        all.append([str(k+1)] + row)
    writer.writerows(all)

with open('temp.csv','rb') as f:
    r = csv.reader(f, delimiter='\t')
    data = [line for line in r]
with open('temp.csv','w') as f:
    w = csv.writer(f, lineterminator='\n')
    w.writerow(['Time','CH1','CH2','CH3','CH4','CH5','CH6','CH7','CH8'])
    w.writerows(data)
    print(data)

my_data = pd.read_csv('temp.csv',sep=u',', header=0, skip_footer=0)
my_data.plot(x='Time',y=['CH1','CH2','CH3','CH4','CH5','CH6','CH7','CH8'],figsize=(14, 10))
plt.show()