csvkit and mysql usages

I want to load the following dataset Education statics from the world bank into MySQL to generate some reports without using phpmyadmin.

Let’s introduce this dataset:

The biggest CSV file it is 156MB so I can not use phpmyadmin or MysqlWorkbench another reason to do not use that kind of tools is to be able to automate the process of data loading. I can use mysql LOAD DATA INFILE but then I have to provide the table with the right structure.

In this scenario I choose a python package called csvkit that allow me to transform between different data formats to SQL and insert it into the database. Continue reading