SyntaxFix

[python] Group dataframe and get sum AND count?

If you have lots of columns and only one is different you could do:

In[1]: grouper = df.groupby('Company Name')
In[2]: res = grouper.count()
In[3]: res['Amount'] = grouper.Amount.sum()
In[4]: res
Out[4]:
                      Organisation Name   Amount
Company Name                                   
Vifor Pharma UK Ltd                  5  4207.93

Note you can then rename the Organisation Name column as you wish.

Examples related to python

• programming a servo thru a barometer • Is there a way to view two blocks of code from the same file simultaneously in Sublime Text? • python variable NameError • Why my regexp for hyphenated words doesn't work? • Comparing a variable with a string python not working when redirecting from bash script • is it possible to add colors to python output? • Get Public URL for File - Google Cloud Storage - App Engine (Python) • Real time face detection OpenCV, Python • xlrd.biffh.XLRDError: Excel xlsx file; not supported • Could not load dynamic library 'cudart64_101.dll' on tensorflow CPU-only installation

Examples related to pandas

• xlrd.biffh.XLRDError: Excel xlsx file; not supported • Pandas Merging 101 • How to increase image size of pandas.DataFrame.plot in jupyter notebook? • Trying to merge 2 dataframes but get ValueError • Python Pandas User Warning: Sorting because non-concatenation axis is not aligned • How to show all of columns name on pandas dataframe? • Pandas/Python: Set value of one column based on value in another column • Python Pandas - Find difference between two data frames • Pandas get the most frequent values of a column • Python convert object to float

Examples related to dataframe

• Trying to merge 2 dataframes but get ValueError • How to show all of columns name on pandas dataframe? • Python Pandas - Find difference between two data frames • Pandas get the most frequent values of a column • Display all dataframe columns in a Jupyter Python Notebook • How to convert column with string type to int form in pyspark data frame? • Display/Print one column from a DataFrame of Series in Pandas • Binning column with python pandas • Selection with .loc in python • Set value to an entire column of a pandas dataframe

Examples related to group-by

• SELECT list is not in GROUP BY clause and contains nonaggregated column .... incompatible with sql_mode=only_full_group_by • Count unique values using pandas groupby • Pandas group-by and sum • Count unique values with pandas per groups • Group dataframe and get sum AND count? • Error related to only_full_group_by when executing a query in MySql • Pandas sum by groupby, but exclude certain columns • Using DISTINCT along with GROUP BY in SQL Server • Python Pandas : group by in group by and average? • How do I create a new column from the output of pandas groupby().sum()?

Examples related to pandas-groupby

• Count unique values with pandas per groups • Group dataframe and get sum AND count? • How do I create a new column from the output of pandas groupby().sum()? • How to loop over grouped Pandas dataframe? • Concatenate strings from several rows using Pandas groupby • pandas dataframe groupby datetime month • How to group dataframe rows into list in pandas groupby • Renaming Column Names in Pandas Groupby function • Get statistics for each group (such as count, mean, etc) using pandas GroupBy? • pandas GroupBy columns with NaN (missing) values