Python Pandas: Convert Rows as Column headers [duplicate]

by

You’re looking for pivot_table:

In [11]: medals = df.pivot_table('no of medals', ['Year', 'Country'], 'medal')

In [12]: medals
Out[12]:
medal             Bronze  Gold  Silver
Year Country
1896 Afghanistan       3     5       4
     Algeria           3     1       2

and if you want to reorder the columns:

In [12]: medals.reindex_axis(['Gold', 'Silver', 'Bronze'], axis=1)
Out[12]:
medal             Gold  Silver  Bronze
Year Country
1896 Afghanistan     5       4       3
     Algeria         1       2       3

More Related Contents:

  1. Splitting dataframe into multiple dataframes
  2. How to select rows in a DataFrame between two values, in Python Pandas?
  3. Performance of Pandas apply vs np.vectorize to create new column from existing columns
  4. Get list from pandas dataframe column or row?
  5. How to convert a dataframe to a dictionary
  6. Pandas new column from groupby averages
  7. Pandas: replace substring in string
  8. Find the end of the month of a Pandas DataFrame Series
  9. Removing prefix from column names in Pandas
  10. How to concatenate two dataframes without duplicates?
  11. Most efficient way to forward-fill NaN values in numpy array
  12. removing time from date&time variable in pandas?
  13. Efficiently create sparse pivot tables in pandas?
  14. How to remove or hide x-axis labels from a seaborn / matplotlib plot
  15. Merging dataframes based on date range
  16. Computing np.diff in Pandas after using groupby leads to unexpected result
  17. Pandas: How to find a particular pattern in a dataframe column?
  18. python, sort descending dataframe with pandas
  19. Remove NaN ‘Cells’ without dropping the entire ROW (Pandas,Python3)
  20. Large Dataset Polynomial Fitting Using Numpy
  21. Pandas converting row with unix timestamp (in milliseconds) to datetime
  22. Extract int from string in Pandas
  23. Deleting multiple columns based on column names
  24. Number rows within group in increasing order in a pandas dataframe
  25. Plot a bar plot from a Pandas DataFrame
  26. Difference between pivot and pivot_table. Why is only pivot_table working?
  27. Comparing 2 columns of two Python Pandas dataframes and getting the common rows
  28. Applying uppercase to a column in pandas dataframe
  29. What’s the best way to sum all values in a Pandas dataframe? [duplicate]
  30. make pandas DataFrame to a dict and dropna

Leave a Comment