Convert pandas dataframe from wide to long

by

You can replace the columns by a multi-index and stack:

df.columns = pd.MultiIndex.from_tuples(df.columns.str.split('_').map(tuple))
df = df.stack()

More Related Contents:

  1. converting a text file to csv file with out index
  2. Get the row(s) which have the max value in groups using groupby
  3. Error: pandas hashtable keyerror
  4. Writing a pandas DataFrame to CSV file
  5. pandas: How do I split text in a column into multiple rows?
  6. Find row where values for column is maximal in a pandas DataFrame
  7. Fast Haversine Approximation (Python/Pandas)
  8. How to filter rows containing a string pattern from a Pandas dataframe [duplicate]
  9. python/pandas: convert month int to month name
  10. How to form tuple column from two columns in Pandas
  11. Convert pandas Series to DataFrame
  12. How to keep leading zeros in a column when reading CSV with Pandas?
  13. Seaborn showing scientific notation in heatmap for 3-digit numbers
  14. Format certain floating dataframe columns into percentage in pandas
  15. Comparing two pandas dataframes for differences
  16. Read XLSB File in Pandas Python
  17. Print very long string completely in pandas dataframe
  18. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  19. How do I filter a pandas DataFrame based on value counts?
  20. Lambda including if…elif…else
  21. Create bool mask from filter results in Pandas [duplicate]
  22. Getting a list of indices where pandas boolean series is True
  23. Pandas DataFrame sort by categorical column but by specific class ordering
  24. How can I remove extra whitespace from strings when parsing a csv file in Pandas?
  25. convert entire pandas dataframe to integers in pandas (0.17.0)
  26. Remove NaN values from pandas dataframe and reshape table [duplicate]
  27. How to convert DataFrame.append() to pandas.concat()?
  28. how to save a pandas DataFrame to an excel file?
  29. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  30. Add image annotations to bar plots

Leave a Comment