/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

4 votes200 views4 answers
Change default python version
Python
0 vote162 views1 answer
Python compressed for concatenate string
Python
3 votes123 views3 answers
How to make my jupyter prin full array
Python
0 vote127 views1 answer
Applies the f function to all Row of this DataFrame
Python
0 vote124 views2 answers
Flask api abort
Python
4 votes175 views4 answers
How to change django admin text
Python Django
0 vote118 views1 answer
Py2exe no console
Python
3 votes131 views1 answer
Label size matplotlib
Python
1 vote126 views1 answer
How to get index of week in list in python
Python
0 vote132 views1 answer
Dtype function with example
Python

Share