Python的csv模塊提供了讀寫CSV文件的簡單方法。 1. 讀取CSV文件時(shí)，可使用csv.reader()逐行讀取，並將每行數(shù)據(jù)作為字符串列表返回；若需通過列名訪問數(shù)據(jù)，則可用csv.DictReader()，它將每行映射為字典。 2. 寫入CSV文件時(shí)，使用csv.writer()並調(diào)用writerow()或writerows()方法寫入單行或多行數(shù)據(jù)；若要寫入字典數(shù)據(jù)，則使用csv.DictWriter()，需先定義列名並通過writeheader()寫入表頭。 3. 處理邊緣情況時(shí)，模塊自動處理帶引號字段內(nèi)的逗號和換行符，但需注意正確使用引號；同時(shí)應(yīng)注意編碼問題，如Windows下的UTF-8-BOM，以及避免空白行帶來的問題，建議在打開文件時(shí)始終設(shè)置newline=''。 4. 模塊支持自定義分隔符，通過csv.register_dialect()註冊自定義方言後，可輕鬆?wèi)?yīng)對以非標(biāo)準(zhǔn)分隔符（如製表符）分隔的數(shù)據(jù)文件。

Working with CSV files in Python is straightforward thanks to the built-in csv module. Whether you're reading from or writing to a CSV file, this module gives you simple tools that handle most common tasks without needing anything else.

Reading CSV Files

If you want to pull data from a CSV file, the csv.reader() function is your go-to option. It reads the file row by row, giving you each line as a list of strings.

Let's say you have a file called data.csv that looks like this:

 Name,Age,Location
Alice,30,New York
Bob,25,Los Angeles
Charlie,35,Chicago

Here's how you'd read it:

 import csv

with open('data.csv', newline='') as csvfile:
    reader = csv.reader(csvfile)
    for row in reader:
        print(row)

This will output:

 ['Name', 'Age', 'Location']
['Alice', '30', 'New York']
['Bob', '25', 'Los Angeles']
['Charlie', '35', 'Chicago']

A few things to note:

• Make sure to use newline='' when opening the file to prevent issues with blank lines on some platforms.
• Each row is returned as a list, so if you need specific values, just index into the list (eg, row[1] for age).

If your CSV has headers and you want to work with named fields, consider using csv.DictReader , which maps each row to a dictionary:

 with open('data.csv', newline='') as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
        print(row['Name'], row['Age'])

Now you're working with key-value pairs instead of indexes — easier to manage if your data has clear column names.

Writing to CSV Files

Writing data to a CSV file is just as easy using csv.writer() . You create a writer object and then pass it rows of data.

Suppose you have a list of lists and want to write them into a new CSV file:

 data = [
    ['Name', 'Age', 'Location'],
    ['Alice', '30', 'New York'],
    ['Bob', '25', 'Los Angeles']
]

with open('output.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerows(data)

You'll get a file that looks like this:

 Name,Age,Location
Alice,30,New York
Bob,25,Los Angeles

Some tips:

• Use 'w' mode to overwrite an existing file or create a new one.
• If you want to append to an existing CSV, use 'a' mode instead.
• The writerow() method writes a single row, while writerows() writes multiple rows at once.

Again, if you want to write dictionaries instead of lists, use csv.DictWriter . Just remember to specify the fieldnames first:

 fieldnames = ['Name', 'Age', 'Location']

with open('output.csv', 'w', newline='') as csvfile:
    writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
    writer.writeheader()
    writer.writerow({'Name': 'Alice', 'Age': 30, 'Location': 'New York'})

Handling Edge Cases

CSV files sometimes contain commas inside quoted fields, or even line breaks within cells. The csv module handles these cases automatically, but only if you use the module correctly.

For example, if a name is written like "Smith, John" inside a cell, the reader will still treat it as a single value — as long as the quotes are properly used in the file.

Also, be careful with encoding:

• On Windows, especially with Excel-generated CSVs, you might run into UTF-8-BOM issues. In that case, open the file with encoding='utf-8-sig' .
• If you're dealing with non-English characters, make sure to set the correct encoding when reading and writing.

Another thing to watch out for: empty lines. Some CSV readers (like Excel) can misinterpret extra blank lines. To avoid that, always use newline='' when opening files in write mode.

Lastly, don't forget about dialects. The csv module supports custom dialects if your CSV uses non-standard delimiters (like tabs or semicolons). For example:

 csv.register_dialect('mydialect', delimiter='\t', quoting=csv.QUOTE_NONE)

with open('data.tsv', newline='') as f:
    reader = csv.reader(f, dialect='mydialect')

That way, you can adapt the csv module to fit different formats without rewriting your logic.

These basic patterns cover most use cases. Once you're comfortable with them, you can start combining them — like reading from one CSV, processing the data, and writing to another. But even if you stop here, you've got solid tools for handling CSV files in Python.

以上是如何使用CSV模塊在Python中使用CSV文件？的詳細(xì)內(nèi)容。更多資訊請關(guān)注PHP中文網(wǎng)其他相關(guān)文章！