1. Learn
    2. /
  2. Courses
    3. /
  3. Streamlined Data Ingestion with pandas

Exercise

Get data from other flat files

While CSVs are the most common kind of flat file, you will sometimes find files that use different delimiters. read_csv() can load all of these with the help of the sep keyword argument. By default, pandas assumes that the separator is a comma, which is why we do not need to specify sep for CSVs.

The version of Vermont tax data here is a tab-separated values file (TSV), so you will need to use sep to pass in the correct delimiter when reading the file. Remember that tabs are represented as \t. Once the file has been loaded, the remaining code groups the N1 field, which contains income range categories, to create a chart of tax returns by income category.

Instructions

100 XP
  • Import pandas with the alias pd.
  • Load vt_tax_data_2016.tsv, making sure to set the correct delimiter with the sep keyword argument.