|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
averaging specific column of multiple files
Post 302585421 by ahamed101 on Wednesday 28th of December 2011 10:44:47 AM
12-28-2011
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello. Im just starting to learn awk so hang in there with me...I have a large text file formatted as such everything is in a single column
ID001
value 1
value 2
value....n
ID002
value 1
value 2
value... n
I want to be able to calculate the average for values for each ID from the... (18 Replies)
Discussion started by: johnmillsbro
18 Replies
2. Shell Programming and Scripting
Hello,
I am trying to average multiple columns simultaneously while skipping the first column.
I am using this awk line to average one column
awk '{sum+=$3} END { print "Average = ",sum/NR}'
But I want to be able to do it for multiple columns while skipping the first column. There... (4 Replies)
Discussion started by: gisele_l
4 Replies
3. Shell Programming and Scripting
Hello
I have file that consist of 2 columns of millions of entries
timestamp and throughput
I want to find the average (throughput ) for each equal timestamp before change it to proper format
e.g : i want to average 2 coloumnd fot all 1308154800 values in column 1
and then
print... (4 Replies)
Discussion started by: aadel
4 Replies
4. Shell Programming and Scripting
Hi,
I am trying to average the values from 3 files with the same format. They are very large files so I will describe the file and show some it of. Basically the file has 83 columns (with nearly 7000 rows). The first three columns are the same for each file while the remaining 80 are values that... (1 Reply)
Discussion started by: kylle345
1 Replies
5. Shell Programming and Scripting
Hello all, I need to compute a row-wise average of files with a single column based on the pattern of the filenames. I really appreciate any help on this. it would just be very difficult to do them manually as the rows are mounting to 100,000 lines. the filenames are as below with convention as... (2 Replies)
Discussion started by: ida1215
2 Replies
6. Shell Programming and Scripting
Dear fellows, I need your help.
I'm trying to write a script to convert a single column into multiple rows.
But it need to recognize the beginning of the string and set it to its specific Column number.
Each Line (loop) begins with digit (RANGE).
At this moment it's kind of working, but it... (6 Replies)
Discussion started by: AK47
6 Replies
7. Shell Programming and Scripting
Hello....
Pls help me (and sorry my english) :)
So
I have a file (test.txt) with 1 long line.... for example:
isgc jsfh udgf osff 8462 error iwzr 653 idchisfb isfbisfb sihfjfeb isfhsi gcz eifh
How to print after the "error" word the 2nd 4th 5th and 7th word??
output well be:
653 isfbisfb... (2 Replies)
Discussion started by: marvinandco
2 Replies
8. Shell Programming and Scripting
I have a file (let say file B) like this:
File B:
A1 3 5
A1 7 9
A2 2 5
A3 1 3
The first column defines a filename and the other two define a range in that specific file. In the same directory, I have also three more files (File A1, A2 and A3). Here is 10 sample lines... (3 Replies)
Discussion started by: Bastami
3 Replies
9. UNIX for Beginners Questions & Answers
I have data of an excel files as given below,
file1
org1_1 1 1 2.5 100
org1_2 1 2 5.5 98
org1_3 1 3 7.2 88
file2
org2_1 1 1 2.5 100
org2_2 1 2 5.5 56
org2_3 1 3 7.2 70
I have multiple excel files as above shown.
I have to copy column 1, column 4 and paste into a new excel file as... (26 Replies)
Discussion started by: dineshkumarsrk
26 Replies
10. UNIX for Beginners Questions & Answers
file1:
Name,Threshold,Curr Samples,Curr Error%,Curr ART
GETHome,100,21601,0.00%,47
GETregistry,100,21592,0.00%,13
GEThomeLayout,100,30466,0.00%,17
file2:
Name,Threshold,Curr Samples,Curr Error%,Curr ART
GETHome,100,21601,0.00%,33
GETregistry,100,21592,0.00%,22... (6 Replies)
Discussion started by: Raghuram717
6 Replies
LEARN ABOUT DEBIAN
blaze-list
BLAZE-LIST(1) BlazeBlogger Documentation BLAZE-LIST(1) NAME
blaze-list - lists blog posts or pages in the BlazeBlogger repository SYNOPSIS
blaze-list [-cpqrsCPSV] [-b directory] [-I id] [-a author] [-t title] [-T tag] [-d day] [-m month] [-y year] [-n number] blaze-list -h|-v DESCRIPTION
blaze-list lists existing blog posts or pages in the BlazeBlogger repository. Additionally, it can also display basic repository statistics. OPTIONS
-b directory, --blogdir directory Allows you to specify a directory in which the BlazeBlogger repository is placed. The default option is a current working directory. -I id, --id id Allows you to display a single blog post or a page with the specified id. -a author, --author author Allows you to list blog posts or pages by the selected author. -t title, --title title Allows you to list blog posts or pages with matching title. -T tag, --tag tag Allows you to list blog posts or pages with matching tag. -d day, --day day Allows you to list blog posts or pages from the specified day of a month. The value has to be in the "DD" form. -m month, --month month Allows you to list blog posts or pages from the specified month. The value has to be in the "MM" form. -y year, --year year Allows you to list blog posts or pages from the specified year. The value has to be in the "YYYY" form. -n number, --number number Allows you to specify a number of blog posts or pages to be listed. -p, --page Tells blaze-list to list pages. -P, --post Tells blaze-list to list blog posts. This is the default option. -S, --stats Tells blaze-list to display statistics. -s, --short Tells blaze-list to display each blog post or page information on a single line. -r, --reverse Tells blaze-list to display blog posts or pages in reverse order. -c, --color Enables colored output. When supplied, this option overrides the relevant configuration option. -C, --no-color Disables colored output. When supplied, this option overrides the relevant configuration option. -q, --quiet Disables displaying of unnecessary messages. -V, --verbose Enables displaying of all messages. This is the default option. -h, --help Displays usage information and exits. -v, --version Displays version information and exits. EXAMPLE USAGE
List all blog post: ~]$ blaze-list ID: 11 | 2010-07-05 | Jaromir Hradilek Title: Join #blazeblogger on IRC Tags: announcement ID: 10 | 2009-12-16 | Jaromir Hradilek Title: Debian and Fedora Packages Tags: announcement etc. List all blog post in reverse order: ~]$ blaze-list -r ID: 1 | 2009-02-10 | Jaromir Hradilek Title: BlazeBlogger 0.7.0 Tags: release ID: 2 | 2009-02-11 | Jaromir Hradilek Title: BlazeBlogger 0.7.1 Tags: release etc. List all pages: ~]$ blaze-list -p ID: 5 | 2009-02-10 | Jaromir Hradilek Title: Downloads ID: 4 | 2009-02-10 | Jaromir Hradilek Title: Themes etc. List each blog post on a single line: ~]$ blaze-list -s ID: 11 | 2010-07-05 | Join #blazeblogger on IRC ID: 10 | 2009-12-16 | Debian and Fedora Packages etc. Display a short version of blog statistics: ~]$ blaze-list -Ss There is a total number of 11 blog posts and 5 pages in the repository. SEE ALSO
blaze-config(1), blaze-add(1) BUGS
To report a bug or to send a patch, please, add a new issue to the bug tracker at <http://code.google.com/p/blazeblogger/issues/>, or visit the discussion group at <http://groups.google.com/group/blazeblogger/>. COPYRIGHT
Copyright (C) 2009-2011 Jaromir Hradilek This program is free software; see the source for copying conditions. It is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Version 1.2.0 2012-03-05 BLAZE-LIST(1)