python

Building first Machine Learning model using Logistic Regression in Python – Step by Step

Leave a Comment / Data Science, Machine Learning, Python / / / , ,

This post briefs how to create our first machine learning predictive model using Logistic regression in Python. When we start working on a Machine Learning project, first, we perform some data wrangling and transformation to get the tidy dataset. Then, we perform some EDA to find trends, patterns, and outliers in the given dataset. Once, we have machine-interpretable data […]

Building first Machine Learning model using Logistic Regression in Python – Step by Step Read More »

Exploratory Data Analysis (EDA) using Python – Second step in Data Science and Machine Learning

2 Comments / Analytics/ML, Data Analysis, Data Science, Machine Learning, Python / / / , , , , ,

In the previous post, “Tidy Data in Python – First Step in Data Science and Machine Learning”, we discussed the importance of the tidy data and its principles. In a Machine Learning project, once we have a tidy dataset in place, it is always recommended to perform EDA (Exploratory Data Analysis) on the underlying data

Exploratory Data Analysis (EDA) using Python – Second step in Data Science and Machine Learning Read More »

Python use case – Resampling time series data (Upsampling and downsampling) – SQL Server 2017

Leave a Comment / Data Analysis, Machine Learning, Python, SQL Server / / / , , , , ,

Resampling time series data in SQL Server using Python’s pandas library In this post, we are going to learn how we can use the power of Python in SQL Server 2017 to resample time series data using Python’s pandas library. Sometimes, we get the sample data (observations) at a different frequency (higher or lower) than

Python use case – Resampling time series data (Upsampling and downsampling) – SQL Server 2017 Read More »

Python use case – Import data from excel to sql server table – SQL Server 2017

Leave a Comment / Python, SQL Server / / / , , ,

If we need to import data from an excel file into SQL Server, we can use these methods: SQL Server Import Export Wizard Create an SSIS package to read excel file and load data into a SQL Server table Use T-SQL OPENROWSET query Use the read_excel method of Python’s pandas library (Only available in SQL Server 2017

Python use case – Import data from excel to sql server table – SQL Server 2017 Read More »

Python use case – Import zipped file without unzipping it in SSIS and SQL Server – SQL Server 2017

Leave a Comment / Python, SQL Server / / / , , , ,

Import zipped CSV file without unzipping it in SSIS using SQL Server 2017 SQL Server Integration Services (SSIS) is one of the most popular ETL tools. It has many built-in components which can be used in order to automate the enterprise ETL(Extract, Transform, and Load). Also, if we need a customized component which is not

Python use case – Import zipped file without unzipping it in SSIS and SQL Server – SQL Server 2017 Read More »

Python use case – Convert rows into comma separated values in a column – SQL Server 2017

Leave a Comment / Python, SQL Server / / / , , , ,

In this post, we are going to learn how we can leverage python in SQL server to generate comma separated values. If we want to combine all values of a single column it is fairly easy as we can use COALESCE function to do that. Here is a reference to the already existing post. But have

Python use case – Convert rows into comma separated values in a column – SQL Server 2017 Read More »

Python use case – Dynamic UNPIVOT using pandas – SQL Server 2017

1 Comment / Python, SQL Server / / / , ,

In this post, we are going to learn how we can leverage the power of Python’s pandas module in SQL Server 2017. pandas is an open source Python library providing data frame as data structure similar to the SQL table with the vectorized operation support for high performance. To know more about pandas, you can click

Python use case – Dynamic UNPIVOT using pandas – SQL Server 2017 Read More »

Connecting Python 3 to SQL Server 2017 using pyodbc

6 Comments / Python, SQL Server / / / ,

In this post “Connecting Python 3 to SQL Server 2017 using pyodbc”, we are going to learn that how we can connect Python 3 to SQL Server 2017 to execute SQL queries. We can change the settings accordingly to connect to other versions of SQL Server also. If you are interested to know more about

Connecting Python 3 to SQL Server 2017 using pyodbc Read More »

Python use case – Get employees for given skill set – SQL Server 2017

Leave a Comment / Python, SQL Server / / / , ,

In the previous blog post “Python use case – Map unequal comma separated values from two columns – SQL Server 2017“, we demonstrated a use case example of Python in SQL Server 2017. Now, in this post, “Python use case – Get employees for given skill set – SQL Server 2017”, we are going to

Python use case – Get employees for given skill set – SQL Server 2017 Read More »

Python use case – Map unequal comma separated values from two columns – SQL Server 2017

4 Comments / Python, SQL Server / / / , ,

We know that Microsoft has integrated Python in SQL Server 2017 to enable rich data analytics capabilities within the database itself. Python is one of the most powerful languages which provides lots of built-in libraries for advanced data analytics and transformations. We can use Python for almost everything from website development to robotics and Data

Python use case – Map unequal comma separated values from two columns – SQL Server 2017 Read More »