Convert csv to excel (python)-CodePudding

I have a CSV file that i'd like to convert to an excel, but the output should be in a certain way.

i am not sure if the csv is the right format for the raw data. i am thinking dict or json

the csv file looks like this but there are other categories (screenshot on the wanted result)

Category,Item,Description,Price,Option category,Option name,Price,Min,Max
Notebooks,Lenovo,No desc,100,RAM,4gb,0,1,1
Notebooks,Lenovo,No desc,100,RAM,8gb,10,1,1
Notebooks,Lenovo,No desc,100,Color,Grey,0,1,1
Notebooks,Lenovo,No desc,100,Color,Black,0,1,1
Notebooks,Lenovo,No desc,100,Color,White,0,1,1