/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 vote325 views1 answer
Import data in pandad
Python
0 vote287 views1 answer
InvalidVersionSpec: Invalid version ' 0 . 7 . 1 2 ': invalid character(s)
Python
4 votes305 views1 answer
How to print an input backwards in python
Python
2 votes313 views1 answer
Private class method python
Python
40 votes295 views3 answers
Python push to dataframe pandas
Python
0 vote312 views1 answer
If not working
Python
0 vote312 views1 answer
How to save multiple choices in django site:stackoverflow.com
Python
5 votes367 views2 answers
My django template doesnt want to load the static file
Python Django
0 vote302 views1 answer
Higlight words in python
Python
0 vote323 views3 answers
Pandas pivot table
Python

Share