Splitting irregular string into multi columns and conditions


I am hoping for some help on some string extraction and splitting. I have this df with a column called condition and within it I have this character string as below. The string starts with a space and continues until the ";".

I want a a convenient way to split this string out into two fully seperate columns, one for date and price

Any help would be great!

> df
1   d += "\\n2021-05-30, 29.99";
2   d += "\\n2021-05-31, 12.99";
3   d += "\\n2021-06-01, 19.99";
4   d += "\\n2021-06-02, 16.48";

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.