Re: Import CSV file, remove columns, print table

[John Kitchin <jkitchin@andrew.cmu.edu>]

[-- Attachment #1: Type: text/plain, Size: 2510 bytes --]

You can do something like this:

#+name: csv
| ID | Name         | Titel / Title | Vorname / First Name | Nachname /
Surname | Institution           |
|  1 | Alice Apple  | Fr./Ms.       | Alice                | Apple
     | Universität zum Apfel |
|  2 | Bob Birne    | Hr./Mr.       | Bob                  | Birne
     | Pear University       |
|  3 | Carol Carrot | Prof.         | Carol                | Carrot
    | University of Veg     |


#+BEGIN_SRC emacs-lisp :var data=csv
(let ((table (mapcar (lambda (row) (list (nth 0 row) (nth 4 row) (nth 3
row))) data)))
  (setf (car table) (append (car table) '("Signature")))
  table)
#+END_SRC

#+RESULTS:
| ID | Nachname / Surname | Vorname / First Name | Signature |
|  1 | Apple              | Alice                |           |
|  2 | Birne              | Bob                  |           |
|  3 | Carrot             | Carol                |           |


John

-----------------------------------
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



On Fri, Sep 13, 2019 at 9:36 AM Loris Bennett <loris.bennett@fu-berlin.de>
wrote:

> Hi,
>
> I want to create a list of participants of an event which people can
> sign, so that I can record who actually turned up.
>
> From the registration website I can download a CSV file and import it
> into and org file:
>
> | ID | Name         | Titel / Title | Vorname / First Name | Nachname /
> Surname | Institution           |
> |  1 | Alice Apple  | Fr./Ms.       | Alice                | Apple
>       | Universität zum Apfel |
> |  2 | Bob Birne    | Hr./Mr.       | Bob                  | Birne
>       | Pear University       |
> |  3 | Carol Carrot | Prof.         | Carol                | Carrot
>      | University of Veg     |
>
>
> I would like to reduce this to
>
> | ID | Nachname / Surname | Vorname / First Name | Signature |
> |  1 | Apple              | Alice                |           |
> |  2 | Birne              | Bob                  |           |
> |  3 | Carrot             | Carol                |           |
>
> and then print it out as a LaTeX table.
>
> I can obviously write a source block of Python or R to do this, but can
> I manipulate the table more directly in Org?
>
> Cheers,
>
> Loris
>
> --
> This signature is currently under construction.
>
>
>

[-- Attachment #2: Type: text/html, Size: 3560 bytes --]