Python
Use Python 2 and 3 Pyodbc and Sqlalchemy to connect to SQL Server Client 11.0
There are several ways you can use Python to connect to SQL Server and one of such ways is to
April 18, 2021
No Comments
SQL
Pyodbc Sqlalchemy Python 2 and 3 SQL Server Native Client 11.0
This is a sample code to use Python to connect to SQL Server Native Client.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
import sqlalchemy import pyodbc try: import urllib params = urllib.quote_plus("DRIVER={SQL Server Native Client 11.0};SERVER=.\MSSQLSERVER_ENT;DATABASE=MagicDirect;Trusted_Connection=yes;") engine = sqlalchemy.create_engine('mssql+pyodbc:///?odbc_connect=%s"' % params) results.to_sql("clusterSegments", engine, if_exists = 'replace')# except (RuntimeError, TypeError, NameError): print('Error in Conneccting') print(RuntimeError, TypeError, NameError) finally: print("connected") |
April 18, 2021
No Comments
Business Intelligence - BI
R Shiny App for Mining Fields Evaluation
Presenting your report in an interactive and user-friendly way is a very effective communicative tool which can help you convey
December 29, 2018
No Comments
Data Science
Run Your Python and R Codes Online For Your Data Science and Machine Learning Projects Mini Projects For Free
Sometimes, you would want to easily access and run your Python and R codes wherever you find yourself in the
December 28, 2018
No Comments
Data Science
Declare Public Protected and Private Variables in Python – Object Oriented Programming
In Python, the scope ( Public, Protected, Private) characteristic of an attribute or member of the class is indicated by
September 8, 2018
No Comments
Data Science
DataSets Around the Web For Big Data, Machine Learning and DataScience Practices
Here is a collection of several DataSet repositories, I have come across the web. ( I will adding more along
September 8, 2018
No Comments
Examining The Structure of A Data Science Project
It is really ideal that you define the structure of your Data Science project before beginning the project. The Data
August 16, 2018
No Comments
Azure Machine Learning
Deploy Productionalise Azure Machine Learning Algorithm Using Python
This is a script to consume Azure Machine Learning Model which you build using Azure ML Studio. So basically this
July 24, 2018
No Comments
Resources
Basic Bash Commands For Quick Reference
These are some common basic bash commands for your quick reference Credit: Big Data For Data Engineers – Coursera Command Description
July 22, 2018
No Comments
Azure Machine Learning
Microsoft Azure Machine Learning Cheat Sheet
This is a quick download of the Microsoft Azure Machine Learning Cheat Sheet. Having them handy can help save
June 13, 2018
No Comments
DataPandas LTS
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs