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
How to write advanced SQL queries
In a previous article we analyzed what SQL (Structured Query Language) is and how it is used with basic examples. In this article we will see its more advanced functions. The code is written with the Transact-SQL extension… read more
What are SQL Joins and how tables are related to each other
Relational databases rely on relationships between their entities (tables and views). However, in order to be able to call associated records from two or more tables / views above, we must somehow declare with which field... 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
What is SQL and what can it do?
We have seen what databases are but in order to use them we must somehow be able to export or import data from them. How is this possible? With Structured Query Language or SQL. It is her main… 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
Python from zero to hero
In this not TLDR article (I hope) we will go over all the basic concepts and constructs of the Python scripting programming language. Python is an interpreted language and not compiled, which means that the translation of the program into language... read more