Access keys of pandas dataframe when using groupby

Question

Arnau

2021年2月3日 11:51

I have the following database:

And I would like to know how many times a combination of BirthDate and Zipcode is repeated throughout the data table:

Now, my question is: How can I access the keys of this output? For instance, how can I get Birthdate=2000101 ZipCode=8002, for i = 0?

The problem is that this is a 'Series' object, so I'm not able to use .columns or .loc here.

David Masip · Accepted Answer · 2021年2月3日 11:51

David Masip answered at 2021年2月3日 11:51

You may use

df.groupby(['BirthDate', 'ZipCode']).size().reset_index().rename(columns={0: 'n'})

and now you have a data frame that you can easily manipulate.