03-20-2013
Following your threads for a while now, the best advice I can give you is: play around with the proposals offered so far so you find the solution yourself and learn sth from it.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
$ cat log.txt
Name Age Sex Lcation nfld alias xsd
CC 25 M XYZ asx KK Y
BB 21 F XAS awe SS N
SD 21 M AQW rty SD A
How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column?
so that the final output will become:
Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies
2. Shell Programming and Scripting
awk -F ";" '{if($10>80 && NR>1) print $0 }' txt_file_*
I am using this command to print the lines which has 10th field more then 80 and leaving the first line of the file which is the header.
But this is not working , the first line is is coming as output , please correct me .
thanks (2 Replies)
Discussion started by: madfox
2 Replies
3. Shell Programming and Scripting
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies
5. Shell Programming and Scripting
HI ,
i have to print the first header of df -h (Filesystem Size Used Avail Use% Mounted on)and line which conatin size Network path only.
Filesystem Size Used Avail Use% Mounted on
/test/sda3 35G 1.8G 32G 6% /
/test/sda10 7.8G 1.1G ... (3 Replies)
Discussion started by: netdbaind
3 Replies
6. Shell Programming and Scripting
Hi,
I have an input like this
1 2 3 4
2 3 4 5
4 5 6 7
I would like to count the no. of columns and print a header with a prefix "Col".
I would also like to count the no. of rows and print as first column with each line number with a prefix "Row"
So, my output would be
... (2 Replies)
Discussion started by: jacobs.smith
2 Replies
7. Shell Programming and Scripting
Dear All,
Good Day. I would like to solve the following issue and got some strange results, if anyone could help me in this regard, you are most welcome.
Here is the problem:
I have a file like
Header Value1 Value2 Value3 Value4 Value5 Value6 ... Value9
12.144 6 5 ... (8 Replies)
Discussion started by: Fredrick
8 Replies
8. Shell Programming and Scripting
i have a input of csv file as below but the sequence of column get changed.
I,e it is not necessary that name comes first then age and rest all, it may vary.
name,age,marks,roll,section
kevin,25,80,456,A
Satch,23,56,789,B
Meena,24,78,H245,C
So i want to print that column entires which... (12 Replies)
Discussion started by: millan
12 Replies
9. Shell Programming and Scripting
Hi,
My input files is like this
axis1 0 1 10
axis2 0 1 5
axis1 1 2 -4
axis2 2 3 -3
axis1 3 4 5
axis2 3 4 -1
axis1 4 5 -6
axis2 4 5 1
Now, these are my following tasks
1. Print a first column for every two rows that has the same value followed by a string.
2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies
10. Shell Programming and Scripting
Hello,
I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically
I/p
c1,c2,c3,c4,c5
10,20,30,40,50
20,30,40,50,60
If i want to find sum only column c1, c3 and output it as c6,c7
O/p
c1,c2,c3,c4,c5,c6,c7
10,20,30,40,50,30,70... (6 Replies)
Discussion started by: mkathi
6 Replies
LEARN ABOUT DEBIAN
statistics::basic::stddev
Statistics::Basic::StdDev(3pm) User Contributed Perl Documentation Statistics::Basic::StdDev(3pm)
NAME
Statistics::Basic::StdDev - find the standard deviation of a list
SYNOPSIS
Invoke it this way:
my $stddev = stddev(1,2,3);
Or this way:
my $v1 = vector(1,2,3);
my $std = stddev($v1);
And then either query the values or print them like so:
print "The stddev of $v1: $std
";
my $sq = $std->query;
my $s0 = 0+$std;
Create a 20 point "moving" stddev like so:
use Statistics::Basic qw(:all nofill);
my $sth = $dbh->prepare("select col1 from data where something");
my $len = 20;
my $std = stddev()->set_size($len);
$sth->execute or die $dbh->errstr;
$sth->bind_columns( my $val ) or die $dbh->errstr;
while( $sth->fetch ) {
$std->insert( $val );
if( defined( my $s = $std->query ) ) {
print "StdDev: $s
";
}
# This would also work:
# print "StdDev: $s
" $std->query_filled;
}
METHODS
new()
The constructor takes a list of values, a single array ref, or a single Statistics::Basic::Vector as arguments. It returns a
Statistics::Basic::StdDev object.
Note: normally you'd use the mean() constructor, rather than building these by hand using "new()".
query_mean()
Returns the Statistics::Basic::Mean object used in the standard deviation computation.
_OVB::import()
This module also inherits all the overloads and methods from Statistics::Basic::_OneVectorBase.
OVERLOADS
This object is overloaded. It tries to return an appropriate string for the calculation or the value of the computation in numeric
context.
In boolean context, this object is always true (even when empty).
AUTHOR
Paul Miller "<jettero@cpan.org>"
I am using this software in my own projects... If you find bugs, please please please let me know. :) Actually, let me know if you find it
handy at all. Half the fun of releasing this stuff is knowing that people use it.
COPYRIGHT
Copyright 2012 Paul Miller -- Licensed under the LGPL
SEE ALSO
perl(1), Statistics::Basic, Statistics::Basic::_OneVectorBase, Statistics::Basic::Vector
perl v5.14.2 2012-01-23 Statistics::Basic::StdDev(3pm)