How to transform rows to two columns, where each new row begins with the first string of the original row?

Question

I have a CSV data looking like this:

non alc,cola,fanta
alc,vodka,vine,beer
juice,apple,orange,tomato,cherry

This is an example - real data rows are much longer, maximum row length is around 200 strings.

I want to transform all data to two columns, where each row of the transformed data begins with the first string of the original row. Like this:

non alc,cola
non alc,fanta
alc,vodka
alc,vine
alc,beer
juice,apple
juice,orange
juice,tomato
juice,cherry

What would be the way to do this with Python?

If this kind of transformation has a special name - I would be thankful for knowing it.

Answer 1

I'm not sure if you want to solve this way or not but please check my answer.

<beverage.csv>
non alc,cola,fanta
alc,vodka,vine,beer
juice,apple,orange,tomato,cherry

Python code:

import csv

file = open('./beverage.csv')
csv_reader = csv.reader(file)

for row in csv_reader:
    for i in range(1, len(row)):
        print(row[0] + ', ' + row[i])

file.close()

Result:

non alc, cola
non alc, fanta
alc, vodka
alc, vine
alc, beer
juice, apple
juice, orange
juice, tomato
juice, cherry