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

0 votes
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.
Jun 25, 2020 in Python by Karan
• 19,580 points

2 answers to this question.

0 votes
I think you can read your excel file, convert it to a dataframe and filter data according to your requirement.
answered Jun 25, 2020 by Karan
• 19,580 points
0 votes

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
answered Jun 25, 2020 by Shivam Dutt Sharma

Related Questions In Python

0 votes
1 answer

Python program to read the excel file which contains more than 65K records

Hi @Rashmi! I read your code and there ...READ MORE

answered Feb 8, 2019 in Python by Omkar
• 69,090 points
0 votes
1 answer
0 votes
1 answer
+3 votes
5 answers

How to read multiple data files in python

Firstly we will import pandas to read ...READ MORE

answered Apr 6, 2018 in Python by DeepCoder786
• 1,720 points
0 votes
2 answers
+1 vote
2 answers

how can i count the items in a list?

Syntax :            list. count(value) Code: colors = ['red', 'green', ...READ MORE

answered Jul 6, 2019 in Python by Neha
• 330 points

edited Jul 8, 2019 by Kalgi 1,842 views
0 votes
0 answers
+4 votes
6 answers

Lowercase in Python

You can simply the built-in function in ...READ MORE

answered Apr 11, 2018 in Python by hemant
• 5,810 points