How to read csv in python

Reading method: 1. Create a python sample file; 2. Import the csv module, and then use the open function to open the CSV file; 3. Pass the file object to the csv.reader function, and then use a for loop to traverse the reading Get each line of data; 4. Print each line of data.

#The correct way to read CSV files in Python is to use the csv module. Here is a simple example:

import csv
with open('file.csv', 'r') as file:
    reader = csv.reader(file)    
    for row in reader:        
    print(row)

In this example, we first import the csv module and then use the open function to open the CSV file. We pass the file object to the csv.reader function and then use a for loop to iterate through each row of data. Finally, we print each row of data.

import pandas as pd
data = pd.read_csv('file.csv', encoding='utf-8')

import csv
with open('file.csv', 'r', encoding='utf-8') as file:
    reader = csv.reader(file, delimiter=';', quotechar='"')    
    for row in reader:        
    # 对每一行数据进行处理

import re# 使用正则表达式处理特殊字符或格式

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