Python import csv to list

Question

I have a CSV file with about 2000 records.

Each record has a string, and a category to it:

This is the first line,Line1 This is the second line,Line2 This is the third line,Line3 

I need to read this file into a list that looks like this:

data = [('This is the first line', 'Line1'),         ('This is the second line', 'Line2'),         ('This is the third line', 'Line3')] 

How can import this CSV to the list I need using Python?

Answer 1

Using the csv module:

import csv  with open('file.csv', newline='') as f:     reader = csv.reader(f)     data = list(reader)  print(data) 

Output:

[['This is the first line', 'Line1'], ['This is the second line', 'Line2'], ['This is the third line', 'Line3']] 

---

If you need tuples:

import csv  with open('file.csv', newline='') as f:     reader = csv.reader(f)     data = [tuple(row) for row in reader]  print(data) 

Output:

[('This is the first line', 'Line1'), ('This is the second line', 'Line2'), ('This is the third line', 'Line3')] 

---

Old Python 2 answer, also using the csv module:

import csv with open('file.csv', 'rb') as f:     reader = csv.reader(f)     your_list = list(reader)  print your_list # [['This is the first line', 'Line1'], #  ['This is the second line', 'Line2'], #  ['This is the third line', 'Line3']] 

Answer 2

Updated for Python 3:

import csv  with open('file.csv', newline='') as f:     reader = csv.reader(f)     your_list = list(reader)  print(your_list) 

Output:

[['This is the first line', 'Line1'], ['This is the second line', 'Line2'], ['This is the third line', 'Line3']]