convert pandas dataframe value to scalar

Question

How do I convert a pandas data frame with 1 row, 1 column into a scalar value?

import pandas as pd
data = {'col1': 1}
df = pd.DataFrame(data=d)

You're initialising the dataframe incorrectly. Did you mean; `df = pd.DataFrame({'col1': [1]})`? — cs95, Dec 20 '17 at 16:19

score 5 · Answer 1 · answered Dec 20 '17 at 17:26

You can use iat to access scalar elements specifying the location by integer (i.e. 0,0 for the top left element, as opposed to at which would take the row and columns labels rather than integer index).

So if you only have one element in your dataframe, df.iat[0,0] will get it for you.

In [139]: import pandas as pd
In [140]: df = pd.DataFrame(data=[1], columns=['col1'])
In [141]: df.iat[0,0]
Out[141]: 1
In [143]: df
Out[143]: 
   col1
0     1

score 2 · Answer 2 · answered Jun 30 '20 at 13:44

2

You can use squeeze.

import pandas as pd
df = pd.DataFrame(data=[1], columns=['col1'])
df.squeeze()

answered Jun 30 '20 at 13:44

deallen7

21
1

convert pandas dataframe value to scalar

2 Answers2