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 627 Jun-29-2021, 06:58 AM
Last Post: tester_V
  Count elements in a list only if they are following each other and are similar law 10 2,361 Aug-02-2019, 10:54 PM
Last Post: law
  spliting similar but multiple lines anna 7 1,994 Apr-20-2019, 08:53 AM
Last Post: anna
  Python: if 'X' in 'Y' but with two similar strings as 'X' DreamingInsanity 6 2,042 Feb-01-2019, 01:28 PM
Last Post: buran
  Similar to Poker bluekade5050 1 1,300 Nov-14-2018, 04:46 PM
Last Post: j.crater
  finding similar objects in a list DRPR 4 2,886 Jun-22-2018, 10:05 AM
Last Post: volcano63

Forum Jump:

User Panel Messages

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