Join 2nd column of multiple files Post: 302959029

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Writing out 2nd column into one file from multiple files

I have several files that are being generated every 20 minutes. Each file contains 2 columns. The 1st column is Text, 2nd column is Data. I would like to generate one single file from all these files as follows: One instance of 1st column Text, followed by 2nd column Data separated by...

2. UNIX for Dummies Questions & Answers

Join 2 files with multiple columns: awk/grep/join?

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. UNIX for Dummies Questions & Answers

Join 2 files using first column

Hi, I'm trying to compare the first column of two files (tab or whitespace delimited, either way's fine, I`ve got both) and print the lines that are identical for the first column of both files. Something like this: File1 AAA 26 49 7 27 36 33 46 75 73 69 AAAAA 4 10 4 7 10 18 21...

4. Shell Programming and Scripting

Join multiple files by column with awk

Hi all, I searched through the forum but i can't manage to find a solution. I need to join a set of files placed in a directory (~1600) by column, and obtain an output with first and second column common to each file, but following columns are taken from the file in the list (precisely the fourth...

5. Shell Programming and Scripting

Join multiple files based on 1 common column

I have n files (for ex:64 files) with one similar column. Is it possible to combine them all based on that column ? file1 ax100 20 30 40 ax200 22 33 44 file2 ax100 10 20 40 ax200 12 13 44 file2 ax100 0 0 4 ax200 2 3 4

6. Shell Programming and Scripting

comparing column of two different files and print the column from in order of 2nd file

Hi friends, My file is like: Second file is : I need to print the rows present in file one, but in order present in second file....I used while read gh;do awk ' $1=="' $gh'" {print >> FILENAME"output"} ' cat listoffirstfile done < secondfile but the output I am...

7. UNIX for Dummies Questions & Answers

How to use the the join command to join multiple files by a common column

Hi, I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt. Each file has 3 columns (2 other columns in addition to the first common column). I want to write a script to join the files by the first common column so that in the...

8. UNIX for Dummies Questions & Answers

Join files by second column

I have file input file1 1/1/2013 A 553.0763397 96 16582 1/1/2013 B 459.8333588 195 11992 1/2/2013 A 844.2973022 306 19555 1/2/2013 B 833.9300537 457 20165 1/3/2013 A 563.6917419 396 13879 1/3/2013 B 632.0749969 169 ...

9. Shell Programming and Scripting

Difference between 2 files, one with 1 column and 2nd file with multiple columns

Hi, I need to find the difference between 2 files in unix and write the result in the new file File1: A B File2: X 123 hajkd Y 345 adjfka A 123 djafjhd B 678 dsndjks Output file: X 123 hajkd Y 345 adjfka Thanks.

10. Shell Programming and Scripting

Join columns across multiple lines in a Text based on common column using BASH

LEARN ABOUT DEBIAN

svm-subset

svm-subset(1)							   User Manuals 						     svm-subset(1)

NAME

       svm-subset - a subset selection tool for LIBSVM

SYNOPSIS

       svm-subset [ -s method ] dataset number [ output1 ] [ output2 ]

DESCRIPTION

       Training  large data is time consuming. Sometimes one should work on a smaller subset first. The python script subset.py randomly selects a
       specified number of samples. For classification data, we provide a stratified selection to ensure the same class distribution in  the  sub-
       set.

OPTIONS

       -s method

       0      -- stratified selection (classification only) (default)

       1      -- random selection

       output1
	      The subset. If output1 is omitted, the subset will be printed on the screen.

       output2
	      The rest of data.

FILES

       See svm-train(1) for the format of dataset

EXAMPLES

	      svm-subset heart_scale 100 file1 file2

       From heart_scale 100 samples are randomly selected and stored in file1. All remaining instances are stored in file2.

BUGS

       Please report bugs to the Debian BTS.

AUTHOR

       Chih-Chung Chang, Chih-Jen Lin <cjlin@csie.ntu.edu.tw>, Chen-Tse Tsai <ctse.tsai@gmail.com> (packaging)

SEE ALSO

       svm-train(1), svm-predict(1)

Linux								     DEC 2009							     svm-subset(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Writing out 2nd column into one file from multiple files

Discussion started by: subhap

2. UNIX for Dummies Questions & Answers

Join 2 files with multiple columns: awk/grep/join?

Discussion started by: InfoSeeker

3. UNIX for Dummies Questions & Answers

Join 2 files using first column

Discussion started by: vanesa1230

4. Shell Programming and Scripting

Join multiple files by column with awk

Discussion started by: macsx82