How to connect to MS SQL Server using Python3 on MacOS

Simply follow the steps below

Install pyodbc in python3pip3 install pyodbcorpython3 -m pip install pyodbcNow install Microsoft ODBC Driver (need to have Homebrew installed on your system)brew tap microsoft/msodbcsql homebrewbrew updateFinal Stepbrew install msodbcsqlNow take idea from following python3 code
Hope it helps.

Nancy: The Virtual Assistant (Python Virtual Assistant)

From the last few months our team (Errorists) have been working on a python powered virtual assistant which we call "Nancy: The Virtual Assistant" or "NTVA" in short.

You can get a sneak peak into is working in the following video:
This video shows working of Nancy: the virtual assistant using text input but no doubt Nancy can also be controlled using Voice input.
Now-a-days, no doubt there are many virtual assistants available in market but none of them are cross platform and open source which limits their capabilities and scope. Nancy will be a python powered virtual assistant to be available cross platform.Nancy reduces work load and help you with your basic day to day computer based tasks by automating them and reducing human efforts.It is a voice controlled VA which automates the boring stuff as it mingles with your hard drive and gives the user facility of working with files vocally.User can work with their machine both offline & online without getting t…

Google Crowdsource Event at Poornima Foundation: Day 2 Review

The Google Translate Community made their remarkable presence in Poornima Foundation on day 2 also, by connecting and interacting with a total of approx 2000+ enthusiastic students, conducting 4 joyous sessions. The day started with a brief introduction about translate community, a video for better understanding and a few questions to make it more interactive like-  How many of you use Google every single day? How many of you use translation every day, week or month? How many of you ever tried to search content in indic languages and how do you feel about the poor results you got? Have you ever thought it would be easier if browsing was that much compatible in indic languages too? Have you ever faced a language barrier in your very own country? The students shared their experiences with the translate team, some of them were so true and made every one realize how important it is to have our languages preserved and shared as the team itself said that the whole internet is ruled by 10 maj…

Google Crowdsource Event at Poornima Foundation: Day 1 Review

For all those readers who have no idea what I'm going to talk about, must go through my previous blog post Google crowdsource event at Poornima Foundation

India's first ever institutional launch of Google's newly released Crowdsource App went joyously at Poornima Foundation, Jaipur. The event was carried out in 5 slots and in each slot nearly 525 students attended the event i.e nearly 2625 students  became part of this exhilarating event today.

What was the event all about?
Google team(translate community) visited to interact with students to make them clear about the usage, need and necessity of Crowdsource app
What exactly is Crowdsource and what is my role in it?
Crowdsource is an app where you do simple micro tasks (translate a phrase, transcribe a handwriting sample, etc), and generate high-quality data. Contributions to these tasks help us improve the quality of Google services that millions of your peers use - services like Google Translate, Google Maps, Google Keybo…

Google Crowdsource Event at Poornima Foundation

We all live in a country with people of diverse origins, who speak different languages. We speak of connecting each and every person to the latest feed and tech. through internet. But are they really able to take full benefits of internet?

The answer is big NO.
The most of the content available on internet is only in English(i.e 53.6% according to wikipedia), followed by Russian(6.4%) and then German(5.6%). The rest of language either play a small fraction in  it or has no part at all. Thus, due to lack of information available in native languages, people can't get benefitted from internet despite of it's huge and endless powers.

In this regard, GOOGLE has taken a huge step to connect people to internet by increasing the amount of content available in other languages.

How that would be possible?
It would be basically done by translating the available content into other languages.

We already have google translate, what's new about crowdsource app?
Well there are many feature…

Python Script To Open Google Maps Of a Place

Some times it is very tedious to open google maps and search for maps of that place. How good it would be if the browser opens automatically with the webpage showing google maps of your desired place.

I'm doing this tutorial using python 3.x but same could be done using python 2.x
The tutorial is based on the learning from "AutomateTheBoringStuff"
I hope you will find it interesting.

The script has following properties:

Read the address from command line arguments or from the clipboard Requires webbrowser module to automatically open default web browser of OS with the desired URL Requires sys module to access command line stored in argv list Requires pyperclip to access address from clip board. This module is not by default. To install this read my blog post Access-Clipboard-Using-Python

Access clipboard using python

I'm doing this tutorial using Python 3.x, but the same can be done using Python 2.x

The following python script has following properties

 requires pyperclip module to run  Copy to and from clipboard  Tested on Unix(MacOs and Ubuntu)  But should also work on windows  Try, test, run and then write your own  And I forgot something, Hello everyone  :-) The required pyperclip can be installed as follows:

pip3 install pyperclip or more specifically
python3 -m pip install pyperclip
The installation can checked on Unix in following way:
pip3 freeze|grep 'pyperclip' or more specifically
python3 -m pip freeze|grep 'pyperclip'
The result will be something like: