You can use the python csv package to read in the data
I would load each into an sqlite3 database if you are using python 3.5
it will already be installed, so simply import sqlite3.
create four tables, each with a name corresponding to your table names,
and containing all of the fields that you show below.
Build indexes for each on the patient identifier, and maybe for the two tables that contain gpid
an index on that as well
Now you can access data from each table with simple sql query on PatientId
I'm rusty on SQL, but you can write a query to pull from all four tables at once.
Someone else here will be able to help with that.
I see Yoriz has replied while I was typing. Use his suggestion and go for pandas.
I would load each into an sqlite3 database if you are using python 3.5
it will already be installed, so simply import sqlite3.
create four tables, each with a name corresponding to your table names,
and containing all of the fields that you show below.
Build indexes for each on the patient identifier, and maybe for the two tables that contain gpid
an index on that as well
Now you can access data from each table with simple sql query on PatientId
I'm rusty on SQL, but you can write a query to pull from all four tables at once.
Someone else here will be able to help with that.
I see Yoriz has replied while I was typing. Use his suggestion and go for pandas.