Get first element of Pandas Series of string

Question

I think I have a relatively simply question but am not able to locate an appropriate answer to solve the coding problem.

I have a pandas column of string: df1['tweet'].head(1) 0 besides food, Name: tweet

I need to extract the text and push it into a Python str object, of this format:

test_messages = ["line1", "line2", "etc"]

The goal is to classify a test set of tweets and therefore believe the input to: X_test = tfidf.transform(test_messages) is a str object.

Andy Hayden · Accepted Answer · 2013-06-15 16:39:40Z

3

Use list convert a Series (column) into a python list:

list(df1["tweet"])

answered Jun 15, 2013 at 16:39

Andy Hayden

378k110 gold badges640 silver badges546 bronze badges

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

Comments

smci · Accepted Answer · 2018-09-03 21:24:17Z

1

Get the Series head(), then access the first value:

df1['tweet'].head(1).item()
or: Use the Series tolist() method, then slice the 0'th element:

df.height.tolist() [94, 170] df.height.tolist()[0] 94

(Note that Python indexing is 0-based, but head() is 1-based)

answered Sep 3, 2018 at 5:50

smci

34.2k21 gold badges118 silver badges152 bronze badges

Subham Shit · Accepted Answer · 2023-02-04 13:10:03Z

1

Option 1 : df1['tweet'][0] or df1.loc[0, 'tweet']
Option 2 : df1['tweet'].to_list()[0]

answered Feb 4, 2023 at 13:10

Subham Shit

312 bronze badges