How to read a column in a csv file in python

You can read specific columns from a CSV file through Python's csv module. The steps are as follows: Import the csv module. Open the CSV file. Create a CSV reader object. Optional: Skip the header row. Loop through the rows, accessing the columns. Close the file.

How to read a specific column from a CSV file

To read a specific column from a CSV file, you can Use Python's csv module. The following steps explain how to do it:

Step 1: Import the csv module

import csv

Step 2: Open the CSV file

with open('data.csv', 'r') as csvfile:

Step 3: Create CSV Reader Object

reader = csv.reader(csvfile)

Step 4: Skip header row (optional)

If the CSV file contains a header row , can be skipped using the following method:

next(reader)

Step 5: Loop through the lines

for row in reader:
    # 访问列
    列名 = row[列索引]

Step 6: Close the file

csvfile.close()

Example:

To read all the values ​​in column 3 (index 2), you can use the following code:

import csv

with open('data.csv', 'r') as csvfile:
    reader = csv.reader(csvfile)
    next(reader)  # 跳过标题行

    for row in reader:
        列名 = row[2]
        print(列名)

The above is the detailed content of How to read a column in a csv file in python. For more information, please follow other related articles on the PHP Chinese website!