Python Forum
Calculate the value which has the similar name in the header using - XLSWRITER using
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Calculate the value which has the similar name in the header using - XLSWRITER using
#1
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
Reply
#2
Please show what you have tried so far, and where you are having difficulty.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Sum similar items tester_V 3 1,898 Jun-29-2021, 06:58 AM
Last Post: tester_V
  Python: if 'X' in 'Y' but with two similar strings as 'X' DreamingInsanity 6 3,802 Feb-01-2019, 01:28 PM
Last Post: buran
  Similar to Poker bluekade5050 1 27,822 Nov-14-2018, 04:46 PM
Last Post: j.crater

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020