Exercise: Read CSV File (csv.reader)¶
Requirement¶
Use the following table (download CSV) as input for user records,
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-noheader.py that reads that file row
by row (use Python’s csv.reader), and outputs the
user records like follows.
$ python read-userdb-noheader.py Users-noheader-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, the CSV file is encoded in cp1252 [1].
Footnotes