在python中合并具有相同类别的csv文件行

I am familiar with basic concepts of reading and writing a csv file in python. But I am stuck to make a logic for this problem. I think GROUP BY can solve my problem but how one can do in python I am familiar with basic concepts of reading an