Using Python3 Want Put Output Either 1 0 Depending Source Image New Sheet Excel File Know Q37104745

Using python3,

I want to put the output as either 1 or 0 depending on theSource (from image below) to a new sheet on an excel file but i donot know how ;-;

To be more clear,

In No.1 in image, the Source is “A” and I want to label this as”0″.

But in No.2, the source is “B” so I want to label this as”1″

How would I be able to write a program that can do thisconversion for all elements to a new sheet but same file in excel?(I have a bigger data set of over 500 entries so doing thisconversion of 1

OR

 

OR