/Python/Pandas count number of rows with value

Pandas count number of rows with value

Get number of rows pandas

number_of_rows = len(df)

6

Pandas count rows in column

>>> df.count(axis='columns')
0    3
1    2
2    3
3    3
4    3
dtype: int64

2

Source: pandas.pydata.org

Pandas count rows with value

len(df[df['score'] == 1.0])

1

Source: morphocode.com

Pandas count number of rows with value

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

Out[37]:

   a
a   
a  2
b  3
s  2

[3 rows x 1 columns]

0

Source: stackoverflow.com

Similar codes

1 vote190 views1 answer
Cut 0s on string python
Python
1 vote187 views1 answer
Get time between things python
Python
0 vote199 views1 answer
Pyplot rectangle over image
Python
1 vote203 views1 answer
Python code to receive gmail
Python
0 vote213 views1 answer
Django cms api
Python Django
1 vote202 views1 answer
Lru cache python
Python
0 vote210 views1 answer
Package python3-pip is not available, but is referred to by another package.
Python
0 vote193 views1 answer
Python create a dictionary of integers
Python
0 vote208 views1 answer
Django serializer,
Python Django
0 vote204 views1 answer
Convolution operation pytorch
Python

Share