# -*- coding: utf-8 -*-
"""
Spyder Editor

This is a temporary script file.
"""
#test
print("Hello Anaconda")

#time series plot of the data for each bin
    #"for each bin, do:"
    #time series plot
#from pandas import Series
#from matplotlib import pyplot
#series=Series.from_csv(r'C:\Users\mtahar\Documents\Python\07182015_AWAC1_data.csv', header=0)
#series.plot(x=[:,1],y=[:,2:4])
#pyplot.show()

import matplotlib.pyplot as plt
import pandas as pd
df=pd.read_excel(r'C:\Users\mtahar\Documents\Python\07182015_AWAC1_data.xls')
plt.plot(df[:,1], df[:,2:4])
plt.show()
#10 min average of flow speed for each bin
    #"for each bin, do:"
    #make a 10 min list
    #mean of a 10 min list
#from statistics import mean
#def Average(lst):
#    return mean(lst)

#from pandas import DataFrame, read_csv
#import matplotlib.pyplot as plt
#import pandas as pd
#file= r'C:\Users\mtahar\Documents\Python\07182015_AWAC1_data.xls'
#df=pd.read_excel(file, sheetname='AWAC')
#print(df['AWAC1/4001/C1/vel_2'])