sdman135 / database-building-and-sql-query-practice

DataBase Building and SQL Practice

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

• Samuel Diaz - Creator - sdman135

License

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

Acknowledgments

• Azathoth - https://www.kaggle.com/azathoth42/myanimelist (the initial .csv file I used, had to clean heavily though...)