Python Pandas – Combining Multiple Columns into one Staggered Column

by

First stack the columns and then drop the multiindex:

df.stack().reset_index(drop=True)
Out: 
0    A
1    E
2    B
3    F
4    C
5    G
6    D
7    H
dtype: object

More Related Contents:

  1. How to provide a reproducible copy of your DataFrame with to_clipboard()
  2. Filter pandas DataFrame by substring criteria
  3. Binning a column with Python Pandas
  4. Compare two DataFrames and output their differences side-by-side
  5. Selecting a row of pandas series/dataframe by integer index
  6. How to reversibly store and load a Pandas dataframe to/from disk
  7. How do I find the closest values in a Pandas series to an input number?
  8. How do I transpose dataframe in pandas without index?
  9. How to select all columns whose names start with X in a pandas DataFrame
  10. Remove reverse duplicates from dataframe
  11. How do I count the NaN values in a column in pandas DataFrame?
  12. Pandas finding local max and min
  13. How to split text in a column into multiple rows
  14. getting the index of a row in a pandas apply function
  15. How to flatten a pandas dataframe with some columns as json?
  16. Pandas merge two dataframes with different columns
  17. Pandas filter dataframe rows with a specific year
  18. Bin pandas dataframe by every X rows
  19. Pandas won’t fillna() inplace
  20. Apply function to each cell in DataFrame
  21. pandas apply function that returns multiple values to rows in pandas dataframe
  22. return max value from pandas dataframe as a whole, not based on column or rows
  23. FastAPI is very slow in returning a large amount of JSON data
  24. How to select rows with NaN in particular column?
  25. Store numpy.array in cells of a Pandas.DataFrame
  26. Filtering pandas dataframe with multiple Boolean columns
  27. Pandas: Incrementally count occurrences in a column
  28. Set value on an entire column of a pandas dataframe
  29. UnicodeDecodeError when reading CSV file in Pandas
  30. how to understand closed and label arguments in pandas resample method?

Leave a Comment