Tag: data coding Page 1 of 2

coding in data science and analytics

SQL Interview Questions: 3 Tech Screening Exercises (For Data Analysts)

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…

coding in data science and analytics

Pandas Tutorial 3: Important Data Formatting Methods (merge, sort, reset_index, fillna)

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…

coding in data science and analytics

Pandas Tutorial 2: Aggregation and Grouping

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…

coding in data science and analytics

Pandas Tutorial 1: Pandas Basics (Reading Data Files, DataFrames, Data Selection)

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…

coding in data science and analytics

Python libraries and packages for Data Scientists (the 5 most important ones)

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…

coding in data science and analytics

Python Import Statement and the Most Important Built-in Modules for Data Scientists

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…

coding in data science and analytics

Python For Loops and If Statements Combined (Python for Data Science Basics #6)

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…

coding in data science and analytics

How to Import Data into SQL Tables

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…

coding in data science and analytics

How to Create a Table in SQL

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…

thoughts about data science and analytics

Data Science Career Question #1: “Is Data Science For Me?”

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…

coding in data science and analytics

Python For Loops Explained (Python for Data Science Basics #5)

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…

coding in data science and analytics

Python If Statements Explained (Python for Data Science Basics #4)

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…

coding in data science and analytics

Python 2 vs Python 3

“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….

thoughts about data science and analytics

Data Analytics Basics (introduction)

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…

coding in data science and analytics

Python Data Structures (Python for Data Science Basics #2)

Where we did we leave off? Oh, right, we learned about how to use variables in Python. Here is the second essential topic that you have to learn…

coding in data science and analytics

Python for Data Science – Tutorial for Beginners #1 – Python Basics

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…

coding in data science and analytics

SQL for Data Analysis – Tutorial – ep6 (advanced stuff)

This is the final episode of the SQL for Data Analysis – Tutorial for Beginners series. Today I’ll show you some more advanced SQL moves! Though junior data…

coding in data science and analytics

SQL for Data Analysis – Tutorial for Beginners – ep5

Combining tables is a key component of data analysis. And SQL is really good at it! Of course each case is different, but I’ve run into analytical tasks too…

coding in data science and analytics

SQL for Data Analysis – Tutorial for Beginners – ep4

You have already learned a lot about the basics of SQL for data analysis. I figured now would be a nice time to have an episode focusing only…

coding in data science and analytics

SQL for Data Analysis – Tutorial for Beginners – ep3

Today I’ll show you the most essential SQL functions that you will use for finding the maximums or the minimums (MAX, MIN) in a data set and to…