Python CSV写入问题求助：如何在task2.csv新行添加数据

Hey there! Let's break down why your CSV write operation is messing up the last row instead of adding a new one, and fix it for good.

The Root of the Problem #

From what you described, the most likely culprits are:

• Incorrect file open mode: If you're using something like r+ (read-write) instead of a (append), the file pointer might start at the beginning or middle of the file, causing overwrites.
• Missing newline='' parameter: Without this, your system might add extra blank lines or mess up line endings, leading to unexpected behavior.
• Unclosed file handles: If you didn't properly close the file after previous operations, the file pointer might not be at the end where you expect it.

The Simple Fix: Proper Append with csv.writer #

Here's a straightforward script that will reliably add your new data as a fresh row every time:

import csv

# Your new data to add
new_entry = ["i", "ink"]

# Open the CSV in append mode, with newline='' to handle line endings correctly
with open('task2.csv', 'a', newline='', encoding='utf-8') as csv_file:
    # Create a CSV writer object
    csv_writer = csv.writer(csv_file)
    # Write the new row
    csv_writer.writerow(new_entry)

Why This Works:

• The 'a' mode automatically positions the file pointer at the end of the file, so every write starts a new line instead of overwriting existing content.
• newline='' tells Python to let the csv module handle line endings, which prevents extra blank rows and ensures compatibility across Windows/macOS/Linux.
• Using a with statement ensures the file is properly closed after writing, so you don't have lingering file pointer issues.

Handling Edge Cases: If Your CSV Ends Without a Newline #

Sometimes, if your existing CSV file's last row doesn't end with a newline, your new data might get appended to the end of that row instead of starting a new one. Here's how to handle that:

import csv
import os

new_entry = ["i", "ink"]
file_path = 'task2.csv'

# Check if the file exists, isn't empty, and ends without a newline
if os.path.exists(file_path) and os.path.getsize(file_path) > 0:
    with open(file_path, 'rb') as f:
        # Move to the second-to-last byte to check line ending
        f.seek(-2, os.SEEK_END)
        last_bytes = f.read()
        # If it doesn't end with a standard newline, add one
        if last_bytes not in (b'\r\n', b'\n'):
            with open(file_path, 'a', encoding='utf-8') as f:
                f.write('\n')

# Now write the new entry as before
with open(file_path, 'a', newline='', encoding='utf-8') as csv_file:
    csv_writer = csv.writer(csv_file)
    csv_writer.writerow(new_entry)

Why Your Previous Attempt Failed #

When you tried saving a pointer to the new line but still had issues, it's probably because the initial file open mode didn't guarantee the pointer was at the end. The first write overwrote the last row because the pointer wasn't correctly positioned, while the second write worked because the pointer had moved to the end after the first (incorrect) write. Using the 'a' mode eliminates this guesswork entirely.

内容的提问来源于stack exchange，提问作者Ashish Kumar