00:39:47	Christian Barreto:	jupyter notebook --notebook-dir=D:/
00:51:19	Christian Barreto:	soi_data=soi.melt(id_vars=["YEAR"],var_name="MON",value_name = "SOI").sort_values(by="YEAR").reset_index(drop=True)
01:08:26	Christian Barreto:	nino12_r=nino["ANOM"].rolling(3,center=True).mean()
nino12_r = nino12_r.iloc[1:]
nino12_r = nino12_r.iloc[:-1]
nino12_r = nino12_r.reset_index(drop=True)
nino12_r
01:10:53	Christian Barreto:	soi_data.SOI
soi_ad=soi_data.SOI.iloc[1:]
soi_ad=soi_ad.iloc[:-1]
soi_ad=soi_ad.reset_index(drop=True)
soi_ad
01:12:42	Christian Barreto:	soi_ad.plot(marker="*")
01:15:38	Christian Barreto:	newdata = pd.concat([nino12_r,soi_ad],axis=1)
01:16:00	Christian Barreto:	#SCATTER PLOT IOS NINO1+2
ax=newdata.plot.scatter(x="SOI",y="ANOM",marker="x")
ax.axvline(0,color="k")
ax.axhline(0,color="k")

ax.set_title("SOI VS ANOM1+2")
01:20:11	Christian Barreto:	*****************************
01:20:13	Christian Barreto:	soi_data=soi.melt(id_vars=["YEAR"],var_name="MON",value_name = "SOI").sort_values(by="YEAR").reset_index(drop=True)
01:29:53	Christian Davila:	Comparte los cuadernos de jupyter por tu github
02:36:18	Christian Barreto:	**************************
02:36:21	Christian Barreto:	# Analisis exp datos Itaca

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

file="Table1.xls"
data=pd.read_excel(file)
data
02:39:38	Christian Barreto:	x=data["tmin"].mean()
med=data["tmin"].median()
q50=data["tmin"].quantile(0.50)
q75=data["tmin"].quantile(0.75)
q25=data["tmin"].quantile(0.25)
#trimean
tmean=(q25+2*q50+q75)/4
02:47:31	Christian Barreto:	x=data["tmin"].mean()
med=data["tmin"].median()
q50=data["tmin"].quantile(0.50)
q75=data["tmin"].quantile(0.75)
q25=data["tmin"].quantile(0.25)
#trimean
tmean=(q25+2*q50+q75)/4

#rango intercuantil

iqr=q75-q25
vrz=data["tmin"].var()
estd=data["tmin"].std()

#simetria de yule-kendal index
yki=(q25-2*q50+q75)/iqr

# imprimiendo en consola
print("media: ",x)
print("q25:", q25)
print("q75:", q75)
print("----------------")
print("trimean:", tmean)
print("varianza:", vrz)
print("STD:", estd)
02:55:33	Christian Barreto:	%reset -sf
import pandas as pd

