drop unused categories using groupby on categorical variable in pandas

by

Since version 0.23 you can specify observed=True in the groupby call to achieve the desired behavior.

More Related Contents:

  1. Filter dataframe rows if value in column is in a set list of values [duplicate]
  2. Converting a Pandas GroupBy output from Series to DataFrame
  3. Split a large pandas dataframe
  4. How can I obtain the element-wise logical NOT of a pandas Series?
  5. Pandas – Slice large dataframe into chunks
  6. Pandas convert a column of list to dummies
  7. Plotting grouped data in same plot using Pandas
  8. Python pandas slice dataframe by multiple index ranges
  9. Parsing a JSON string which was loaded from a CSV using Pandas
  10. Python – rolling functions for GroupBy object
  11. Prevent pandas from interpreting ‘NA’ as NaN in a string
  12. Key error when selecting columns in pandas dataframe after read_csv
  13. Missing data, insert rows in Pandas and fill with NAN
  14. pandas left join and update existing column
  15. Merge rows based on value (pandas to excel – xlsxwriter)
  16. How to round values only for display in pandas while retaining original ones in the dataframe?
  17. Use .corr to get the correlation between two columns
  18. Python-pandas: the truth value of a series is ambiguous
  19. How to select rows with one or more nulls from a pandas DataFrame without listing columns explicitly?
  20. How to add header row to a pandas DataFrame
  21. UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x8b in position 1: invalid start byte, while reading csv file in pandas
  22. How to drop column according to NAN percentage for dataframe?
  23. How to remove numbers from string terms in a pandas dataframe
  24. Sum columns by level in a pandas MultiIndex DataFrame
  25. How to remove rows in a Pandas dataframe if the same row exists in another dataframe?
  26. applying regex to a pandas dataframe
  27. Converting OHLC stock data into a different timeframe with python and pandas
  28. In pandas, can I deeply copy a DataFrame including its index and column?
  29. Intersection of two pandas dataframes based on column entries
  30. Create a Pandas DataFrame from deeply nested JSON

Leave a Comment