How to save the rows in different columns based on the conditions?

Question

I want to select rows based on the index like 0 to 30 index & save them to a data frame and again pick the index from 30 to 60 & save them into the same data frame but different column and I want to do it multiple times. How can I do that?

I don't know how to do it, please help me out.

Please provide enough code so others can better understand or reproduce the problem. — Community, Sep 26 '21 at 17:14

score 0 · Answer 1 · answered Sep 19 '21 at 07:51

0

If df is is your initial DataFrame:

df1 = pd.DataFrame(index = df.index)
df1['<=30'] = df[df.index <= 30]['your_col_of_interest']
df1['>30 & <60'] = df[(df.index > 30) & (df.index <= 60)]['your_col_of_interest']

answered Sep 19 '21 at 07:51

chambeeee

95
9

How to save the rows in different columns based on the conditions?

1 Answers1