How to get column and row names in DataFrame?

While analyzing the real datasets which are often very huge in size, we might need to get the rows or index names and columns name in order to perform some certain operations. 

Note: For downloading the nba dataset used in the below examples Click Here 

Getting row names in Pandas dataframe

First, let’s create a simple dataframe with nba.csv 

Output: 

Now let’s try to get the row name from the above dataset.

Method #1: Simply iterate over indices 

Output: 

0 1 2 3 4 5 6 7 8 9 

  
Method #2: Using rows with dataframe object 

Output: 

[0, 1, 2, 3, 4, 5, 6, 7, 8, 9]

  
Method #3: index.values method returns an array of index. 

Output: 

[0, 1, 2, 3, 4, 5, 6, 7, 8, 9]

  
Method #4: Using tolist() method with values with given the list of index. 

Output: 

[0, 1, 2, 3, 4, 5, 6, 7, 8, 9]

Method #5: Count number of rows in dataframe
Since we have loaded only 10 top rows of dataframe using head() method, let’s verify total number of rows first.

Output: 

Now, let’s print the total count of index. 

Output: 

458

Getting column names in Pandas dataframe

Now let’s try to get the columns name from nba.csv dataset.
Method #1: Simply iterating over columns 

Output: 

  
Method #2: Using columns with dataframe object 

Output: 
 

  
Method #3: column.values method returns an array of index. 

Output: 
 

  
Method #4: Using tolist() method with values with given the list of columns. 

Output: 
 

  
Method #5: Using sorted() method
Sorted() method will return the list of columns sorted in alphabetical order. 

Output: 
 

 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. And to begin with your Machine Learning Journey, join the Machine Learning – Basic Level Course