How to loop over grouped Pandas dataframe?

Michael Zippo

👻 Check our latest review to choose the best laptop for Machine Learning engineers and Deep learning tasks!

DataFrame:

  c_os_family_ss c_os_major_is l_customer_id_i
0      Windows 7                         90418
1      Windows 7                         90418
2      Windows 7                         90418

Code:

print df
for name, group in df.groupby("l_customer_id_i").agg(lambda x: ",".join(x)):
    print name
    print group

I"m trying to just loop over the aggregated data, but I get the error:

ValueError: too many values to unpack

@EdChum, here"s the expected output:

                                                    c_os_family_ss  
l_customer_id_i
131572           Windows 7,Windows 7,Windows 7,Windows 7,Window...
135467           Windows 7,Windows 7,Windows 7,Windows 7,Window...

                                                     c_os_major_is
l_customer_id_i
131572           ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,...
135467           ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,...

The output is not the problem, I wish to loop over every group.

👻 Read also: what is the best laptop for engineering students?

We hope this article has helped you to resolve the problem. Apart from How to loop over grouped Pandas dataframe?, check other code Python module-related topics.

Want to excel in Python? See our review of the best Python online courses 2023. If you are interested in Data Science, check also how to learn programming in R.

By the way, this material is also available in other languages:

Cornwall Schteiner

Munchen | 2023-03-29

Maybe there are another answers? What How to loop over grouped Pandas dataframe? exactly means?. Will use it in my bachelor thesis

Anna Danburry

London | 2023-03-29

I was preparing for my coding interview, thanks for clarifying this - How to loop over grouped Pandas dataframe? in Python is not the simplest one. I just hope that will not emerge anymore

Walter Sikorski

Paris | 2023-03-29

Simply put and clear. Thank you for sharing. How to loop over grouped Pandas dataframe? and other issues with code Python module was always my weak point 😁. I am just not quite sure it is the best method