Pandas: Get the specified row value of a given DataFrame

Last update on April 03 2025 13:11:20 (UTC/GMT +8 hours)

47. Get Row Value

Write a Pandas program to get the specified row value of a given DataFrame.

Sample Solution :

Python Code :

import pandas as pd
d = {'col1': [1, 2, 3, 4, 7], 'col2': [4, 5, 6, 9, 5], 'col3': [7, 8, 12, 1, 11]}
df = pd.DataFrame(data=d)
print("Original DataFrame")
print(df)
print("Value of Row1")
print(df.iloc[0])
print("Value of Row4")
print(df.iloc[3])

Sample Output:

Original DataFrame
   col1  col2  col3
0     1     4     7
1     2     5     8
2     3     6    12
3     4     9     1
4     7     5    11
Value of Row1
col1    1
col2    4
col3    7
Name: 0, dtype: int64
Value of Row4
col1    4
col2    9
col3    1
Name: 3, dtype: int64

Explanation:

The above code first creates a Pandas DataFrame df using a dictionary ‘d’ with three columns 'col1', 'col2', and 'col3', and five rows of data.

df.iloc[0]: This line selects the first row of the DataFrame df using the .iloc indexer, which selects rows by their integer position. Since the first row has an integer position of 0, this will select the first row of the DataFrame.

df.iloc[3] : This line selects the fourth row of the DataFrame df using the .iloc indexer, which selects rows by their integer position. Since the fourth row has an integer position of 3, this will select the fourth row of the DataFrame.

For more Practice: Solve these Related Problems:

Write a Pandas program to extract a specific row by its index and then convert that row to a dictionary.
Write a Pandas program to get a row value using loc based on its label and then display only selected columns.
Write a Pandas program to retrieve a row by its integer index using iloc and then print each column value on a new line.
Write a Pandas program to extract a row based on a condition in one of its columns and then output the row as a Series.

Python-Pandas Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to check whether a given column is present in a DataFrame or not.
Next: Write a Pandas program to get the datatypes of columns of a DataFrame.