Here is my datatable!
[table1]
| RCP_NM | MN_CT | RCP_DTLS | |
|---|---|---|---|
| 0 | soup | soup recipe | salt 10g, sweet potato 20g |
| 1 | egg soup | vegetables recipe | onion 10g |
| 1 | egg soup | egg recipe | egg 10g, salt 5g |
| 2 | fried chicken | seasoning recipe | salt 10g, sugar 20g |
| 2 | fried chicken | chicken recipe | 1 chicken |
| 2 | fried chicken | etc ingredient recipe | 1 dish, parsley 10g |
| 3 | great dishes | etc | etc |
| .. | .. | .. | .. |
and I want to make this table below
I want to separate based on ,(comma) in RCP_DTLS
I marked bold that separated rows.
[table2]
| RCP_NM | MN_CT | RCP_DTLS | |
|---|---|---|---|
| 0 | soup | soup recipe | salt 10g |
| 0 | soup | soup recipe | sweet potato 20g |
| 1 | egg soup | vegetables recipe | onion 10g |
| 1 | egg soup | egg recipe | egg 10g |
| 1 | egg soup | egg recipe | salt 5g |
| 2 | fried chicken | seasoning recipe | salt 10g |
| 2 | fried chicken | seasoning recipe | sugar 20g |
| 2 | fried chicken | chicken recipe | 1 chicken |
| 2 | fried chicken | etc ingredient recipe | 1 dish |
| 2 | fried chicken | etc ingredient recipe | parsley 10g |
| 3 | great dishes | etc | etc |
| .. | .. | .. | .. |
I tried add another index table1 with groupby function
but after I divide RCP_DTLS row, my data is twisted.
