How to split excel field data which contains the multiple delimiter values

Question

Hi Team,

Can any one help me regarding a query, How to split excel field data which contains the multiple delimiter values?

ex:column name Filed_data which contains values as A=1;B=2;C=3;D=4

I want to display based on field names as A with value 1 like that.

Answer 1

I think you can read your excel file, convert it to a dataframe and filter data according to your requirement.

Answer 2

Try the following:

new = data["Filed_data"].str.split(";", n = 1, expand = True)
 
# making separate columns from new data frame for A, B, #etc.
data["A"]= new[0]
data["B"]= new[1]
-
-
and so on