Python making multiple columns in a dataframe into a single column

Question

I have a large dataframe with multiple columns (>1000) in Python and i wish to combine them into a single column so that i can transfer it into excel in the format that i want it to be.

Eg.

1   100   500   900
2   200   600   1000
3   300   700   1100
4   400   800   1200

into

1  100
2  200
3  300
4  400
5  500
6  600
7  700
8  800
9  900
10 1000
11 1100
12 1200

Any suggestions/solutions are appreciated.

U13-Forward · Accepted Answer · 2021-07-21 09:50:49Z

1

If you can use pandas, try using Series with flatten:

print(pd.Series(df.values.flatten()))

Edit:

Or if you want to keep the order:

print(pd.concat([df[i] for i in df.columns]).reset_index(drop=True))

edited Jul 21, 2021 at 9:50

answered Jul 21, 2021 at 9:04

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

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

2 Comments

jaclynx Over a year ago

i tried this method but it seems like it rearranges the sequence of my values when in a single column

U13-Forward Over a year ago

@jaclynx Check my Edited: section, please accept and upvote if it works :)

Collectives™ on Stack Overflow

Python making multiple columns in a dataframe into a single column

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related