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
flow-stat
flow-stat(1) General Commands Manual flow-stat(1)NAME
flow-stat -- Generate reports with flow data.
SYNOPSIS
flow-stat [-hnpPw] [-d debug_level] [-f format] [-S sort_field] [-s sort_field] [-t tally_lines] [-T title]
DESCRIPTION
The flow-stat utility generates usage reports for flow data sets by IP address, IP address pairs, ports, packets, bytes, interfaces, next
hops, autonomous systems, ToS bits, exporters, and tags.
OPTIONS -d debug_level
Enable debugging.
-f format
Report format. Choose from the following:
0 Overall Summary
1 Average packet size distribution
2 Packets per flow distribution
3 Octets per flow distribution
4 Bandwidth per flow distribution
5 UDP/TCP destination port
6 UDP/TCP source port
7 UDP/TCP port
8 Destination IP
9 Source IP
10 Source/Destination IP
11 Source or Destination IP
12 IP protocol
13 octets for flow duration plot data
14 packets for flow duration plot data
15 short summary
16 IP Next Hop
17 Input interface
18 Output interface
19 Source AS
20 Destination AS
21 Source/Destination AS
22 IP ToS
23 Input/Output Interface
24 Source Prefix
25 Destination Prefix
26 Source/Destination Prefix
27 Exporter IP
28 Engine Id
29 Engine Type
30 Source Tag
31 Destination Tag
32 Source/Destination Tag
-h Display help.
-n Use symbolic names where appropriate.
-p Display header information.
-P Report as percent total.
-s sort_field
Sort ascending on field sort_field.
-S sort_field
Sort descending on field sort_field.
-t tally_lines
Tally totals every tally_lineslines.
-T title Set report title to title.
-w Wide output.
EXAMPLES
Provide a report on top source/destination IP pairs sorted by octets, report in percent total form for the flows in /flows/krc4. Use the
preload option to flow-cat to preserve meta information and display it with flow-stat.
flow-cat -p /flows/krc4 | flow-stat -f10 -P -p -S4
EXAMPLES
Many times a campus network will have a single border router which has one interface pointing to the internal side and many interfaces
pointing to other providers. These interfaces each have a unique numerical id known in SNMP terms as an ifIndex. The ifIndex to interface
name mappings can be determined by using a tool such as snmpwalk or using show commands in recent versions of IOS with the 'show snmp mib
ifmib ifindex' or JunOS 'show interfaces'. Once the ifIndex for each interface is known flow-filter can be combined with flow-stat to pro-
vide reports such as inbound vs outbound top src/destination IP addresses.
Provide a top source IP address report by outbound traffic, ie the top senders of traffic on the campus network. Assume the ifIndex of the
campus interface is 5.
flow-cat -p /flows/krc4 | flow-filter -i5 | flow-stat -f9 -P -p -S3
EXAMPLES
Provide a top destination IP address report by outbound traffic, ie the top sinks of traffic on the campus network. Assume the ifIndex of
the campus interface is 5.
flow-cat -p /flows/krc4 | flow-filter -I5 | flow-stat -f8 -P -p -S3
EXAMPLES
Provide a top source/destination AS report. Use symbolic names.
flow-cat -p /flows/krc4 | flow-stat -f20 -n -P -p -S4
BUGS
None known.
AUTHOR
Mark Fullmer maf@splintered.net
SEE ALSO flow-tools(1)flow-stat(1)