18. CSV

Question 1

with Open

Answer 1

use with resource and make sure it is close, like try escape

with open(‘Input/Covid.csv’, mode=’r’) as csv_file:

Question 2

DictReader(csv_file)

Answer 2

each row will be read as a separate dictionary creating a dictionary “set’. header will be read as dict key

Question 3

open read write mode

Answer 3

read: r
write: w
read/write: ‘r+’

Question 4

reader(csv_file)

Answer 4

reader splits each row on a specified delimiter and returns a list of strings; compare to Dictreader

use line count (count yourself) to split the header

Question 5

writer(csv_file)

Answer 5

change the whole file if it is w mode

Question 6

reading csv with two columns as dict

Answer 6

d = dict(reader)