im new to python and want to understand how to work with dataframes
I have a dataframe-
desc13month
Out[45]:
OutputValues CntOutputValues
0 12-99-Annual (AE) 217
1 21-581-Ineligible Services(IPS) 210
2 125-99-Annual (AE),126-22-Jermaine (JE) 196
3 22-99-Annual (AE) 181
4 21-50-Prime (PE) 169
I want the OutputValues column to be unconcatenated. If you notice, the last string for example "Annual" depends on the second string 99. if its is 22 it changes to Jermaine.Sometimes there could be multiple like we see for row 2. My final output should indicate these columns and an additional column which has that last string
illustration-
desc13month
Out[45]:
OutputValues CntOutputValues final
0 12-99-Annual (AE) 217 Annual (AE)
1 21-581-Ineligible Services(IPS) 210 Ineligible Services(IPS)
2 125-99-Annual (AE),126-22-Jermaine (JE) 196 Annual (AE),Jermaine (JE)
3 22-99-Annual (AE) 181 Annual (AE)
4 21-50-Prime (PE) 169 Prime (PE)