HackInScience/src/training/20-csv-and-python.py at main · levintech/HackInScience

33 lines (26 loc) · 1.06 KB

import csv

import datetime

def generate_csv(a_list):

dict_list = []

for itemSet in a_list:

temp_dict = dict((x, y) for x, y in itemSet)

temp_dict['date'] = temp_dict['date'].strftime('%m/%d/%Y')

temp_dict['locations'] = ','.join(temp_dict['locations'])

dict_list.append(temp_dict)

print(dict_list)

with open('results.csv', 'w', newline='') as csvfile:

fieldnames = ['temperature', 'date', 'locations', 'weather']

writer = csv.DictWriter(csvfile, fieldnames=fieldnames)

writer.writeheader()

for item in dict_list:

writer.writerow(item)

def parse_csv():

dict_list = []

with open('students.csv', 'r', newline='') as csvfile:

reader = csv.DictReader(csvfile)

for row in reader:

month, day, year = row['Birthdate'].split('/')

row['Birthdate'] = datetime.date(int(year), int(month), int(day))

row['Marks'] = [int(item) for item in row['Marks'].split(',')]

dict_list.append(row)

return dict_list

Provide feedback