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
import pandas as pd
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
import pandas as pd
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