Open In App

How to Get Cell Value from Pandas DataFrame?

Improve
Improve
Like Article
Like
Save
Share
Report

In this article, we will discuss how to get the cell value from the Pandas Dataframe in Python

Method 1 : Get a value from a cell of a Dataframe using loc() function

Pandas DataFrame.loc attribute access a group of rows and columns by label(s) or a boolean array in the given DataFrame. Here, we will use loc() function to get cell value.

Python3




# import pandas module
import pandas as pd
 
# create dataframe with 3 columns
data = pd.DataFrame({
    "id": [7058, 7059, 7072, 7054],
    "name": ['sravan', 'jyothika', 'harsha', 'ramya'],
    "subjects": ['java', 'python', 'html/php', 'php/js']})
 
# get the cell value using loc() function
# in name column and 1 row
print(data['id'].loc[data.index[0]])
 
# get the cell value using loc() function
# in name column and 2 row
print(data['name'].loc[data.index[1]])
 
# get the cell value using loc() function
# in subjects column and 4 row
print(data['subjects'].loc[data.index[3]])


Output:

7058
jyothika
php/js

Method 2: Get a value from a cell of a Dataframe using iloc[]

Dataframe.iloc[] method is used when the index label of a data frame is something other than numeric series of 0, 1, 2, 3….n or in case the user doesn’t know the index label. Here we will use index number to access index value.

Python3




# import pandas module
import pandas as pd
 
# get the cell value using iloc() function
# in id column and 1 row
print(data['id'].iloc[0])
 
# get the cell value using iloc() function
# in name column and 1 row
print(data['name'].iloc[0])
 
# get the cell value using iloc() function
# in subjects column and 1 row
print(data['subjects'].iloc[0])


Output:

7058
sravan
java

Method 3: Get a value from a cell of a Dataframe using values() function

values() is an inbuilt method in Python programming language that returns a view object. The view object contains the values of the dictionary, as a list.

Python3




# import pandas module
import pandas as pd
 
# get the cell value using values() function
# in id column and 1 row
print(data['name'].values[0])
 
# get the cell value using values() function
# in id column and 2 row
print(data['id'].values[1])
 
# get the cell value using values() function
# in subjects column and 4 row
print(data['subjects'].values[3])


Output:

sravan
7059
php/js

Method 4: Get a value from a cell of a Dataframe using at[] function

To return data in a dataframe at the passed position, use the Pandas at[] function. [position, Column Name] is the format of the passed location. This method functions similarly to Pandas loc[], except at[] returns a single value and so executes more quickly.

Python3




# import pandas module
import pandas as pd
 
# get the cell value using at() function
# in id column and 2 row
print(data.at[1, 'id'])
 
# get the cell value using at() function
# in id column and 4 row
print(data.at[3, 'name'])
 
# get the cell value using at() function
# in subjects column and 1 row
print(data.at[0, 'subjects'])


Output:

7059
ramya
java

Method 5: Get a value from a cell of a Dataframe using iat[] function

This function takes a row and column indexes to display cell values in the Dataframe. This is also work same as at[].

Python3




# import pandas module
import pandas as pd
 
# create dataframe with 3 columns
data = pd.DataFrame({
    "id": [7058, 7059, 7072, 7054],
    "name": ['sravan', 'jyothika', 'harsha', 'ramya'],
    "subjects": ['java', 'python', 'html/php', 'php/js']
}
)
 
# get the cell value using iat() function
# in id column and 1 row
print(data.iat[0, 0])
 
# get the cell value using iat() function
# in name column and 1 row
print(data.iat[0, 1])
 
# get the cell value using iat() function
# in id column and 2 row
print(data.iat[1, 0])


Output:

7058
sravan
7059


Last Updated : 05 Aug, 2022
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads