I am working with two series in Pandas
. Radiation with data every minute and Humidity with data every hour. I need to find the way to do the annual cycles and then perform a scatterplot, for this I need that my two series have the same amount of data and that is every hour. My Radiation data is every minute.
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
from datetime import datetime, timedelta
import matplotlib.dates as mdates
import scipy.stats
Data = np.genfromtxt('6001_Pira_1.csv', dtype='str', delimiter=',')
Fecha_Hora = Data[:,1]
Radiacion = Data[:,2].astype(np.float)
Temperatura = Data[:,3].astype(np.float)
Calidad = Data[:,4].astype(np.float)
Radiacion_Filtrado = Radiacion[(Calidad == 1) | (Calidad == 2)]
Fecha_Hora_Filtrada = Fecha_Hora[(Calidad == 1) | (Calidad == 2)]
FechaHora_1 = []
for i in range(len(Fecha_Hora_Filtrada)):
tmp = Fecha_Hora_Filtrada[i]
Date = datetime.strptime(tmp, '%Y-%m-%d %H:%M:%S') - timedelta(hours=5)
FechaHora_1.append(Date)
Radiacion_Proyecto = pd.DataFrame(Radiacion_Filtrado,FechaHora_1)
Radiacion_Proyecto = Radiacion_Proyecto['2016-03':]
#Ciclos diurnos
Serie = Radiacion_Proyecto
Median = []
Mean = []
perc25 = []
perc_75 = []
perc_10 = []
perc_90 = []
for i in range(24):
**# Si fuera Ciclo Anual
# Data['2015-' + np.str(i)] # La i son los 12 meses (Contador)
#print i**
a = Serie.between_time(np.str(i)+':00', np.str(i)+':59')
a = a.values[np.isfinite(a.values)]
Median.append(np.median(a))
Mean.append(np.mean(a))
perc25.append(np.percentile(a,25))
perc_75.append(np.percentile(a,75))
perc_10.append(np.percentile(a,10))
perc_90.append(np.percentile(a,90))
**#Ciclo anual
# Si fuera Ciclo Anual
#for i in range(12):
FP = Serie(['2016 -' + np.str(i)])
#a = Serie.between_time(np.str(i)+':00', np.str(i)+':59')
# La i son los 12 meses (Contador)
#print i** **No se como hacerlo!**