01-26-2011
Frequency of a range of numbers
Hello,
I have a column where there are values from 1 to 150.
I want to get the frequency of values in the following ranges:
1-5
6-10
11-15
....
....
....
146-150
How can I do this in a for loop?
Thanks,
Guss
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I want to grep a range of numbers in a log file. My log file looks like this:
20050807070609Z;blah blah
That is a combination of yr,month,date,hours,minutes,seconds.
I want to search in the log file events that happened between a particular time.
like between 20050807070000 to 20050822070000... (1 Reply)
Discussion started by: azmathshaikh
1 Replies
2. UNIX for Dummies Questions & Answers
Hi im new to unix and need to find a way to grep the top 5 numbers in a file and put them into another file. For example my file looks like this
abcdef 50000
abcdef 45000
abcdef 40000
abcdef 35000
abcdef 30000
abcdef 25000
abcdef 20000
abcdef 15000
abcdef 10000
and so on...
How can... (1 Reply)
Discussion started by: ProgChick2oo9
1 Replies
3. Shell Programming and Scripting
Howdy experts,
We have some ranges of number which belongs to particual group as below.
GroupNo StartRange EndRange
Group0125 935300 935399
Group2006 935400 935476
937430 937459
Group0324 935477 935549
... (6 Replies)
Discussion started by: thepurple
6 Replies
4. UNIX for Dummies Questions & Answers
Hello,
I have two columns with data that look like this:
Col1 Col2
------ -----
a 1
a 2
a 3
a 4
a 7
a 8
a 9
a 10
a 11
b 6
b 7
b 8
b 9
b 14 (5 Replies)
Discussion started by: Gussifinknottle
5 Replies
5. Shell Programming and Scripting
I have a data file that has 6 columns and I have sorted the 3rd column so that all rows are sorted according to the 3rd column (from lowest to highest number). An example is shown below:
7563 273 1 -15.81100000 25.37250000 -19.27320000
8149 294 1 -17.90540000 ... (3 Replies)
Discussion started by: ananyob
3 Replies
6. UNIX for Dummies Questions & Answers
Hi I have a data file with two columns which looks like:
1 42
2 40
3 55
4 50
5 38
6 49
7 33
8 46
9 39
10 33
11 33
12 26
13 46
14 44
15 55
16 54
17 30
18 32 (7 Replies)
Discussion started by: marhuu
7 Replies
7. Shell Programming and Scripting
Dear Friends,
I want to know how to grep for the lines that has a number between given range(start and end).
I have tried the following sed command.
sed -n -e '/20030101011442/,/20030101035519/p'
However this requires both start and end to be part of the content being grepped. However... (4 Replies)
Discussion started by: tamil.pamaran
4 Replies
8. UNIX for Dummies Questions & Answers
I am trying to extract specific information from a large *.sam file (it's originally 28Gb).
I want to extract all lines that are on chr3 somewhere in the range of 112,937,439-113,437,438.
Here is a sample line from my file so you can get a feel for what each line looks like:
seq.4 0 ... (8 Replies)
Discussion started by: genGirl23
8 Replies
9. Shell Programming and Scripting
Hi,
I'm trying to match a filename that could be called anything from vout001 to vout252 and was trying to do a small test but I'm not getting the result I thought I would..
Can some one tell me what I'm doing wrong?
*****@********>echo $mynumber ... (4 Replies)
Discussion started by: Jazmania
4 Replies
10. Shell Programming and Scripting
Hi
I am getting an argument which specifies the range of numbers. eg: 7-15
Is there a way that i can easily (avoiding loop) print the range of number between and including the specified above.
The above example should translate to 7,8,9,10,11,12,13,14,15 (3 Replies)
Discussion started by: tostay2003
3 Replies
LEARN ABOUT PHP
pdostatement.bindcolumn
PDOSTATEMENT.BINDCOLUMN(3) 1 PDOSTATEMENT.BINDCOLUMN(3)
PDOStatement::bindColumn - Bind a column to a PHP variable
SYNOPSIS
public bool PDOStatement::bindColumn (mixed $column, mixed &$param, [int $type], [int $maxlen], [mixed $driverdata])
DESCRIPTION
PDOStatement.bindColumn(3) arranges to have a particular variable bound to a given column in the result-set from a query. Each call to
PDOStatement.fetch(3) or PDOStatement.fetchAll(3) will update all the variables that are bound to columns.
Note
Since information about the columns is not always available to PDO until the statement is executed, portable applications should
call this function afterPDOStatement.execute(3).
However, to be able to bind a LOB column as a stream when using the PgSQL driver, applications should call this method before call-
ing PDOStatement.execute(3), otherwise the large object OID will be returned as an integer.
PARAMETERS
o $column
- Number of the column (1-indexed) or name of the column in the result set. If using the column name, be aware that the name
should match the case of the column, as returned by the driver.
o $param
- Name of the PHP variable to which the column will be bound.
o $type
- Data type of the parameter, specified by the PDO::PARAM_* constants.
o $maxlen
- A hint for pre-allocation.
o $driverdata
- Optional parameter(s) for the driver.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Binding result set output to PHP variables
Binding columns in the result set to PHP variables is an effective way to make the data contained in each row immediately available
to your application. The following example demonstrates how PDO allows you to bind and retrieve columns with a variety of options
and with intelligent defaults.
<?php
function readData($dbh) {
$sql = 'SELECT name, colour, calories FROM fruit';
try {
$stmt = $dbh->prepare($sql);
$stmt->execute();
/* Bind by column number */
$stmt->bindColumn(1, $name);
$stmt->bindColumn(2, $colour);
/* Bind by column name */
$stmt->bindColumn('calories', $cals);
while ($row = $stmt->fetch(PDO::FETCH_BOUND)) {
$data = $name . " " . $colour . " " . $cals . "
";
print $data;
}
}
catch (PDOException $e) {
print $e->getMessage();
}
}
readData($dbh);
?>
The above example will output:
apple red 150
banana yellow 175
kiwi green 75
orange orange 150
mango red 200
strawberry red 25
SEE ALSO
PDOStatement.execute(3), PDOStatement.fetch(3), PDOStatement.fetchAll(3), PDOStatement.fetchColumn(3).
PHP Documentation Group PDOSTATEMENT.BINDCOLUMN(3)