Hello
The following works
#+TBLNAME: raw-data2
| | Result |
|--------+--------|
| | 0.5 |
| | 1.5 |
| | 2.5 |
| | 3.5 |
| | 4 |
| | 7 |
| | 7.5 |
| | NP |
| | NP |
|--------+--------|
| All:NP | 2 |
#+TBLFM: @>$2='(length(org-lookup-all "NP" '(@2$2..@-I$2) nil))
The entries NP in the second column are counted and the result is put in
the last row.
I also want to the frequency (in a certain range) in the table, but I
want the result in a different table, that is why I need the remote
function
Auxiliary function from the web.
#+BEGIN_SRC emacs-lisp
(defun in-interval (bounds el)
(and (>= el (car bounds)) (<= el (cadr bounds))))
#+END_SRC
| lower bound | upper bound | frequency |
|-------------+-------------+-----------|
| 0.1 | 4.9 | 5 |
| 5 | 6.9 | 0 |
| 7 | 8.9 | 2 |
| 9 | 10 | 0 |
#+TBLFM: $3='(length (org-lookup-all '($1 $2) '(remote(raw-data2,@2$1..@>$1))
nil 'in-interval));N
Works.
Now I want to combine the first org-lookup with the second one and have
the result in a different table
so I tried
| lower bound | upper bound | frequency |
|-------------+-------------+-----------|
| 0.1 | 4.9 | 0 |
| 5 | 6.9 | 0 |
| 7 | 8.9 | 0 |
| 9 | 10 | 0 |
|-------------+-------------+-----------|
| | | 1 |
#+TBLFM: $3='(length (org-lookup-all '($1 $2) '(remote(raw-data2,@2$1..@>$1))
nil 'in-interval));N::@>$2='(length(org-lookup-all "NP"
'(remote(raw-data2,@2$2..@-I$2)) nil))
But this does not work.
Any help would be strongly appreciated.
Thanks
Uwe Brauer
