RE: pandas read dataframe and sum all value same month and year

2019-02-04 Thread Avi Gross
list@python.org Subject: Re: pandas read dataframe and sum all value same month and year Deal all, following Peter's suggestion, I put the example code: import pandas as pd import numpy as np from datetime import datetime #input: start_date = np.array(["2012-01-01 06:00",'

Re: pandas read dataframe and sum all value same month and year

2019-02-04 Thread Diego Avesani
Deal all, following Peter's suggestion, I put the example code: import pandas as pd import numpy as np from datetime import datetime #input: start_date = np.array(["2012-01-01 06:00",'2013-01-01 06:00','2014-01-01 06:00']) end_date = np.array(["2013-01-01 05:00",'2014-01-01 05:00','2015-01-0

pandas read dataframe and sum all value same month and year

2019-02-04 Thread Diego Avesani
Dear all, I am reading the following data-frame: datatime,T,RH,PSFC,DIR,VEL10,PREC,RAD,CC,FOG 2012-01-01 06:00, -0.1,100, 815,313, 2.6, 0.0, 0, 0,0 2012-01-01 07:00, -1.2, 93, 814,314, 4.8, 0.0, 0, 0,0 2012-01-01 08:00, 1.7, 68, 815,308, 7.5, 0.0, 41, 11,0 2012-01-01 09:00, 2.4, 65