Open In App
Related Articles

Get a specific row in a given Pandas DataFrame

Improve Article
Improve
Save Article
Save
Like Article
Like

In the Pandas DataFrame, we can find the specified row value with the function iloc(). In this function, we pass the row number as a parameter. In this article, we will see how we can get a specific row in a given Pandas Dataframe.

pandas.DataFrame.iloc[] Function Syntax

Syntax : pandas.DataFrame.iloc[]

Parameters :

  • Index Position : Index position of rows in integer or list of integer
  • Return type : Data frame or Series depending on parameters

Print a Specific Row of a Pandas DataFrame Examples

Example 1: Specific row in a given Pandas DataFrame

In this example, we are using iloc function. The code creates a DataFrame from a dictionary, prints the original DataFrame, and then displays the values of the second row using the iloc method.

python3




# importing the module
import pandas as pd
 
# creating a DataFrame
data = {'1' : ['g', 'e', 'e'],
        '2' : ['k', 's', 'f'],
        '3' : ['o', 'r', 'g'],
        '4' : ['e', 'e', 'k']}
df = pd.DataFrame(data)
print("Original DataFrame")
display(df)
 
print("Value of row 1")
display(df.iloc[1])


Output

Original DataFrame
1 2 3 4
0 g k o e
1 e s r e
2 e f g k
Value of row 1
1 e
2 s
3 r
4 e
Name: 1, dtype: object

Example 2: Get row in a given Pandas DataFrame

The code generates a DataFrame containing student names and their scores in three subjects. It then prints the original DataFrame and displays the values of the fourth row (index 3) corresponding to the student ‘Alex’ using the iloc method.

python3




# importing the module
import pandas as pd
 
# creating a DataFrame
data = {'Name' : ['Simon', 'Marsh', 'Gaurav',
                'Alex', 'Selena'],
        'Maths' : [8, 5, 6, 9, 7],
        'Science' : [7, 9, 5, 4, 7],
        'English' : [7, 4, 7, 6, 8]}
df = pd.DataFrame(data)
print("Original DataFrame")
display(df)
 
print("Value of row 3 (Alex)")
display(df.iloc[3])


Output

Original DataFrame
Name Maths Science English
0 Simon 8 7 7
1 Marsh 5 9 4
2 Gaurav 6 5 7
3 Alex 9 4 6
4 Selena 7 7 8
Value of row 3 (Alex)
Name Alex
Maths 9
Science 4
English 6
Name: 3, dtype: object

Whether you're preparing for your first job interview or aiming to upskill in this ever-evolving tech landscape, GeeksforGeeks Courses are your key to success. We provide top-quality content at affordable prices, all geared towards accelerating your growth in a time-bound manner. Join the millions we've already empowered, and we're here to do the same for you. Don't miss out - check it out now!

Last Updated : 30 Nov, 2023
Like Article
Save Article
Previous
Next
Similar Reads
Complete Tutorials