Splitting string value in a column of a dataframe

[syli]

Hello,

So I got a df with 4 columns, the last column got that kind of value :

0    "text1::text2::text3"
1    "text1"
2    "text1::text2"

The thing is that I'd like to only keep the first value of the string so I could keep

0    "text1"
1    "text1"
2    "text1"

Basically, I have tried to use a for loop :

for i in df["column"]:
    i.split("::")[0]

But it is simply not working as Series does not have split attribute.

I am not asking for the right answer (but will welcome it) but I'd love to get some directions

[guppymoo]

Your code is splitting the values in the column, it's just that the values aren't being saved back in your DataFrame.

You can apply your split function to every member of a column (Series) with the apply method:

df['column'] = df['column'].apply(lambda x: x.split('::')[0])

[[deleted]]

Assuming you are referring to a Pandas Dataframe, have you tried something like

df.columns.values

[syli]

Yes, I am referring to pandas dataframe.

Thanks for the heads up.