Python 3.x - Extract string from data frame [duplicate]

Question

Assume a dataframe df -

df = pd.DataFrame(['a'])

I want to extract the string 'a' from this dataframe. I tried to extract it by trying the following from stackoverflow answers - Attempt 1 -

print(df.iloc[0])
>>0    a
Name: 0, dtype: object

Attempt 2 -

print(df.astype(str))
>>  0
0  a

Please help me extract the string 'a' from the dataframe

Anton Protopopov · Accepted Answer · 2016-05-04 11:39:36Z

1

With iloc you getting the first series from dataframe. If you want first element of that series you should use it twice or with iloc[0][0]:

In [57]: df.iloc[0][0]
Out[57]: 'a'

In [58]: df.iloc[0].iloc[0]
Out[58]: 'a'

answered May 4, 2016 at 11:39

Anton Protopopov

31.9k13 gold badges93 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1