Skip to content

This repo contains all the necessary material and specifically the python script (parser) in order to read a large file of data that cannot be read otherwise on a local machine due to memory limitations. It takes advantage of the python package 'json' to parse the data and it also includes the SQL queries to populate the tables of a relational db.

Notifications You must be signed in to change notification settings

EleniNeti/parser-json-to-sql

Repository files navigation

parser-json-to-sql

7506880 free-json-file-1-504451

This repo contains all the necessary material and specifically the python script (parser) in order to read a large file of data that cannot be read otherwise on a local machine due to memory limitations. It's also a life-saviour for those data analysts that do not have access to cloud computing resources or who just want to work locally in their machines. The script actually takes advantage of the python package 'json' to parse the data and it also includes the SQL queries to populate the tables (relations) of a relational database. More specifically, we designed and built a bookstore's database in PostgreSQL for the sake of our analysis. You can tailor the script according to your needs.

About

This repo contains all the necessary material and specifically the python script (parser) in order to read a large file of data that cannot be read otherwise on a local machine due to memory limitations. It takes advantage of the python package 'json' to parse the data and it also includes the SQL queries to populate the tables of a relational db.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published