Right way to reverse a pandas DataFrame?

by 
data.reindex(index=data.index[::-1])

or simply:

data.iloc[::-1]

will reverse your data frame, if you want to have a for loop which goes from down to up you may do:

for idx in reversed(data.index):
    print(idx, data.loc[idx, 'Even'], data.loc[idx, 'Odd'])

or

for idx in reversed(data.index):
    print(idx, data.Even[idx], data.Odd[idx])

You are getting an error because reversed first calls data.__len__() which returns 6. Then it tries to call data[j - 1] for j in range(6, 0, -1), and the first call would be data[5]; but in pandas dataframe data[5] means column 5, and there is no column 5 so it will throw an exception. ( see docs )

More Related Contents:

  1. Reverse DataFrame column order
  2. How to deal with SettingWithCopyWarning in Pandas
  3. Apply multiple functions to multiple groupby columns
  4. Scatter plots in Pandas/Pyplot: How to plot by category [duplicate]
  5. GroupBy results to dictionary of lists
  6. Pandas timeseries plot setting x-axis major and minor ticks and labels
  7. How to remove nan value while combining two column in Panda Data frame?
  8. How do I operate on a DataFrame with a Series for every column?
  9. Improve subplot size/spacing with many subplots in matplotlib
  10. Pandas split column into multiple columns by comma
  11. Restart cumsum and get index if cumsum more than value
  12. How to use groupby to concatenate strings in python pandas?
  13. replace column values in one dataframe by values of another dataframe
  14. How to add an empty column to a dataframe?
  15. python pandas dataframe, is it pass-by-value or pass-by-reference
  16. Pandas expand rows from list data available in column
  17. Convert pandas DateTimeIndex to Unix Time?
  18. pandas dataframe select columns in multiindex [duplicate]
  19. Create Column with ELIF in Pandas
  20. Pandas – Compute z-score for all columns
  21. Selecting/excluding sets of columns in pandas [duplicate]
  22. pandas filtering and comparing dates
  23. Find date range overlap in python
  24. Reverse a get_dummies encoding in pandas
  25. Updating a value in a pandas dataframe in an iterrows loop
  26. Discrete legend in seaborn heatmap plot
  27. Clean way to convert quarterly periods to datetime in pandas
  28. Combine Pandas data frame column values into new column
  29. Wide to long data transform in pandas
  30. Is it possible to add a string as a legend item

Leave a Comment