Re: format number is not recognized in a cycle

2019-02-04 Thread Diego Avesani
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, 0, 0,0 > 2012-01-01

Re: format number is not recognized in a cycle

2019-02-04 Thread Peter Otten
Diego Avesani wrote: > Dear Peter, Deal all, > > Trying different options, I manage this solution: > >mask = (df['datatime'] > str(start_date[ii])) & (df['datatime'] <= >str(end_date[ii])) > > As you can notice, I have put str before start_date[ii]) and end_date[ii]. > > What do you t

Re: format number is not recognized in a cycle

2019-02-04 Thread Diego Avesani
Dear Peter, Deal all, Trying different options, I manage this solution: mask = (df['datatime'] > str(start_date[ii])) & (df['datatime'] <= str(end_date[ii])) As you can notice, I have put str before start_date[ii]) and end_date[ii]. What do you think? Thanks On Monday, 4 February 20

Re: format number is not recognized in a cycle

2019-02-04 Thread Peter Otten
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). Therefore I'm out of the debugging cycle for now. -- https://mail.python.org/mailman/listinfo/python-list

Re: format number is not recognized in a cycle

2019-02-04 Thread Diego Avesani
Dear Peter, thanks a lot for your patience. this is the 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

Re: format number is not recognized in a cycle

2019-02-04 Thread Peter Otten
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, 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 > 20

format number is not recognized in a cycle

2019-02-04 Thread Diego Avesani
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,