thank you for your help.
I have data that looks like this:
city, room_type A, X A, Y A, Z B, X B, Y B, Y
I want my end result to look like this:
city, count(X), count(Y), count(z) A, 1, 1, 1 B, 1, 2, 0
I am grouping by city and I want to show the count of each room_type in each city.
Any way to do this with python pandas? Thank you.
I learned SQL years ago and think that it may have been possible. I'm sure python can do the same. Thanks!