12-24-2019
transposes function
I was using transposes the rows into columns, then data.frame creates a list of the columns to match the data match(data.frame(t(x)), data.frame(t(y)))
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hey guys,
I needed to add a route to my routing table and I got it to work but on reboot it gets removed. Anyone know what file I can add this route to so it stays on the machine after a reboot? (9 Replies)
Discussion started by: kingdbag
9 Replies
2. Shell Programming and Scripting
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies
3. Shell Programming and Scripting
Hi ,
I have two tables with same length t1 and t2, I want to cretae a new third table where i put the difference between the elements of t2 and t1,
t3= t1 - t2
t3= t1 - t2
I am new to scripts, any help please? thanks (7 Replies)
Discussion started by: Celine19
7 Replies
4. Shell Programming and Scripting
I am comparing two table structure in different databases,Put into 2 txt files , when comparing if column sequnce and data type is not matching ,it has to display that info else Table structure is ok.
wrote shell script ,its not working .I am getting "Table structure is not ok" even if both... (1 Reply)
Discussion started by: akil
1 Replies
5. UNIX for Dummies Questions & Answers
I have a host table that looks similar like this:
# IP Name Comment
10.10.10.1 Lab1-1 # Static for Lab1 subnet
10.10.10.2 Lab1-2 # Static for Lab1 subnet
10.10.10.3 Lab1-3 ... (2 Replies)
Discussion started by: mjl927
2 Replies
6. Shell Programming and Scripting
Hi, I have text file:
Name: xyz
Gender: M
Address: "120_B_C; ksilskdj; lsudlfw"
Zip: 20392
Name: KLM
Gender: F
Address: "65_D_F; wnmlsi;lsuod;,...."
Zip:90233I want to insert 2 new lines before the 'Address: ' line deriving value from this Address line value
The Address value in quotes... (1 Reply)
Discussion started by: ysrini
1 Replies
7. Shell Programming and Scripting
Hi,
Can anyone help me that, How to see the table fields in Oracle database through shell script(ksh).
I have tried with the following:
sqlplus -s $user/$passwd@$sid << SQL >> session.log
select * from Testtab.sql
I'm not able to see anything..
Thanks (4 Replies)
Discussion started by: zxcjggu708
4 Replies
8. Shell Programming and Scripting
Hello,
I have two files file 1 and file 2 each having result of a query on certain database tables and need to compare for Col1 in file1 with Col3 in file2, compare Col2 with Col4 and output the value of Col1 from File1 which is a) not present in Col3 of File2 b) value of Col2 is different from... (2 Replies)
Discussion started by: RasB15
2 Replies
9. Shell Programming and Scripting
Using the awk below I am able to combine all the matching dates in $1, but I can not seem to remove the non-matching from the file. Thank you :).
file
20161109104500.0+0000,x,5631
20161109104500.0+0000,y,2
20161109104500.0+0000,z,2
20161109104500.0+0000,a,4117... (3 Replies)
Discussion started by: cmccabe
3 Replies
LEARN ABOUT DEBIAN
dirfile2ascii
dirfile2ascii(1) GETDATA dirfile2ascii(1)
NAME
dirfile2ascii -- output dirfile database vectors as ASCII text
SYNOPSIS
dirfile2ascii [ OPTION ]... DIRFILE
[ [ -a | -A | -e | -E | -F | -g | -G | -o | -i | -u | -x | -X ] FIELD ]...
DESCRIPTION
Fetches data from a dirfile(5) database specified by DIRFILE and writes it as ASCII to standard output. Any number of vector FIELDs may be
specified. Each specified field is printed in a separate column.
Mandatory arguments to long options are mandatory for short options too.
-d, --delimeter=delim
separate columns by delim. (Default: a single space.)
-f, --first-frame=first_frame-last_frame
read from frame first_frame to frame last_frame (inclusive).
-f, --first-frame=first_frame:nframes
equivalent to --first-frame=first_frame --num-frames=nframes.
-f, --first-frame=first_frame
If first_frame >= 0, start reading at frame first_frame. If first_frame is -1 and --num-frames=nframes is specified, read the last
nframes frames. If --first-frame is not specified, reading starts at frame zero.
-n, --num-frames=nframes
read at most nframes frames. If not specified, or if nframes = 0, all frames to the end-of-field are read.
-p, --precision=format
use format to format output. format may contain any of the flag characters, a field width, and/or a precision as specified in
printf(3). It may not contain a length modifier.
-q, --quiet
don't write diagnostic messages on standard error. (This is the default behaviour).
-s, --skip=frame_skip
if frame_skip > 0, output only one sample for every frame_skip frames.
-v, --verbose
write diagnostic messages on standard error.
-z, --fill=STRING
Fill columns which go past the end of their corresponding field with the string STRING. The default behaviour is to fill columns
with floating-point conversions with NaN and columns with integer conversion with 0, which mirrors what occurs when an attempt is
made to print data from before the start of a field. (Note: the default behaviour cannot be reproduced with this option, since
STRING is applied to all columns, regardless of conversion type.)
In addition to the above, each FIELD argument may be preceded by a short option, one of: -a, -A, -e, -E, -F, -g, -G, -i, -o, -u, -x, -X,
indicating the conversion to be used. See printf(3) for the meaning of these conversion specifiers. The output flags, width, and preci-
sion may be specified by using --precision. If no conversion specifier is given, %f is used.
For conversion specifiers %a, %A, %e, %E, %f, %F, %g, %G, data is read from the dirfile as double precision floats. For conversion speci-
fier %i, data is read as 64-bit signed integers. For conversion specifiers %o, %u, %x, %X, data is read as 64-bit unsigned integers.
LIMITATIONS
No native support for printing complex data is provided. This may be worked around by using dirfile(5) representation suffixes. For exam-
ple, the command
$ dirfile2ascii DIRFILE FIELD.r FIELD.i
will print the real and imaginary parts of the complex valued field FIELD in the first and second columns, respectively.
SEE ALSO
dirfile(5), printf(3)
Version 0.7.1 30 November 2010 dirfile2ascii(1)