Python list group by count

Find frequency of numbers in list python

from collections import Counter

def frequency_table(n):
    table = Counter(n)
    print('Number\tFrequency')
    for number in table.most_common() :
        print('{0}\t{1}'.format(number[0], number[1]))
        
# src : Doing Math With Python

List count frequency python

import collections
a = [1,1,1,1,2,2,2,2,3,3,4,5,5]
counter=collections.Counter(a)
print(counter)
# Counter({1: 4, 2: 4, 3: 2, 5: 2, 4: 1})
print(counter.values())
# [4, 4, 2, 1, 2]
print(counter.keys())
# [1, 2, 3, 4, 5]
print(counter.most_common(3))
# [(1, 4), (2, 4), (3, 2)]

Source: stackoverflow.com

How to get count by using group by in python

df[['col1', 'col2', 'col3', 'col4']].groupby(['col1', 'col2']).agg(['mean', 'count'])

Source: stackoverflow.com

Python list group by count

>>> a = [1,1,1,1,2,2,2,2,3,3,4,5,5]
>>> d = {x:a.count(x) for x in a}
>>> d
{1: 4, 2: 4, 3: 2, 4: 1, 5: 2}
>>> a, b = d.keys(), d.values()
>>> a
[1, 2, 3, 4, 5]
>>> b
[4, 4, 2, 1, 2]

Source: stackoverflow.com

Similar codes

0 vote126 views1 answer
Python - merge and incluse only specific columns
Python
5 votes123 views1 answer
Englsih to japanese
Python
6 votes127 views5 answers
How to count unique values in a column dataframe in python
Python
0 vote155 views1 answer
Django create object with default today date
Python Django
7 votes185 views4 answers
From django.contrib import messages
Python Django
0 vote125 views1 answer
The webpage at http://127.0.0.1:8000/ might be temporarily down or it may have moved permanently to a new web address. django
Python
0 vote187 views1 answer
Compute the mean of this RDD’s elements.
Python
0 vote135 views1 answer
Get pixel color pygame
Python
1 vote166 views1 answer
Python close gile
Python
-1 vote199 views1 answer
Getting a column that corresponds to the average of two columns in pandas
Python