Skip to content

Latest commit

 

History

History
34 lines (18 loc) · 961 Bytes

File metadata and controls

34 lines (18 loc) · 961 Bytes

Relational DataBase building, data ingesting + SQL query practice

For this project I wanted to showcase my ability to make a Relational DataBase.

What Did I Do?

  • Imported .cvs files (data to be ingested later into the DataBase).

  • Used Sqlite3 to create and establish connection to DataBase file.

  • Constructed and populated tables with a few functions.

  • Lastly I queried (SQL) data from the newly made DataBase. Querying with conditions and saving them to Pandas Dataframes.

Built With

  • Python 3.8
  • Jupyter Notebook 6.0.1
  • A few imports: pandas, numpy, and sqlite3

Authors

License

This project is licensed under the MIT License - see the LICENSE.md file for details

Acknowledgments