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
sqlobject-admin
SQLOBJECT-ADMIN(1) General Commands Manual SQLOBJECT-ADMIN(1)
NAME
sqlobject-admin - manage your database as defined with SQLObject classes
SYNOPSIS
sqlobject-admin [options] command
DESCRIPTION
The sqlobject-admin tool included with SQLObject allows you to manage your database as defined with SQLObject classes.
Some of the features include creating tables, checking the status of the database, recording a version of a schema, and updating the
database to match the version of the schema in your code.
COMMANDS
The following commands are recognized:
help
Show the help text.
create
Find the tables and create them. Existing tables are simply skipped.
sql
Show the SQL to create all the tables.
drop
Drop tables. Missing tables are skipped.
execute
Execute an arbitrary SQL expression.
list
List out all the found classes.
status
Show if tables are present in the database.
record
Record historical information about the database status
upgrade
Update the database to a new version (as created by record)
OPTIONS
-c CONNECTION, --connection=CONNECTION
Connection string for the database .
-f FILENAME, --config-file=FILENAME
Configuration file from which to get the connection to the database.
-m MODULE, --module=MODULE
A module to look in for classes.
-p PACKAGE, --package=PACKAGE
A package to look in.
--class=CLASSMATCH
Restricting the found classes to the matching classes.
--egg=EGG_SPEC
Egg description that should be loaded.
AUTHORS
This manual page was written by Carl Chenet <chaica@ohmytux.com>.
LICENSE
This package is licensed under the GNU Lesser General Public License. You can
find the full text of the LGPL in /usr/share/common-licenses/LGPL in your
Debian system.
06/03/2010 SQLOBJECT-ADMIN(1)