Exercise: Read CSV File (csv.dictreader)¶
Requirement¶
As a followup to Exercise: Read CSV File (csv.reader), use the following table
(download CSV) to read the user
records from.
ID |
First name |
Last name |
Date of Birth |
|---|---|---|---|
1 |
Jörg;DI |
Faschingbauer |
19.6.1966 |
2 |
Caro |
Faschingbauer |
25.4.1997 |
3 |
Johanna |
Faschingbauer |
11.6.1995 |
4 |
Philipp |
Lichtenberger |
6.4.1986 |
5 |
Elizabeth II |
Queen |
1.1.1900 |
Write a program read-userdb-header.py that reads that file row by
row (use Python’s csv.dictreader), and outputs the
user records like follows.
$ python read-userdb-header.py Users-header-cp1252.csv
ID:1, Firstname:Jörg;DI, Lastname:Faschingbauer, Date of birth: 19.6.1966
ID:2, Firstname:Caro, Lastname:Faschingbauer, Date of birth: 25.4.1997
ID:3, Firstname:Johanna, Lastname:Faschingbauer, Date of birth: 11.6.1995
ID:4, Firstname:Philipp, Lastname:Lichtenberger, Date of birth: 6.4.1986
ID:5, Firstname:Elizabeth II, Lastname:Queen, Date of birth: 1.1.1900
Note
Btw, like in Exercise: Read CSV File (csv.reader), the CSV file is encoded in
cp1252.