How to increment date range by a value from a date record in pandas python? -


let's have:

{"uid": 1111, "from": "2015-11-07", "to": "2015-12-31"} 

and date range below:

datetimeindex(['2011-12-31', '2012-12-31', '2013-12-15', '2015-12-01',                '2015-12-16'],               dtype='datetime64[ns]', freq='a-dec', tz=none) 

i turn datetimeindex dataframe. want achieve increment column called count 1 when date exist in range. example below dates should have been incremented:

'2015-12-01', '2015-12-16' 

is want?

    in [1]: import pandas      in [2]: index = pandas.datetimeindex(['2011-12-31', '2012-12-31', '2013-12-15', '2015-12-01', '2015-12-16'],        ...: dtype='datetime64[ns]',  tz=none)      in [3]: df = pandas.dataframe(index=index)      in [4]: df["count"] = 0      in [5]: df.loc["2015-11-07":"2015-12-31"] += 1      in [6]: df     out[6]:                  count     2011-12-31      0     2012-12-31      0     2013-12-15      0     2015-12-01      1     2015-12-16      1 

Comments