How do i make a sublist of every CSV row and put that sublist inside a list

Question

I'm making a sublist of every row inside a csv file but i'm getting a single list back

wines_list = []

for row in wines:
    wines_list.append(row)

print(wines_list)

This returns:

['id', 'country', 'description', 'designation', 'points', 'price', 
'province', 'taster_name', 'title', 'variety', 'winery', 'fixed acidity', 
'volatile acidity', 'citric acid', 'residual sugar', 'chlorides', 'free 
sulfur dioxide', 'total sulfur dioxide', 'density', 'pH', 'sulphates', 
'alcohol']

But i wan't it to append all values to sublist, and append that to wines_list

So i want wines_list to become something like:

[[1, 'netherlands', 'description of the wine', 'designation', 'points', 'price', 
'province', 'taster_name', 'title', 'variety', 'winery', 'fixed acidity', 
'volatile acidity', 'citric acid', 'residual sugar', 'chlorides', 'free 
sulfur dioxide', 'total sulfur dioxide', 'density', 'pH', 'sulphates', 
'alcohol'], ANOTHER SUB LIST HERE]

https://stackoverflow.com/questions/41585078/how-do-i-read-and-write-csv-files-with-python — Zonyl, Apr 02 '19 at 14:29

score 0 · Accepted Answer · answered Apr 02 '19 at 14:27

0

easiest way is something like this

import csv
pathtocsv='path/to/file'
with open(pathtocsv,'r') as cfile:
    creader=csv.reader(cfile,delimiter=',')
    wines_list=list(creader)

print(wines_list)

then wines_list will be a list of lists

answered Apr 02 '19 at 14:27

SuperStew

2,857
2
15
27

if you don't want the headers, sure you could. or `wines_list.pop(0)` at the end of the `with` block – SuperStew Apr 02 '19 at 14:30
Thank you! got it to work, will accept as soon as i can! – Wesley van S Apr 02 '19 at 14:31

How do i make a sublist of every CSV row and put that sublist inside a list

1 Answers1

Linked