gnuplot: plotting students' progress of grades

gnuplot: plotting students' progress of grades

[Tobias Frischholz]

[-- Attachment #1.1: Type: text/plain, Size: 1483 bytes --]

Hi List,

I have a table in org which looks like this (student’s grades):

|---+------------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+---------|
|   | Schüler    | 1-fach | 1-fach | 1-fach | 1-fach | 2-fach | 2-fach | 2-fach | 2-fach | 4-fach | 4-fach | 4-fach | 4-fach | Endnote |
|---+------------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+---------|
| # | Wurm, Hans |      4 |      3 |      2 |      3 |      3 |        |      3 |      1 |      3 |        |      3 |      5 |    3.18 |
| # | Igel, Sepp |      1 |      2 |      3 |      3 |        |        |        |      3 |      2 |        |      3 |      6 |    3.28 |
|---+------------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+---------|
| # | \o         |   2.50 |   2.50 |   2.50 |   3.00 |   3.00 |   0.00 |   3.00 |   2.00 |   2.50 |   0.00 |   3.00 |   5.50 |    3.23 |
|---+------------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+————|

I would like to use gnuplot to show me a line graph of each student’s single grades in order to resemble their progress during the school year.
Can this be achieved with it?

Best regards,
Tobias Frischholz

PGP PUBLIC KEY: http://pgp.mit.edu/pks/lookup?search=0xCD463AC1&op=index


[-- Attachment #1.2: Type: text/html, Size: 3111 bytes --]

[-- Attachment #2: Message signed with OpenPGP using GPGMail --]
[-- Type: application/pgp-signature, Size: 842 bytes --]

Re: gnuplot: plotting students' progress of grades

[Robert Klein]

Hi,

Tobias Frischholz <tobias@friolz.com> wrote:

> Hi List,
> 
> I have a table in org which looks like this (student’s grades):
> 
  [s.d.]
> I would like to use gnuplot to show me a line graph of each student’s
> single grades in order to resemble their progress during the school
> year. Can this be achieved with it?
> 

You can use something like this:

#+Name: grades
|---+------------+--------+--------+--------+------|
|   | Schüler    | 1-fach | 1-fach | 1-fach | note |
|---+------------+--------+--------+--------+------|
| # | Wurm, Hans |      4 |      3 |      2 | 3.18 |
| # | Igel, Sepp |      1 |      2 |      3 | 3.28 |
|---+------------+--------+--------+--------+------|
| # | \o         |   2.50 |   2.50 |   2.50 | 3.23 |
|---+------------+--------+--------+--------+------|

#+begin_src gnuplot :var data=grades :file noten.png
  put your gnuplot code here
#+end_src

Please see the worg page
http://orgmode.org/worg/org-contrib/babel/languages/ob-doc-gnuplot.html
for more information.

Best regards
Robert



> Best regards,
> Tobias Frischholz
> 
> PGP PUBLIC KEY:
> http://pgp.mit.edu/pks/lookup?search=0xCD463AC1&op=index
> 

Re: gnuplot: plotting students' progress of grades

[Loris Bennett]

Hi Tobias,

Tobias Frischholz <tobias@friolz.com> writes:

> Hi List,
>
> I have a table in org which looks like this (student’s grades):
>
> |---+------------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+---------|
> | | Schüler | 1-fach | 1-fach | 1-fach | 1-fach | 2-fach | 2-fach | 2-fach |
> 2-fach | 4-fach | 4-fach | 4-fach | 4-fach | Endnote |
> |---+------------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+---------|
> | # | Wurm, Hans | 4 | 3 | 2 | 3 | 3 | | 3 | 1 | 3 | | 3 | 5 | 3.18 |
> | # | Igel, Sepp | 1 | 2 | 3 | 3 | | | | 3 | 2 | | 3 | 6 | 3.28 |
> |---+------------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+---------|
> | # | \o | 2.50 | 2.50 | 2.50 | 3.00 | 3.00 | 0.00 | 3.00 | 2.00 | 2.50 | 0.00 |
> 3.00 | 5.50 | 3.23 |
> |---+------------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+————|
>
> I would like to use gnuplot to show me a line graph of each student’s single
> grades in order to resemble their progress during the school year.
> Can this be achieved with it?
>
> Best regards,
> Tobias Frischholz
>
> PGP PUBLIC KEY: http://pgp.mit.edu/pks/lookup?search=0xCD463AC1&op=index

I haven't used gnuplot for a couple of decades and in recent years have
used R with org for this sort of thing, but I'm sure it's possible

Have you looked at

http://orgmode.org/worg/org-contrib/babel/languages/ob-doc-gnuplot.html

?

Cheers,

Loris

-- 
This signature is currently under construction.

Re: gnuplot: plotting students' progress of grades

[Eric S Fraga]

On Tuesday,  1 Sep 2015 at 08:38, Robert Klein wrote:

[...]

> You can use something like this:

[...]

> #+begin_src gnuplot :var data=grades :file noten.png
>   put your gnuplot code here
> #+end_src

The problem for the OP will be that the data are in rows instead of
columns and gnuplot will only plot columns (selected using
"using").  The table needs to be transposed first (which is possible but
don't ask me how ;-).

-- 
: Eric S Fraga (0xFFFCF67D), Emacs 25.0.50.2, Org release_8.3.1-176-g45abec

Re: gnuplot: plotting students' progress of grades

[John Kitchin]

You can transpose the table like this:
(org-table-transpose-table-at-point)

Alternatively (adapted from that code): this might get you where you
need to be:

#+name: my-data
| 1 | 2 | 3 | 4 |
| a | b | c | d |

#+BEGIN_SRC emacs-lisp
(defun get-transposed-table (tblname)
  (save-excursion
    (org-open-link-from-string (format  "[[%s]]" tblname))
    (while (not (org-table-p))
      (forward-line))
    (let* ((table (delete 'hline (org-table-to-lisp)))
           (contents (mapcar (lambda (p)
                               (let ((tp table))
                                 (mapcar
                                  (lambda (rown)
                                    (prog1
                                        (pop (car tp))
                                      (setq tp (cdr tp))))
                                  table)))
                             (car table))))
      (mapconcat (lambda(x) (concat "| " (mapconcat 'identity x " | " ) "  |\n" ))
                 contents ""))))
#+END_SRC

#+RESULTS:
: get-transposed-table

#+BEGIN_SRC python :var data=(get-transposed-table "my-data")
print data
#+END_SRC

#+RESULTS:
: | 1 | a  |
: | 2 | b  |
: | 3 | c  |
: | 4 | d  |
:




Eric S Fraga writes:

> On Tuesday,  1 Sep 2015 at 08:38, Robert Klein wrote:
>
> [...]
>
>> You can use something like this:
>
> [...]
>
>> #+begin_src gnuplot :var data=grades :file noten.png
>>   put your gnuplot code here
>> #+end_src
>
> The problem for the OP will be that the data are in rows instead of
> columns and gnuplot will only plot columns (selected using
> "using").  The table needs to be transposed first (which is possible but
> don't ask me how ;-).

--
Professor John Kitchin
Doherty Hall A207F
Department of Chemical Engineering
Carnegie Mellon University
Pittsburgh, PA 15213
412-268-7803
@johnkitchin
http://kitchingroup.cheme.cmu.edu