Opposite of melt in python pandas

by

there are a few ways;
using .pivot:

>>> origin.pivot(index='label', columns="type")['value']
type   a  b  c
label         
x      1  2  3
y      4  5  6
z      7  8  9

[3 rows x 3 columns]

using pivot_table:

>>> origin.pivot_table(values="value", index='label', columns="type")
       value      
type       a  b  c
label             
x          1  2  3
y          4  5  6
z          7  8  9

[3 rows x 3 columns]

or .groupby followed by .unstack:

>>> origin.groupby(['label', 'type'])['value'].aggregate('mean').unstack()
type   a  b  c
label         
x      1  2  3
y      4  5  6
z      7  8  9

[3 rows x 3 columns]

More Related Contents:

  1. How can I pivot a dataframe?
  2. Pandas long to wide reshape, by two variables
  3. Reshape wide to long in pandas
  4. Pandas DataFrame stack multiple column values into single column
  5. How to spread a column in a Pandas data frame
  6. Pandas: Difference between pivot and pivot_table. Why is only pivot_table working?
  7. Difference between pivot and pivot_table. Why is only pivot_table working?
  8. Transpose the data in a column every nth rows in PANDAS
  9. Python pandas groupby aggregate on multiple columns, then pivot
  10. How do I select rows from a DataFrame based on column values?
  11. Pandas Melt Function
  12. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  13. Python Pandas: Check if string in one column is contained in string of another column in the same row
  14. First non-null value per row from a list of Pandas columns
  15. Pandas: Filtering multiple conditions
  16. Fastest way to populate QTableView from Pandas data frame
  17. Get data from pandas into a SQL server with PYODBC
  18. Pivoting a Pandas Dataframe containing strings – ‘No numeric types to aggregate’ error
  19. how do I calculate a rolling idxmax
  20. binning a dataframe in pandas in Python [duplicate]
  21. What is the difference between pandas agg and apply function?
  22. Pandas: Return Hour from Datetime Column Directly
  23. From password-protected Excel file to pandas DataFrame
  24. Row-wise average for a subset of columns with missing values
  25. Plot multiple columns of pandas DataFrame using Seaborn
  26. Dynamically filtering a pandas dataframe
  27. Pandas: Creating aggregated column in DataFrame
  28. how to specify the datetime format in read_csv
  29. Drop row in pandas dataframe if any value in the row equals zero
  30. Get total values_count from a dataframe with Python Pandas

Leave a Comment