Skip to content
Related Articles

Related Articles

Python | Pandas Index.delete()
  • Last Updated : 16 Dec, 2018

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier.

Pandas Index.delete() function returns a new object with the passed locations deleted. We can pass more than one locations to be deleted in the form of list.

Syntax: Index.delete(loc)

Parameters :
loc : Scalar/List of Indices

Returns : new_index : Index



Example #1: Use Index.delete() function to delete the first value in the Index.




# importing pandas as pd
import pandas as pd
  
# Creating the Index
idx = pd.Index(['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',
                'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'])
  
# Print the Index
idx

Output :

Let’s delete the month of ‘Jan’. It is present at the 0th index so we will pass 0 as an argument to the function.




# delete the first label in the given Index
idx.delete(0)

Output :

As we can see in the output, the function has returned an object with its first label deleted.
 
Example #2: Use Index.delete() function to delete more than one labels in the Index.




# importing pandas as pd
import pandas as pd
  
# Creating the Index
idx = pd.Index(['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',
                'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'])
  
# Print the Index
idx

Output :

Let’s delete the second, third, fourth and fifth indices from the Index. We pass a list of values to be deleted to the function.




# to delete values present at 2nd, 3rd, 4th and 5th place in the Index.
idx.delete([2, 3, 4, 5])

Output :

As we can see the labels corresponding to the passed values in the Index has been deleted.

Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.

My Personal Notes arrow_drop_up
Recommended Articles
Page :