要求程序搜索一行,然后在重新保存之前调整 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
