w3resource

Pandas: Get the specified row value of a given DataFrame

Pandas: DataFrame Exercise-47 with Solution

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.

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.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.