/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 vote206 views1 answer
Divide every element in numpy array
Python
0 vote170 views1 answer
Read list from txt python
Python
0 vote176 views1 answer
Python round without math
Python
0 vote199 views1 answer
Fakultät python
Python
0 vote166 views1 answer
Binary to octal in python
Python
9 votes174 views1 answer
Pass argument to a py file
Python
0 vote210 views1 answer
Python send image in post request with json data
Python
14 votes172 views3 answers
Pyautogui send keys
Python
0 vote220 views1 answer
How to query json field django
Python Django
14 votes168 views6 answers
How to print hello world in python
Python

Share