Home >Backend Development >Python Tutorial >How Can I Import CSV Data into a List in Python?

How Can I Import CSV Data into a List in Python?

Mary-Kate Olsen
Mary-Kate OlsenOriginal
2024-11-30 12:58:11838browse

How Can I Import CSV Data into a List in Python?

Importing CSV Data into a List in Python

When working with CSV (Comma-Separated Values) files in Python, one may encounter the need to import the data into a list for further processing. This question addresses this scenario, providing a comprehensive solution to convert CSV data into a structured list of tuples or strings.

Using the csv module, we can achieve this with a simple code block:

import csv

# Open the CSV file
with open('file.csv', 'r') as f:
    # Create a CSV reader
    reader = csv.reader(f)
    
    # Convert CSV data to a list of tuples
    data = list(reader)

This code will read the CSV file, with each row represented as a tuple within the data list. The format of each tuple is (string, category).

Alternatively, if you prefer a list of strings, simply modify the code as follows:

...
# Convert CSV data to a list of strings
data = [row for row in reader]

For older versions of Python 2, the updated code is:

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

Regardless of your Python version, the solution provided enables you to effectively import CSV data into a list, either as tuples or strings, streamlining your data manipulation tasks.

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

Statement:
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