Splitting string inside pandas dataframe

Question

I have this column in my dataframe which has numbers in a string like "6,22,67,82" for example. I want to split this strings into arrays of integers and keep the arrays in the dataframe.

  h['htgt']=h['htgt'].split()

This does not work because it tries to split the whole series.

jpp · Accepted Answer · 2018-09-07 12:58:36Z

1

You can use pd.Series.str.split with expand=True and then convert to int. Assumes you have an equal number of numbers in each string.

h = pd.DataFrame({'htgt': ['6,22,67,82', '12,45,65,14', '54,15,9,94']})

res = h['htgt'].str.split(',', expand=True).astype(int)

print(res)

    0   1   2   3
0   6  22  67  82
1  12  45  65  14
2  54  15   9  94

answered Sep 7, 2018 at 12:58

jpp

166k37 gold badges301 silver badges363 bronze badges

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

1 Comment

Borut Flis Over a year ago

Thank you for the answer. The strings do not contain the same amount of numbers, so I am using expand is False, to keep array as entries in the column.

Collectives™ on Stack Overflow

Splitting string inside pandas dataframe

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related