Posts by: Spiro Sideris

Data Retrieval and Cleaning: Tracking Migratory Patterns

Advancing your skills is an important part of being a data scientist. When starting out, you mostly focus on learning a programming language, proper use of third party tools, displaying visualizations, and the theoretical understanding of statistical algorithms. The next step is to test your skills on more difficult data sets. Sometimes these data sets […]

Tutorial: Python Functions and Functional Programming

Learn about functions in Python and master the basics of functional Python programming in this in-depth tutorial for data scientists and programmers.

Postgres Internals: Building a Description Tool

In previous blog posts, we have described the Postgres database and ways to interact with it using Python. Those posts provided the basics, but if you want to work with databases in production systems, then it is necessary to know how to make your queries faster and more efficient. To understand what efficiency means in […]

Tutorial: Loading Data into Postgres using Python and CSVs

This in-depth tutorial covers how to use Python and SQL to load data from CSV files into Postgres using the psycopg2 library.