import numpy as np
import pandas as pd
import matplotlib.pyplot as plt


recovered_data_frame = pd.read_csv('time_series_covid_19_recovered.csv')

print(recovered_data_frame.head(5))

data_frame = recovered_data_frame.pivot_table(values=['1/22/20',
'1/23/20',
'1/24/20',
'1/25/20',
'1/26/20',
'1/27/20',
'1/28/20',
'1/29/20',
'1/30/20',
'1/31/20',
'2/1/20',
'2/2/20',
'2/3/20',
'2/4/20',
'2/5/20',
'2/6/20',
'2/7/20',
'2/8/20',
'2/9/20',
'2/10/20',
'2/11/20',
'2/12/20',
'2/13/20',
'2/14/20',
'2/15/20',
'2/16/20',
'2/17/20',
'2/18/20',
'2/19/20',
'2/20/20',
'2/21/20',
'2/22/20',
'2/23/20',
'2/24/20',
'2/25/20',
'2/26/20',
'2/27/20',
'2/28/20',
'2/29/20',
'3/1/20',
'3/2/20',
'3/3/20',
'3/4/20',
'3/5/20',
'3/6/20',
'3/7/20',
'3/8/20',
'3/9/20',
'3/10/20',
'3/11/20',
'3/12/20',
'3/13/20',
'3/14/20',
'3/15/20',
'3/16/20',
'3/17/20',
'3/18/20',
'3/19/20',
'3/20/20'], index=['Country/Region'], aggfunc=np.sum)


data_frame.reset_index(inplace=True)
print()
print(data_frame)

data_frame_t = data_frame.T
data_frame_t.reset_index(inplace=True)

print()
print(data_frame_t)

print(data_frame_t.columns)
fig = plt.figure()

#x = list(data_frame_t['index'][1:60].values)
#y = list(data_frame_t['0'][1:60].values)

#print(x)
#print(y)

#ax = plt.gca()

#plt.plot(kind='line',x='Country/Region',y='Afghanistan',ax=ax)
#plt.plot(x,y)
#plt.show()




