Python libraries included in SQL Server 2017

For data scientists, python is one of the two must have languages. The following list of python libraries come pre-installed when you install the python option during SQL Server 2017’s install. The ones most relevant to a data scientist are in bold.

Its most notable exception is libraries for doing deep learning, so after SQL Server installs, you will likely want to install keras and tensorflow (and possibly librosa if you want to do speech recognition). For NLP you already have NLTK (though without the NLTK corpus and extra tools which I recommend adding). For many NLTK needs, NLTK is enough, but if not you might consider pyphen and/or gensim. If you are getting text from word docs, I recommend installing docx2txt. For getting data from the web, you might also want to install urllib.

To install any library not already list, open a command prompt with administrator’s permission and run
python -m pip install yourlibname
(optionally add ==yourversionnumber  to the end of that if you don’t want to install the library’s latest version)