python - Pandas cumulative function of series with dates and NaT -

-

this may known limitation, i'm struggling calculate cumulative minimum of series in pandas when series contains nat's. there way make work?

simple example below:

import pandas pd  s = pd.series(pd.date_range('2008-09-15', periods=10, freq='m')) s.loc[10] = pd.nat s.cummin()  valueerror: not convert object numpy datetime

this bug has been fixed in pandas 0.15.2 (to released).

as workaround, use skipna=false, , handle nats "manually":

import pandas pd import numpy np np.random.seed(1)  s = pd.series(pd.date_range('2008-09-15', periods=10, freq='m')) s.loc[10] = pd.nat np.random.shuffle(s) print(s) # 0    2008-11-30 # 1    2008-12-31 # 2    2009-01-31 # 3    2009-06-30 # 4    2008-10-31 # 5    2009-03-31 # 6    2008-09-30 # 7    2009-04-30 # 8           nat # 9    2009-05-31 # 10   2009-02-28 # dtype: datetime64[ns]  mask = pd.isnull(s) result = s.cummin(skipna=false) result.loc[mask] = pd.nat print(result)

yields

0    2008-11-30 1    2008-11-30 2    2008-11-30 3    2008-11-30 4    2008-10-31 5    2008-10-31 6    2008-09-30 7    2008-09-30 8           nat 9    2008-09-30 10   2008-09-30 dtype: datetime64[ns]

Comments

Post a Comment

Popular posts from this blog

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

-
i using activeadmin , have file doing this: activeadmin.register role something--- end however, server gives me error: runtimeerror: circular dependency detected while autoloading constant role /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:461:in `load_missing_constant' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:184:in `const_missing' ~/desktop/boxfox/app/admin/role.rb:1:in `<top (required)>' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:424:in `load' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:424:in `block in load_file' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:616:in `new_constants_in' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:423:in `load_file' /library/ruby/gems/2.0.0/gems/activesuppor
Read more

c++ - OpenMP unpredictable overhead -

-
i have simple openmp code runs 4 empty threads , reports time: #include "omp.h" #include <sys/time.h> #include <cstdio> double start_time; void process_thread() { } int main(){ struct timeval tv; gettimeofday(&tv, null); start_time = 1000*((double)tv.tv_sec + 1e-6*(double)tv.tv_usec); printf("beginning time: %.3fms ",start_time-start_time); #pragma omp parallel schedule(static,1) for(int i=0;i<4;i++) process_thread(); gettimeofday(&tv, null); double cur_time = 1000*((double)tv.tv_sec + 1e-6*(double)tv.tv_usec); printf("finishing time: %.3fms\n\n",cur_time-start_time); } without openmp running time small , consistent: beginning time: 0.000ms finishing time: 0.050ms beginning time: 0.000ms finishing time: 0.050ms beginning time: 0.000ms finishing time: 0.049ms beginning time: 0.000ms finishing time: 0.049ms beginning time: 0.000ms finishing time: 0.050ms beginnin
Read more

javascript - Wordpress slider, not displayed 100% width -

-
so im making first wordpress theme scratch going fine got problem. want slider on homepage 1 thing wrong. im setting width of image 100% !important doesnt go 100% width. makes image wider not 100%. example here: http://bit.ly/11ouebg see image doesnt contain whole width. can see background-color. really weird, im using meteor slides. i hope can me out :d
Read more