shuffling/permutating a DataFrame in pandas

by

Use numpy’s random.permuation function:

In [1]: df = pd.DataFrame({'A':range(10), 'B':range(10)})

In [2]: df
Out[2]:
   A  B
0  0  0
1  1  1
2  2  2
3  3  3
4  4  4
5  5  5
6  6  6
7  7  7
8  8  8
9  9  9


In [3]: df.reindex(np.random.permutation(df.index))
Out[3]:
   A  B
0  0  0
5  5  5
6  6  6
3  3  3
8  8  8
7  7  7
9  9  9
1  1  1
2  2  2
4  4  4

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Converting between datetime, Timestamp and datetime64
  3. Fast Haversine Approximation (Python/Pandas)
  4. How to get value counts for multiple columns at once in Pandas DataFrame?
  5. Pandas Timedelta in Days
  6. Conditionally fill column values based on another columns value in pandas
  7. Calculate weighted average using a pandas/dataframe
  8. How to remove blanks/NA’s from dataframe and shift the values up
  9. Pandas finding local max and min
  10. Take multiple lists into dataframe
  11. extracting days from a numpy.timedelta64 value
  12. selecting across multiple columns with python pandas?
  13. Populate a Pandas SparseDataFrame from a SciPy Sparse Matrix
  14. Vectorized look-up of values in Pandas dataframe
  15. Problem in combining bar plot and line plot (python)
  16. PIP Install Numpy throws an error “ascii codec can’t decode byte 0xe2”
  17. vectorize conditional assignment in pandas dataframe
  18. Pandas: How to create a datetime object from Week and Year?
  19. Binning a column with pandas
  20. Convert numpy type to python
  21. Concat DataFrame Reindexing only valid with uniquely valued Index objects
  22. Numpy isnan() fails on an array of floats (from pandas dataframe apply)
  23. Store numpy.array in cells of a Pandas.DataFrame
  24. plotting a histogram on a Log scale with Matplotlib
  25. Filtering pandas dataframe with multiple Boolean columns
  26. Parse a Pandas column to Datetime when importing table from SQL database and filtering rows by date
  27. How to resample a dataframe with different functions applied to each column?
  28. Resample time series in pandas to a weekly interval
  29. Convert a column of timestamps into periods in pandas
  30. How to use numpy to get the cumulative count by unique values in linear time?

Leave a Comment