How to pivot a dataframe in Pandas? [duplicate]

by

You can use pivot_table:

pd.pivot_table(df, values="Value", index=['Country','Year'], columns="Indicator").reset_index()

this outputs:

 Indicator  Country     Year    1   2   3   4   5
 0          Angola      2005    6   13  10  11  5
 1          Angola      2006    3   2   7   3   6

More Related Contents:

  1. How to switch columns rows in a pandas dataframe
  2. Convert column to row in Python Pandas
  3. Transpose the data in a column every nth rows in PANDAS
  4. Filter pandas DataFrame by substring criteria
  5. Binning a column with Python Pandas
  6. Pandas split DataFrame by column value
  7. How to take column-slices of dataframe in pandas
  8. Pandas groupby multiple fields then diff
  9. Numpy “where” with multiple conditions
  10. Shuffle DataFrame rows
  11. Pandas dataframe groupby plot
  12. Remove duplicates from dataframe, based on two columns A,B, keeping row with max value in another column C
  13. Rename specific column(s) in pandas
  14. How to access pandas groupby dataframe by key
  15. Concatenate a list of pandas dataframes together
  16. How to drop duplicates based on two or more subsets criteria in Pandas data-frame
  17. NLTK-based text processing with pandas
  18. How to show all columns’ names on a large pandas dataframe?
  19. python pandas dataframe slicing by date conditions
  20. In Pandas, does .iloc method give a copy or view?
  21. Python – Delete duplicates in a dataframe based on two columns combinations?
  22. Scraping dynamic data selenium – Unable to locate element
  23. Convert list into a pandas dataframe
  24. Python Pandas: Convert “.value_counts” output to dataframe
  25. Remove NaN/NULL columns in a Pandas dataframe?
  26. Group DataFrame in 5-minute intervals
  27. Remove ends of string entries in pandas DataFrame column
  28. How to convert DataFrame.append() to pandas.concat()?
  29. Pythonic/efficient way to strip whitespace from every Pandas Data frame cell that has a stringlike object in it
  30. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x

Leave a Comment