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

Este é um arquivo de script temporário.
"""
import numpy as np
import matplotlib.pyplot as plt

f=open("covid.dat")
header = f.readline()   #readline lê uma linha, observe a falta do "s", já readlines lê linhas
header = header.split() #separa os valores

linhas = f.readlines()  #lê todas as linhas restantes, observe o "s" a mais
mes,mortos, infec = [],[],[]
for linha in linhas:
    l = linha.split()
    mes.append(l[0])
    mortos.append(int(l[1]))
    infec.append(int(l[2]))
    
mortos = np.array(mortos)
infec = np.array(infec)
plt.title('Evolução covid-19 Brasil')
plt.plot(mes,infec,'-bs', label='Infectados')
plt.plot(mes,mortos,'-rs', label='Mortos')
plt.xlabel("Data")
plt.legend(loc="best")
plt.show()


# =============================================================================
# def read_ods(filename, sheet_no=0, header=0):
#     tab = ezodf.opendoc(filename=filename).sheets[sheet_no]
#     return pd.DataFrame({col[header].value:[x.value for x in col[header+1:]]
#                           for col in tab.columns()})
# =============================================================================
#covid=read_ods('covid19.ods')    
#covid
#Out[6]: 
#          Data  Mortes   Infect  ...  Casos/Dia  Mortos/Dia   NaN
#0   2020-02-26     0.0      1.0  ...        1.0         0.0  None
#1   2020-02-27     0.0      1.0  ...        0.0         0.0  None
#2   2020-02-28     0.0      1.0  ...        0.0         0.0  None
#3   2020-02-29     0.0      2.0  ...        1.0         0.0  None
#4   2020-03-01     0.0      2.0  ...        0.0         0.0  None
#5   2020-03-02     0.0      2.0  ...        0.0         0.0  None

#retirando NaN
#mortes = covid['Mortes'][np.logical_not(np.isnan(covid['Mortes']))]


#covid = ezodf.opendoc('covid19.ods').sheets[0]

#import pyexcel_ods3 as pods
#covid=pods.get_data("covid19.ods",start_column=1, column_limit=9, start_row=1, row_limit=39)