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