Tag: Tutorial

Getting Started with R Markdown — Guide and Cheatsheet

Learn the fundamentals of R markdown in this in-depth tutorial, or simply use it as a quick reference guide and cheatsheet for R markdown formatting.

Tutorial: Add a Column to a Pandas DataFrame Based on an If-Else Condition

When we’re doing data analysis with Python, we might sometimes want to add a column to a pandas DataFrame based on the values in other columns of the DataFrame. Although this sounds straightforward, it can get a bit complicated if we try to do it using an if-else conditional. Thankfully, there’s a simple, great way […]

Tutorial: Web Scraping in R with rvest

Learn how to do web scraping in R by using the rvest package to scrape data about the weather in this free R web scraping tutorial.

R API Tutorial: Getting Started with APIs in R

Learn how to access APIs using your R programming skills in this free tutorial covering how to get data from NASA’s free ISS API.

SQL Fundamentals Tutorial: Start Learning SQL Today!

Learn the fundamentals of SQL and start writing SQL queries to answer business questions in this free SQL fundamentals tutorial and interactive course.

Python Datetime Tutorial: Manipulate Times, Dates, and Time Spans

Learn to manipulate times, dates, and time series data in Python and become a master of the datetime module in this Dataquest tutorial.

Python Range Tutorial: Learn to Use This Helpful Built-In Function

Python’s range function is a great way to quickly generate a count of numbers within a range. Master this simple but powerful function in this tutorial.

Python if else Tutorial: Control the Flow of Your Code

Learn how to use if, else, and elif in this free Python tutorial. Learn to control your code while analyzing real-world data.

Tutorial: Transforming Data with Python Scripts and the Command Line

Learn to create Python scripts for data analysis using the Command Line in this intermediate Python tutorial digging into Hacker News headlines.

xlwings Tutorial: Make Excel Faster Using Python

Pythons xlwings is a tool that allows you to use Python code to control and analyze data in Excel spreadsheets. This tutorial will help you get started.

How Much Have You Spent on Amazon? Analyzing Amazon Data

How much have I spent on Amazon? That’s a scary question, but if you want to know the answer, here’s how you can find it…and a lot more!

Pandas Tutorial: Analyzing Video Game Data with Python and Pandas

Pandas is a Python library that can make data analysis much simpler. In this tutorial, we’ll use Python and pandas to analyze video game data.

Tutorial: Inserting Records and DataFrames Into a SQL Database

Master the art of the SQL Insert to add data to SQL and MySQL databases using SQL queries, as well as from within Python, and when using pandas.

Tutorial: Install Linux on Windows with Windows Subsystem for Linux

Here’s how to install Linux on Windows 10 machines so that you can access the Unix command line for data science workflows.

Tutorial: Advanced For Loops in Python

If you’ve already mastered the basics of iterating through Python lists, take it to the next level and learn to use for loops in pandas, numpy, and more!