|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Clustering data by matching columns
Post 302609937 by geetu on Tuesday 20th of March 2012 03:36:17 PM
03-20-2012
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hey,
I have two files that have exactly the same format. They are both tab-delimited and contain 12 columns. However the # of rows vary. What I want to do is match columns # 5,6 and 7 between the two files. If they do match exactly (based on numbers) then I want the whole row from file 2 to... (1 Reply)
Discussion started by: phil_heath
1 Replies
2. UNIX for Dummies Questions & Answers
Hello everyone!
I have a huge dataset looking like this:
nameX nameX 0 1 2 2 2 2 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 ...............
nameY nameY 2 2 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 .....
nameB nameB 0 1 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 .....
(can be several thousands of codes)
and I need... (8 Replies)
Discussion started by: kush
8 Replies
3. UNIX for Dummies Questions & Answers
Hi to all,
I have two separated files:
FILE1
"V1" "V2" "V3"
Mary James Nicole
Robert Francisco Sophie
Nancy Antony Matt
Josephine Louise Rose
Mark Simon
Charles
FILE2
"V1" "V2" "V3"... (2 Replies)
Discussion started by: eleonoral
2 Replies
4. UNIX for Dummies Questions & Answers
Hello experts,
I have this problem, I need to match values based on two files, this is what I have:
file1
1.1
1.2
1.3
5.5
1.4
1.5
1.6
file2
1 a
2 B
3 C
4 D
5 z (7 Replies)
Discussion started by: Gery
7 Replies
5. Shell Programming and Scripting
Hi,
I have the following files.
cat 1.txt
cat 2.txt
output.txt
The logic is as follows.... (10 Replies)
Discussion started by: jacobs.smith
10 Replies
6. Shell Programming and Scripting
Hello,
I have two files as following:
#bin chrom chromStart chromEnd name score strand observed
585 chr2 29442 29443 rs4637157 0 + C/T
585 chr2 33011 33012 rs13423995 0 + A/G
585 chr2 34502 34503 rs13386087 0 + ... (2 Replies)
Discussion started by: Homa
2 Replies
7. Shell Programming and Scripting
Hi,
I need to join two files together with one common value in a column. I think I can use awk or join or a combination but I can't quite get it.
Basically my data looks like this, with the TICKER columns matching up in each file
File1
TICKER,column 1, column, 2, column, 3, column 4
... (6 Replies)
Discussion started by: unkleruckus
6 Replies
8. Shell Programming and Scripting
Hello All,
I want to make a file which will have primarily lines of file2 but when first 2 fields matches with the file1 it should have those lines of file1..
example is as below..
file1
a;b;1
c;d
f;e
t;r;5
file2
b;g
a;b
c;d
v;b
f;e
t;r (2 Replies)
Discussion started by: ailnilanjan
2 Replies
9. Shell Programming and Scripting
I am using awk to match columns and output based on those matches. For some reason it is not printing matching columns, am I missing something?
Operating system - windows with cygwin.
Command that I am using:
sed 's/]*,]*/,/g' $tempdir/file1 > $tempdir/file1.$$ && awk -F, 'FNR==NR{f2=$2... (7 Replies)
Discussion started by: dis0wned
7 Replies
10. UNIX for Beginners Questions & Answers
Hi,
i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file
I have tried with join and awk and i keep getting blank outputs or same file
is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies
LEARN ABOUT CENTOS
amstatus
AMSTATUS(8) System Administration Commands AMSTATUS(8) NAME
amstatus - display the state of an Amanda run SYNOPSIS
amstatus [--file amdumpfile] [--summary] [--dumping] [--waitdumping] [--waittaper] [--dumpingtape] [--writingtape] [--finished] [--failed] [--estimate] [--gestimate] [--stats] [--locale-independent-date-format] [--config] config DESCRIPTION
Amstatus gives the current state of the Amanda run specified by the config configuration. If there is no active Amanda running, it summarizes the result of the last run. It may also be used to summarize the results of a previous run. See the amanda(8) man page for more details about Amanda. OPTIONS
All options may be abbreviated to the shortest non-ambiguous sub-string. If no options are given, everything is displayed. [--config] config Specify the Amanda configuration you want to display the state for. --file amdumpfile Specify an alternate file instead of the amdump or amflush file. --summary Display a summary of the state of the run. --dumping Display all partitions that are dumping. --waitdumping|wdumping Display all partitions that are waiting to be dumped. --waittaper|wtaper Display all partitions dumped that are waiting to be written to tape. --dumpingtape|dtape Display all partitions that are dumping directly to tape. --writingtape|wtape Display all partitions that are writing to tape. --finished Display all partitions that are dumped and written to tape. --failed|error Display all partitions that failed. --estimate Display all partitions whose estimate is finished. Works only during the estimate phase. --gestimate|gettingestimate Display all partitions whose estimate is not finished. Works only during the estimate phase. --stats|statistics Display statistics about active-time of taper and dumpers. --locale-independent-date-format Output the date in a locale independent format. The format is the same executing: date +'%Y-%m-%d %H:%M:%S %Z' EXIT CODE
The exit code of amstatus is the ORed value of: 0 = success 1 = error 4 = a dle failed 8 = Don't know the status of a dle (RESULT_MISSING in the report) 16 = tape error or no more tape SEE ALSO
amanda(8), amcheck(8), amdump(8), amrestore(8), amadmin(8) The Amanda Wiki: : http://wiki.zmanda.com/ AUTHOR
Stefan G. Weichinger <sgw@amanda.org> Amanda 3.3.3 01/10/2013 AMSTATUS(8)