How To Add a Column to a Data Frame in Pandas (Python)

How To Add a Column to a Data Frame in Pandas (Python)

Channel:
United States DataDaft
Subscribers:
53,100
Published on ● Video Link: https://www.youtube.com/watch?v=6WmNmAdX5wU


Duration: 3:27
8,850 views
134

This video shows 3 ways to add new columns to Pandas Data Frames in Python. Adding new columns is a basic data manipulation task that is a common part of the data cleaning and wrangling process.

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

import statsmodels.api as sm #(To access mtcars dataset)
mtcars = sm.datasets.get_rdataset("mtcars", "datasets", cache=True).data

mtcars.head()

# Method #1: Direct Column Assignment

mtcars["new_1"] = mtcars.mpg ＞ 20

mtcars.head()

# Method #2: Use .insert()

mtcars.insert(2, # Where to insert
"new_2", # Name of new column
mtcars.mpg ＞ 25) # What to insert

mtcars.head()

# Method #3: Use .assign()

mtcars = mtcars.assign(new_3 = mtcars.mpg ＞ 15, # New column
new_4 = mtcars.mpg ＞ 30) # Another new column

mtcars.head()


* 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



Other Videos By DataDaft


2020-07-24Python for Data Analysis: Working With Text Data
2020-07-23Python for Data Analysis: Exploring and Cleaning Data
2020-07-22Python for Data Analysis: List Comprehensions
2020-07-21Python for Data Analysis: Functions
2020-07-21Python for Data Analysis: Control Flow (if, else, for, while)
2020-07-20Python for Data Analysis: Reading and Writing Data
2020-07-17Python for Data Analysis: Pandas Data Frames
2020-07-16Python for Data Analysis: Numpy Arrays
2020-07-15Python for Data Analysis: Dictionaries and Sets
2020-07-10One Piece Strongest Characters Over Time Based on Fight Performance
2020-06-29How To Add a Column to a Data Frame in Pandas (Python)
2020-06-23Python for Data Analysis: Tuples and Strings
2020-06-16Top 10 Data Science Tools Over Time
2020-06-09Python for Data Analysis: Lists
2020-06-02Songs of the 2010s: All #1 Hits
2020-05-28Songs of the 2000s: All #1 Hits
2020-05-19Python for Data Analysis: Variables
2020-05-16Goku vs Vegeta: Power Levels Over Time
2020-05-12Python for Data Analysis: Basic Data Types
2020-05-11Songs of the 90s: All #1 Hits
2020-05-08Songs of the 80s: All #1 Hits


Tags:
add a column to a data frame in python
add a column to a data frame in pandas
pandas add column
pandas add columns
python data frames
pandas data frames
add a column to a dataframe in pandas
add a column to a dataframe in python
python add column
pandas basics
add columns in pandas
add a column in pandas
create new columns in pandas
create new column in pandas
pandas dataframes
learn pandas
python data science
learn python
pandas
python
python dataframes