Create columns from single column pandas

Question

I have a dataframe with multiple columns but I want to focus on a specific one. From this column called "Value" I would like to create N columns where N is a window of the column "Value". I'll try to explain it better in the following image

In this particular case, my parameter N is equal to 5, but of course it can change dynamically. Starting from the first row, I want to take the next 5 values and transpose them to columns, the same for the second row, and so on so forth..

Can anyone help me to solve this problem?

My idea was to try to iterate over rows and assign values to subset of columns like this

df[['D1','D2','D3','D4','D5']].loc[1] = ['1','2','3','4','5']

but it seems that it's not possible.

akuiper · Accepted Answer · 2022-03-19 23:29:30Z

1

You are looking for shift:

for i in range(1, 6):
    df[f"D{i}"] = df["VALUE"].shift(-i)

answered Mar 19, 2022 at 23:29

akuiper

216k33 gold badges362 silver badges379 bronze badges

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

Collectives™ on Stack Overflow

Create columns from single column pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related