Join two files combining multiple columns and produce mix and match output
I would like to join two files when two columns in each file matches with each other and then produce an output when taking multiple columns.
Like I have file A
and file B
and I want the output when column 2 and 3 of file A matches with Column 1 and 4 of file B; then produce output like below
Hello,
My apologies if this has been posted elsewhere, I have had a look at several threads but I am still confused how to use these functions. I have two files, each with 5 columns:
File A: (tab-delimited)
PDB CHAIN Start End Fragment
1avq A 171 176 awyfan
1avq A 172 177 wyfany
1c7k A 2 7... (3 Replies)
I'm trying to combine colums from multiple file to a single file but having some issues, appreciate your help.
The filenames are the same except for the extension,
path1.m0
---------
a b c
d e f
g h i
path1.m1
---------
m n o
p q r
s t u
File names are path1.m
The... (3 Replies)
Hello,
I have two files which are of the following format
File 1 which has two columns
Protein_ID Substitution
NP_997239 T53R
NP_060668 V267M
NP_058515 P856A
NP_001206 T55M
NP_006601 D371Y ... (2 Replies)
I have the following format of input from multiple files
File 1
24.01 -81.01 1.0
24.02 -81.02 5.0
24.03 -81.03 0.0
File 2
24.01 -81.01 2.0
24.02 -81.02 -5.0
24.03 -81.03 10.0
I need to scan through the files and when the first 2 columns match I... (18 Replies)
Hello Unix gurus,
I have a large number of files (say X) each containing two columns of data and the same number of rows.
I would like to combine these files to create a unique merged file containing X columns corresponding to the second column of each file (with a bonus of having the first... (3 Replies)
Join and merge multiple files with duplicate key and fill void columns
Hi guys,
I have many files that I want to merge:
file1.csv:
1|abc
1|def
2|ghi
2|jkl
3|mno
3|pqr
file2.csv: (5 Replies)
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 DEBIAN
nifti_stats
NIFTI_STATS(1) User Commands NIFTI_STATS(1)NAME
nifti_stats - compute NIfTI statistical functions
SYNOPSIS
nifti_stats [-q|-d|-1|-z] value CODE [p1 p2 p3]
DESCRIPTION
nifti_stats supports several distributions (normal, uniform, logistic, chi, etc.) and calculates density or cummulative distribution func-
tion (and many more). Values are printed to stdout and can be piped to other tools.
value can be a single number or in the form bot:top:step.
default ==> output p = Prob(statistic < val).
-q ==> output is 1-p.
-d ==> output is density.
-1 ==> output is x such that Prob(statistic < x) = val.
-z ==> output is z such that Normal cdf(z) = p(val).
-h ==> output is z such that 1/2-Normal cdf(z) = p(val).
Allowable CODEs:
CORREL, TTEST, FTEST, ZSCORE, CHISQ, BETA, BINOM, GAMMA, POISSON, NORMAL, FTEST_NONC, CHISQ_NONC, LOGISTIC, LAPLACE, UNIFORM, TTEST_NONC,
WEIBULL, CHI, INVGAUSS, EXTVAL, PVAL, LOGPVAL and LOG10PVAL
Following CODE are distributional parameters, as needed.
Results are written to stdout, 1 number per output line.
EXAMPLE
Piping output into AFNI program 1dplot:
nifti_stats -d 0:4:.001 INVGAUSS 1 3 | 1dplot -dx 0.001 -stdin
SEE ALSO libnifti(1), nifti_tool(1), nifti1_test(1).
Homepage: http://niftilib.sourceforge.net
AUTHOR
RW Cox - SSCC/NIMH/NIH/DHHS/USA/EARTH - March 2004
This manual page was written by Michael Hanke <michael.hanke@gmail.com>, for the Debian project (but may be used by others).
nifti_stats September 2007 NIFTI_STATS(1)