Is there a way to create pandas DataFrameGroupBy from multiple lists?

Asked Mar 07 '22 at 12:15

Active Mar 07 '22 at 12:19

Viewed 18 times

I have three lists, one with clients ids, one with months and one with categories.

clients_ids = [1, ..., 130000]
months = [1, ..., 12]
categories = [0, 1, 2, 3, 4, 5, 6]

And I want to create pandas GroupBy Object, from these lists, that will look like this

Is there a way to do it?

edited Mar 07 '22 at 12:19

DarrylG

asked Mar 07 '22 at 12:15

TayJen

Your output is ambiguous, please provide the desired output as a DataFrame object – mozway Mar 07 '22 at 12:16
2

Do you want to generate a [`product`](https://pandas.pydata.org/docs/reference/api/pandas.MultiIndex.from_product.html) of the lists? – mozway Mar 07 '22 at 12:17
1

that looks closer to a pivot table. – Umar.H Mar 07 '22 at 12:18
@mozway didn't know that such function exists in pandas, thank you! – TayJen Mar 07 '22 at 12:21

0 Answers0