Get name and count of unique elements based on other column unique element

Question

Given the following sample dataframe:

df = 

Car       Country  

BMW       Germany
Tesla     USA
BMW       Germany
Mercedes  France
Tesla     USA

Based on unique values of column Country I want to get count and naming of column Car. Desired output:

Germany: 
BMW - 2

USA:
Telsa - 2

France:
Mercedes - 1

I have tried to play with pivot table but it was mess

score 1 · Accepted Answer · answered Oct 24 '22 at 13:06

1

A classic use for groupby:

df.groupby(["Country", "Car"]).size()

answered Oct 24 '22 at 13:06

Code Different

1 Answers1