Query Data from a Private DataBase and save it in a Pandas DataFrame
Project description
MicrosoftSQLServerToPandasDataFrame
Description
This package query data from any SQL Server Database and parse it into a Pandas Dataframe it can be useful for pipelines process and speed up your development process.
Usage
from SQLServerToPandasDataFrame import CreateQuery, createConnection, runQuery
Base_Query = "select * from [DataBase].dbo.Table"
server = "HOST_DIRECTION"
user = "USER_NAME"
password = "PASSWORD"
conn = createConnection("MyDataBase", server, user, password)
print(runQuery(query1, conn))
Settings
This package performs by default all the connections to a SQL Server using ODBC Driver 17 for SQL Server
driver. if you wanna use a different driver, please replace add the driver parameter in create Connection method.
conn = createConnection("MyDataBase", server, user, password, driver = "DRIVER OF YOUR PREFERENCE")
conn = createConnection("MyDataBase", server, user, password, driver = "ODBC Driver 17 for SQL Server")
We use Pyodbc
as ODBC access library, for more driver options please ckeck the documentation PyODBC Documentation.
Collaborators
- Germán Andrés Jején Cortés @andres_jejen on twitter
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for SQLServerToPandasDataFrame-germanandresjejencortes-0.0.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 30666d5273ac559590feb8128a7d530e38d878bda66ed5925ccb383646b75e8e |
|
MD5 | 8ec4bd601010e1ecc9a55e5b9a7310b6 |
|
BLAKE2b-256 | 3a7faeb03e293b9f60b122a5dc2f7bd7757ee3b2ec8e6464ca8cd385f1977e5d |
Close
Hashes for SQLServerToPandasDataFrame_germanandresjejencortes-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f0b5d0b3ed2039f9cfa650429e226c7e2e68fb8a1eef4452e9a12077c1a19f4d |
|
MD5 | 52e7184e59851cdf3b7f7f12c781ff36 |
|
BLAKE2b-256 | 10c0e8b3b8e35ddb0f1333ccf1fbc718876c9da04a2dc746b272835bcec66ba2 |