How to reorder indexed rows based on a list in Pandas data frame

by

You could set index on predefined order using reindex like

In [14]: df.reindex(["Z", "C", "A"])
Out[14]:
company  Amazon  Apple  Yahoo
Z             0      0    150
C           173      0      0
A             0    130      0

However, if it’s alphabetical order, you could use sort_index(ascending=False)

In [12]: df.sort_index(ascending=False)
Out[12]:
company  Amazon  Apple  Yahoo
name
Z             0      0    150
C           173      0      0
A             0    130      0

Like pointed below, you need to assign it to some variable

In [13]: df = df.sort_index(ascending=False)

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  3. How to unnest (explode) a column in a pandas DataFrame, into multiple rows
  4. How to drop rows of Pandas DataFrame whose value in a certain column is NaN
  5. Error: pandas hashtable keyerror
  6. Writing a pandas DataFrame to CSV file
  7. Remove unwanted parts from strings in a column
  8. pandas: How do I split text in a column into multiple rows?
  9. Find row where values for column is maximal in a pandas DataFrame
  10. How to filter rows containing a string pattern from a Pandas dataframe [duplicate]
  11. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  12. Drop rows containing empty cells from a pandas DataFrame
  13. Why does my Pandas DataFrame not display new order using `sort_values`?
  14. python/pandas: convert month int to month name
  15. How to check if a column exists in Pandas
  16. How to form tuple column from two columns in Pandas
  17. Convert pandas Series to DataFrame
  18. Pandas selecting by label sometimes return Series, sometimes returns DataFrame
  19. Pandas groupby.size vs series.value_counts vs collections.Counter with multiple series
  20. Remove name, dtype from pandas output of dataframe or series
  21. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  22. pandas: combine two columns in a DataFrame
  23. How do I filter a pandas DataFrame based on value counts?
  24. Lambda including if…elif…else
  25. Pandas query function not working with spaces in column names
  26. Pandas DataFrame sort by categorical column but by specific class ordering
  27. Remove NaN values from pandas dataframe and reshape table [duplicate]
  28. How to convert DataFrame.append() to pandas.concat()?
  29. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  30. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x

Leave a Comment