Uploaded September 2020 | Updated November 2026, 2 hours ago
This video shows how to add columns from Data Frames in the Pandas library for Python.
If you find this video useful, like, share and subscribe to support the channel!
► Subscribe: youtube.com/c/DataDaft?sub_confirmation=1
Code used in this Python Code Clip:
import pandas as pd
import statsmodels.api as sm #(To access mtcars dataset)
mtcars = sm.datasets.get_rdataset("mtcars", "datasets", cache=True).data
mtcars.head()
# Add row to end of data frame with df.append()
row = mtcars.loc["Volvo 142E",]
mtcars = mtcars.append(row)
mtcars.tail()
# Add a new row by assignment with index name
mtcars.loc["NEW_CAR"] = [0,1,2,3,4,5,6,7,8,9,10]
mtcars.tail()
# Insert row at given position
# Construct a row to insert as a data frame
row_values = [12,35,46,27,28,24,23,13,64,34,64]
insert_row = pd.DataFrame({v: row_values[k] for k, v in enumerate(mtcars.columns)},
index = ["Insert_Car"])
# Choose an insertion index
insert_index = len(mtcars.index)-2
# Use indexing to append rows
mtcars = mtcars.iloc[:insert_index,].append([insert_row, mtcars.iloc[insert_index:,]])
mtcars.tail()
* 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: kite.com/get-kite/?utm_medium=referral&utm_source=youtube&utm_campaign=datadaft&utm_content=description-only
This video shows how to add columns from Data Frames in the Pandas library for Python.
If you find this video useful, like, share and subscribe to support the channel!
► Subscribe: youtube.com/c/DataDaft?sub_confirmation=1
Code used in this Python Code Clip:
import pandas as pd
import statsmodels.api as sm #(To access mtcars dataset)
mtcars = sm.datasets.get_rdataset("mtcars", "datasets", cache=True).data
mtcars.head()
# Add row to end of data frame with df.append()
row = mtcars.loc["Volvo 142E",]
mtcars = mtcars.append(row)
mtcars.tail()
# Add a new row by assignment with index name
mtcars.loc["NEW_CAR"] = [0,1,2,3,4,5,6,7,8,9,10]
mtcars.tail()
# Insert row at given position
# Construct a row to insert as a data frame
row_values = [12,35,46,27,28,24,23,13,64,34,64]
insert_row = pd.DataFrame({v: row_values[k] for k, v in enumerate(mtcars.columns)},
index = ["Insert_Car"])
# Choose an insertion index
insert_index = len(mtcars.index)-2
# Use indexing to append rows
mtcars = mtcars.iloc[:insert_index,].append([insert_row, mtcars.iloc[insert_index:,]])
mtcars.tail()
* 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: kite.com/get-kite/?utm_medium=referral&utm_source=youtube&utm_campaign=datadaft&utm_content=description-only

![How to Rename Columns in Pandas (Python)
↓ Code Available Below! ↓
This video shows how to rename the columns of a data frame in pandas. Data sometimes comes with columns that are in a bad format or not sufficiently explanatory, so you may want to rename them. Renaming columns can also come in handy as preprocessing step prior to performing join (marge) operations.
Note that if you want to rename all of the columns you can also do it with direct assignment like this:
df.columns = [newcolname1, newcolname2, newcolname3...]
The method shown in the video will work whether you are assigning new names to all of the columns or just some of the columns.
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
data = pd.DataFrame({char: [Goku,Vegeta, Nappa,Gohan,Piccolo],
pl: [12000, 16000, 4000, 1500, 3000],
ucl: [orange, blue, black, orange, purple]})
data
# Rename columns with df.rename()
data.rename(columns={char:character,
pl: power level,
ucl: uniform color}, inplace = True)
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 Rename Columns in Pandas (Python)](https://i.ytimg.com/vi/c81n9E_fm3U/mqdefault.jpg)


![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)





