Pandas: Multiple columns into one column

by

The trick is to use stack()

df.stack().reset_index()
    
   level_0   level_1  0
0        0  Column 1  A
1        0  Column 2  E
2        1  Column 1  B
3        1  Column 2  F
4        2  Column 1  C
5        2  Column 2  G
6        3  Column 1  D
7        3  Column 2  H

More Related Contents:

  1. Fast punctuation removal with pandas
  2. How to one-hot-encode from a pandas column containing a list?
  3. Skip rows during csv import pandas
  4. Rename Pandas DataFrame Index
  5. Pandas groupby cumulative sum
  6. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  7. pandas dataframe groupby datetime month
  8. Pandas DataFrame concat vs append
  9. Pandas counting and summing specific conditions
  10. How to add multiple annotations to a barplot
  11. How do I get the row count of a Pandas DataFrame?
  12. forward fill specific columns in pandas dataframe
  13. How can I replicate rows in Pandas?
  14. pandas – get most recent value of a particular column indexed by another column (get maximum value of a particular column indexed by another column)
  15. How to create a DataFrame of random integers with Pandas?
  16. summing two columns in a pandas dataframe
  17. add a row at top in pandas dataframe [duplicate]
  18. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  19. Computing diffs within groups of a dataframe
  20. Specifying date format when converting with pandas.to_datetime
  21. Is it possible to add a string as a legend item in matplotlib
  22. Nested Dictionary to MultiIndex pandas DataFrame (3 level)
  23. Grouped Bar graph Pandas
  24. KeyError when indexing Pandas dataframe
  25. countplot with normalized y axis per group
  26. Check if certain value is contained in a dataframe column in pandas [duplicate]
  27. double quoted elements in csv cant read with pandas
  28. Pandas: Find rows which don’t exist in another DataFrame by multiple columns
  29. Resample time series in pandas to a weekly interval
  30. how to understand closed and label arguments in pandas resample method?

Leave a Comment