/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

0 vote107 views1 answer
Append time complexity python
Python
0 vote117 views1 answer
Django table view sort filter
Python Django
14 votes112 views5 answers
How to import modules in python
Python
0 vote100 views1 answer
How to save python variables locally
Python
0 vote110 views1 answer
Django raw without sql injection
Python
0 vote120 views2 answers
How to get username discord ext python
Python
76 votes145 views6 answers
How to iterate through a list in python
Python
0 vote141 views4 answers
Django-sslserver · PyPI
Python Django
0 vote122 views1 answer
Python string: .upper()
Python
0 vote324 views1 answer
Np.stack
Python

Share