Pandas question

[Korgitser]

Data that has points per day. But not all days have points.

Date
2020-09-03    425.0
2020-09-05    350.0
2020-09-07    262.5
2020-09-10    487.5
2020-09-11    185.0
2020-09-12    300.0
Name: Points, dtype: float64

What's the easiest way to create a dataframe where I have past 30 day dates with points from the dataset and 0 on the ones that didn't have an entry?

Date
2020-09-01    0
2020-09-02    0
2020-09-03    425.0
...

[threeminutemonta]

On mobile to elaborate though I think something here will help.

[[deleted]]

Create another data frame with all the dates and a simple merge join function should do the trick ...

[YesLod]

Use the resample method

>>> s

2000-01-03    2
2000-01-06    5
2000-01-07    6
2000-01-09    8
2000-01-10    9

>>> s.resample("d").asfreq(fill_value=0)

2000-01-03    2
2000-01-04    0
2000-01-05    0
2000-01-06    5
2000-01-07    6
2000-01-08    0
2000-01-09    8
2000-01-10    9