Tag: data coding Page 1 of 2

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 last time that Python if statements are similar to how our brain processes conditions in our everyday life? That’s true for for loops too….

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 left off? Oh, right, we learned about how to use variables in Python. Here is the second essential topic, that you have to learn, if you…

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, when you are doing data analysis. And SQL is really good at it! Of course each case is different, but I’ve run…

coding in data science and analytics

SQL for Data Analysis – Tutorial for Beginners – ep4

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

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…

coding in data science and analytics

SQL for Data Analysis – Tutorial for Beginners – ep2

This is the second episode of my SQL for Data Analysis (for beginners) series, and today I’ll show you every tiny little detail of the SQL WHERE clause….

coding in data science and analytics

How to install SQL Workbench for postgreSQL

In my previous SQL for data analysis tutorial, I briefly mentioned that I prefer SQL Workbench over pgadmin4 for SQL querying. Today I will show you how you can install it…

coding in data science and analytics

SQL for Data Analysis – Tutorial for Beginners – ep1

SQL (Structured Query Language) is a must if you want to be a Data Analyst or a Data Scientist. I have worked with many online businesses in the…

Strategy and Business in Data Science and Analytics

The structure of your Data Team. The flow of the data in your organization.

Smaller companies have smaller data teams (maybe just one person), bigger companies have bigger. The tricky thing is that the several different aspects of a data project need…

coding in data science and analytics

Data Coding 101 – Intro to Bash – ep6 (last episode)

This is the last piece of my “Data Coding 101: Introduction to Bash” series, where I introduce the very basics of how to use the command line for…