/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 vote174 views2 answers
If list of columns exist pandas
Python
1 vote179 views1 answer
Python get timestamp 2020-04-23T12:00:00Z
Python
10 votes204 views3 answers
Create a virtualenv python3
Python
-2 votes187 views3 answers
Pyhton
Python
0 vote199 views1 answer
What is *args and **kwargs in django
Python Django
12 votes157 views2 answers
Max of a dict
Python
0 vote157 views1 answer
How to pause a thread in python
Python
0 vote146 views1 answer
Histogram matplotliub
Python
0 vote172 views1 answer
How to edit a pdf file in python
Python
0 vote254 views2 answers
How to close a flask web server with python
Python Flask

Share