/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 vote271 views1 answer
Something useless. python
Python
0 vote256 views1 answer
Must have equal len keys and value when setting with an ndarray
Python
8 votes262 views1 answer
X = df.iloc[:, 1:]
Python
0 vote254 views1 answer
Fastest way to Convert Integers to Strings in Pandas DataFrame
Python
0 vote262 views3 answers
Type object 'datetime.datetime' has no attribute 'timedelta'
Python
-3 votes293 views1 answer
Django socketio web chat example
Python Django
0 vote265 views1 answer
Compare times python
Python
0 vote252 views1 answer
Python Record live streams (TS FILES)
Python
0 vote285 views1 answer
How to get a user's avatar with their id in discord.py?
Python
2 votes254 views3 answers
How to print dataframe in python without index
Python

Share