Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Merging two files with condition
Top Forums Shell Programming and Scripting Merging two files with condition Post 302542301 by digipak on Wednesday 27th of July 2011 07:14:34 AM
Old 07-27-2011
Merging two files with condition
I have two files of the type

111 222 10
112 223 20
113 224 30
114 225 20


and

111 222 9
444 555 8
113 224 32
666 777 25

I want to merge files based on 1 and 2nd column. if 1st and 2nd column are unique in file 1 and 2 keep them, if they 1st and 2nd column are comman in two files then average the values in 3rd column so I need the final result as;

111 222 9.5 <--- 1st and 2nd column in both are same so 3rd is avg.
112 223 20 <--- Unique to file1
113 224 31 <----- 1st and second column are same so 3rd is avg.
114 225 20 <--- Unique to file 1
444 555 8 <----- unique to file 2
666 777 25 <---- unique to file 2

Please help me with awk or any other script.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Merging two files

Hi I have a requirement like this. I have two files This is how data1.txt looks: EI3171280 38640658501 NENN2005-12-129999-12-312005-12-12HALL NANCY 344 CHENEY HIGHWAY ... (4 Replies)
Discussion started by: venommaker
4 Replies

2. Shell Programming and Scripting

merging files

Thanks in advance I have 2 files having key field in each.I would like to join both on common key.I have used join but not sucessful. The files are attached here . what i Want in the output is on the key field SLS OFFR . I have used join commd but not successful. File one ======= SNO ... (6 Replies)
Discussion started by: vakharia Mahesh
6 Replies

3. Shell Programming and Scripting

Help with merging files

i would like to merge two files that have the same format but have different data. i would like to create one output file that contains information from both the original files.:rolleyes: (2 Replies)
Discussion started by: joe black
2 Replies

4. Shell Programming and Scripting

merging of files.

Hi, I want to merge the two files on the basis of columns like... file 1 Data Key A 12 B 13 file2 Data Value A A1 A A2 B B1 B B2 (5 Replies)
Discussion started by: clx
5 Replies

5. Shell Programming and Scripting

Merging of all files based on a condition

Hi Friends, I am new to UNIX. I need to merge all the files(to FINAL.txt) in single directory based one condition. Out of all the files one of file will have specific value like :GF01: at any where in the file. so the file which is having :GF01: should be appended at the last. EX:... (5 Replies)
Discussion started by: arund_01
5 Replies

6. Shell Programming and Scripting

Merging two files with same name

Hello all, I have limited experience in shell scripting. Here goes my question: I have two directories that have same number of files with same file names i.e. consider 2 directories A and B. Both directories have files 1.txt, 2.txt...... I need to merge the file 1.txt of A with file 1.txt... (5 Replies)
Discussion started by: jaysean
5 Replies

7. Shell Programming and Scripting

merging two files

file1.txt 1 2 10 11 56 57 7 8 43 44 and let's suppose that there is a file called file2.txt with 100 columns I want to produce a file3.txt with columns specified in file1.txt in that order (1,2,10,11,56,57,7,8,43,44) Thanks! (2 Replies)
Discussion started by: johnkim0806
2 Replies

8. Shell Programming and Scripting

Merging two files

Guys, I am having little problem with getting a daily report! The daily process that I do is as follows 1. Unload Header for the report from the systables to one unl file, say Header.unl 2. Unload the data from the required table/tables to another unl file, say Data.unl 3. Send a... (2 Replies)
Discussion started by: PikK45
2 Replies

9. UNIX for Dummies Questions & Answers

Merging two files baased on condition

Hi All, I have two below files(fileds separated by space). File1 001078401 A 5A1 001078401 B 085 001030035 A 5A1 001030035 B 085 File2 001078401 C 001 001078401 D 065 001030035 C 001 001030035 D 065... (6 Replies)
Discussion started by: satyar
6 Replies

10. Shell Programming and Scripting

Merging two files

