have the following csv structure file. Time 1 2 3 01/01/2010 00:00 274,16 576,44 1523,9
I tried to convert time to timestamp but I cannot plot the data as I get the following error:
I tried to convert time to timestamp but I cannot plot the data as I get the following error:
Error:File "pandas/_libs/index.pyx", line 111, in pandas._libs.index.IndexEngine.get_loc File "pandas/_libs/index.pyx", line 138, in pandas._libs.index.IndexEngine.get_loc
File "pandas/_libs/hashtable_class_helper.pxi", line 1619, in pandas._libs.hashtable.PyObjectHashTable.get_item
File "pandas/_libs/hashtable_class_helper.pxi", line 1627, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: 'Time'
data=pd.read_csv('test.csv', delimiter='delimiter', header='infer') data.head() data['Timestamp']=pd.to_datetime(data['Time']) plt.figure(num=1, figsize=(10,5)) data.Timestamp.plot() #Plotting the newly added timestamp column plt.xlabel('Reading Count') plt.ylabel('Date') plt.show()I am wondering if anybody could help me to plot some data from the excel source provided in the following Github link: https://github.com/charlicruz/Energy-Demand