Thanks very much for your help with this. I must be missing something fundamental when running your script. Whether I simplify it and run line by line or by making it an executable and run just as you posted, I get the following error:
Attached is the simple 3column.csv for testing (note, I had to append ".txt" in order to upload). Does it run ok for you?
Thanks in advance.
***disregard the error message. I believe this was on my end and not related to shamrock's script***
Hi guys
I have an input file with multiple columns and and rows.
Is it possible to calculate correlation of certain value of certain No (For example x of S1 = 112) with all other values (for example start with x 112 corr a 3 of S1 = x-a 0.2 )
INPUT
*******
No S1 S2 S3 S4 Sn
a 3 ... (2 Replies)
Hi everyone,
i am new to perl programming, i have a problem in extracting single column from csv file. the column is the 20th column,
please help me..
at present i use this code
#!C:/perl/bin
use warnings;
use strict;
my $file1 = $ARGV;
open FILE1, "<$file1"
or die "Can't... (13 Replies)
Howdy,
I need to convert an association data matrix, currently in a two-column format, into a matrix with numbers indicating the number of associations. I've been looking around for AWK code in the list, but could not find anything. Here's an example of what I want to perform:
original... (10 Replies)
Hi everyone
I am very new at awk but think that that might be the best strategy for this. I have a matrix very similar to a correlation matrix and in practical terms I need to convert it into a list containing the values from the matrix (one value per line) with the first field of the line (row... (5 Replies)
Hello,
am I new to awk, and I am tryint to:
INPUT FILE:
"73423555","73423556","73423557","73423558","73423559"
OUTPUT FILE:
73423555
73423556
73423557
73423558
73423559
My useless code so far:
#!/bin/awk -F ','
BEGIN
{
i=0;
} (8 Replies)
hi, someone to know how can i read a specific column of csv file and search the value in other csv columns if exist the value in the second csv copy entire row with all field in a new csv file. i suppose that its possible using awk but i m not expertise thanks in advance (8 Replies)
Hi
I want to grep a column 6 & column 7 from a CSV Format file & then i have to find the difference between these columns as these both columns contains date & time in 7/7/2012 9:20 this format . So kindly help me out ASAP.
But please kindly dis xls has to be converted in csv format as may... (5 Replies)
Dear all,
I'm new in perl scripting and I'm trying to creating a matrix from a 3 column file sorting data in a particular manner. In the final matrix I need to have the first column "IDs" on the header of the columns and the second column values on the header of each row. And the value fo the... (2 Replies)
Hi, Is it possible to transpose the matrix like this using awk ? Many thanks in advance
Input
abc Name_1 0
abc Name_2 1
abc Name_3 2
abc Name_4 0.4
def Name_1 0
def Name_2 9
def Name_3 78
def Name_4 1
Output
abc def
Name_1 0 ... (4 Replies)
Example:
I have files in below format
file 1:
zxc,133,joe@example.com
cst,222,xyz@example1.com
File 2 Contains:
hxd
hcd
jws
zxc
cst
File 1 has 50000 lines and file 2 has around 30000 lines :
Expected Output has to be :
hxd
hcd
jws (5 Replies)
Discussion started by: TestPractice
5 Replies
LEARN ABOUT DEBIAN
mcxmap
mcxmap(1) USER COMMANDS mcxmap(1)
NAME
mcxmap - permute or remap the indices of graphs and matrices.
SYNOPSIS
mcxmap -imx fname (input) [-o fname (output)] [-make-map (output map file name)] [-make-mapc (output map file name)] [-make-mapr (output map
file name)] [-cmul a (coefficient)] [-cshift b (translate)] [-rmul c (coefficient)] [-rshift d (translate)] [-mul e (coefficient)] [-shift f
(translate)] [-map fname (row/col map file)] [-rmap fname (row map file)] [-cmap fname (column map file)] [-mapi fname (row/col map file
(use inverse))] [-rmapi fname (row map file (use inverse))] [-cmapi fname (column map file (use inverse))] [-tab fname (read (and map) tab
file)]
DESCRIPTION
This utility relabels graphs or matrices. Its main use is in applying a map file to a given matrix or graph. A map file contains a so called
map matrix in mcl format that has some special properties (given further below). The functionality of mcxmap can also be provided by mcx, as
a mapped matrix (i.e. the result of applying a map matrix to another matrix) is simply the usual matrix product of a matrix and a map
matrix. However, mcx will construct a new matrix and leave the original matrix to be mapped alone. When dealing with huge matrices, consid-
erable gains in efficiency memory-wise and time-wise can be achieved by doing the mapping in-place. This is what mcxmap does. In the
future, its functionality may be embedded in mcx with new mcx operators.
The special properties of a map matrix are
o The column domain and row domain are of the same cardinality.
o Each column has exactly one entry.
o Each row domain index occurs in exactly one column.
These properties imply that the matrix can be used as a map from the column domain onto the row domain. An example map matrix is found in
the EXAMPLES Section.
OPTIONS
-o fname (output file)
Output file.
-imx fname (input file)
Input file.
-map fname (row/col map file))
-rmap fname (row map file)
-cmap fname (column map file)
-mapi fname (row/col map file (use inverse))
-rmapi fname (row map fil (use inverse))
-cmapi fname (column map fil (use inverse))
Different ways to specify map files.
-make-map (output map file name)
-make-mapc (output map file name)
-make-mapr (output map file name)
Generate a map that maps the specified domain onto the appropriate canonical domain and write the map matrix to file.
-cmul a (coefficient)
-cshift b (translate)
These options have affect if neither a column map file nor column canonification is specified. If any of the first two options is used,
column indices i are mapped to a*i+b.
-rmul c (coefficient)
-rshift d (translate)
These options have affect if neither a row map file nor row canonification is specified. If any of the first two options is used,
indices i are mapped to c*i+d.
-mul e (coefficient)
-shift f (translate)
If a map file is specified for a given domain, neither a map file nor canonification is specified. If any of the first two options is
used, the indices i will be mapped to e*i+f.
-tab fname (read (and map) tab file)
This option requires the -map option. mcxmap will output the mapped tab definition.
EXAMPLES
The matrix below has two canonical domains which are identical. It denotes a map of the canonical domain onto itself, in which node 0 is
relabeled to 8, node 1 is relabeled to 5, et cetera.
(mclheader
mcltype matrix
dimensions 12x12
)
(mclmatrix
begin
0 8 $
1 5 $
2 3 $
3 2 $
4 4 $
5 6 $
6 7 $
7 9 $
8 1 $
9 10 $
10 11 $
11 0 $
)
AUTHOR
Stijn van Dongen.
SEE ALSO
mcxio(5), mcx(1), mcxsubs(1), and mclfamily(7) for an overview of all the documentation and the utilities in the mcl family.
mcxmap 12-068 8 Mar 2012 mcxmap(1)