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…Category: Coding In Data Science and Analytics Page 1 of 3
Working with current dates and times in data science projects is quite common. In this episode of my SQL tutorial series I’ll show you the best functions that…
In this episode of the SQL tutorial series you’ll learn two simple but important commands that you’ll use frequently when working in SQL: TRUNCATE TABLE and DROP TABLE….
This is the second episode of my web scraping tutorial series. In the first episode, I showed you how you can get and clean the data from one…
Running hobby projects is the best way to practice data science before getting your first job. And one of the best ways to get real data for a…
Over the last 6 years I’ve been part of many job interviews – on both sides of the table. The most fun, but also the most feared, part…
100% practical 6-week data science challenge & video course — simulating of being a junior data scientist at a true-to-life startup.
This is the third episode of my pandas tutorial series. In this one I’ll show you four data formatting methods that you might use a lot in data…
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…
Last time I wrote about Python For Loops and If Statements. Today we will talk about how to combine them. In this article, I’ll show you – through a…
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…
Learning SQL is very useful for anyone in the online world. And it’s a definite must for Data Analysts/Scientists! Here are 8 articles to start with…
I put together a ‘Python 3 for Data Science’ tutorial series starting from the very basics. It features 9 practical articles – that covers everything you need to know!
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…
We use if statements in our everyday life all the time – even if our everyday life is not written in Python. If the light is green then…