Uncategorized
datapandasadmin

GDPR- What Is It ? Why You Should Be Concerned And What Actions To Take

GDPR stands for General Data Protection Regulation (GDPR) also referred to as the EU General Data Protection Regulation (GDPR).  According to the EUGDPR website , The EU General Data Protection Regulation (GDPR) is the most important change in data privacy regulation in 20 years. The EU General Data Protection Regulation (GDPR) replaces the Data Protection Directive 95/46/EC and was designed to harmonize

Read More »
December 16, 2017 No Comments
Uncategorized
datapandasadmin

The sp_execute_external_script (Transact-SQL) Definition And Arguments

The sp_execute_external_script  system stored procedure is the stored procedure which invokes the external environment to run an external script (either Python or R ) in a T-SQL script. This is quite highlights of the sp_execute_external_script stored and some short notes on it.   let’s quickly look at the structure of the stored procedure sp_execute_external_script @language = N’language,

Read More »
November 11, 2017 No Comments
Uncategorized
datapandasadmin

How to Install Whl Packages and Modules in Python

Sometimes, you might need some packages which do not come with the standard Python libraries and you would want to install them separately. You will notice how frustrating it is when you get stuck because of a package you are missing.   Sentdex on Youtube covers that accurately and you can watch him here:  

Read More »
August 19, 2017 No Comments
Uncategorized
datapandasadmin

Add Action to AutoIt Message Box – Catching the Message Box Returned Value

Adding actions to messages boxes Message Boxes, like most functions, return one of these values and their respective meanings Button Pressed Return Values: OK = $IDOK (1) CANCEL  = $IDCANCEL (2) ABORT = $IDABORT (3) RETRY  = $IDRETRY (4) IGNORE  = $IDIGNORE (5) YES =  $IDYES (6) NO =  $IDNO (7) CONTINUE **  = $IDCONTINUE (11) TRY

Read More »
October 23, 2016 No Comments

Save Python Pivot Table in Excel Sheets ExcelWriter

Untitled This is a quick script on how to save Python pivot_table in an excel file. Credit to  pbpython In [1]: import sqlalchemy import pyodbc from pandas import DataFrame import pandas as pd   In [2]: df = DataFrame ## connect to SqlServer Database and get information. try: import urllib params = urllib.quote_plus(“DRIVER={SQL Server Native Client 11.0};SERVER=.\MSSQLSERVER_ENT;DATABASE=Antrak;Trusted_Connection=yes;”)

Read More »
October 5, 2016 No Comments

DataPandas LTS

An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs

EXPLORE DataPandas

ImportAnt link

GET IN TOUCH

  • Location: Location
  • Contact us:
  • Email: cs@datapandas.com
Facebook Twitter Envelope Linkedin

© 2023 DataPandas