excel automation python script

for example there are column A,B and C are there
column A contains car parts problem (Description(like Ac not working, oil leakage, etc..))
by taking reference of column A it has to fill the Column B & C.
for reference sending the file
please filter it and look it