LoslegenKostenlos starten

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.

Diese Übung ist Teil des Kurses

<Kurs>Data Processing in Shell</Kurs>
Kurs ansehen

Interaktive praktische Übung

Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.

# Print a list of column headers in the data 
csvcut -n Spotify_MusicAttributes.csv

# Print the first column, by position
csvcut -c ___ Spotify_MusicAttributes.csv
Code bearbeiten und ausführen