/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

2 votes324 views1 answer
How to resize tkinter window
Python
2 votes343 views1 answer
Reverse order np array
Python
2 votes350 views3 answers
Geopandas set crs
Python
0 vote335 views1 answer
Python - How to execute a program or call a system command?
Python
9 votes334 views2 answers
Pygame play sound
Python
0 vote350 views1 answer
How to convert multi list into dict in python
Python
0 vote355 views1 answer
Django model registration
Python Django
-1 vote314 views2 answers
How to find a square root of a number using python
Python
0 vote338 views1 answer
Python 3 define type in arguments with default value
Python
3 votes317 views1 answer
Visual studio code import library python
Python

Share