Python: Random selection per group

by

From 0.16.x onwards pd.DataFrame.sample provides a way to return a random sample of items from an axis of object.

In [664]: df.groupby('Group_Id').apply(lambda x: x.sample(1)).reset_index(drop=True)
Out[664]:
  Name  Group_Id
0  ABC         1
1  XYZ         2
2  DEF         3

More Related Contents:

  1. Generating random dates within a given range in pandas
  2. Read a small random sample from a big CSV file into a Python data frame
  3. Random row selection in Pandas dataframe
  4. Sample each group after pandas groupby
  5. Split pandas dataframe based on groupby
  6. Fast punctuation removal with pandas
  7. pandas loc vs. iloc vs. at vs. iat?
  8. Skip rows during csv import pandas
  9. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  10. How to check if any value is NaN in a Pandas DataFrame
  11. How to drop rows from pandas data frame that contains a particular string in a particular column? [duplicate]
  12. pandas dataframe groupby datetime month
  13. Find the end of the month of a Pandas DataFrame Series
  14. vlookup in Pandas using join
  15. Vectorised Haversine formula with a pandas dataframe
  16. pandas multiprocessing apply
  17. Memory error when using pandas read_csv
  18. Python Pandas replicate rows in dataframe
  19. How to copy/paste DataFrame from Stack Overflow into Python
  20. Improve Row Append Performance On Pandas DataFrames
  21. What is correct syntax to swap column values for selected rows in a pandas data frame using just one line?
  22. Can’t drop NAN with dropna in pandas
  23. Legend only shows one label when plotting with pandas
  24. How to read a list of parquet files from S3 as a pandas dataframe using pyarrow?
  25. Error: The truth value of a Series is ambiguous – Python pandas
  26. Computing diffs within groups of a dataframe
  27. Is it possible to add a string as a legend item in matplotlib
  28. append dictionary to data frame
  29. ValueError: Shape of passed values is (1, 6), indices imply (6, 6)
  30. Random Python dictionary key, weighted by values

Leave a Comment