complete dates pandas per group by

Robson Melchiades answered on May 4, 2022 Popularity 4/10 Helpfulness 1/10

answer complete dates pandas per group by

related complete dates pandas per group by

complete dates pandas per group by

Comment

# Get Min Per Group
dates = mydf.groupby('Id')['Dt'].min().to_frame(name='min')
# Get max from Frame
dates['max'] = mydf['Dt'].max()

# Create MultiIndex with separate Date ranges per Group
midx = pd.MultiIndex.from_frame(
    dates.apply(
        lambda x: pd.date_range(x['min'], x['max'], freq='MS'), axis=1
    ).explode().reset_index(name='Dt')[['Dt', 'Id']]
)

# Reindex
mydf = (
    mydf.set_index(['Dt', 'Id'])
        .reindex(midx, fill_value=0)
        .reset_index()
)

Popularity 4/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: group-by pandas python

Link to this answer
Share Copy Link

Contributed on May 04 2022

Robson Melchiades

0 Answers Avg Quality 2/10

Closely Related Answers

complete dates pandas per group by

Comment

s = (pd.MultiIndex.from_tuples([[x, d]
      for x, y in df.groupby("Id")["Dt"]
      for d in pd.date_range(min(y), max(df["Dt"]), freq="MS")], names=["Id", "Dt"]))

print (df.set_index(["Id", "Dt"]).reindex(s, fill_value=0).reset_index())

Popularity 4/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: group-by pandas python

Link to this answer
Share Copy Link

Contributed on May 04 2022

Robson Melchiades

0 Answers Avg Quality 2/10

complete dates pandas per group by

Contents

More Related Answers

complete dates pandas per group by

Closely Related Answers

complete dates pandas per group by

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.