Match sum of values in each column with the corresponding column value present in trailer record
Hi All,
I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record.
For example, let's assume for column D excluding Header and Trailer in the csv find the sum of all data records in column D and check whether that sum is equal to value present in column D in the trailer record. This same process needs to be done for all the columns from D through O.
For this I have developed one shell script which does the same (I know you experts can do it in better way instead of creating so many temp files. But as I am very new to shell scripting I have just applied my thought in my way).
This shell is behaving differently for each file, For file pf_20150127.csv it is working perfectly because the temp files which I am comparing are giving the same results, PFA the snapshot of values match (Sum_Match.jpb) in temp files.
If I execute the same script for file pf_20150325.csv, The counts does not match. The trailer record value in the original file now is being displayed with 2 decimal places and my sum output does not have decimal values. I don't understand whether it's a file problem or unix has some internal mechanism which reads files and displays values in different manner. PFA the temp file outputs of this file (Sum_mismatch.jpg).
I believe it's not a file problem, Now where is the problem in my script. How can I read and compare the sum with that of the value in the trailer record irrespective of original tariler record have decimals or whole numbers.
I have attached the actual test csv files which I have mentioned and temp files output of both files. Please help me out as I am in real help and I could not think of any other way of doing it. Please suggest if I have to change my design entirely to achieve my requirement, If yes please provide me the solution.
Hi All,
I have a file which is having 3 columns as (string string integer)
a b 1
x y 2
p k 5
y y 4
.....
.....
Question:
I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
I have a file in the following layout:
201008005946873001846130058030701006131840000000000000000000
201008006784994001154259058033001009527844000000000000000000
201008007323067002418095058034801002418095000000000000000000
201008007697126001722141058029101002214158000000000000000000... (2 Replies)
Hi,
My input files is like this
axis1 0 1 10
axis2 0 1 5
axis1 1 2 -4
axis2 2 3 -3
axis1 3 4 5
axis2 3 4 -1
axis1 4 5 -6
axis2 4 5 1
Now, these are my following tasks
1. Print a first column for every two rows that has the same value followed by a string.
2. Match on the... (3 Replies)
Hi,
I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column)
The input is for example, after sorted:
K00001 1 1 4 3... (8 Replies)
Hi,
i have log like below:
A 2 5
B 4 1
C 6 8
B 0 1
C 1 0
B 2 3
A 0 0
i want to make result if match with A then sum from column 2 and 3
so the results:
A 2 5 (5 Replies)
this is part of a KT i am going thru.
i am writing a script in bash shell, linux where i have 2 columns where 1st signifies the nth hour like 00, 01, 02...23 and 2nd the file size.
sample data attached.
Desired output is 3 columns which will give the nth hour, number of entries in nth hour and... (3 Replies)
I have a file which need to be summed up using date column.
I/P:
2017/01/01 a 10
2017/01/01 b 20
2017/01/01 c 40
2017/01/01 a 60
2017/01/01 b 50
2017/01/01 c 40
2017/01/01 a 20
2017/01/01 b 30
2017/01/01 c 40
2017/02/01 a 10
2017/02/01 b 20
2017/02/01 c 30
2017/02/01 a 10... (6 Replies)