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 302978685 by ncwxpanther on Tuesday 2nd of August 2016 02:21:51 PM
Old 08-02-2016
control.file
Code:
2016 06

Sample base file 201606.pnt. I also tried using files that had values only of xx.xx in the 3rd field. This sample has both xx.xx and xxx.xx in the 3rd filed....if that matters.
Code:
 
 24.5625  -81.8125    39.16
 24.5625  -81.7708    40.81
 24.5625  -81.7292    46.73
 24.5625  -81.6875    52.67
 24.6042  -81.6458    62.22
 24.6458  -81.5625    66.18
 24.6458  -81.4792    68.19
 24.6875  -81.5625    67.32
 24.6875  -81.3958    71.72
 24.7292  -81.3958    73.26
 24.7708  -80.9375    90.29
 25.1458  -81.1042   116.34
 25.1458  -81.0625   117.04
 25.1458  -81.0208   119.01
 25.1458  -80.9792   118.53
 25.1458  -80.9375   118.07
 25.1458  -80.7708   142.98
 25.1458  -80.7292   149.23
 25.1458  -80.4375   171.91
 25.1458  -80.3958   172.67
 25.1875  -81.1042   122.42
 25.1875  -81.0625   125.46
 25.1875  -81.0208   125.53
 25.1875  -80.9792   125.67
 25.1875  -80.9375   127.46
 25.1875  -80.8958   130.94

Sample base file 201506.pnt
Code:
 
 24.5625  -81.8125    74.28
 24.5625  -81.7708    72.68
 24.5625  -81.7292    66.90
 24.5625  -81.6875    61.92
 24.6042  -81.6458    57.16
 24.6458  -81.5625    60.11
 24.6458  -81.4792    62.80
 24.6875  -81.5625    62.20
 24.6875  -81.3958    68.01
 24.7292  -81.3958    69.86
 24.7708  -80.9375    85.71
 25.1458  -81.1042   159.11
 25.1458  -81.0625   161.78
 25.1458  -81.0208   162.54
 25.1458  -80.9792   163.41
 25.1458  -80.9375   169.29
 25.1458  -80.7708   150.50
 25.1458  -80.7292   145.82
 25.1458  -80.4375   122.51
 25.1458  -80.3958   120.30
 25.1875  -81.1042   168.44
 25.1875  -81.0625   170.80
 25.1875  -81.0208   173.15
 25.1875  -80.9792   176.74
 25.1875  -80.9375   176.95
 25.1875  -80.8958   176.87

 

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 10:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy