Connecting to Microsoft SQL Server using Python

Hello All, Here is a quick guide to connect to Microsoft SQL Server and Extract data to a csv. I have an interest in python recently and posting all that saves me time at work. Python is so powerful that it saves me a lot of time either doing the work manually or writing the same process using other tools. The code below is simple … Continue reading Connecting to Microsoft SQL Server using Python

Split Multiple Files Using Python

Hello Guys,   I found this code really useful and wanted to post it for future reference. At work , at times there is a need to provide data in excel. Unfortunately Microsoft Excel cannot load data which is more than 80K.  In this case scripts like splitting data comes in handy. The code first creates a function and then its called by passing the … Continue reading Split Multiple Files Using Python

Connecting to Redshift using Python

Hi, I have been exploring Python recently as a part of doing my Masters in Data Science and I must says , its really a powerful tool and the possibilities are endless using Python. Recently we had a project to connect to Amazon Redshift and was having issues using ODBC and adapter. I was exploring on the possibility of using Python and its amazing that … Continue reading Connecting to Redshift using Python

How to rename files in a directory using Python – (Solved)

Hello All,   I got myself coding using Python . Its really a great tool and wanted to share some of things I have been doing while mastering this tool. Scenario – I am collecting data from twitter and unfortunately got my filename wrong. There were around 750 files in the folder and manually changing the name is cumbersome , that is where python helped … Continue reading How to rename files in a directory using Python – (Solved)