python-pandasHow to count dataframe rows with condition
import pandas as pd
data = pd.DataFrame({
'Vendor': ['US', 'US', 'US', 'KR', 'KR'],
'Phone': ['ip5', 'ip6', 'ip8', 'sms', 'xi'],
'Phone Price': [204, 304, 404, 405, 305]
})
res = len(data[data['Vendor'] == 'US'])ctrl + cimport pandas as pdload Pandas module | pd.DataFramecreates Pandas DataFrame object |
len(returns length (rows count) of a given dataframe | data['Vendor'] == 'US'sample filter to use before counting rows |
reswill contain filtered rows count | |
Usage example
import pandas as pd
data = pd.DataFrame({
'Vendor': ['US', 'US', 'US', 'KR', 'KR'],
'Phone': ['ip5', 'ip6', 'ip8', 'sms', 'xi'],
'Phone Price': [204, 304, 404, 405, 305]
})
res = len(data[data['Vendor'] == 'US'])
print(res)output
3
Related
More of Python Pandas
- How to convert column object values to String
- How to convert column values to Int
- How to join dataframes
- How to read dataframe from XML
- How to change values in a column based on condition
- How to save dataframe to XML file
- What is opposite of melt() in Pandas
- How to rename dataframe column by index
- How to convert dataframe to list of lists
- How to join dataframes on multiple columns
See more codes...