Slicing each line from data CSV file

Question

I have a movie dataset that looks like this:

1,Toy Story (1995),Adventure|Animation|Children|Comedy|Fantasy
2,Jumanji (1995),Adventure|Children|Fantasy
3,Grumpier Old Men (1995),Comedy|Romance
4,Waiting to Exhale (1995),Comedy|Drama|Romance
5,Father of the Bride Part II (1995),Comedy
6,Heat (1995),Action|Crime|Thriller
7,Sabrina (1995),Comedy|Romance
8,Tom and Huck (1995),Adventure|Children

I want to extract only the last part (genres part, e.g, Adventure|Animation|Children|Comedy|Fantasy) and store them in a list list[Adventure, Animation, Children, Comedy, Fantasy]. However, I am still stuck at slicing step. I don't know how to do that since line[:-1] doesn't slice. I use Python 2.7

with open(path + 'movie.csv') as f:
    for line in f:
        print line[:-1]

Dylan Lawrence · Accepted Answer · 2017-03-30 16:29:03Z

2

with open(path + 'movie.csv') as f:
    for line in f:
        print line.split(',')[:-1].rstrip('\n').split('|')

answered Mar 30, 2017 at 16:29

Dylan Lawrence

1,53311 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jean-François Fabre · Accepted Answer · 2017-03-30 16:36:43Z

2

Your slice will return the last character of each line, since the lines are not splitted when you read the file in regular manner. You should read the file using csv module that separates the lines automatically with ',' delimiter. Then split the result with |.

import csv
with open(path + 'movie.csv') as f:
    reader = csv.reader(f, delimiter=',')
    for row in reader:
        print(row[-1].split('|'))

edited Mar 30, 2017 at 16:36

Jean-François Fabre♦

141k24 gold badges179 silver badges246 bronze badges

answered Mar 30, 2017 at 16:31

Kasravnd

108k19 gold badges167 silver badges195 bronze badges

Collectives™ on Stack Overflow

Slicing each line from data CSV file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related