What is the most efficient way of counting occurrences in pandas?

by

I think df['word'].value_counts() should serve. By skipping the groupby machinery, you’ll save some time. I’m not sure why count should be much slower than max. Both take some time to avoid missing values. (Compare with size.)

In any case, value_counts has been specifically optimized to handle object type, like your words, so I doubt you’ll do much better than that.

More Related Contents:

  1. How can I pivot a dataframe?
  2. GroupBy pandas DataFrame and select most common value
  3. String concatenation of two pandas columns
  4. Pandas convert a column of list to dummies
  5. How to create a large pandas dataframe from an sql query without running out of memory?
  6. Find column name in pandas that matches an array
  7. How to add hovering annotations to a plot
  8. Sort a pandas dataframe series by month name
  9. Panda’s DataFrame – renaming multiple identically named columns
  10. PyInstaller and Pandas
  11. Converting between datetime and Pandas Timestamp objects
  12. Suppressing scientific notation in pandas? [duplicate]
  13. Remove or replace spaces in column names
  14. Pandas DataFrame column to list [duplicate]
  15. Bulk Insert A Pandas DataFrame Using SQLAlchemy
  16. Create Empty Dataframe in Pandas specifying column types
  17. What is the difference between Series.replace and Series.str.replace?
  18. How to plot multiple pandas columns
  19. pandas read_html ValueError: No tables found
  20. how to read certain columns from Excel using Pandas – Python
  21. How to slice a pandas DataFrame by position?
  22. How to merge csv files with different headers but same data on condition
  23. Writing a Python Pandas DataFrame to Word document
  24. Find unique values in a Pandas dataframe, irrespective of row or column location
  25. Select row from a DataFrame based on the type of the object(i.e. str)
  26. Selecting Data between Specific hours in a pandas dataframe
  27. Change the facecolor of boxplot in pandas
  28. How to annotate a seaborn barplot with the aggregated value
  29. Add column of empty lists to DataFrame
  30. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path

Leave a Comment