02-13-2015
Gnuplot 3d binning
Hello
I have a text file with tens of thousands of rows
The format is
x y
where both x and y can be anything between -100 and +100.
What I would like to do is have a 3d gnuplot where there are 10,000 squared or bins and each bin will count how many rows have a value that would be assigned to that bin.
So if a row is -50, -50
and then next row is again -50, -50
then the value for that bin would be 2
anybody got any idea how to make script in bash to do this??
I need to count the number of rows with x value between -100 and -99 and y value between -100 and -99....
then count the number of rows with x value between -100 and -99 and y value between -99 and -98
etc
and then is should have a 3 column text file which I cna display in gnuplot.
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi, I am a beginner using UNIX, and was wondering how to use gnuplot from UNIX on my pc. I am connected remotely to my work's UNIX server using Secure Shell Client, and gnuplot won't open a new window when I use the plot command. How do I do this?
Moreover, is it possible to save things from the... (0 Replies)
Discussion started by: KTTFB64
0 Replies
2. Shell Programming and Scripting
Hi everyone!
Can you please help me with some shell scripting?
I have an input file input.txt
It has 3 columns (Time, Event, Value)
Time event Value
03:38:22 A 57
03:38:23 A 56
03:38:24 B 24
03:38:25 C 51
03:38:26 B 7
03:38:26 ... (7 Replies)
Discussion started by: Needhelp2
7 Replies
3. Shell Programming and Scripting
I could not find this on the search..
I want to know how to trim a row
so lets say I have a file that looks like this:
bob 88888888888888
and I want to trim column 2 (lets say 4 off the front and end)
bob 888888
Also, how would I bin column 2
Lets so I want to add and average... (1 Reply)
Discussion started by: phil_heath
1 Replies
4. UNIX and Linux Applications
Hi,
I am trying to make a plot of an ASCII file using GNUplot, but I keep getting error msg:
for example plot filename.txt
It says that (.txt ) is not identified ... I tried to write it without the .txt part, but I also get the error msg.
Any idea why? :confused: (1 Reply)
Discussion started by: cosmologist
1 Replies
5. Shell Programming and Scripting
Hi I have a file that I want to bin.
I am using this code:
awk -F'\t' -v r=40 '{for(i=r;i<=NF;i+=r){for(j=0;j<r;j++){sum+=$(i-j)}printf "%s ", sum/r;sum=0}; printf "\n"}' file1 > file2
So basically what this code does is that it will averaging every 40 columns (creating bins of 40). But... (2 Replies)
Discussion started by: phil_heath
2 Replies
6. Emergency UNIX and Linux Support
Dear All,
I am new to GNUPLOT :D and dont know how it works, but actually there is a LINUX script generated by me which is running & capturing data in real time, the problem is that i want to plot that data in real time using GNUPLOT.:confused:
please help.:wall: (5 Replies)
Discussion started by: jojo123
5 Replies
7. Shell Programming and Scripting
simple question I thought.
How do I setup a chart in gnuplot that draws a "upper threshold" for a given set of data.
I have the graph charting fine. I have peaks and valleys. I can either setup a number that I want to be the "upper threshold". a horizontal line based either in the data,... (5 Replies)
Discussion started by: kag3ythree
5 Replies
8. Shell Programming and Scripting
hi
i have some data like this
input:
1 apples oranges 234
2 oranges apples 2345
3 grapes bananas 1000000
4 melons banans 10000000
5 bananas apples 5000000
6 mangoes banans 2000000
7 apples bananas 1999999
i want to put all those which are coming between 1 and 999999 in to one bin... (8 Replies)
Discussion started by: anurupa777
8 Replies
MOVE(7) PostgreSQL 9.2.7 Documentation MOVE(7)
NAME
MOVE - position a cursor
SYNOPSIS
MOVE [ direction [ FROM | IN ] ] cursor_name
where direction can be empty or one of:
NEXT
PRIOR
FIRST
LAST
ABSOLUTE count
RELATIVE count
count
ALL
FORWARD
FORWARD count
FORWARD ALL
BACKWARD
BACKWARD count
BACKWARD ALL
DESCRIPTION
MOVE repositions a cursor without retrieving any data. MOVE works exactly like the FETCH command, except it only positions the cursor and
does not return rows.
The parameters for the MOVE command are identical to those of the FETCH command; refer to FETCH(7) for details on syntax and usage.
OUTPUTS
On successful completion, a MOVE command returns a command tag of the form
MOVE count
The count is the number of rows that a FETCH command with the same parameters would have returned (possibly zero).
EXAMPLES
BEGIN WORK;
DECLARE liahona CURSOR FOR SELECT * FROM films;
-- Skip the first 5 rows:
MOVE FORWARD 5 IN liahona;
MOVE 5
-- Fetch the 6th row from the cursor liahona:
FETCH 1 FROM liahona;
code | title | did | date_prod | kind | len
-------+--------+-----+------------+--------+-------
P_303 | 48 Hrs | 103 | 1982-10-22 | Action | 01:37
(1 row)
-- Close the cursor liahona and end the transaction:
CLOSE liahona;
COMMIT WORK;
COMPATIBILITY
There is no MOVE statement in the SQL standard.
SEE ALSO
CLOSE(7), DECLARE(7), FETCH(7)
PostgreSQL 9.2.7 2014-02-17 MOVE(7)