/Python/Get count of values in column pandas

Get count of values in column pandas

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

Number of times a value occurs in dataframne

df['a'].value_counts()

1

Source: stackoverflow.com

Pandas count values by column

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

0

Get count of values in column pandas

In [37]:df = pd.DataFrame({'a':list('abssbab')})
df.groupby('a').count()Out[37]:  aa  a 2b 3s 2[3 rows x 1 columns]

0

Source: stackoverflow.com

Similar codes

0 vote254 views1 answer
Python with braces
Python
-1 vote246 views1 answer
Django filter on related field
Python Django
28 votes209 views6 answers
Pandas test for nan
Python
6 votes219 views4 answers
Pandas read csv without header
Python
1 vote201 views1 answer
Multipl excel sheets in pandas
Python
0 vote190 views2 answers
Numpy linspace
Python
0 vote184 views1 answer
How remove spaces python input
Python
0 vote251 views1 answer
Turtule code for digital clock
Python
0 vote263 views1 answer
Remove particular row number in pandas
Python
26 votes168 views2 answers
Pil image crop
Python

Share