Skip to main content
 首页 » 编程设计

Python追加CSV内容并重新保存

2025年02月15日11lhb25

要求程序搜索一行,然后在重新保存之前调整 CSV 的特定元素。

感谢任何帮助!

import csv 
import os 
username=input('Enter username: ') 
with open ('user.csv', 'r') as user: 
    reader=csv.reader(user, delimiter=',') 
    print(reader) 
 
with open ('newuser.csv', 'w') as newdetail: 
    writer=csv.writer(newdetail, delimiter=',') 
    for colomn in reader: 
        if username in coloum[1]: 
            print('User found! \n') 
            print('UserID: '+colomn[0]) 
            print('Username: '+colomn[1]) 
            print('Interest: '+colomn[2]) 
            change = (column[2]) 
            change = input("What is your new interest?") 
            print(colomn[2]+' has been changed to ', change) 
        writer.writerow(colomn) 
os.remove('user.csv') 
os.rename('newuser.csv', 'user.csv') 

当前错误是:

dir/ line 10, in <module> 
    for colomn in reader: 
ValueError: I/O operation on closed file. 

非常感谢,这是我到现在为止的地方。目前仅打印正在编辑的单行,而不是所有其他未调整的电影。

import csv 
import os 
new = [] 
username=input('Enter movie: ') 
with open ('movies.csv', 'r') as user: 
    reader=csv.reader(user, delimiter=',') 
    #print(reader) 
 
    with open ('newmovies.csv', 'w') as newdetail: 
        writer=csv.writer(newdetail, delimiter=',') 
        for colomn in reader: 
            if username in colomn[1]: 
                print('Movie found!') 
                print('MovieID: '+colomn[0]) 
                print('Movie name: '+colomn[1]) 
                print('Interest: '+colomn[2]) 
        choice = input("what is your new interest?") 
        print('Interest has been changed to ', choice) 
        new = [(colomn[0]),(colomn[1]),(choice)] 
        writer.writerow(new) 
os.remove('movies.csv') 
os.rename('newmovies.csv', 'movies.csv') 

请您参考如下方法:

reader 对象不包含数据,但只能直接访问文件。一旦关闭 user.csv 文件(从 with 范围退出时),reader 就不再有用了。

尝试将第二个 with 放在第一个范围内:

with open ('user.csv', 'r') as user: 
    reader=csv.reader(user, delimiter=',') 
    print(reader) 
    with open ('newuser.csv', 'w') as newdetail: 
        writer=csv.writer(newdetail, delimiter=',') 
        for colomn in reader: 
            if username in colomn[1]: 
                print('User found! \n') 
                print('UserID: '+colomn[0]) 
                print('Username: '+colomn[1]) 
                print('Interest: '+colomn[2]) 
                change = (column[2]) 
                change = input("What is your new interest?") 
                print(colomn[2]+' has been changed to ', change) 
            writer.writerow(colomn) 

附言- 修复第 11 行 - colomn 而不是 coloum