CODEWITHSUNDEEP
listpython-3.xcsv
Yousra Gad
Yousra Gad

Reputation: 363

How to append a row in CSV file to list?

I have a CSV file contains data reviews and I want to append it to list. Here is a sample in my file.csv:

I love eating them and they are good for watching TV and looking at movies
This taffy is so good.  It is very soft and chewy

I want save in a list all the words of the second line and print them: ['This', 'taffy', 'is', 'so', 'good.', 'It', 'is', 'very', 'soft', 'and', 'chewy']

I tried this:

import csv
with open('file.csv', 'r') as csvfile:
 data = csv.reader(csvfile, delimiter=',')
 texts = []
 next(data)  
 for row in data:
     texts.append(row[2])
 print(texts)

My problem is it doesn't print anythings. Can anyone help here?.. Thanks in advance

Upvotes: 1

Views: 1761

Answers (1)

developer_hatch
developer_hatch

Reputation: 16224

Don't forget to import csv, if you want to save all the words in the second line, you have to enumerate the lines and take what you want, after that split them and save it in the list, like this:

import csv
texts = [] 
with open('csvfile.csv', 'r') as csvfile:
    for i, line in enumerate(csvfile):
        if i == 1:
            for word in line.split():
                texts.append(word)
print(texts)



$['This', 'taffy', 'is', 'so', 'good.', 'It', 'is', 'very', 'soft', 'and', 'chewy']

Upvotes: 1

Related Questions