Python: Removing Rows on Count condition

by

Here you go with filter 

df.groupby('city').filter(lambda x : len(x)>3)
Out[1743]: 
  city
0  NYC
1  NYC
2  NYC
3  NYC

Solution two transform 

sub_df = df[df.groupby('city').city.transform('count')>3].copy() 
# add copy for future warning when you need to modify the sub df

More Related Contents:

  1. How are iloc and loc different?
  2. How to convert index of a pandas dataframe into a column
  3. How to reset index in a pandas dataframe? [duplicate]
  4. What rules does Pandas use to generate a view vs a copy?
  5. Pandas split DataFrame by column value
  6. Selecting a row of pandas series/dataframe by integer index
  7. What is the difference between using squared brackets or dot to access a column?
  8. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  9. Get column index from column name in python pandas
  10. Pandas groupby.size vs series.value_counts vs collections.Counter with multiple series
  11. Python Pandas: Get index of rows where column matches certain value
  12. Using replace efficiently in pandas
  13. In Python pandas, start row index from 1 instead of zero without creating additional column
  14. Selecting a range of columns in a dataframe
  15. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  16. start index at 1 for Pandas DataFrame
  17. How to split a dataframe string column into two columns?
  18. Annotate bars with values on Pandas bar plots
  19. Comparing two dataframes and getting the differences [duplicate]
  20. Pandas Groupby and Sum Only One Column
  21. Pandas Dataframe: Replacing NaN with row average
  22. How to read a .xlsx file using the pandas Library in iPython?
  23. Pandas Replace NaN with blank/empty string
  24. How to append rows in a pandas dataframe in a for loop?
  25. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  26. How to reorder indexed rows based on a list in Pandas data frame
  27. Trying to merge 2 dataframes but get ValueError
  28. Python pandas integer YYYYMMDD to datetime
  29. Replace NaN with empty list in a pandas dataframe
  30. When is it appropriate to use df.value_counts() vs df.groupby(‘…’).count()?

Leave a Comment