python list apply lamda 1

[kingz2000]

Hi guys,

I have a list with this command: categories.loc[0,:]

which reads

0 related-1
1 request-0
2 offer-0
3 aid_related-0

Now I would like to append a Dataframe "categories" with these contents, except I don't want the last two symbols.

So the categories dataframe should have columns "related", "request", "offer" and "aid related" as new columns.

I tried this:

row = categories.loc[0,:]

for line in row:
categories=categories.apply[lambda x: line.str.split('-')[0])

which does not work.
Can anyone help?

Kingz

 

[mikrom]

if you have lambda of x, then you have to use x inside of it, i.e. x.split("-")[0] (and not line.str.split('-')[0])

see example:

>>> categories = pd.Series(["related-1", "request-0", "offer-0", "aid_related-0"])
>>> categories.loc[0:]
0        related-1
1        request-0
2          offer-0
3    aid_related-0
dtype: object
>>> categories = categories.apply(lambda x: x.split("-")[0])
>>> categories.loc[0:]
0        related
1        request
2          offer
3    aid_related
dtype: object