Need some help writing a basic code

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 :stuck_out_tongue:

Hope to hear back … Cheers!!!