How to Access Columns by Name in Pandas (Python)

How to Access Columns by Name in Pandas (Python)

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


Category:
Guide
Duration: 2:45
1,773 views
35

↓ Code Available Below! ↓

This video shows how to access the columns of a pandas data frame using the name of the column. Although base python data structures like lists don't have index names, data frames have named columns that often give information about what is in the column, so it is usually more natural to select columns by name than a numeric index.

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()

# Access a column with direct indexing
mtcars["mpg"]

# Access a column with direct dot indexing
mtcars.mpg

# Access multiple columns by name
mtcars[["mpg","cyl","hp"]]

# Access multiple columns by name with a subset of rows by row name
mtcars.loc[["Mazda RX4 Wag","Valiant", "Porsche 914-2"],["mpg","cyl","hp"]]

# Access multiple columns by name with a subset of rows by row index
mtcars.loc[mtcars.index[[2,6,26]],["mpg","cyl","hp"]]



* 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-12-21Python for Data Analysis: Linear Regression
2020-12-17Python for Data Analysis: ANOVA
2020-12-16Python for Data Analysis: Chi-Squared Tests
2020-12-15Python for Data Analysis: Hypothesis Testing and T-Tests
2020-11-30How To Flatten Nested Lists in Python
2020-11-21How To Add Text To a Plot in R
2020-11-20How To Add Points To a Plot in R
2020-11-13How To Use applymap() In Pandas (Python)
2020-11-12How To Use apply() In Pandas (Python)
2020-11-11How To Use map() In Pandas (Python)
2020-11-04How to Access Columns by Name in Pandas (Python)
2020-11-04How to Access Columns by Numeric Index in Pandas (Python)
2020-11-04How to Access Rows by Name in Pandas (Python)
2020-11-04How to Access Rows by Numeric Index in Pandas (Python)
2020-10-30How to Get Unique (Distinct) Values of a Column in Pandas (Python)
2020-10-29How to Select Columns Based on a Logical Condition in Pandas (Python)
2020-10-28Spider-Man Spider Chart Pumpkin
2020-10-28How to Select Rows Based on a Logical Condition in Pandas (Python)
2020-10-27How to Check the First and Last Rows of a Data Frame in Pandas (Python)
2020-10-26How to Concatenate Data Frames in Pandas (Python)
2020-10-25How to Join Data Frames in Pandas (Python)


Tags:
pandas select column by name
select column by name in pandas
select column by name
select data frame column by name
data frame column select
pandas access column by name
pandas get column by name
pandas column name
pandas column indexing
pandas subset columns
pandas subset data
pandas select column
pandas get column
pandas access column
pandas columns
data frame get column
data frame access column
data frame select column
pandas basics
learn pandas