Re: format number is not recognized in a cycle

Dear all, Dear Peter, could you suggest me one? Thanks a lot, Diego On Monday, 4 February 2019 13:58:17 UTC+1, Diego Avesani wrote: > Dear all, > > I have this dataframe: > > datatime,T,RH,PSFC,DIR,VEL10,PREC,RAD,CC,FOG > 2012-01-01 06:00, 0.4,100, 911,321, 2.5, 0.0,

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

12-01-01 14:00, 3.3, 68, 912, 42, 0.5, 0.0, 151, 22,0 Hope this could help in finding a way to sum value belonging to the same month. Thanks again, a lot Diego On Monday, 4 February 2019 15:50:52 UTC+1, Diego Avesani wrote: > Dear all, > > I am reading the following data-frame: &g

Re: format number is not recognized in a cycle

ks On Monday, 4 February 2019 20:00:32 UTC+1, Peter Otten wrote: > Diego Avesani wrote: > > > this is the code: > > While the example is fine now it runs without error over here, on rather old > versions of pandas (0.13.1) and numpy (1.8.2). > > The

Re: format number is not recognized in a cycle

0, 0,0 2012-01-01 21:00, -7.7,100, 818,118, 0.7, 0.0, 0, 0,0 2012-01-01 22:00, -7.8,100, 817,130, 0.5, 0.0, 0, 0,0 2012-01-01 23:00, -7.9,100, 816,160, 0.6, 0.0, 0, 0,0 2012-01-02 00:00, -8.3,100, 816,123, 0.6, 0.0, 0, 0,0 2012-01-02 01:00, -8.6,100, 815,119, 0.8, 0.0,

pandas read dataframe and sum all value same month and year

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

format number is not recognized in a cycle

Dear all, I have this dataframe: datatime,T,RH,PSFC,DIR,VEL10,PREC,RAD,CC,FOG 2012-01-01 06:00, 0.4,100, 911,321, 2.5, 0.0, 0, 0,0 2012-01-01 07:00, 0.8,100, 911,198, 0.8, 0.0, 0, 22,0 2012-01-01 08:00, 0.6,100, 912, 44, 1.2, 0.0, 30, 22,0 2012-01-01 09:00, 3.1, 76, 912, 22, 0.8,

Re: mask and proper index

of forum. In this moment, I have another problem related to the data I am working on. Should I write another post? Should I do something else related to this post? Thanks a lot again, you are my lifesaver On Sunday, 3 February 2019 16:56:44 UTC+1, Diego Avesani wrote: > Dear all, >

mask and proper index

Dear all, I am trying to apply a mask to my dataframe: mask = (df['datatime'] > start_date) & (df['datatime'] <= end_date) df = df.loc[mask] It seems to work pretty well. After that I crate the cumulative of its element as: PP_cumPP = np.cumsum(df[PP_station]) However, I am not able to co