Hey, I'm Tomi Mester. This is my data blog, where I give you a sneak peek into online data analysts' best practices. You will find articles and videos about data analysis, AB-testing, research, data science and more…
Let’s continue with the pandas tutorial series. This is the second episode, where I’ll introduce aggregation (such as min, max, sum, count, etc.) and grouping. Both are very…
Pandas is one of the most popular Python libraries for Data Science and Analytics. I like to say it’s the “SQL of Python.” Why? Because pandas helps you…
Did you know that Python wasn’t originally built for Data Science? And yet today it’s one of the best languages for statistics, machine learning, and predictive analytics as…
So far we have worked with the most essential concepts of Python: variables, data structures, built-in functions and methods, for loops, and if statements. These are all parts…
In my Python workshops and online courses I see that one of the trickiest things for newcomers is the syntax itself. It’s very strict and many things might…
Connecting Google Data Studio to your PostgreSQL database is easier than you would think. I will walk you through the whole process step by step. By the end…
Following the previous article about creating data tables in SQL, now we want to load data into our freshly created SQL table. In this article, I’ll show you…
Working with SQL for data analysis sometimes requires creating new tables. Do you want to store the output of your SQL queries? Do you need to pull new…
Last time I wrote about why it’s worth it to become a data scientist. This time I’d like to answer another important and very common data science career…
Why become a data scientist? From time to time, I get this question from people who are flirting with the idea of becoming a data professional. Since you…
Remember that I told you last time that Python if statements are similar to how our brain processes conditions in our everyday life? That’s true for for loops…
“Should I learn Python 2 or Python 3?” For everyone who has just started to learn Python for Data Science, this is an important initial question to answer….
You might have heard that Data Scientist was ranked as the best job of 2017 in the USA (based on Glassdoor’s research). Recently many IT professionals have started…
If you are learning Data Science, pretty soon you will meet Python. Why is that? Because it’s one of the most commonly used data languages.It’s popular for 3…
Today I’ll show you some more advanced SQL moves! Okay, I’d rather put them into the intermediate category. They are not beginner things — but it’s also for…