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
Post a Comment