Fastest way to sort each row in a pandas dataframe

by

I think I would do this in numpy:

In [11]: a = df.values

In [12]: a.sort(axis=1)  # no ascending argument

In [13]: a = a[:, ::-1]  # so reverse

In [14]: a
Out[14]:
array([[8, 4, 3, 1],
       [9, 7, 2, 2]])

In [15]: pd.DataFrame(a, df.index, df.columns)
Out[15]:
   A  B  C  D
0  8  4  3  1
1  9  7  2  2

I had thought this might work, but it sorts the columns:

In [21]: df.sort(axis=1, ascending=False)
Out[21]:
   D  C  B  A
0  1  8  4  3
1  2  7  2  9

Ah, pandas raises:

In [22]: df.sort(df.columns, axis=1, ascending=False)

ValueError: When sorting by column, axis must be 0 (rows)

More Related Contents:

  1. When should I (not) want to use pandas apply() in my code?
  2. Does pandas iterrows have performance issues?
  3. Why does concatenation of DataFrames get exponentially slower?
  4. Replace values in a pandas series via dictionary efficiently
  5. What is the most efficient way to loop through dataframes with pandas?
  6. pandas loc vs. iloc vs. at vs. iat?
  7. Performance of Pandas apply vs np.vectorize to create new column from existing columns
  8. Pandas: peculiar performance drop for inplace rename after dropna
  9. What is the performance impact of non-unique indexes in pandas?
  10. Efficiently return the index of the first value satisfying condition in array
  11. Most efficient way to forward-fill NaN values in numpy array
  12. Vectorizing Haversine distance calculation in Python
  13. Pandas pd.Series.isin performance with set versus array
  14. Vectorizing or Speeding up Fuzzywuzzy String Matching on PANDAS Column
  15. What is the fastest way to output large DataFrame into a CSV file?
  16. Select the max row per group – pandas performance issue
  17. Getting days since last occurence in Pandas DataFrame?
  18. Split Python sequence (time series/array) into subsequences with overlap
  19. Can I perform dynamic cumsum of rows in pandas?
  20. Filter pandas DataFrame by substring criteria
  21. Pandas Extract Number from String
  22. How to flatten a pandas dataframe with some columns as json?
  23. How to drop duplicates based on two or more subsets criteria in Pandas data-frame
  24. How to show all columns’ names on a large pandas dataframe?
  25. In Pandas, does .iloc method give a copy or view?
  26. HDF5 – concurrency, compression & I/O performance [closed]
  27. Searching for a string in a large text file – profiling various methods in python
  28. How to plot multiple bars grouped
  29. How to easily share a sample dataframe using df.to_dict()
  30. Detecting thresholds in HSV color space (from RGB) using Python / PIL

Leave a Comment