Uploaded July 2020 | Updated November 2026, 2 hours ago
This video covers the basics of joining data frames in Python with the pandas library.
Subscribe:
► youtube.com/c/DataDaft?sub_confirmation=1
This is lesson 18 of a 30-part introduction to the Python programming language for data analysis and predictive modeling. Link to the code notebook below:
Python for Data Analysis: Joining Data
kaggle.com/hamelg/python-for-data-18-merging-data
This guide does not assume any prior exposure to Python, programming or data science. It is intended for beginners with an interest in data science and those who might know other programming languages and would like to learn Python.
I will create the videos for this guide such that you should be able to learn a lot just watching on YouTube, but to get the most out of the guide, it is recommended that you create a Kaggle account so that you can copy and edit each lesson so that you can follow along and run code yourself.
Introduction to Python Playlist:
youtube.com/playlist?list=PLiC1doDIe9rCYWmH9wIEYEXXaJ4KAi3jc
Link to the Python for Data Analysis written guide index page:
kaggle.com/hamelg/python-for-data-analysis-index .
⭐ Kite is a free AI-powered coding assistant that integrates with popular editors and IDEs to give you smart code completions and docs while you’re typing. It is a cool application of machine learning that can also help you code faster! Check it out here: kite.com/get-kite/?utm_medium=referral&utm_source=youtube&utm_campaign=datadaft&utm_content=description-only
This video covers the basics of joining data frames in Python with the pandas library.
Subscribe:
► youtube.com/c/DataDaft?sub_confirmation=1
This is lesson 18 of a 30-part introduction to the Python programming language for data analysis and predictive modeling. Link to the code notebook below:
Python for Data Analysis: Joining Data
kaggle.com/hamelg/python-for-data-18-merging-data
This guide does not assume any prior exposure to Python, programming or data science. It is intended for beginners with an interest in data science and those who might know other programming languages and would like to learn Python.
I will create the videos for this guide such that you should be able to learn a lot just watching on YouTube, but to get the most out of the guide, it is recommended that you create a Kaggle account so that you can copy and edit each lesson so that you can follow along and run code yourself.
Introduction to Python Playlist:
youtube.com/playlist?list=PLiC1doDIe9rCYWmH9wIEYEXXaJ4KAi3jc
Link to the Python for Data Analysis written guide index page:
kaggle.com/hamelg/python-for-data-analysis-index .
⭐ Kite is a free AI-powered coding assistant that integrates with popular editors and IDEs to give you smart code completions and docs while you’re typing. It is a cool application of machine learning that can also help you code faster! Check it out here: kite.com/get-kite/?utm_medium=referral&utm_source=youtube&utm_campaign=datadaft&utm_content=description-only
![How to Gather Columns in Pandas (Python)
↓ Code Available Below! ↓
This video shows how to gather data using the melt function in the pandas library for Python, which allows you transform data in a wide format into data in a long format. Manipulating data with gather and spread operations (also known as melt and cast/pivot) is a common data preprocessing task.
If you find this video useful, like, share and subscribe to support the channel!
► Subscribe: https://www.youtube.com/c/DataDaft?sub_confirmation=1
Code used in this Python Code Clip:
import pandas as pd
# Starting with wide data
data = pd.DataFrame({character: [Goku,Vegeta, Nappa,Gohan,Piccolo],
uniform color: [orange, blue, black, orange, purple],
saiyan: [12000, 16000, 4000, 1500, 3000],
frieza: [150000000, 3000000, 4000, 75000, 1200000],
cell: [1000000000, 1000000000, 4000, 2000000000, 300000000],
buu: [4000000000, 2500000000, 4000, 5000000000, 500000000]})
data
# Gather multiple columns with df.melt()
# Gathers into key column - value column pairs
data = data.melt(id_vars = [character, uniform color],# Columns to keep (not gathered)
value_vars = [saiyan,frieza,cell,buu], # Columns to gather
var_name = saga, # Name of new gathered column
value_name = power level) # Name of new value column
data
** Note: YouTube does not allow greater than or less than symbols in the text description, so the code above will not be exactly the same as the code shown in the video! I will use Unicode large < and > symbols in place of the standard sized ones. .
⭐ Kite is a free AI-powered coding assistant that integrates with popular editors and IDEs to give you smart code completions and docs while you’re typing. It is a cool application of machine learning that can also help you code faster! Check it out here: https://www.kite.com/get-kite/?utm_medium=referral&utm_source=youtube&utm_campaign=datadaft&utm_content=description-only How to Gather Columns in Pandas (Python)](https://i.ytimg.com/vi/d0lErH-moT4/mqdefault.jpg)









![How to Select Rows Based on a Logical Condition in Pandas (Python)
↓ Code Available Below! ↓
This video shows how to select the rows of a data frame based on a logical condition, such as whether the value of a column conform to a given logical expression. Filtering or subsetting the rows of a data frame by the values of one or more columns is a common an useful operation that youll perform regularly when cleaning, manipulating and exploring data.
If you find this video useful, like, share and subscribe to support the channel!
► Subscribe: https://www.youtube.com/c/DataDaft?sub_confirmation=1
Code used in this Python Code Clip:
data = pd.DataFrame({character: [Goku,Vegeta, Nappa,Gohan,
Piccolo,Tien,Yamcha, Krillin],
power_level: [12000, 16000, 4000, 1500, 3000,
2000, 1600, 2000],
uniform color: [orange, blue, black, orange,
purple, green, orange, orange],
species: [saiyan,saiyan,saiyan,half saiyan,
namak,human,human,human]})
data
# Create a logical index with one value for each row
logical_index = data[power_level] > 2000
logical_index
# Use the logical index to index into the data frame
data[logical_index]
# Select rows based on multiple logical conditions
logical_condition_1 = data[power_level] > 2000
logical_condition_2 = data[species] != saiyan
data[logical_condition_1 & logical_condition_2]
* Note: YouTube does not allow greater than or less than symbols in the text description, so the code above will not be exactly the same as the code shown in the video! I will use Unicode large < and > symbols in place of the standard sized ones. .
⭐ Kite is a free AI-powered coding assistant that integrates with popular editors and IDEs to give you smart code completions and docs while you’re typing. It is a cool application of machine learning that can also help you code faster! Check it out here: https://www.kite.com/get-kite/?utm_medium=referral&utm_source=youtube&utm_campaign=datadaft&utm_content=description-only How to Select Rows Based on a Logical Condition in Pandas (Python)](https://i.ytimg.com/vi/g8v5c9zmpJI/mqdefault.jpg)