Generate sum of a particular column date wise Post: 302886219

Sponsored Content

Top Forums Shell Programming and Scripting Generate sum of a particular column date wise Post 302886219 by villain41 on Thursday 30th of January 2014 06:19:41 AM

01-30-2014

Registered User

Thanks a lot for ur response. I tried below stuff

Code:

Hostname:~ 905>cat two.txt
01/22/2014,23:43:00,1742.8,
01/22/2014,23:43:00,1742.8,
01/22/2014,23:44:00,1749.06666666667,
01/25/2014,23:45:00,2046.45,
01/25/2014,23:43:00,1742.8,
01/25/2014,23:44:00,1749.06666666667,
01/25/2014,23:45:00,2046.45,
01/25/2014,23:43:00,1742.8,
01/25/2014,23:44:00,1749.06666666667,
01/29/2014,23:45:00,2046.45,
01/29/2014,23:43:00,1742.8,
01/29/2014,23:44:00,1749.06666666667,
01/29/2014,23:45:00,2046.45,
Hostname:~ 906>
Hostname:~ 907> awk -F"," 'NR==FNR{a[$1]+=$3;next} a[$1] {print $1" "a[$1]}' two.txt | uniq
Hostname:~ 908>

I am not getting any error but getting blank prompt comes up..
am I doing anything wrong here..plz help me

---------- Post updated at 03:12 AM ---------- Previous update was at 03:06 AM ----------

Its working..
I used the file names 2 times now.
I initially thought the file name is duplicated mistakenly in ur command.
Now I tried ur command, its 100% working, thanks a lot again forur help.

---------- Post updated at 03:19 AM ---------- Previous update was at 03:12 AM ----------

Hi,
The code is working awesome..
instead of exponential sum can I get the real integer number, plz

01/23/2014 5.04681e+06
01/24/2014 4.9229e+06
01/25/2014 4.26656e+06
01/26/2014 4.94703e+06
01/27/2014 6.0064e+06
01/28/2014 5.4583e+06
01/29/2014 5.22587e+06
01/30/2014 3931

Last edited by villain41; 01-30-2014 at 07:18 AM.. Reason: Please use code tags

villain41

View Public Profile for villain41

Find all posts by villain41

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

processing matrix column wise

I have a m X n matrix written out to file, say like this: 1,2,3,4,5,6 2,6,3,10,34,67 1,45,6,7,8,8 I want to calculate the column averages in the MINIMUM amount of code or processing possible. I would have liked to use my favorite tool, "AWK" but since it processes rowwise, getting the...

2. Shell Programming and Scripting

o/p column wise by nawk

hi i have file which hav following entries 1501,AAA,2.00 1525,AAA,2.00 1501,AAA,2.00 1525,AAA,2.00 1501,AAA,3.00 1525,AAA,3.00 1525,AAA,3.00 1501,AAA,3.00 1501,AAA,3.00 i want to have a o/p coloum wise like 1501,AAA,13 1525,AAA,10 here 13 comes as a sum of last colum value...

3. Shell Programming and Scripting

Column wise file parsing.

Shell script for the below operation : File "A" contains : SEQ++1' MOA+9:000,00:ABC' RFF+AIK:000000007' FII+PH+0170++AA' NAD+PL+++XXXXXXXXXXX XXXXXXX XX++XXX XXXX XXXX X.X. XXXXXXXXX+++NL' SEQ++2' MOA+9:389,47:ABC' RFF+AIK:02110300000008' FII+PH+0PSTBNL2A:25:5+BB'...

4. Solaris

column wise substitution in a file

Hi, I have two files. Want to make an addition of the fifth column of from both the files and redirect it to a third file. Both files have same records except fifth field and same record should be inserted into new file having fifth field as addition of fifth fields of both files. for...

5. Solaris

delete files by date wise

Hi guys, I want to delete files from june 13 to june 30, using rm command can any one tell me the sintax to remove. I ahve hunderd of core files in my /var dir. so i want to clear last month core files. Thanks in Advance.:))

6. Shell Programming and Scripting

Sum of column by group wise

Hello All , I have a problem with summing of column by group Input File - COL_1,COL_2,COL_3,COL_4,COL_5,COL_6,COL_7,COL_8,COL_9,COL_10,COL_11 3010,21,1923D ,6,0,0.26,0,0.26,-0.26,1,200807 3010,21,192BI ,6,24558.97,1943.94,0,1943.94,22615.03,1,200807 3010,21,192BI...

7. Shell Programming and Scripting

Column wise text adding

Hi I have pasted sample data as below:- in data.txt Please suggest any way out: as the 3rd field is cat data.txt 22:37:34 STARTING abc 22:37:40 FAILURE sadn 00:06:42 STARTING asd 00:06:51 FAILURE ad 02:06:38 STARTING acs 02:06:46 FAILURE cz 04:06:35 STARTING xzc...

8. Shell Programming and Scripting

Date wise calculations?

POST_DATE CHECK_NUMBER TYPE LOGIN_NAME 2015.09.09 XXXXXXXXXX mark XXXXXXXXXX 2015.09.09 XXXXXXXXXX fsadf XXXXXXXXXX 2015.10.05 XXXXXXXXXX defaa XXXXXXXXXX 2015.10.05 XXXXXXXXXX dewe XXXXXXXXXX 2015.10.06 XXXXXXXXXX dqwe XXXXXXXXXX 2015.09.14 XXXXXXXXXX dt4e XXXXXXXXXX...

9. Shell Programming and Scripting

Proper Column wise matching

My below code works fine if none of the columns has pipe as its content in it, If it has the pipe in any of the content then the value moves to the next column. I wanted my code to work fine even if the column has pipe in it apart from the delimiter. NOTE : If there is a pipe in the content...

10. UNIX for Beginners Questions & Answers

Sum the values in the column using date column

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...

LEARN ABOUT DEBIAN

red

ED(1)                                                              User Commands                                                             ED(1)

NAME

       Ed - line-oriented text editor

SYNOPSIS

       ed [options] [file]

DESCRIPTION

       GNU Ed - The GNU line editor.

OPTIONS

       -h, --help
              display this help and exit

       -V, --version
              output version information and exit

       -G, --traditional
              run in compatibility mode

       -l, --loose-exit-status
              exit with 0 status even if a command fails

       -p, --prompt=STRING
              use STRING as an interactive prompt

       -r, --restricted
              run in restricted mode

       -s, --quiet, --silent
              suppress diagnostics

       -v, --verbose
              be verbose

       Start edit by reading in 'file' if given.  If 'file' begins with a '!', read output of shell command.

       Exit status: 0 for a normal exit, 1 for environmental problems (file not found, invalid flags, I/O errors, etc), 2 to indicate a corrupt or
       invalid input file, 3 for an internal consistency error (eg, bug) which caused ed to panic.

REPORTING BUGS

       Report bugs to bug-ed@gnu.org
       Ed home page: http://www.gnu.org/software/ed/ed.html
       General help using GNU software: http://www.gnu.org/gethelp

COPYRIGHT

       Copyright (C) 1994 Andrew L. Moore.
       Copyright (C) 2014 Free Software Foundation, Inc.  License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
       This is free software: you are free to change and redistribute it.  There is NO WARRANTY, to the extent permitted by law.

SEE ALSO

       The full documentation for Ed is maintained as a Texinfo manual.  If the info and Ed programs are properly installed at your site, the com-
       mand

              info Ed

       should give you access to the complete manual.

Ed 1.10                                                            January 2014                                                              ED(1)