python-pandasHow to count unique values in a dataframe
import pandas as pd
data = pd.DataFrame({
'Vendor': ['US', 'US', 'US', 'KR', 'KR'],
'Phone': ['ip5', 'ip6', 'ip8', 'sms', 'xi'],
'Phone Price': [204, 304, 204, 405, 204]
})
res = data['Phone Price'].nunique()ctrl + cimport pandas as pdload Pandas module | pd.DataFramecreates Pandas DataFrame object |
'Phone Price'column to count unique values in | .nunique()returns unique values count in a given dataframe |
reswill contain unique values 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, 204, 405, 204]
})
res = data['Phone Price'].nunique()
print(res)output
3
Related
More of Python Pandas
- How to convert datetime to timestamp
- How to convert column values to Int
- How to replace values in dataframe
- How to set data frame index
- What is opposite of melt() in Pandas
- How to use multiple conditions in mask()
- How to find duplicates in dataframe
- How to left join dataframes
- How to replace strings in dataframe column
- How to load dataframe from Excel (XSL)
See more codes...