Use DataFrame.drop and pass it a Series of index labels:
In [65]: df
Out[65]:
one two
one 1 4
two 2 3
three 3 2
four 4 1
In [66]: df.drop(df.index[[1,3]])
Out[66]:
one two
one 1 4
three 3 2
Pandas
pandas.pydata.org › docs › reference › api › pandas.DataFrame.drop.html
pandas.DataFrame.drop — pandas 3.0.2 documentation
Drop a specific index combination from the MultiIndex DataFrame, i.e., drop the combination 'falcon' and 'weight', which deletes only the corresponding row
Top answer 1 of 15
530
Use DataFrame.drop and pass it a Series of index labels:
In [65]: df
Out[65]:
one two
one 1 4
two 2 3
three 3 2
four 4 1
In [66]: df.drop(df.index[[1,3]])
Out[66]:
one two
one 1 4
three 3 2
2 of 15
158
Note that it may be important to use the "inplace" command when you want to do the drop in line.
df.drop(df.index[[1,3]], inplace=True)
Because your original question is not returning anything, this command should be used. http://pandas.pydata.org/pandas-docs/version/0.17.0/generated/pandas.DataFrame.drop.html
python - Remove Row Index dataframe pandas - Stack Overflow
Given a df in[0]df1 out[0] DATE REVENUE COST POSITION FACTOR 0 2017/01/01 1000 900 10 1 2017/01/01 900 700 9 2 2017/01/01 1100 800 7 I have an More on stackoverflow.com
Removing rows from pandas dataframe efficiently?
I have to use data from two pandas dataframes but I’m having trouble figuring out how to remove data efficiently from the datasets. The df_books dataframe contains roughly 300k entries which includes book details (isbn, title, and author), while the df_ratings dataframe contains 1.1 million ... More on forum.freecodecamp.org
0
0
July 27, 2021Removing a row from a pandas dataframe by index location
You could do something like this. df.reset_index().drop([1,2,3]).set_index("index_name") More on reddit.com
2
2
September 29, 2017indexing - How to delete a row in a Pandas DataFrame and relabel the index? - Stack Overflow
I am reading a file into a Pandas DataFrame that may have invalid (i.e. NaN) rows. This is sequential data, so I have row_id+1 refer to row_id. When I use frame.dropna(), I get the desired structur... More on stackoverflow.com
Videos
09:39
17. How to delete rows/ columns from a Pandas DataFrame | Python ...
05:49
Delete Rows of pandas DataFrame Conditionally in Python (Example) ...
Delete Rows From Pandas Dataframe - YouTube
03:37
Python - How to delete rows in a multi-level index dataframe - YouTube
01:57
How to Remove a Row From a Data Frame in Pandas (Python) - YouTube
04:36
How to remove or drop index from dataframe in python pandas ? - ...
Note.nkmk.me
note.nkmk.me › home › python › pandas
pandas: Delete rows/columns from DataFrame with drop() | note.nkmk.me
August 8, 2023 - Use a list to delete multiple rows at once. print(df.drop(['Bob', 'Dave', 'Frank'])) # age state point # name # Alice 24 NY 64 # Charlie 18 CA 70 # Ellen 24 CA 88 print(df.drop(index=['Bob', 'Dave', 'Frank'])) # age state point # name # Alice 24 NY 64 # Charlie 18 CA 70 # Ellen 24 CA 88 ... By default, the original DataFrame remains unchanged, and a new DataFrame is returned.
GeeksforGeeks
geeksforgeeks.org › pandas › how-to-drop-rows-in-pandas-dataframe-by-index-labels
How to drop rows in Pandas DataFrame by index labels? - GeeksforGeeks
drop() method in Pandas is a simple way to remove rows by their index labels.
Published July 15, 2025
GeeksforGeeks
geeksforgeeks.org › pandas › python-delete-rows-columns-from-dataframe-using-pandas-drop
Python | Delete rows/columns from DataFrame using Pandas.drop() - GeeksforGeeks
July 11, 2025 - Pandas is one of those packages which makes importing and analyzing data much easier. In this article, we will how to delete a row in Excel using Pandas as well as delete a column from DataFrame using Pandas. Syntax: DataFrame.drop(labels=None, axis=0, index=None, columns=None, level=None, inplace=False, errors='raise')
Shane Lynn
shanelynn.ie › home › delete rows & columns in dataframes quickly using pandas drop
Delete Rows & Columns in DataFrames using Pandas Drop
December 17, 2021 - To drop a specific row from the data frame – specify its index value to the Pandas drop function. # delete a single row by index value 0 data = data.drop(labels=0, axis=0) # delete a few specified rows at index values 0, 15, 20.
Spark By {Examples}
sparkbyexamples.com › home › pandas › pandas drop rows by index
Pandas Drop Rows by Index - Spark By {Examples}
May 7, 2024 - How to perform Drop Rows by Index in Pandas DataFrame? By using the Pandas drop function we can drop/delete the row or list of rows by index labels or
GeeksforGeeks
geeksforgeeks.org › pandas › drop-rows-from-the-dataframe-based-on-certain-condition-applied-on-a-column
Drop Rows from Dataframe based on certain Condition applied on a Column - Pandas - GeeksforGeeks
October 3, 2025 - drop() can remove rows by index. First, identify the rows to drop using a condition, then delete them permanently.
Vultr Docs
docs.vultr.com › python › third-party › pandas › drop
Python Pandas drop() - Remove Data Entries | Vultr Docs
December 30, 2024 - Use boolean indexing to specify the condition and drop() to remove the rows.
ActiveState
activestate.com › home › resources › quick read › how to delete a column/row from a dataframe
How to Delete a Column/Row From a DataFrame using Pandas - ActiveState
January 24, 2024 - Since the “drop” function accepts indices, we applied the index function to the Report_Card DataFrame, and then provided arguments to create a Series object that evaluates to True for the locations of all rows containing German as the lecture value. And finally, if we wanted to delete our entire DataFrame, we can simply use:
Top answer 1 of 3
20
I hope this works :)
df.reset_index(inplace=True) # Resets the index, makes factor a column
df.drop("Factor",axis=1,inplace=True) # drop factor from axis 1 and make changes permanent by inplace=True
2 of 3
13
Try using:
df1.reset_index(drop=True)
This resets the index to the default integer index and removes the original one.
If you want to assign this change to original dataframe it is easier to use:
df1.reset_index(drop=True, inplace=True)
As it will edit the df1 dataframe without making a copy of it.
Edlitera
edlitera.com › blog › posts › pandas-dataframe-remove-rows
How to Remove Rows from a Pandas DataFrame | Edlitera
Arguably the easiest way to drop rows, provided you have a clear understanding of which rows to drop, is by referencing their index labels. This way we can remove any row, or even multiple rows, from our Pandas DataFrame.
freeCodeCamp
forum.freecodecamp.org › python
Removing rows from pandas dataframe efficiently? - Python - The freeCodeCamp Forum
July 27, 2021 - I have to use data from two pandas dataframes but I’m having trouble figuring out how to remove data efficiently from the datasets. The df_books dataframe contains roughly 300k entries which includes book details (isbn, …
Arab Psychology
scales.arabpsychology.com › home › how to easily remove rows by index in pandas
How To Easily Remove Rows By Index In Pandas
December 5, 2025 - When aiming to remove a single observation identified by a numeric label, the syntax is straightforward. Here, we target index 0, which corresponds to the first row in a zero-indexed Pandas object: #drop first row from DataFrame df = df.drop(index=0) For scenarios requiring the removal of multiple disconnected rows, the index parameter accepts a list or array-like structure containing all the index labels that need deletion...
freeCodeCamp
freecodecamp.org › news › drop-list-of-rows-from-pandas-dataframe
Data Analytics with Pandas – How to Drop a List of Rows from a Pandas Dataframe
June 1, 2021 - You can delete a list of rows from Pandas by passing the list of indices to the drop() method. ... This is how you can delete rows with a specific index.
TutorialsPoint
tutorialspoint.com › python_pandas › python_pandas_removing_rows_from_dataframe.htm
Python Pandas - Removing Rows from a DataFrame
The pandas DataFrame.drop() method is used to remove a specific row from the pandas DataFrame. It can be used to drop rows by their label or position (integer-based index), and it returns a new DataFrame with the selected rows removed.
Spark By {Examples}
sparkbyexamples.com › home › pandas › pandas drop rows from dataframe examples
Pandas Drop Rows From DataFrame Examples - Spark By {Examples}
October 2, 2024 - By using pandas.DataFrame.drop() method you can drop/remove/delete rows from DataFrame. axis param is used to specify what axis you would like to remove.
Quora
quora.com › How-should-I-delete-rows-from-a-DataFrame-in-Python-Pandas
How should I delete rows from a DataFrame in Python-Pandas? - Quora
Use DataFrame.drop(labels, axis=0, inplace=False) to remove row(s) whose index equals labels. ... Deleting rows from a pandas DataFrame can be done in several idiomatic ways depending on criteria: by index label/position, by boolean condition, ...
Reddit
reddit.com › r/learnpython › removing a row from a pandas dataframe by index location
r/learnpython on Reddit: Removing a row from a pandas dataframe by index location
September 29, 2017 -
Has anyone here tried to drop a row from a pandas dataframe by index location rather than by the index? Is there anyway to do it similar to the drop attribute with the inplace option equal to True?
Like this question?:
https://stackoverflow.com/questions/46494583/drop-a-row-in-pandas-dataframe-base-on-integer-index-location
Top answer 1 of 2
17
Use pandas.DataFrame.reset_index(), the option drop=True will do what you are looking for.
In [14]: df = pd.DataFrame(np.random.randn(5,4))
In [15]: df.ix[::3] = np.nan
In [16]: df
Out[16]:
0 1 2 3
0 NaN NaN NaN NaN
1 1.895803 0.532464 1.879883 -1.802606
2 0.078928 0.053323 0.672579 -1.188414
3 NaN NaN NaN NaN
4 -0.766554 -0.419646 -0.606505 -0.162188
In [17]: df = df.dropna()
In [18]: df.reset_index(drop=True)
Out[18]:
0 1 2 3
0 1.895803 0.532464 1.879883 -1.802606
1 0.078928 0.053323 0.672579 -1.188414
2 -0.766554 -0.419646 -0.606505 -0.162188
2 of 2
4
In addition to an accepted answer:
You should also use inplace=True as well:
df.reset_index(drop=True, inplace=True)