/Python/Pandas count values by column

Pandas count values by column

Count values pandas

>>> index = pd.Index([3, 1, 2, 3, 4, np.nan])
>>> index.value_counts()
3.0    2
4.0    1
2.0    1
1.0    1
dtype: int64

10

Source: pandas.pydata.org

Pandas count

>>> df.set_index(["Person", "Single"]).count(level="Person")
        Age
Person
John      2
Lewis     1
Myla      1

1

Source: pandas.pydata.org

Pandas count values by column

df = pd.DataFrame({'a':list('abssbab')})
df.groupby('a').count()

0

Similar codes

0 vote110 views1 answer
Scrollable table tkinter
Python
0 vote114 views1 answer
Pprint dic without sorting
Python
1 vote119 views1 answer
Python sort list of strings numerically
Python
0 vote113 views1 answer
Data format pandas
Python
1 vote111 views1 answer
How to provide default value when assign i ngvariables python
Python
39 votes112 views6 answers
Remove all whitespace from string python
Python
3 votes106 views1 answer
Delete a key value pair from a dictionary in python
Python
1 vote134 views1 answer
How to loop over day name in python
Python
0 vote120 views1 answer
Matlab filter in python
Python
1 vote119 views1 answer
Change shortcuts in pychar,
Python

Share