Hi,
I got a lot of files looking like this:
1
0.5
6
All together there are ard 1'000'000 lines in each of the ard 100 files.
I want to build the average for every line, and write the result to a new file.
The averaging should start at a specific line, here for example at line... (10 Replies)
Hi,
I have 20 files which have respective 50 lines with different values.
I would like to process each line of the 50 lines in these 20 files one at a time and do an average of 3rd field ($3) of these 20 files. This will be output to an output file.
Instead of using join to generate whole... (8 Replies)
Hi,
first, I have searched in the forum for this, but I could not find the right answer. (There were some similar threads, but I was not sure how to adapt the ideas.)
Anyway, I have a quite natural problem: Given are several text files. All files contain the same number of lines and the same... (3 Replies)
Hello there,
I found an elegant solution to computing average values from multiple text files
awk '{for (i=1;i<=NF;i++){if ($i!~"n/a"){a+=$i}else{b++}}}END{for (i=1;i<=FNR;i++){for (j=1;j<=NF;j++){printf (a/(3-b))((b>0)?"~"b" ":" ")};printf "\n"}}' file1 file2 file3
I tried to modify... (2 Replies)
I have roughly ~30 .txt files in a directory which all have unique names. These files all contain text arranged in columns separated by whitespace (example file:
[#YY MM DD hh mm WDIR WSPD GST WVHT DPD APD MWD PRES ATMP WTMP DEWP VIS TIDE
#yr mo dy hr mn degT m/s m/s m sec ... (5 Replies)
Hi,
I would like to calculate the average of column 'y' based on the value of column 'pos'.
For example, here is file1
id pos y c
11 1 220 aa
11 4333 207 f
11 5333 112 ee
11 11116 305 e
11 11117 310 r
11 22228 781 gg
11 ... (2 Replies)
Hi,
My input file
Gene1 1
Gene1 2
Gene1 3
Gene1 0
Gene2 0
Gene2 0
Gene2 4
Gene2 8
Gene3 9
Gene3 9
Gene4 0
Condition:
If the first column matches, then look in the second column. If there is a value of zero in the second column, then don't consider that record while averaging.
... (5 Replies)
I have the following format of input from multiple files
File 1
24.01 -81.01 1.0
24.02 -81.02 5.0
24.03 -81.03 0.0
File 2
24.01 -81.01 2.0
24.02 -81.02 -5.0
24.03 -81.03 10.0
I need to scan through the files and when the first 2 columns match I... (18 Replies)
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
LEARN ABOUT DEBIAN
aoe-stat
aoe-stat(8) System Manager's Manual aoe-stat(8)NAME
aoe-stat - print aoe device status report
SYNOPSIS
modprobe aoe
aoe-stat
env sysfs_dir=/sys aoe-stat
DESCRIPTION
The aoe-stat script collects information on ATA over Ethernet devices from sysfs.
For each AoE device the kernel has discovered, there is one row in the script's output. Each row has the following columns.
devicename
The device name is of the form eX.Y,
with X being the AoE device shelf address, and Y being the AoE slot address.
size The size of the AoE device is in gigabytes (billions of bytes).
ifname The network interface name is printed in the third column.
payload
The number of bytes read from or written to the storage target in each AoE packet appears in the fourth column, unless the aoe
driver does not export this information.
status The device status is in the last column. Possible values are up, down, and down,closewait. The "up" status means the aoe driver
considers this device ready for I/O. The "down" status means the opposite. The "down,closewait" status means that some software
still has the device open, and when this straggler closes the device, it will enter the "down" state.
ENVIRONMENT VARIABLES
If the sysfs_dir variable is set in the environment, it will override the default location where aoe-stat will look for sysfs, namely
/sys.
WARNINGS
If the minor device number of a device node does not match that of its namesake, aoe-stat will print a warning as shown below.
nai:~# aoe-stat
e0.3 0.104GB eth0 up
e0.4 4398.046GB eth0 up
e20.0 1000.215GB eth0 up
e42.0 2000.431GB eth0 up
aoe-stat Warning: device node /dev/etherd/e45.1 has wrong minor device number
e45.1 1152.874GB eth0 up
Using such a device node is dangerous, because its name doesn't match the actual device that you would be reading from and writing to.
Such a broken device node should be removed. Device nodes are created by udev or (on systems without udev) by aoe-mkdevs.
EXAMPLE
In this example, the root user on a host named nai loads the aoe driver module and then prints a list of all the available aoe devices.
Then he remembers to bring up the storage network interfaces, does an AoE discovery, and prints the list again. This time the list shows
all the devices in shelf seven.
nai:~# modprobe aoe
nai:~# aoe-stat
nai:~# ifconfig eth3 up
nai:~# aoe-discover
nai:~# aoe-stat
e0.0 10995.116GB eth0 up
e0.1 10995.116GB eth0 up
e0.2 10995.116GB eth0 up
e1.0 1152.874GB eth0 up
e7.0 370.566GB eth0 up
nai:~#
SEE ALSO aoe-discover(8), aoe-interfaces(8), aoe-mkdevs(8), aoe-mkshelf(8), aoetools(8), udev(7).
AUTHOR
Ed L. Cashin (ecashin@coraid.com)
aoe-stat(8)