Filtering data by row with csvkit
Now it's time get some hands-on practice for filtering data by exact row values using -m. Whether it's text or numeric, csvgrep can help us filter by these values.
This exercise is part of the course
Data Processing in Shell
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Print a list of column headers in the data
csvcut -n Spotify_MusicAttributes.csv
# Filter for row(s) where track_id = 118GQ70Sp6pMqn6w1oKuki
___ -c "track_id" -m ___ Spotify_MusicAttributes.csv