Joining local CSV files using SQL
csvsql
can be used to join CSV files together even when neither of them are in a database. Here, we have two CSV files Spotify_MusicAttributes.csv
and Spotify_Popularity.csv
that are both on song level but contain different attributes for each song. We can combine the two files together using a SQL-like JOIN, and we can do so, through the power of csvsql
.
This exercise is part of the course
Data Processing in Shell
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
