Read CSV rows by column
Parse quoted CSV content into dictionaries using Python's built-in CSV reader.
Original Pearto instructional example. Test it in your own environment and adapt it to your requirements.
import csv
from io import StringIO
source = StringIO('name,score\nAda,98\nLin,95\n')
for row in csv.DictReader(source):
print(row['name'], int(row['score']))