Skip to content

Latest commit

 

History

11 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 
 
 

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

0 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors

Languages