In this project, we utitlized the Csvkit library, which supercharges your workflow by adding 13 new command line tools specifically for working with CSV files. We focused on below 5 tools from Csvkit:
- csvstack: for stacking rows from multiple CSV files.
- csvlook: renders CSV in pretty table format.
- csvcut: for selecting specific columns from a CSV file.
- csvstat: for calculating descriptive statistics for some or all columns.
- csvgrep: for filtering tabular data using specific criteria.
We used csvkit version 0.9.1 in this mission and you can read about the installation procedure in the documentation. Furthermore, we worked with the 3 datasets on housing affordability which may be downloaded from below: