Pandas groupby for zero values

by

You can use this:

df = df.groupby(['Symbol','Year']).count().unstack(fill_value=0).stack()
print (df)

Output:

             Action
Symbol Year        
AAPL   2001       2
       2002       0
BAC    2001       0
       2002       2

More Related Contents:

  1. How do I Pandas group-by to get sum?
  2. Get statistics for each group (such as count, mean, etc) using pandas GroupBy?
  3. How to groupby consecutive values in pandas DataFrame
  4. Python: get a frequency count based on two columns (variables) in pandas dataframe some row appers
  5. Pandas dataframe get first row of each group
  6. Pandas groupby multiple fields then diff
  7. How to access pandas groupby dataframe by key
  8. Python Pandas How to assign groupby operation results back to columns in parent dataframe?
  9. How can I use cumsum within a group in Pandas?
  10. pandas – find first occurrence
  11. Add a sequential counter column on groups to a pandas dataframe
  12. Group dataframe and get sum AND count?
  13. pandas divide row value by aggregated sum with a condition set by other cell
  14. Select row by max value in group in a pandas dataframe
  15. Pandas groupby with bin counts
  16. get first and last values in a groupby
  17. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  18. how to convert monthly data to quarterly in pandas
  19. Get the row corresponding to the max in pandas GroupBy [duplicate]
  20. Get frequency of item occurrences in a column as percentage [duplicate]
  21. How to get number of groups in a groupby object in pandas?
  22. How to change column names from numbers to names [closed]
  23. How to test if a string contains one of the substrings in a list, in pandas?
  24. How to convert index of a pandas dataframe into a column
  25. Pandas split DataFrame by column value
  26. NLTK-based text processing with pandas
  27. Convert list into a pandas dataframe
  28. Python: How to drop a row whose particular column is empty/NaN?
  29. Combine Pandas data frame column values into new column
  30. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13

Leave a Comment