How to Gather Columns in Pandas (Python)
31↓ 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