How to Remove a Row From a Data Frame in Pandas (Python)

How to Remove a Row From a Data Frame in Pandas (Python)

Channel:
United States DataDaft
Subscribers:
44,100
Published on ● Video Link: https://www.youtube.com/watch?v=9yF2l0WPENM


Category:
Guide
Duration: 1:57
8,317 views
92

This video shows how to delete rows Data Frames in the Pandas library for Python.

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

# Delete rows by name with df.drop()

mtcars = mtcars.drop(["Mazda RX4 Wag"], # Rows to drop
axis = 0) # 0 for rows

mtcars.head()

# Delete rows by index

mtcars = mtcars.drop(mtcars.index[[0,2]], # Rows indicies to drop
axis = 0) # 0 for rows

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-10-06Python Regex: How To Remove Punctuation
2020-10-05Python Regex: How To Match All Whitespace
2020-10-02Python Regex: How To Replace All Substrings In a String
2020-10-01Python Regex: How To Split a String On Multiple Characters
2020-09-30Python Regex: How Find a Substring in a String
2020-09-21Fastest To OVER 9000: Battle of the GOATs
2020-09-17How to Detect and Fill Missing Values in Pandas (Python)
2020-09-11How to Use where() in Numpy and Pandas (Python)
2020-09-10How to Do Elementwise Math in Python
2020-09-04How to Add a Row To a Data Frame in Pandas (Python)
2020-09-03How to Remove a Row From a Data Frame in Pandas (Python)
2020-09-02How to Remove a Column From a Data Frame in Pandas (Python)
2020-08-29Python Programming Practice: LeetCode #104 -- Maximum Depth of Binary Tree
2020-08-28Python Programming Practice: LeetCode #136 -- Single Number
2020-08-28Python Programming Practice: LeetCode #283 -- Move Zeroes
2020-08-26Python Programming Practice: LeetCode #169 -- Majority Element
2020-08-25Python Programming Practice: LeetCode #70 -- Climbing Stairs
2020-08-14Top 15 MMA Fighters Over Time Ranked by Elo (1980-2020)
2020-08-12Python Programming Practice: LeetCode #2 -- Add Two Numbers
2020-08-11Python for Data Analysis: Confidence Intervals
2020-08-10Python for Data Analysis: Probability Distributions


Tags:
remove a row from a data frame in python
remove a row from a data frame in pandas
pandas dataframes
learn pandas
pandas
python
python dataframes
delete a row from a data frame in pandas
pandas remove rows
pandas delete rows
remove row from data frame
delete row from data frame
delete from data frame
delete from dataframes
remove rows
delete rows
pandas drop rows
df.drop
df.drop()
pandas basics
pandas delete data
pandas delete records
pandas remove records