10 More Discussions You Might Find Interesting
1. Programming
Hi All,
I would like get the minimum value in the certain column with respect to other column.
For example, I have a text file like this.
ATOM 1 QSS SPH S 0 -2.790 -1.180 -2.282 2.28 2.28
ATOM 1 QSS SPH S 1 -2.915 -1.024 -2.032 2.31 2.31
ATOM 1 ... (4 Replies)
Discussion started by: bala06
4 Replies
2. Shell Programming and Scripting
Hello everyone,
I am using ksh on Solaris 10 and I'm gathering data in a CSV file that looks like this:
20170628-23:25:01,1,0,0,1,1,1,1,55,55,1
20170628-23:30:01,1,0,0,1,1,1,1,56,56,1
20170628-23:35:00,1,0,0,1,1,2,1,57,57,2
20170628-23:40:00,1,0,0,1,1,1,1,58,58,2... (6 Replies)
Discussion started by: ejianu
6 Replies
3. Shell Programming and Scripting
Hello,
I want to get the maximum value of each record separated by empty line based on the 3rd column of each row within each record?
Input:
A1 chr5D 634 7 82 707
A2 chr5D 637 6 82 713
A3 chr5D 637 5 82 713
A4 chr5D 626 1 82 704... (4 Replies)
Discussion started by: yifangt
4 Replies
4. Shell Programming and Scripting
Hello,
I need to find out the minimum and maximum values based on specific column, and then print out the entire row with the max value.
Infile.txt:
scf6 290173 290416 . + X_047241 T_00113118-1
scf6 290491 290957 . + X_047241 T_00113118-2
scf6 290898 290957 . + X_047241 T_00113119-3
scf6... (2 Replies)
Discussion started by: yifangt
2 Replies
5. UNIX for Dummies Questions & Answers
Dear Unix Gurus,
I have a text file with multiple columns, for example, see sample.txt below
0 1 301
1 4 250
2 6 140
3 2 610
7 1 180I want to find the maximum in, say, column 3, normalise all the values to this maximum value (to 4 decimal places) and spit everything into a new... (2 Replies)
Discussion started by: tintin72
2 Replies
6. Shell Programming and Scripting
From the below table I want to print highest value and lowest value using awk script.
aaa 55 66 96 77
ggg 22 96 77 23
ddd 74 58 18 3
kkk 45 89 47 92
zzz 34 58 89 92
Thanks, Green
edit by bakunin: it sure is not news to you that you should use CODE-tags, no? And that we do not want such... (3 Replies)
Discussion started by: gwgreen1
3 Replies
7. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
I am trying to complete a script which will allow me to find:
a) reads a value from the keyboard. (ask the... (4 Replies)
Discussion started by: dstewie
4 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have a wide and long dataset which looks as follows:
0 3 4 2 3 0 2 2 ...
3 2 4 0 2 2 2 3 ...
0 3 4 2 0 4 4 4 ...
3 0 4 2 2 4 2 4 ...
....
I would like to obtain the minimum of each column (ignoring zero values) so the output would look like:
3 2 4 2 2 2 2 2
I have the... (3 Replies)
Discussion started by: kasan0
3 Replies
9. Shell Programming and Scripting
Hello,
I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2
SDF4 -0.211654
SDF4 0.978068
... (1 Reply)
Discussion started by: Diya123
1 Replies
10. Shell Programming and Scripting
Hi. How do I find an expression with awk in only one column, and if it fits, then print that whole column.
1 apple oranges
2 bannanas pears
3 cats dogs
4 hesaid shesaid
echo "which number:"
read NUMBER (user inputs number 2 for this example)
awk " /$NUMBER/ {field to search is field... (2 Replies)
Discussion started by: glev2005
2 Replies
funcone(1) SAORD Documentation funcone(1)
NAME
funcone - cone search of a binary table containing RA, Dec columns
SYNOPSIS
funcone <switches> <iname> <oname> <ra[hdr]> <dec[hdr]> <radius[dr'"]> [columns]
OPTIONS
-d deccol:[hdr] # Dec column name, units (def: DEC:d)
-j # join columns from list file
-J # join columns from list file, output all rows
-l listfile # read centers and radii from a list
-L listfile # read centers and radii from a list, output list rows
-n # don't use cone limits as a filter
-r racol:[hdr] # RA column name, units (def: RA:h)
-x # append RA_CEN, DEC_CEN, RAD_CEN, CONE_KEY cols
-X # append RA_CEN, DEC_CEN, RAD_CEN, CONE_KEY cols, output all rows
DESCRIPTION
Funcone performs a cone search on the RA and Dec columns of a FITS binary table. The distance from the center RA, Dec position to the RA,
Dec in each row in the table is calculated. Rows whose distance is less than the specified radius are output.
The first argument to the program specifies the FITS file, raw event file, or raw array file. If "stdin" is specified, data are read from
the standard input. Use Funtools Bracket Notation to specify FITS extensions, and filters. The second argument is the output FITS file.
If "stdout" is specified, the FITS binary table is written to the standard output.
The third and fourth required arguments are the RA and Dec center position. By default, RA is specified in hours while Dec is specified in
degrees. You can change the units of either of these by appending the character "d" (degrees), "h" (hours) or "r" (radians). Sexagesimal
notation is supported, with colons or spaces separating hms and dms. (When using spaces, please ensure that the entire string is quoted.)
The fifth required argument is the radius of the cone search. By default, the radius value is given in degrees. The units can be changed by
appending the character "d" (degrees), "r" (radians), "'" (arc minutes) or '"' (arc seconds).
By default, all columns of the input file are copied to the output file. Selected columns can be output using an optional sixth argument
in the form:
"column1 column1 ... columnN"
A seventh argument allows you to output selected columns from the list file when -j switch is used. Note that the RA and Dec columns used
in the cone calculation must not be de-selected.
Also by default, the RA and Dec column names are named "RA" and "Dec", and are given in units of hours and degrees respectively. You can
change both the name and the units using the -r [RA] and/or -d [Dec] switches. Once again, one of "h", "d", or "r" is appended to the
column name to specify units but in this case, there must be a colon ":" between the name and the unit specification.
If the -l [listfile] switch is used, then one or more of the center RA, center Dec, and radius can be taken from a list file (which can be
a FITS table or an ASCII column text file). In this case, the third (center RA), fourth (center Dec), and fifth (radius) command line argu-
ments can either be a column name in the list file (if that parameter varies) or else a numeric value (if that parameter is static). When a
column name is specified for the RA, Dec, or radius, you can append a colon followed by "h", "d", or "r" to specify units (also ' and " for
radius). The cone search algorithm is run once for each row in the list, taking RA, Dec, and radius values from the specified columns or
from static numeric values specified on the command line.
When using a list, all valid rows from each iteration are written to a single output file. Use the -x switch to help delineate which line
of the list file was used to produce the given output row(s). This switch causes the values for the center RA, Dec, radius, and row number
to be appended to the output file, in columns called RA_CEN, DEC_CEN, RAD_CEN and CONE_KEY, respectively. Alternatively, the -j (join)
switch will append all columns from the list row to the output row (essentially a join of the list row and input row), along with the
CONE_KEY row number. These two switches are mutually exclusive.
The -X and -J switches write out the same data as their lower case counterparts for each row satisfying a cone search. In addition, these
switches also write out rows from the event file that do not satisfy any cone search. In such cases, that CONE_KEY column will be given a
value of -1 and the center and list position information will be set to zero for the given row. Thus, all rows of the input event file are
guaranteed to be output, with rows satisfying at least one cone search having additional search information.
The -L switch acts similarly to the -l switch in that it takes centers from a list file. However, it also implicitly sets the -j switch,
so that output rows are the join of the input event row and the center position row. In addition, this switch also writes out all center
position rows for which no event satisfies the cone search criteria of that row. The CONE_KEY column will be given a value of -2 for cen-
ter rows that were not close to any data row and the event columns will be zeroed out for such rows. In this way, all centers rows are
guaranteed to be output at least once.
If any of "all row" switches (-X, -J, or -L) are specified, then a new column named JSTAT is added to the output table. The positive
values in this column indicate the center position row number (starting from 1) in the list file that this data row successful matched in a
cone search. A value of -1 means that the data row did not match any center position. A value of -2 means that the center position was
not matched by any data row.
Given a center position and radius, the cone search algorithm calculates limit parameters for a box enclosing the specified cone, and only
tests rows whose positions values lie within those limits. For small files, the overhead associated with this cone limit filtering can
cause the program to run more slowly than if all events were tested. You can turn off cone limit filtering using the -n switch to see if
this speeds up the processing (especially useful when processing a large list of positions).
For example, the default cone search uses columns "RA" and "Dec" in hours and degrees (respectively) and RA position in hours, Dec and
radius in degrees:
funone in.fits out.fits 23.45 34.56 0.01
To specify the RA position in degrees:
funcone in.fits out.fits 23.45d 34.56 0.01
To get RA and Dec from a list but use a static value for radius (and also write identifying info for each row in the list):
funcone -x -l list.txt in.fits out.fits MYRA MYDec 0.01
User specified columns in degrees, RA position in hours (sexagesimal notation), Dec position in degrees (sexagesimal notation) and radius
in arc minutes:
funcone -r myRa:d -d myDec in.fits out.fits 12:30:15.5 30:12 15'
SEE ALSO
See funtools(7) for a list of Funtools help pages
version 1.4.2 January 2, 2008 funcone(1)