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 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.2.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | ad35f60f086749a349a77cb51668be88ab83bf1940d602d682c5405e01063aff |
|
MD5 | 16a4226c0944daa100b012bc2f5ef466 |
|
BLAKE2b-256 | 974e2e3c040dfa8e9738a77a5305290e7c7dadd1c4dce23cd8adc152ca64efd5 |
Close
Hashes for SQLServerToPandasDataFrame_germanandresjejencortes-0.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a5cedceb8f0e619ffa213693a9111079cab3d199b6db1daf2f576e4cfc426690 |
|
MD5 | 0b4668d0f32466b728fa2198238a7acf |
|
BLAKE2b-256 | 76436607b45fde6020ebebc2ca8f436173b5e13e8b78ede093fd724ae9a4b8a8 |