Home » Python » Python Programs

How to get a single value as a string from pandas dataframe?

Given a pandas dataframe, we have to get a single value as a string from pandas dataframe. By Pranit Sharma Last updated : October 06, 2023

Pandas is a special tool that allows us to perform complex manipulations of data effectively and efficiently. Inside pandas, we mostly deal with a dataset in the form of DataFrame. DataFrames are 2-dimensional data structures in pandas. DataFrames consist of rows, columns, and data.

Problem statement

Given a pandas dataframe, we have to get a single value as a string from pandas dataframe.

Getting a single value as a string from pandas dataframe

We are given the Pandas dataframe with columns of string type. Since pandas are a heavy computational tool, we can even query a single value from a dataframe of type object but this value also contains the index or other information which we need to remove or we need to find a way in which we can get this single value as a string without the additional information for example index name column name or dtype information.

For example,

Python program to get a single value as a string from pandas dataframe

# Importing pandas package
import pandas as pd

# Importing numpy package
import numpy as np

# Creating a dictionary
d = {'a':['Funny','Boring'],'b':['Good','Bad']}

# Creating a DataFrame
df = pd.DataFrame(d)

# Display Original df
print("Original DataFrame:\n",df,"\n")

# Get the single value
res = df[df['a'] == 'Funny']['a']

# Display result
print("Result:\n",res,"\n")

Output:

We can see that the above output contains some additional information apart from the string 'Funny'.

To remove this additional information, we just need one additional step we need to use the item() method along with the condition we are applying.

Let us understand with the help of an example,

# Importing pandas package
import pandas as pd

# Importing numpy package
import numpy as np

# Creating a dictionary
d = {'a':['Funny','Boring'],'b':['Good','Bad']}

# Creating a DataFrame
df = pd.DataFrame(d)

# Display Original df
print("Original DataFrame:\n",df,"\n")

# Get the single value
res = df[df['a'] == 'Funny']['a'].item()

# Display result
print("Result:\n",res,"\n")

Output:

Python Pandas Programs »