Pandas, group by count and add count to original dataframe?

by

IIUC

In [247]: df['count'] = df.groupby('kind').transform('count')

In [248]: df
Out[248]:
    kind          msg  count
0    aaa   aaa text 1      3
1    aaa   aaa text 2      3
2    aaa   aaa text 3      3
3     bb    bb text 1      4
4     bb    bb text 2      4
5     bb    bb text 3      4
6     bb    bb text 4      4
7   cccc  cccc text 1      2
8   cccc  cccc text 2      2
9     dd    dd text 1      1
10     e     e text 1      1
11   fff   fff text 1      1

sorting:

In [249]: df.sort_values('count', ascending=False)
Out[249]:
    kind          msg  count
3     bb    bb text 1      4
4     bb    bb text 2      4
5     bb    bb text 3      4
6     bb    bb text 4      4
0    aaa   aaa text 1      3
1    aaa   aaa text 2      3
2    aaa   aaa text 3      3
7   cccc  cccc text 1      2
8   cccc  cccc text 2      2
9     dd    dd text 1      1
10     e     e text 1      1
11   fff   fff text 1      1

More Related Contents:

  1. How do I melt a pandas dataframe?
  2. How to split data into 3 sets (train, validation and test)?
  3. Requirements for converting Spark dataframe to Pandas/R dataframe
  4. Adding a column thats result of difference in consecutive rows in pandas
  5. Python/Pandas: counting the number of missing/NaN in each row
  6. pandas dataframe group and sort by weekday
  7. Merge two data frames based on common column values in Pandas
  8. Splitting multiple columns into rows in pandas dataframe
  9. Pandas- Select rows from DataFrame based on condition
  10. Why are Pandas and GeoPandas able to read a database table using a DBAPI (psycopg2) connection but have to rely on SQLAlchemy to write one?
  11. How to remove levels from a multi-indexed dataframe?
  12. Scrape tables into dataframe with BeautifulSoup
  13. Compare two DataFrames and output their differences side-by-side
  14. Selecting a row of pandas series/dataframe by integer index
  15. How do I find the closest values in a Pandas series to an input number?
  16. How do I count the NaN values in a column in pandas DataFrame?
  17. getting the index of a row in a pandas apply function
  18. How to flatten a pandas dataframe with some columns as json?
  19. Tilde sign in pandas DataFrame
  20. Drop columns whose name contains a specific string from pandas DataFrame
  21. Appending a list or series to a pandas DataFrame as a row?
  22. In Pandas, does .iloc method give a copy or view?
  23. Convert Pandas Series to DateTime in a DataFrame
  24. Why is np.where faster than pd.apply
  25. Extract column value based on another column in Pandas
  26. Python Pandas: Get index of rows where column matches certain value
  27. Change the color of text within a pandas dataframe html table python using styles and css
  28. Remove substring from column based on another column
  29. How can I draw scatter trend line on matplot? Python-Pandas
  30. DataFrame object has no attribute append

Leave a Comment