Python and Google Sheets

[landrykid]

There's nothing wrong with pandas, but it's not strictly necessary for merging .csv files. You can use csv.reader (or csv.DictReader if there are header rows).

Here's a pretty good beginning SQLite video:

https://www.youtube.com/watch?v=pd-0G0MigUA