dryad | An almost-parallel , semi-functioning , dynamic linker | GPU library

• approach using apply(pd.Series) to expand a list into columns
• using stack() and unstack() generate multi-index columns that are zero-indexed values into 2D list
• flatten multi-index to match your stated requirement (one-indexed instead of zero indexed)

A .sql file is just plain text file with a different extension. So normally, you can open it with Notepad or any text editor such as Geany, Atom or Notepad++.

If you wish to execute the SQL script, in DBeaver, you first have to create the connection to the target database. Then, in the database navigator on the left, right-click on your database and select "SQL editor". A new empty SQL editor opens, linked to your database. Then click on "SQL Editor" in the top bar, and click on "import SQL script":

Navigate to the .sql file and select it.

Just in case, DBeaver also exists on Mac so if you need to use several OS it might be convenient to install DBeaver on all your computers and so keep the same tool everywhere.

Steps to follow to create a database from a .sql file

If you have an SQL script to create mySQL database, it will not run fine in a SQLite or any other database. For example, mySQL CREATE TABLE would mention something like ENGINE=InnoDB. SQLite will not understand this option. And it is generally true : SQL script are very similar from one database system to another, but not exactly identical. So unfortunately not interchangeable.

So to transfer your database from one computer (let's say the "source") to another (let's say the "target"), you need first to "dump" it i.e. to put all SQL instructions to create it into one file. As I understand you have already done it.

Then you will have to reinstall the same database engine (so mySQL in your case I guess) on the target computer. Then connect DBeaver (or whatever client : mySQL Workbench, Datagrip, even command line...) to this database and execute the script as shown above.

The SQL script is NOT the database, it is just the steps to create it. The database engine will read your SQL script and recreate your database accordingly.

Form an array and then permute the dimensions: