From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id KNeSNnTkMWAnCgAA0tVLHw (envelope-from ) for ; Sun, 21 Feb 2021 04:41:24 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id EMFbMnTkMWClYwAAB5/wlQ (envelope-from ) for ; Sun, 21 Feb 2021 04:41:24 +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 13D0116CBF for ; Sun, 21 Feb 2021 05:41:24 +0100 (CET) Received: from localhost ([::1]:43110 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lDgYb-00073c-Oq for larch@yhetil.org; Sat, 20 Feb 2021 23:41:21 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:36256) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lDgYG-00073V-4H for emacs-orgmode@gnu.org; Sat, 20 Feb 2021 23:41:00 -0500 Received: from hiwela.pair.com ([209.68.5.201]:45703) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lDgYE-0006Aw-34 for emacs-orgmode@gnu.org; Sat, 20 Feb 2021 23:40:59 -0500 Received: from hiwela.pair.com (localhost [127.0.0.1]) by hiwela.pair.com (Postfix) with ESMTP id 626A79806B7; Sat, 20 Feb 2021 23:40:53 -0500 (EST) Received: from minshall-entroware-apollo.cliq.com (unknown [95.8.212.136]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by hiwela.pair.com (Postfix) with ESMTPSA id 2F06B8F0957; Sat, 20 Feb 2021 23:40:53 -0500 (EST) Received: from apollo2.minshall.org (localhost [IPv6:::1]) by minshall-entroware-apollo.cliq.com (Postfix) with ESMTP id 88F71630C4; Sun, 21 Feb 2021 07:40:50 +0300 (+03) From: Greg Minshall To: John Kitchin Subject: Re: state of the art in org-mode tables e.g. join, etc In-reply-to: Your message of "Sat, 20 Feb 2021 16:15:02 -0500." X-Mailer: MH-E 8.6+git; nmh 1.7.1; GNU Emacs 27.1 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <529054.1613882450.1@apollo2.minshall.org> Date: Sun, 21 Feb 2021 07:40:50 +0300 Message-ID: <529055.1613882450@apollo2.minshall.org> Received-SPF: softfail client-ip=209.68.5.201; envelope-from=minshall@umich.edu; helo=hiwela.pair.com X-Spam_score_int: -11 X-Spam_score: -1.2 X-Spam_bar: - X-Spam_report: (-1.2 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_NONE=0.001, SPF_SOFTFAIL=0.665 autolearn=no 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: org-mode-email Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN X-Migadu-Spam-Score: -2.27 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=fail reason="SPF not aligned (relaxed), No valid DKIM" header.from=umich.edu (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: 13D0116CBF X-Spam-Score: -2.27 X-Migadu-Scanner: scn0.migadu.com X-TUID: jP7fWG8AFQCG John, > Is there a state of the art in using org-tables as little databases > with joins and stuff? i have to admit i do all that with an R code source block. (the dplyr package has the relevant joins, e.g. dplyr::inner_join().) and, in R, ":colnames yes" as a header argument gives you header lines on results. (maybe that's ?now? for "all" languages?) Greg https://dplyr.tidyverse.org/articles/two-table.html?q=join#mutating-joins