Split a string with , and split a string even no , present in a dataframe column

Question

I have a dataframe column and i need to split a column with "," and even if no "," present in the value.

Value
=====
59.5

59.5, 5

60

60,5

desired output

value1  value2

======  ======

59.5

59.5      5

60        

60        5

Tried the code but getting an below error:

df['value1'], df_merge['value2'] = df['value'].str.split(',', 1).str

ValueError: not enough values to unpack (expected 2, got 1)

Does this answer your question? [Pandas split column into multiple columns by comma](https://stackoverflow.com/questions/37600711/pandas-split-column-into-multiple-columns-by-comma) — Henry Ecker, Apr 07 '21 at 19:50

score 0 · Answer 1 · answered Apr 07 '21 at 19:53

0

You could search for "," first and only do the split if str contains ",".

answered Apr 07 '21 at 19:53

cwittah

329
1
2
15

Can you write it in the code format pls for my above dataframe column ? – Karthik chengalvarayan Apr 07 '21 at 20:08

Thatcher Thornberry · Answer 2 · 2021-04-07T20:38:08.207

0

Use the string method str.partition. It returns a 3 tuple every time with what's on the left of your chosen partition (you would choose a comma) and whats to the right of it.

df['value1'], _, df_merge['value2'] = str(df['value']).partition(',')

edited Apr 07 '21 at 20:38

answered Apr 07 '21 at 19:55

Thatcher Thornberry

452
1
11

Can you write it in the code format pls ? – Karthik chengalvarayan Apr 07 '21 at 20:20
Tried the above code, but the got the below error: ValueError: too many values to unpack (expected 2) – Karthik chengalvarayan Apr 07 '21 at 20:49
Did you included the underscore? – Thatcher Thornberry Apr 07 '21 at 22:57

Split a string with , and split a string even no , present in a dataframe column

2 Answers2