Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Ranking data points from multiple files
Top Forums Shell Programming and Scripting Ranking data points from multiple files Post 302978688 by Don Cragun on Tuesday 2nd of August 2016 02:47:10 PM
Old 08-02-2016
And when I run the script I suggested with those three files, I get the output:
Code:
24.5625	-81.8125	39.16	1
24.5625	-81.8125	74.28	2
24.5625	-81.7708	40.81	1
24.5625	-81.7708	72.68	2
24.5625	-81.7292	46.73	1
24.5625	-81.7292	66.90	2
24.5625	-81.6875	52.67	1
24.5625	-81.6875	61.92	2
24.6042	-81.6458	57.16	1
24.6042	-81.6458	62.22	2
24.6458	-81.5625	60.11	1
24.6458	-81.5625	66.18	2
24.6458	-81.4792	62.80	1
24.6458	-81.4792	68.19	2
24.6875	-81.5625	62.20	1
24.6875	-81.5625	67.32	2
24.6875	-81.3958	68.01	1
24.6875	-81.3958	71.72	2
24.7292	-81.3958	69.86	1
24.7292	-81.3958	73.26	2
24.7708	-80.9375	85.71	1
24.7708	-80.9375	90.29	2
25.1458	-81.1042	116.34	1
25.1458	-81.1042	159.11	2
25.1458	-81.0625	117.04	1
25.1458	-81.0625	161.78	2
25.1458	-81.0208	119.01	1
25.1458	-81.0208	162.54	2
25.1458	-80.9792	118.53	1
25.1458	-80.9792	163.41	2
25.1458	-80.9375	118.07	1
25.1458	-80.9375	169.29	2
25.1458	-80.7708	142.98	1
25.1458	-80.7708	150.50	2
25.1458	-80.7292	145.82	1
25.1458	-80.7292	149.23	2
25.1458	-80.4375	122.51	1
25.1458	-80.4375	171.91	2
25.1458	-80.3958	120.30	1
25.1458	-80.3958	172.67	2
25.1875	-81.1042	122.42	1
25.1875	-81.1042	168.44	2
25.1875	-81.0625	125.46	1
25.1875	-81.0625	170.80	2
25.1875	-81.0208	125.53	1
25.1875	-81.0208	173.15	2
25.1875	-80.9792	125.67	1
25.1875	-80.9792	176.74	2
25.1875	-80.9375	127.46	1
25.1875	-80.9375	176.95	2
25.1875	-80.8958	130.94	1
25.1875	-80.8958	176.87	2

Which lines in this output have a point1, point2 pair that is not present in the file 201606.pnt?

If I add one more line to 201506.pnt containing:
Code:
1 2 3

which is a point1, point2 pair that is not present in 201606.pnt and rerun the script; I get exactly the same output showing that the line I added was ignored since that point pair is not present in 201606.pnt.

Please explain what the script I suggested is doing incorrectly with the new data you just showed us in post #42?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

to extarct data points

suppose u have a file which consist of many data points separated by asterisk Question is to extract third part in each line . 0.0002*0.003*-0.93939*0.0202*0.322*0.3332*0.2222*0.22020 0.003*0.3333*0.33322*-0.2220*0.3030*0.2222*0.3331*-0.3030 0.0393*0.3039*-0.03038*0.033*0.4033*0.30384*0.4048... (5 Replies)
Discussion started by: cdfd123
5 Replies

2. Shell Programming and Scripting

recoding data points using SED??

Hello all, I have a data file that needs some serious work...I have no idea how to implement the changes that are needed! The file is a genotypic file with >64,000 columns representing genetic markers, a header line, and >1100 rows that looks like this: ID 1 2 3 4 ... (7 Replies)
Discussion started by: doobedoo
7 Replies

3. Shell Programming and Scripting

Group search (multiple data points) in Linux

Hi All I have a data set like this tab delimited: weft fgr-1 345 -1 fgrythdgd weft fgr-3 456 -2 ghjdklflllff weft fgr-11 456 -3 ghtjuffl weft fgr-1 213 -2 ghtyjdkl weft fgr-34 567 -5 fghytkflf frgt fgr-36 567 -1 ghrjufjf frgt fgr-45 678 -2 ghjruir frgt fgr-34 546 -5 gjjjgkldlld frgt... (4 Replies)
Discussion started by: Lucky Ali
4 Replies

4. UNIX for Dummies Questions & Answers

How to get data only inside polygon created by points which is part of whole data from file?

hiii, Help me out..i have a huge set of data stored in a file.This file has has 2 columns which is latitude & longitude of a region. Now i have a program which asks for the number of points & based on this number it asks the user to enter that latitude & longitude values which are in the same... (7 Replies)
Discussion started by: reva
7 Replies

5. Programming

GNUPLOT- how to change the style of data points

Hi, I am trying to arrange my graphs with GNUPLOT. Although it looked like simple at the beginning, I could not figure out an answer for the following: I want to change the style of my data points (not the line, just exact data points) The terminal assigns first + and then x to them but what I... (0 Replies)
Discussion started by: natasha
0 Replies

6. UNIX for Dummies Questions & Answers

Using AWK: Extract data from multiple files and output to multiple new files

Hi, I'd like to process multiple files. For example: file1.txt file2.txt file3.txt Each file contains several lines of data. I want to extract a piece of data and output it to a new file. file1.txt ----> newfile1.txt file2.txt ----> newfile2.txt file3.txt ----> newfile3.txt Here is... (3 Replies)
Discussion started by: Liverpaul09
3 Replies

7. UNIX for Dummies Questions & Answers

Finding data value that contains x% of points

Hi, I need help on finding the value of my data that encompasses certain percentage of my total data points (n). Attached is an example of my data, n=30. What I want to do is for instance is find the minimum threshold that still encompasses 60% (n=18), 70% (n=21) and 80% (n=24). manually to... (4 Replies)
Discussion started by: ida1215
4 Replies

8. Shell Programming and Scripting

Grabbing data between 2 points in text file

I have a text file that shows the output of my solar inverters. I want to separate this into sections. overview , device 1 , device 2 , device 3. Each device has different number of lines. but they all have unique starting points. Overview starts with 6 #'s, Devices have 4#'s and their data starts... (6 Replies)
Discussion started by: Mikey
6 Replies

9. UNIX for Dummies Questions & Answers

Stack data from multiple files into one, with variable column files

Hello Gurus, Im new to scripting. Got struck with a file merge issue in Unix. Was looking for some direction and stumbled upon this site. I saw many great posts and replies but couldnt find a solution to my issue. Greatly appreciate any help.. I have three csv files -> Apex_10_Latest.csv,... (1 Reply)
Discussion started by: wamshi
1 Replies

10. Shell Programming and Scripting

In PErl script: need to read the data one file and generate multiple files based on the data

We have the data looks like below in a log file. I want to generat files based on the string between two hash(#) symbol like below Source: #ext1#test1.tale2 drop #ext1#test11.tale21 drop #ext1#test123.tale21 drop #ext2#test1.tale21 drop #ext2#test12.tale21 drop #ext3#test11.tale21 drop... (5 Replies)
Discussion started by: Sanjeev G
5 Replies
All times are GMT -4. The time now is 12:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy