12-24-2008
Hi,
I have another request..
here, V2 is a counter
I want to match V2 value with the V1 value with the same time series (t1) before V2 counter get reset to "1"..
e.g. 1,2,3,1 ---> I want to get value of V1 when value of V2 is "3" (before reset to "1")
or
e.g. 1,2,1,1,1, ---> I want to get the value of V1 when value of V2 are "2" followed by three consecutive "1"
Input File:
t1 V1 t2 V2
10.000000 4.387413 10.139355302 1
10.100000 4.397372 10.252770182 2
10.200000 4.406951 10.398060182 1
10.300000 3.940732 10.515105302 1
10.400000 4.044359 10.645365302 1
10.500000 4.139778 10.768800182 2
10.600000 4.222087 10.929725222 3
10.700000 4.299174 11.106285302 1
10.800000 2.941378 11.216505302 1
10.900000 3.081282 11.324910182 2
11.000000 3.219284 11.626115222 3
11.100000 3.354575 11.822715302 4
11.200000 3.486347 11.968005302 5
11.300000 3.613792 12.107075222 1
11.400000 3.730119 12.233535302 1
11.500000 3.846800 12.377615222 1
11.600000 3.956768 12.494055302 1
11.700000 4.059215 12.642540182 1
11.800000 4.153333 12.742740182 1
11.900000 4.234293 12.853565222 1
12.000000 4.309844 13.093440182 1
..............
..............
Desired Output:
t1 V1 V2
10.200000 4.406951 2
10.300000 3.940732 1
10.500000 4.139778 1
10.900000 3.081282 3
11.100000 3.354575 1
11.900000 4.234293 5
...............
...............
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Suppose I have 500 files in a directory and I need to Use awk to calculate average of column 3 for each of the file, how would I do that? (6 Replies)
Discussion started by: grossgermany
6 Replies
2. HP-UX
I have a question as below and i need to write a shell or perl script for this query:My Input file looks like below
RNo Marks
12 50
15 70
18 80
12 40
13 55
18 88
13 75... (4 Replies)
Discussion started by: smacherla
4 Replies
3. UNIX for Dummies Questions & Answers
I'm trying to iterate a UNIX awk script that returns min/max temperature data for each day from a monthly weather data file (01_weath.dat). The temperature data is held in $5. The temps are reported each minute so each day contains 1440 temperature enteries. The below code has gotten me as far as... (5 Replies)
Discussion started by: jgourley
5 Replies
4. Shell Programming and Scripting
Hello,
I'm hoping to get some help on calculating an average time from a list of times (hour:minute:second).
Here's what my list looks like right now, it will grow (I can get the full date or change the formatting of this as well):
07:55:31
09:42:00
08:09:02
09:15:23
09:27:45
09:49:26... (4 Replies)
Discussion started by: jaredhanks
4 Replies
5. Shell Programming and Scripting
Hi,
I have the following data in a file for example:
P1 XXXXXXX.1 YYYYYYY.1 ZZZ.1
P1 XXXXXXX.2 YYYYYYY.2 ZZZ.2
P1 XXXXXXX.3 YYYYYYY.3 ZZZ.3
P1 XXXXXXX.4 YYYYYYY.4 ZZZ.4
P1 XXXXXXX.5 YYYYYYY.5 ZZZ.5
P1 XXXXXXX.6 YYYYYYY.6 ZZZ.6
P1 XXXXXXX.7 YYYYYYY.7 ZZZ.7
P1 XXXXXXX.8 YYYYYYY.8 ZZZ.8
P2... (6 Replies)
Discussion started by: alex2005
6 Replies
6. Shell Programming and Scripting
I want to calculate the average line by line of some files with several lines on them, the files are identical, just want to average the 3rd columns of those files.:wall:
Example file:
File 1
001 0.046 0.667267
001 0.047 0.672028
001 0.048 0.656025
001 0.049 ... (2 Replies)
Discussion started by: AriasFco
2 Replies
7. Shell Programming and Scripting
I have an awk script that gives the following output:
Average end-to-end transmission delay 2.7 to 5.7 is 0.635392 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 0.66272 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 0.691712 seconds
Average end-to-end transmission... (4 Replies)
Discussion started by: ENG_MOHD
4 Replies
8. Programming
I have some time series data that I need to resample or downsample at some specific time intervals. The firs column is time in decimal hours. I am tryiong to resample this data every 3 minutse. So I need a data value ever 0.05. Here is the example data and as you can see, there time slot for 0.1500... (3 Replies)
Discussion started by: malandisa
3 Replies
9. Shell Programming and Scripting
Hi All,
Thank you for reading through my post and helping me figure out how I would be able to perform this task.
For example: I have a list of continuous output collected into a file in the format as seen below:
Date...........Time........C....A......... B
==========================... (5 Replies)
Discussion started by: terrychen
5 Replies
10. Shell Programming and Scripting
Hello dears,
I have a log file with records like below and want to get a average of one column based on the search of one specific keyword.
2015-02-07 08:15:28 10.102.51.100 10.112.55.101 "kevin.c" POST ... (2 Replies)
Discussion started by: Newman
2 Replies
LEARN ABOUT PHP
ini_get_all
INI_GET_ALL(3) 1 INI_GET_ALL(3)
ini_get_all - Gets all configuration options
SYNOPSIS
array ini_get_all ([string $extension], [bool $details = true])
DESCRIPTION
Returns all the registered configuration options.
PARAMETERS
o $extension
- An optional extension name. If set, the function return only options specific for that extension.
o $details
- Retrieve details settings or only the current value for each setting. Default is TRUE (retrieve details).
RETURN VALUES
Returns an associative array with directive name as the array key.
When $details is TRUE (default) the array will contain global_value (set in php.ini), local_value (perhaps set with ini_set(3) or .htac-
cess), and access (the access level).
When $details is FALSE the value will be the current value of the option.
See the manual section for information on what access levels mean.
Note
It's possible for a directive to have multiple access levels, which is why access shows the appropriate bitmask values.
CHANGELOG
+--------+------------------+
|Version | |
| | |
| | Description |
| | |
+--------+------------------+
| 5.3.0 | |
| | |
| | Added $details. |
| | |
+--------+------------------+
EXAMPLES
Example #1
ini_get_all(3) examples
<?php
print_r(ini_get_all("pcre"));
print_r(ini_get_all());
?>
The above example will output something similar to:
Array
(
[pcre.backtrack_limit] => Array
(
[global_value] => 100000
[local_value] => 100000
[access] => 7
)
[pcre.recursion_limit] => Array
(
[global_value] => 100000
[local_value] => 100000
[access] => 7
)
)
Array
(
[allow_call_time_pass_reference] => Array
(
[global_value] => 0
[local_value] => 0
[access] => 6
)
[allow_url_fopen] => Array
(
[global_value] => 1
[local_value] => 1
[access] => 4
)
...
)
Example #2
Disabling $details
<?php
print_r(ini_get_all("pcre", false)); // Added in PHP 5.3.0
print_r(ini_get_all(null, false)); // Added in PHP 5.3.0
?>
The above example will output something similar to:
Array
(
[pcre.backtrack_limit] => 100000
[pcre.recursion_limit] => 100000
)
Array
(
[allow_call_time_pass_reference] => 0
[allow_url_fopen] => 1
...
)
SEE ALSO
"How to change configuration settings", ini_get(3), ini_restore(3), ini_set(3), get_loaded_extensions(3), phpinfo(3), ReflectionExten-
sion::getINIEntries.
PHP Documentation Group INI_GET_ALL(3)