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.
-
Notifications
You must be signed in to change notification settings - Fork 0
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.
EleniNeti/parser-json-to-sql
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
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 0
No packages published