Creation of pandas dataframe, repeating entries with loop

Question

I'm trying to pad out a dataframe that I'm using to graph some sales data to fill the remaining weeks of the year with zeros. My code is as follows:

weeks = [x for x in range(max(sales['WEEK']+1),53)]
padding = pd.DataFrame(np.zeros((53max(sales['WEEK']+1),len(sales.columns))),index=weeks)

Which returns me a pandas DataFrame 43 rows x 3 columns. What I really need to do is repeat the index of each of my 43 rows 7 times, giving me a DataFrame with 301 rows . I can't work this out, any ideas?

BENY · Accepted Answer · 2018-03-02 16:02:13Z

1

Assuming you have the df as you dataframe with shape (43,3)

With repeat+reindex

New_df=df.reindex(df.index.repeat([7]*len(df)))

answered Mar 2, 2018 at 16:02

BENY

324k22 gold badges176 silver badges250 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

BENY Over a year ago

@roastbeeef yw~ : -) happy coding

Collectives™ on Stack Overflow

Creation of pandas dataframe, repeating entries with loop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related