Python as a scripting language gives unlimited possibilities for automation. In this article we will see how in collaboration with SQL Server it is possible to translate the entire table field into Greek with one click through google translate. First… read more
How can we calculate our car insurance premiums in SQL Server using Python (no API)
Let's say we have in SQL Server a table of cars and drivers and we want to find their cheapest premium. This will certainly be possible with an API / Web Service. But this solution would require the… read more
What are models in Data Science
What are models in Data Science? In a simple sentence, models are built so that we can make predictions about a trend we are investigating. There are two categories of models: supervised, which we train, and unsupervised, which is done through... read more
How to visualize data on a map using Python
In this article with the help of jupyter notebook and python we will make a heatmap. We will do a complete analysis using dataframe, polynomial regression scatter plot, bar plot. Let's start by loading the libraries we'll need: What… read more
What is Always Encrypted and how it is applied to protect sensitive data
In the era of GDPR let's talk about another SQL Server feature to protect sensitive data. It's none other than Always Encrypted! What is Always Encrypted Its purpose is that the data is always encrypted by… read more
How to make charts in Microsoft Excel using Python
In Microsoft Excel, in addition to using functions and pivoting, we have the possibility to add graphs based on this data. But we know that graphs can also be made using Python with libraries such as matplotlib and seaborn.… read more
Pivoting in Microsoft Excel using Python
In an earlier article we have seen the possibilities to perform Excel functions such as vlookup through Python. In this article we will see how we can perform pivoting through Python. We will analyze ways so that we can find information… read more
Vlookup with Python without using Microsoft Excel functions
Microsoft Excel is very efficient when managing a small amount of data. But it requires the use of functions which are very easy to modify by mistake or to forget to remove them before saving the result. Somewhere there comes the… read more
How to make our first graph using Python
In the article we will see how we can make barplots using Python easily and quickly. To begin with, we should load 3 libraries that we have ready with the functions we will need: In the variable df we loaded a dataframe... read more