Hi All , I have a scenario where we need to combine two files . Below are the sample files and expected output , File 1: 1|ab 1|ac 1|ae 2|ad 2|ac File 2: 1|xy 1|fc 2|gh 2|ku Output file : 1|ab|xy (3 Replies)
Discussion started by: saj
3 Replies

LEARN ABOUT DEBIAN

ngraph

NGRAPH(1)						      General Commands Manual							 NGRAPH(1)

NAME

       Ngraph - creating scientific 2-dimensional graphs

SYNOPSIS

       ngraph [options] [data file(s) or ngp file]

DESCRIPTION

       Ngraph  is  the program to create scientific 2-dimensional graphs for researchers and engineers. Graphs can be exported to PostScript, SVG,
       PNG or PDF format.

OPTIONS

       Command line options are:

       -L file
	      load ngp file

       -x column
	      data column for the x axis

       -y column
	      data column for the y axis

       -X     use X axis as the x axis

       -Y     use Y axis as the y axis

       -U     use U axis as the x axis

       -R     use R axis as the y axis

       -d {mark | line | polygon | curve | diagonal | arrow | rectangle | rectangle_fill | rectangle_solid_fill | errorbar_x | errorbar_y | stair-
       case_x | staircase_y | bar_x | bar_y | bar_fill_x | bar_fill_y | bar_solid_fill_x | bar_solid_fill_y | fit}
	      specify plot type

       -m type
	      specify mark type (0-89)

       -o size
	      specify mark size

       -l style
	      specify line style

       -w width
	      specify line width

       -CR n  specify red component of the 1st plot color (0-255)

       -CG n  specify green component of the 1st plot color (0-255)

       -CB n  specify blue component of the 1st plot color (0-255)

       -cr n  specify red component of the 2nd plot color (0-255)

       -cg n  specify green component of the 2nd plot color (0-255)

       -cb n  specify blue component of the 2nd plot color (0-255)

       -s line
	      specify number of the head skip

       -r step
	      specify number of the read step

       -f line
	      specify number of the final line

       -vx n  neighbor average of the x data

       -vy n  neighbor average of the y data

       -mx formula
	      specify math transformation for the x data

       -my formula
	      specify math transformation for the y data

       -ex {linear | log | inverse | MJD}
	      specify scale type of the x axis

       -ey {linear | log | inverse | MJD}
	      specify scale type of the y axis

       -minx value
	      specify minimum value of x axis

       -maxx value
	      specify maximum value of x axis

       -incx value
	      specify increment value of x axis

       -miny value
	      specify minimum value of y axis

       -maxy value
	      specify maximum value of y axis

       -incy value
	      specify increment value of y axis

       -g     load settings from data file

       -png file
	      convert ngp file to PNG format

       -pdf file
	      convert ngp file to PDF format

       -ps file
	      convert ngp file to PostScript format

       -eps file
	      convert ngp file to Encapsulated PostScript format

       -svg file
	      convert ngp file to SVG format

       -gra file
	      convert ngp file to GRA format

       -dialog
	      show print dialog (with -p option)

       -p file
	      print ngp file

       -n     output ngp-file to stdout

       -h, --help
	      show help message

       -v, --version
	      show version of Ngraph

       -V, --VERSION
	      show detail information about Ngraph

FILES

       ${HOME}/.Ngraph/Ngraph.nsc
	      start up script

       ${HOME}/.Ngraph/Ngraph.ini
	      configuration file

       ${HOME}/.Ngraph/Ngraph.ngp
	      default graph

AUTHORS

       Satoshi ISHIZAKA

       Hiroyuki Ito <ZXB01226@nifty.com>

SEE ALSO

       ngp2(1)

COPYRIGHT

       Copyright (C) 2003 Satoshi ISHIZAKA

       Copyright (C) 2008-2011 Hiroyuki Ito

4th Berkeley Distribution					       Local								 NGRAPH(1)
All times are GMT -4. The time now is 02:53 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy