Hi Python gurus,
I am doing a repetitive task which I believe can be done in a super easy way with some basic python code. Unfortunately, with my very limited programming knowledge, I am unable to put a code to do this. I was wondering if someone could help me in writing the code.
Here is the problem →
I have data nicely divided into different columns in excel.
Now I need to label this data, something like this →
So basically I need a code where I define path to my excel sheet
Then read data row by row for columns B,C,D,E and continue pasting in this format
{‘id’: ‘0’,
‘ner_tags’: [0, 1, 2, 3],
‘tokens’: [‘B1’, ‘C1’, ‘D1’, ‘E1’]
}
{‘id’: ‘0’,
‘ner_tags’: [0, 1, 2, 3],
‘tokens’: [‘B2’, ‘C2’, ‘D2’, ‘E2’]
}
… and so on !!!
Is someone able to help me ?
I hope I don’t get banned from forum for asking someone to code without trying it out myself, I have not much programming skills 
Hope to hear back … Cheers!!!