How to get rows/index names in Pandas dataframe
While analyzing the real datasets which are often very huge in size, we might need to get the rows or index names in order to perform some certain operations.
Let’s discuss how to get row names in Pandas dataframe.
First, let’s create a simple dataframe with nba.csv
# Import pandas package import pandas as pd # making data frame # calling head() method # storing in new variable data_top = data.head( 10 ) # display data_top |
Now let’s try to get the row name from above dataset.
Method #1: Simply iterate over indices
# Import pandas package import pandas as pd # making data frame data = pd.read_csv( "nba.csv" ) # calling head() method # storing in new variable data_top = data.head() # iterating the columns for row in data_top.index: print (row, end = " " ) |
Output:
0 1 2 3 4 5 6 7 8 9
Method #2: Using rows with dataframe object
# Import pandas package import pandas as pd # making data frame data = pd.read_csv( "nba.csv" ) # calling head() method # storing in new variable data_top = data.head() # list(data_top) or list (data_top.index) |
Output:
[0, 1, 2, 3, 4, 5, 6, 7, 8, 9]
Method #3: index.values
method returns an array of index.
# Import pandas package import pandas as pd # making data frame data = pd.read_csv( "nba.csv" ) # calling head() method # storing in new variable data_top = data.head() list (data_top.index.values) |
Output:
[0, 1, 2, 3, 4, 5, 6, 7, 8, 9]
Method #4: Using tolist()
method with values with given the list of index.
# Import pandas package import pandas as pd # making data frame data = pd.read_csv( "nba.csv" ) # calling head() method # storing in new variable data_top = data.head() list (data_top.index.values.tolist()) |
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 varify total number of rows first.
# iterate the indices and print each one for row in data.index: print (row, end = " " ) |
Output:
Now, let’s print the total count of index.
# Import pandas package import pandas as pd # making data frame data = pd.read_csv( "nba.csv" ) row_count = 0 # iterating over indices for col in data.index: row_count + = 1 # print the row count print (row_count) |
Output:
458
Recommended Posts:
- How to get column names in Pandas dataframe
- How to lowercase column names in Pandas dataframe
- Python | Change column names and row indexes in Pandas DataFrame
- Python | Pandas DataFrame.fillna() to replace Null values in dataframe
- Python | Pandas TimedeltaIndex.names
- Python | Pandas MultiIndex.names
- Add a row at top in pandas DataFrame
- Python | Pandas dataframe.mad()
- Python | Pandas dataframe.mul()
- Python | Pandas DataFrame.loc[]
- Python | Pandas Dataframe.at[ ]
- Python | Pandas Dataframe.iat[ ]
- Python | Pandas dataframe.ne()
- Python | Pandas dataframe.add()
- Saving a Pandas Dataframe as a CSV
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.