file="Chuquibambilla_Puno.xlsx"
data=pd.read_excel(file)
data
02:57:17	Christian Barreto:	data_idx=data.set_index("FECHA")
data_idx
02:58:18	Christian Barreto:	data_idx.loc[data_idx.index.month==2]
03:00:01	Christian Barreto:	# chequear comandos pivot, groupby
03:02:20	Christian Barreto:	#selecting months
# chequear comandos pivot, groupby
jan=data_idx.loc[data_idx.index.month==1].reset_index(drop=True)
feb=data_idx.loc[data_idx.index.month==2].reset_index(drop=True)
mar=data_idx.loc[data_idx.index.month==3].reset_index(drop=True)
abr=data_idx.loc[data_idx.index.month==4].reset_index(drop=True)
may=data_idx.loc[data_idx.index.month==5].reset_index(drop=True)
jun=data_idx.loc[data_idx.index.month==6].reset_index(drop=True)
jul=data_idx.loc[data_idx.index.month==7].reset_index(drop=True)
ago=data_idx.loc[data_idx.index.month==8].reset_index(drop=True)
sep=data_idx.loc[data_idx.index.month==9].reset_index(drop=True)
ocb=data_idx.loc[data_idx.index.month==10].reset_index(drop=True)
nov=data_idx.loc[data_idx.index.month==11].reset_index(drop=True)
dic=data_idx.loc[data_idx.index.month==12].reset_index(drop=True)
03:03:05	Christian Barreto:	jan.rename(columns={'CHUQUIBAMBILLA': 'ene'},inplace=True)
feb.rename(columns={'CHUQUIBAMBILLA': 'feb'},inplace=True)
mar.rename(columns={'CHUQUIBAMBILLA': 'mar'},inplace=True)
abr.rename(columns={'CHUQUIBAMBILLA': 'abr'},inplace=True)
may.rename(columns={'CHUQUIBAMBILLA': 'may'},inplace=True)
jun.rename(columns={'CHUQUIBAMBILLA': 'jun'},inplace=True)
jul.rename(columns={'CHUQUIBAMBILLA': 'jul'},inplace=True)
ago.rename(columns={'CHUQUIBAMBILLA': 'ago'},inplace=True)
sep.rename(columns={'CHUQUIBAMBILLA': 'sep'},inplace=True)
ocb.rename(columns={'CHUQUIBAMBILLA': 'oct'},inplace=True)
nov.rename(columns={'CHUQUIBAMBILLA': 'nov'},inplace=True)
dic.rename(columns={'CHUQUIBAMBILLA': 'dic'},inplace=True)
03:11:02	Christian Barreto:	newdata = pd.concat([jan, feb,mar,abr,may,jun,jul,ago,sep,ocb,nov,dic],axis=1)
newdata
03:13:36	Christian Barreto:	import matplotlib.pyplot as plt
03:16:56	Christian Barreto:	import matplotlib.pyplot as plt
ax=newdata.mean().plot(kind="bar")
newdata.quantile(0.10).plot(style="k",linestyle="dashed")
newdata.quantile(0.50).plot(style="g",linestyle="dashed")
newdata.quantile(0.75).plot(style="yellow",linestyle="dashed")
newdata.quantile(0.95).plot(style="red",linestyle="dashed")

plt.savefig("plot_chuquibambilla_means_prctl.png",dpi=300)
03:24:29	Christian Barreto:	# analizamos un año en especifico, año 1983(niño)
date1="1956"
date2="2014"

mydates=pd.date_range(date1,date2,freq="Y").strftime("%Y")
mydates
03:24:40	Christian Barreto:	data_idx=newdata.set_index(mydates)
data_idx
03:29:16	Christian Barreto:	#selecionamos año 1999
d99=data_idx.loc["1999"]
ax=d99.plot.bar()
newdata.quantile(0.10).plot(style="k",linestyle="dashed")
newdata.quantile(0.50).plot(style='g',linestyle="dashed")
newdata.quantile(0.75).plot(style='yellow',linestyle="dashed")
newdata.quantile(0.95).plot(style='red',linestyle="dashed")

ax.set_title('PP, 199')
03:50:21	ALANIA SUMARAN JOEL YOEL DZ02:	#DATOS EXTRAS
%reset -sf
import pandas as pd

file = "otrasestaciones.xlsx"
data1=pd.read_excel(file)
data = data1.iloc[:,0:2]
data_idx=data.set_index("FECHA")

jan=data_idx.loc[data_idx.index.month==1].reset_index(drop=True)
feb=data_idx.loc[data_idx.index.month==2].reset_index(drop=True)
mar=data_idx.loc[data_idx.index.month==3].reset_index(drop=True)
abr=data_idx.loc[data_idx.index.month==4].reset_index(drop=True)
may=data_idx.loc[data_idx.index.month==5].reset_index(drop=True)
jun=data_idx.loc[data_idx.index.month==6].reset_index(drop=True)
jul=data_idx.loc[data_idx.index.month==7].reset_index(drop=True)
ago=data_idx.loc[data_idx.index.month==8].reset_index(drop=True)
sep=data_idx.loc[data_idx.index.month==9].reset_index(drop=True)
ocb=data_idx.loc[data_idx.index.month==10].reset_index(drop=True)
nov=data_idx.loc[data_idx.index.month==11].reset_index(drop=True)
dic=data_idx.loc[data_idx.index.month==12].reset_index(drop=True)

jan.rename(columns={'JAUJA': 'ene'},inplace=True)
feb.rename(columns={'JAUJA':
04:01:12	Christian Davila:	buenas noches, gracias
04:02:26	Stefany Amado Menauth DZ6:	Las grabaciones del curso, las subirán al campus virtual?
04:03:15	Stefany Amado Menauth DZ6:	Gracias
04:03:22	Lia Nicolle:	Muchas gracias
04:03:22	Jorge Poma  Dz11:	Buenas noches, felices fiestas
04:03:23	José Luis Ñiquen Sánchez DZ11:	gracias