1. Learn
  2. /
  3. Courses
  4. /
  5. Data Processing in Shell

Exercise

Filtering data by column with csvkit

Let's get some hands-on practice for filtering data column using the csvkit command csvcut. Remember that we can filter columns by referring to the position of the column (e.g. 1st column, 2nd column) or by referring to the exact name of the column as it appears in the data file.

Instructions 1/4

undefined XP
  • 1
    • Print the first column in Spotify_MusicAttributes.csv by referring to the column by its position in the file.
  • 2
    • Print the first, third, and fifth column in Spotify_MusicAttributes.csv by referring to them by position.
  • 3
    • Print the first column in Spotify_MusicAttributes.csv by referring to the column by its name.
  • 4
    • Print the first, third, and fifth column in Spotify_MusicAttributes.csv by referring to them by name.