From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id qCW1ImtaIWEyGwAAgWs5BA (envelope-from ) for ; Sat, 21 Aug 2021 21:56:27 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id 6MOpHWtaIWHcOAAAbx9fmQ (envelope-from ) for ; Sat, 21 Aug 2021 19:56:27 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id AEA5FB1A1 for ; Sat, 21 Aug 2021 21:56:26 +0200 (CEST) Received: from localhost ([::1]:36052 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mHX6P-0007Ja-2s for larch@yhetil.org; Sat, 21 Aug 2021 15:56:25 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:49202) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mHX5f-0007FH-N2 for emacs-orgmode@gnu.org; Sat, 21 Aug 2021 15:55:39 -0400 Received: from mail-wm1-x335.google.com ([2a00:1450:4864:20::335]:55981) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1mHX5d-0001ZI-Ee for emacs-orgmode@gnu.org; Sat, 21 Aug 2021 15:55:39 -0400 Received: by mail-wm1-x335.google.com with SMTP id l6so1736325wmq.5 for ; Sat, 21 Aug 2021 12:55:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version; bh=KynYpZxYg4UkXlQOxqKNTq5w48ywWNOcOcsj1jj5KPE=; b=GY8661eJPPbkY9YyhG40ltb/t0ce1gRLKXo43xRDzE5XGVbRj6fYn2cgiRVkGXIKNZ n/crq8jjmDtRSG83oaSKv7nml18tGJmrMDm/P5BszV9jSU2Bco2B7+PVoJDMoY6KE+WZ Ti5MWq7Emvegeh7rrxcok9rvaJivtbP0pem0GEJcCzHMGLZ4pe/5FK+2I48Lw/gfU6yK tZPyF5sLDty1r9x7xpLwXzo4/Y3yTWaQ5pdM2h6eerV5swJ3pnq9EFwwGA228jRsyFRF 7HBgQD4K082qrZwexA3rJ0736KXlWPEHn8KWUDT64scH+fROwTuQcKf5HYgXYC9VHp0/ k0Qg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:cc:subject:references:date:in-reply-to :message-id:user-agent:mime-version; bh=KynYpZxYg4UkXlQOxqKNTq5w48ywWNOcOcsj1jj5KPE=; b=pMgbRFOt5D9UaJoOLb7S7KH+vsdqqvoXf3/PgB0gYyGL8rWK0gebYW4EIZ2GgY3MaT LIRi4LUVfXmpfUn0HcSyI5HwTFJSXpss5BalCslUUw7EmkSHB4z6K98eCWhzI2ENwjGS P9DUvR4EzZh91H8lTqgkLYtbXNn9mujz2oreA2cNgZQ4iaZlcwuOMIVRaxShKKkwZydE s26dM6+WTZzvmg62THyavZS8k/WkSQAWZdpkxAvKs5ZhsDhTSygKiqKbmFCvXw2ax8eT FJycsjoRyjLAkVnH73uQjhzG9nM8SQsRWoY4uR5FdLOAWcLx8ekAkLd+I1S30baPwFKM 8vtA== X-Gm-Message-State: AOAM5326M2IIF++cz07ljPsmaJrJ+wZYZFi69Xxjkgt1IT5EDUmEfqqf a+xt/Ddhy/+RQcrsHxR/Yzw= X-Google-Smtp-Source: ABdhPJzzQxATQZoQI9WhwWquWx/8XqRFIn4uPV+n5VJZu2XwKMaBX9rb7lkLzNepQTV+H3qFfhmoyQ== X-Received: by 2002:a1c:f206:: with SMTP id s6mr9368274wmc.15.1629575735563; Sat, 21 Aug 2021 12:55:35 -0700 (PDT) Received: from freegnu (ip-95-223-72-77.hsi16.unitymediagroup.de. [95.223.72.77]) by smtp.gmail.com with ESMTPSA id h4sm10003490wrm.42.2021.08.21.12.55.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 21 Aug 2021 12:55:35 -0700 (PDT) From: Jeremie Juste To: "Berry, Charles" via "General discussions about Org-mode." Subject: Re: Number format for table results outut from R data.frame/tibble References: <09213D27-4679-4C44-B512-8E257CFECA4D@health.ucsd.edu> Date: Sat, 21 Aug 2021 21:55:34 +0200 In-Reply-To: (Charles Berry's message of "Sat, 21 Aug 2021 17:39:00 +0000") Message-ID: <877dgeh8sp.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2a00:1450:4864:20::335; envelope-from=jeremiejuste@gmail.com; helo=mail-wm1-x335.google.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: "Berry, Charles" Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1629575787; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=KynYpZxYg4UkXlQOxqKNTq5w48ywWNOcOcsj1jj5KPE=; b=tik8HQusMrnjNvBDTG5/zqVUpA+hqIeR4F1WSq1Elick+/Mp0tZIGc6eRJLyw8Sojs8lQX wV5gfifeYbr+KuFISoNsZZzQ0a8sUtCCeUyCMhSqc8/Elxl1HGswRgRLFZ4bt691O2VtDI 0ZNgQqJBUkhco9yGsABImeLG1GT2fGuiS+T0bW/TzsYJ+3Mc5LywlYFsYfcyK833TFx0DE gA2RHeLE3Sqh1YDXVNBo4nsR51jNQvYwbZN8voh7b93CS0IKxN71JgObcPCdJrFa4+n2NP pTZnkI5ZDQQ96KQXbGBt3wP7xYHyLVJMLexYg0GcysIOG75iJMknYjeiHT5vBA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1629575787; a=rsa-sha256; cv=none; b=nv90nN6AJqjiYMJCtI7KuymmILm+C5p2UnzZvXmf6QO/frGjux5kfwl/E17UHocQMBAvHe ytnZfI8J2eV4BjYKmlCqOoOnklwidOJa4EcsWm/os2t/GZSbQUn1A/vBwQMC3NvfZ+3rqI XfBC/GR10NVQ8DrPtWq0qNSYQJuXGFWVEv0k0/RveAK7MrBndhtYQDeW0fZhdYbwacTfg6 f0SAqBnJwAEAamaECGui9fwle4xWfElT2PnMjAKEGI7/TOajmUJQb4AknILJH9/WpeGRx5 u5V+QijQMT2gxmktgp4Rxvm6llLI+CvKTX3ds2edXoNXxMKtP31dNV/bpFwV/Q== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20161025 header.b=GY8661eJ; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Spam-Score: -1.32 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20161025 header.b=GY8661eJ; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: AEA5FB1A1 X-Spam-Score: -1.32 X-Migadu-Scanner: scn0.migadu.com X-TUID: 4tWBS9bY+C8t Hello, John For my workflow, I generally use the minimum from xtable and do the formatting in org-mode using the :post parameter to call another lisp code block. That said, as Chuck said, you can go a long way with xtable. In my attic, I found the following code where I take only the core data from xtable and do formatting in org-mode. This code may be a little extravagant on the latex side but, it shows the possibilities. HTH, Jeremie #+LATEX_HEADER: \usepackage{booktabs} #+LATEX_HEADER: \usepackage{array} #+LATEX_HEADER: \usepackage{setspace} #+LATEX_HEADER: \usepackage{dcolumn} #+LATEX_HEADER: \usepackage{array} #+LATEX_HEADER: \usepackage{setspace} #+LATEX_HEADER:\usepackage{longtable,tabularx,ltablex} #+LATEX_HEADER:\usepackage{siunitx} #+LATEX_HEADER:\usepackage[flushleft]{threeparttablex} #+Name: add-table-env #+BEGIN_SRC emacs-lisp :var table="TABLE" notes="NOTES" caption="CAPTION" :results silent :exports none (replace-regexp-in-string "\\\\begin{tabular}.*\\S.*\\toprule\\|\\\\end{tabular}" "" (format "\\scriptsize{ \\begin{center} \\begin{TableNotes}\\footnotesize \\item[\\hspace{-\\fontdimen2\\font}] %s \\end{TableNotes} \\begin{ThreePartTable} \\sisetup{table-format=-2.3, table-space-text-post=***, table-number-alignment=center} \\keepXColumns \\begin{tabularx}{\\textwidth}{l *{3}{D..{5.3}}} \\caption{%s} \\\\ \\toprule \\toprule \\multicolumn{1}{c}{colnum 1} &\\multicolumn{1}{c}{colnum 2} \\\\ \\cmidrule(lr){1-1} \\cmidrule(lr){2-2} %s \\insertTableNotes \\end{tabularx} \\end{ThreePartTable} \\end{center} } \\pagebreak " notes caption table)) #+END_SRC #+begin_src R :session foo :results output latex :post add-table-env(*this*, "Some note", "A caption" ) :exports results library(tibble) library(xtable) tmp <- tibble(x=1:5, y=x/pi) print.xtable(xtable(tmp), include.colnames=FALSE,include.rownames=FALSE,floating=FALSE, comment = FALSE,dcolumn=TRUE,booktabs=TRUE ,sanitize.text.function = function(x) { x[x=="NA"] <-"" x}) #+end_src