Home > Backend Development > Python Tutorial > How to Import a CSV File into a List in Python?

How to Import a CSV File into a List in Python?

DDD
Release: 2024-12-30 05:01:15
Original
1004 people have browsed it

How to Import a CSV File into a List in Python?

Import CSV File into List in Python

Importing a CSV file into a list in Python is a common task. In this article, we'll demonstrate how to accomplish this using the csv module.

Method:

  1. Import the csv module: import csv
  2. Open the CSV file using a context manager: with open('file.csv', newline='') as f:
  3. Create a reader object: reader = csv.reader(f)
  4. Convert the reader object to a list: data = list(reader)

Example:

Consider a CSV file with the following data:

This is the first line,Line1
This is the second line,Line2
This is the third line,Line3
Copy after login

To import this data into a list, we can use the following code:

import csv

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

print(data)
Copy after login

Output:

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

Note: If you need tuples instead of lists, you can modify the above code as follows:

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

This will produce a list of tuples:

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

For Python 2 users, you can use the following code:

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

print your_list
Copy after login

The above is the detailed content of How to Import a CSV File into a List in Python?. For more information, please follow other related articles on the PHP Chinese website!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template