DataEngineeringProject1

INTRODUCTION

Data from Alcohol Inventory was used to load data from .csv files to SQL Server
Pandas, which is a Python library, was used to clean and transform .csv file.
Pyodbc, which is a Python module that is used to access to ODBC databases, was used to gain access to SQL Server, create a database, then design tables and load data from csv files to these tables

MAIN CONCLUSIONS

All steps were successfully done.
Thanks to a pyodbc module, it is possible to gain access to SQL Server and create a database, design tables and execute a SQL statement.

<sub>Fig. 1 It shows that a database & tables were created in SQL Server

Fig. 2 It shows that data was loaded in the table</sub>

In-depth analysis with detailed information is included in DataEngineeringProject1.ipynb

To create this projects, these sites were used Python SQL Driver - pyodbc & pyodbc & Documentation pyodbc & How to query SQL Data with Python pyodbc.