subham singh
Reputation: 33
how do i find the city & country with the highest number of unique customers, also the count of unique players?
[![dataset![][1]](https://i.sstatic.net/Hmi8i.jpg)
][2]
how to find the country with highest number of unique customers?
Upvotes: 0
Views: 579
Answers (1)
Bushmaster
Reputation: 4608
can you try:
df=df.groupby('COUNTRY')['IDCUSTOMER'].nunique()
#or if you want to group by country and city
df=df.groupby(['COUNTRY','CITY'[)['IDCUSTOMER'].nunique()
Upvotes: 1
Related Questions
- How can I count # of occurences of more than one column (eg city & country)?
- Analysis of Customer Data using Pandas Dataframes
- Calculating the number of starts, by customer using Pandas
- Count the number of clients that have bought in different stores in my dataframe
- Python: How to show only the sport with the highest number of athletes by country?
- Using pandas to select customers unique to each organization
- Generate pair of columns of stores visited by the same client using a transaction dataframe and calculate aggregated metrics
- How to calculate total sales per client? Python
- Finding New/Existing Customers from a Dataframe
- How do I find the highest count of the same values with Pandas Python?