Python Forum
Calculate the value which has the similar name in the header using - XLSWRITER using - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Calculate the value which has the similar name in the header using - XLSWRITER using (/thread-33201.html)



Calculate the value which has the similar name in the header using - XLSWRITER using - rsd - Apr-06-2021

Hi All,
I need to calculate the value which has the similar name in the header. Here i have Bill and Non Bill fields in the column. I need to calculate all the Bill separately and non-bill separately and need to sum in another column Bill Amt Total and Non Bill Amt Total using xlswrriter in python.

Input file
[Image: 6GQir.png]

Output file
https://i.stack.imgur.com/OKeRD.png


RE: Calculate the value which has the similar name in the header using - XLSWRITER using - Larz60+ - Apr-06-2021

Please show what you have tried so far, and where you are having difficulty.