Category: Coding In Data Science and Analytics Page 1 of 3

coding in data science and analytics

Data Visualization and Data Analysis in Python — using the OkCupid dataset (Part 2)

This article is about dating and data science! Please welcome our guest author, Amy Birdee, who has done multiple data science hobby projects recently and built a truly…

Coding in Data Science and Analytics

Data Cleaning and Exploratory Data Analysis Using the OkCupid Dataset (Part 1)

This article is about dating and data science! Please welcome our guest author, Amy Birdee, who has done multiple data science hobby projects recently and built a truly…

coding in data science and analytics

Beautiful Soup Tutorial 2. – How to Scrape Multiple Web Pages

Scraping one web page is fun, but scraping more web pages is more fun. In this tutorial you’ll learn how to do just that; along the way you’ll…

coding in data science and analytics

Beautiful Soup Tutorial 1. – An Introduction to Web Scraping with Python

As a data scientist or data analyst, sooner or later you’ll come to a point where you have to collect large amounts of data. Be it a hobby…

coding in data science and analytics

Winning the Kevin Bacon Game with SQL: Data Science Hobby Project Example

James Rice was a participant in my 6-week data science course (The Junior Data Scientist’s First Month). After finishing the course, he started a cool hobby project and…

coding in data science and analytics

Data Science Hobby Project: Web Scraping Book Ratings With BeautifulSoup

Tamas Ujhelyi was a participant in my 6-week data science course (the Junior Data Scientist’s First Month). After finishing the course, he started a cool hobby project and…

coding in data science and analytics

How Data Collection Works on Websites (JavaScript tracking on front end + apache2 log on back end)

In this article, I want to quickly show you how websites collect data. It’s important to know this for two reasons: If you are a website visitor, it’s…

coding in data science and analytics

How to Upload your Dataset to a Server (Using the Command Line or Jupyter)

In this article, I’ll answer a question that frequently comes up in my online courses, which is: How do you upload a dataset (e.g. csv, txt or tsv…

coding in data science and analytics

Data Science Hobby Project Example: Twitter Data Analysis With JavaScript

Tomi Gelo was one of the first participants in my 6-week data science course (the Junior Data Scientist’s First Month). Since then, he has done some pretty cool…

coding in data science and analytics

Sublime Text 3 Intro (+ How to Connect Sublime to a Remote Server)

I’ve written about the importance of scripting in data science. But I’ve realized that I’ve never introduced my favorite script editor. It’s Sublime Text 3! In this article,…

coding in data science and analytics

Pandas tutorial 5: Scatter plot with pandas and matplotlib

Scatter plots are frequently used in data science and machine learning projects. In this pandas tutorial, I’ll show you two simple methods to plot one. Both solutions will…

coding in data science and analytics

How to Plot a Histogram in Python (Using Pandas)

Plotting a histogram in Python is easier than you’d think! And in this article, I’ll show you how. I have a strong opinion about visualization in Python, which…

coding in data science and analytics

How to Run a Python Script (Step by Step Tutorial, with Example)

In this tutorial, you’ll learn how to run a Python script. And it’s quite essential. When working on data science projects, you’ll write Python code all the time……

coding in data science and analytics

SQL current date — How to get the current date, time, month or year in postgreSQL?

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…

coding in data science and analytics

SQL TRUNCATE TABLE and DROP TABLE (tutorial)

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

coding in data science and analytics

Scraping Multiple Web Pages with For Loops (in bash) — Web Scraping Tutorial ep#2

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…

coding in data science and analytics

Web Scraping Tutorial — episode #1 — Scraping a Webpage (with Bash)

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…

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…

the junior data scientist's first month

The Junior Data Scientist’s First Month (Video Course)

100% practical 6-week data science challenge & video course — simulating of being a junior data scientist at a true-to-life startup.

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…