wherogue.blogg.se

Relating databases in idatabase
Relating databases in idatabase




relating databases in idatabase

Though the SQLAlchemy library can connect to a variety of relational sources including MySql, Oracle and Postgresql and Mssql. We will use Sqlite3 as our relational database as it is very light weight and easy to use.

relating databases in idatabase

Run the following command in the Anaconda Prompt Window to install the SQLAlchemy package. Assuming you have installed Anaconda as described in this chapter,

relating databases in idatabase

The installation is very straight forward using Anaconda which we have discussed in the chapter Data Science Environment. This package is named as sqlalchemy which provides full SQL language functionality to be used in python. We can connect to relational databases for analysing data using the pandas library as well as another additional library for implementing database connectivity.






Relating databases in idatabase