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

1 vote133 views1 answer
Django createmany
Python
4 votes201 views2 answers
How to find the last occurrence of a character in a string in python
Python
0 vote158 views1 answer
Hex string to hex number
Python
1 vote94 views1 answer
Python check if dataframe type
Python
8 votes138 views1 answer
Pygame draw rect syntax
Python
50 votes168 views1 answer
How to find item in list python without indexnig
Python
1 vote153 views6 answers
Python tuple
Python
3 votes202 views6 answers
ImportError: Couldn't import Django. Are you sure it's installed and available on your PYTHONPATH environment variable? Did you forget to activate a virtual environment?
Python Django
0 vote182 views1 answer
Get current url with parameters url django
Python Django
5 votes151 views3 answers
Correlation matrix python
Python