Exercise: Read CSV File (csv.reader)

Requirement

Use the following table (download CSV) as input for user records,

Users-noheader-cp1252.csv

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].

Dependencies

cluster_python Python Programming: From Absolute Beginner to Advanced Productivity cluster_python_basics Python: The Language Fundamentals cluster_python_misc Python: Miscellaneous Topics cluster_python_exercises Exercises cluster_python_exercises_userdb User Database (Exercise Series) python_basics_python_0160_boolean Boolean python_basics_python_0150_datatypes_overview Datatypes python_basics_python_0160_boolean->python_basics_python_0150_datatypes_overview python_basics_python_0500_files File I/O python_basics_python_0220_for for Loops python_basics_python_0500_files->python_basics_python_0220_for python_misc_encoding Encoding python_basics_python_0500_files->python_misc_encoding python_basics_python_0120_helloworld Hello World python_basics_python_0110_blahblah Blahblah python_basics_python_0120_helloworld->python_basics_python_0110_blahblah python_basics_python_0300_strings More About Strings python_basics_python_0200_sequential_types Sequential Datatypes python_basics_python_0300_strings->python_basics_python_0200_sequential_types python_basics_python_0300_strings->python_basics_python_0150_datatypes_overview python_basics_python_0250_refs_flat_deep_copy References, (Im)mutability python_basics_python_0300_strings->python_basics_python_0250_refs_flat_deep_copy python_basics_python_0130_syntax_etc Syntax etc. python_basics_python_0130_syntax_etc->python_basics_python_0120_helloworld python_basics_python_0139_commandline_argv Commandline Arguments (sys.argv) python_basics_python_0139_commandline_argv->python_basics_python_0130_syntax_etc python_basics_python_0125_running Running Python Programs python_basics_python_0139_commandline_argv->python_basics_python_0125_running python_basics_python_0150_datatypes_overview_compound Compound Datatypes python_basics_python_0150_datatypes_overview_compound->python_basics_python_0150_datatypes_overview python_basics_python_0193_while while Loops python_basics_python_0193_while->python_basics_python_0160_boolean python_basics_python_0170_if The if Statement python_basics_python_0193_while->python_basics_python_0170_if python_basics_python_0200_sequential_types->python_basics_python_0150_datatypes_overview_compound python_basics_python_0125_running->python_basics_python_0120_helloworld python_basics_python_0140_variables Variables python_basics_python_0150_datatypes_overview->python_basics_python_0140_variables python_basics_python_0320_strings_methods Miscellaneous String Methods python_basics_python_0320_strings_methods->python_basics_python_0300_strings python_basics_python_0140_variables->python_basics_python_0130_syntax_etc python_basics_python_0250_refs_flat_deep_copy->python_basics_python_0150_datatypes_overview_compound python_basics_python_0250_refs_flat_deep_copy->python_basics_python_0150_datatypes_overview python_basics_python_0250_refs_flat_deep_copy->python_basics_python_0140_variables python_basics_python_0170_if->python_basics_python_0160_boolean python_basics_python_0220_for->python_basics_python_0193_while python_basics_python_0220_for->python_basics_python_0200_sequential_types python_misc_encoding->python_basics_python_0150_datatypes_overview python_misc_encoding->python_basics_python_0320_strings_methods python_misc_csv CSV Files python_misc_csv->python_basics_python_0500_files python_misc_csv->python_basics_python_0150_datatypes_overview_compound python_misc_csv->python_basics_python_0220_for python_exercises_userdb_csvreader Exercise: Read CSV File (csv.reader) python_exercises_userdb_csvreader->python_basics_python_0139_commandline_argv python_exercises_userdb_csvreader->python_misc_csv

Footnotes