I have a .txt file as per below content with 4 fields as Name, Age, Salary and Date of Salary received Vijay,35,6000,29-12-2023 Manoj,32,12000,29-7-2023 Vinoth,31,11000,29-12-2023 Vijay,32,10000,29-10-2023 Vijay,32,7000,29-12-2023 Manoj,30,10000,29-11-2023 Vinoth,32,10000,29-10-2023 Vijay,32,10000,29-4-2023 Mano,32,1000,29-12-2023 Vijay,32,3000,29-8-2023 I wish to write a python program to sum up the Salary when the Name and Age matches with subsequent rows. Will you able to do the code ? Certainly! You can achieve this by reading the contents of the file, parsing each line to extract the relevant information (Name, Age, Salary), and then using a dictionary to store the sum of salaries for each unique combination of Name and Age. Here's a Python program that accomplishes this: def read_file(file_path): data = [] with open(file_path, 'r') as file: for line in file: line = line.strip() if line: name, age, salary, _ = l...
Comments
Post a Comment