Python csv update row

from tempfile import NamedTemporaryFile
import shutil
import csv

filename = 'my.csv'
tempfile = NamedTemporaryFile(mode='w', delete=False)

fields = ['ID', 'Name', 'Course', 'Year']

with open(filename, 'r') as csvfile, tempfile:
    reader = csv.DictReader(csvfile, fieldnames=fields)
    writer = csv.DictWriter(tempfile, fieldnames=fields)
    for row in reader:
        if row['ID'] == str(stud_ID):
            print('updating row', row['ID'])
            row['Name'], row['Course'], row['Year'] = stud_name, stud_course, stud_year
        row = {'ID': row['ID'], 'Name': row['Name'], 'Course': row['Course'], 'Year': row['Year']}
        writer.writerow(row)

shutil.move(tempfile.name, filename)

Source: stackoverflow.com

Similar codes

10 votes252 views3 answers
Create a role with discord.py
Python
0 vote228 views1 answer
Change title size matplotlib
Python
0 vote199 views1 answer
Django set boolean field value in view
Python Django
0 vote233 views1 answer
Ubuntu 20.10 python 3.8
Python
0 vote227 views1 answer
Python int in list
Python
0 vote218 views1 answer
Download viper for python ubutunu
Python
11 votes242 views3 answers
Pandas conditional replace values in a series
Python
553 votes269 views10 answers
Where am i
Python
0 vote258 views1 answer
Check django version in your system
Python Django
-1 vote266 views1 answer
Insert into string python
Python