Apr-06-2021, 06:14 AM
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]](https://i.stack.imgur.com/6GQir.png)
Output file
https://i.stack.imgur.com/OKeRD.png
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
Output file
https://i.stack.imgur.com/OKeRD.png