26 Oct Delete rows/ columns in a Pandas DataFrame

The drop() method is used in Python to delete rows/ columns in a Pandas DataFrame. It is used to remove a particular row or column. Under the parameters of the drop() method, mention the column you want to delete with the axis.

We will now see two examples:

1. Drop columns
2. Drop rows

Before moving further, we’ve prepared a video tutorial to delete rows/ columns in a Pandas DataFrame:

Drop columns using drop()

The columns are dropped using the column names. The axis is set to 1 since we want to drop a column. The columns axis can also be used for the drop() method to remove the specified column:

Let us see an example to drop columns using the drop() method:

Output

Drop rows using drop()

The rows are dropped using the index label set as a parameter of the drop() method. The rows of that particular label are removed. Set the axis to 0 since we want to drop a row. The rows axis i.e. index can also be used for the drop() method to remove the specified row:

Let us see an example of dropping a row using the drop() method. Here, the row with the 2^nd index is removed:

Output

---

If you liked the tutorial, spread the word and share the link and our website Studyopedia with others.

---

For Videos, Join Our YouTube Channel: Join Now

---