Sum the values of column matching and not matching from a txt file and write output to a two different files using Python

+1 vote
Name                                                    value

DR_CNDAOFSZAPZP_GPFS_VOL.0 139264

DR_CNDAOFSZAPZP_GPFS_VOL.1 15657

DR_CNDAOFSZAPZP_GPFS_VOL.0 139264

DR_CNDAOFSZAPZP_GPFS_VOL.1 156579

DR_CNDAOFSZAPZP_GPFS_VOL.2 156579

DR_CNDAOFSZAPZP_GPFS_VOL.3 156579

DR_CNDAOFSZAPZP_GPFS_VOL.5 172236

Output1

     Name                                                  \Value

DR_CNDAOFSZAPZP_GPFS_VOL.0 278528

DR_CNDAOFSZAPZP_GPFS_VOL.1 172236

Output2 with out matching names

DR_CNDAOFSZAPZP_GPFS_VOL.2 156579

DR_CNDAOFSZAPZP_GPFS_VOL.3 156579

DR_CNDAOFSZAPZP_GPFS_VOL.5 172236
Nov 20, 2019 in Python by Sagar
 • 130 points • 1,185 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Python

–1 vote
2 answers

In Python, How do I read 2 CSV files, compare column 1 from both, and then write to a new file where the Column 1s match?

Hi @Mike. First, read both the csv ...READ MORE

answered Jul 24, 2019 in Python by Omkar
 • 69,220 points • 33,464 views
+1 vote
1 answer

I am trying to write a program in python for the occurrences of a character given the start and stop values of that string only using while

Here's the code: check = input("Enter the character: ...READ MORE

answered Nov 15, 2019 in Python by Rishi
 • 1,930 views
0 votes
1 answer

How to write a program that counts number of characters, number of words, number of repeated words and number of repeated characters in a text file using opps concept in python

Here's the logic. You have to add ...READ MORE

answered Oct 28, 2019 in Python by Omkar
 • 69,220 points • 1,986 views
0 votes
1 answer

How to list a column of float values from csv file without importing (Python)

Using the default CSV module Demo: import csv with open(filename, "r") ...READ MORE

answered Sep 16, 2020 in Python by Rajiv
 • 8,870 points • 8,937 views
0 votes
1 answer

How to find the value of a row in a csv file in python and print column and row of that value ?

Hello @Khanhh , Use panda to find the value of ...READ MORE

answered Oct 15, 2020 in Python by Niroj
 • 82,840 points • 6,767 views
0 votes
1 answer

How to use read a WSDL file from the file system using Python suds?

Hi, good question. It is a very simple ...READ MORE

answered Jan 21, 2019 in Python by Nymeria
 • 3,560 points • 8,310 views
0 votes
1 answer

how do i change string to a list?

suppose you have a string with a ...READ MORE

answered May 21, 2019 in Python by Mohammad
 • 3,230 points • 3,111 views
0 votes
2 answers

how can i randomly select items from a list?

You can also use the random library's ...READ MORE

answered Apr 9, 2020 in Python by Patrick
 • 5,298 views
+1 vote
2 answers

how can i count the items in a list?

Syntax :            list. count(value) Code: colors = ['red', 'green', ...READ MORE

answered Jul 7, 2019 in Python by Neha
 • 330 points
edited Jul 8, 2019 by Kalgi • 4,434 views
0 votes
1 answer

how do i use the enumerate function inside a list?

Enumerate() method adds a counter to an ...READ MORE

answered Nov 16, 2021 in Python by Ruhan Siddiqui
 • 3,243 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.