Sponsored Content
Full Discussion: Matching tables
Top Forums UNIX for Beginners Questions & Answers Matching tables Post 303042424 by cowa on Tuesday 24th of December 2019 03:33:44 AM
Old 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

Routing tables

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

Converting tables of row data into columns of tables

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

tables in scripts

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

comparing two tables

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

VI editor and tables

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

Insert lines above matching line with content from matching

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

Selecting tables

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

Compare file1 for matching line in file2 and print the difference in matching lines

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

awk to combine all matching dates and remove non-matching

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
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)
All times are GMT -4. The time now is 09:11 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy