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 […]
Read MoreTutorial: 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.
Read MorePostgres 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 […]
Read MoreTutorial: 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.
Read More