Reverse DataFrame column order

by

A solution close to what you have already tried is to use:

>>> football[football.columns[::-1]]
   losses  wins     team  year
0       5    11    Bears  2010
1       8     8    Bears  2011
2       6    10    Bears  2012
3       1    15  Packers  2011
4       5    11  Packers  2012
5      10     6    Lions  2010
6       6    10    Lions  2011
7      12     4    Lions  2012

football.columns[::-1] reverses the order of the DataFrame’s sequence of columns, and football[...] reindexes the DataFrame using this new sequence.

A more succinct way to achieve the same thing is with the iloc indexer: 

football.iloc[:, ::-1]

The first : means “take all rows”, the ::-1 means step backwards through the columns.

The loc indexer mentioned in @PietroBattiston’s answer works in the same way.

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. How to switch columns rows in a pandas dataframe
  20. Pandas groupby.size vs series.value_counts vs collections.Counter with multiple series
  21. Remove name, dtype from pandas output of dataframe or series
  22. pandas – find first occurrence
  23. How to convert a dataframe to a dictionary
  24. Max and Min date in pandas groupby
  25. Read CSV into a dataFrame with varying row lengths using Pandas
  26. What’s the best way to sum all values in a Pandas dataframe? [duplicate]
  27. Combine Pandas data frame column values into new column
  28. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  29. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  30. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path

Leave a Comment