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 ms11 with LMTPS id ObZnEZ7RNmAdCwAA0tVLHw (envelope-from ) for ; Wed, 24 Feb 2021 22:22:22 +0000 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 yHSnDJ7RNmB2CQAAbx9fmQ (envelope-from ) for ; Wed, 24 Feb 2021 22:22:22 +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 6B312E571 for ; Wed, 24 Feb 2021 23:22:21 +0100 (CET) Received: from localhost ([::1]:60126 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lF2Y0-0001ON-Iu for larch@yhetil.org; Wed, 24 Feb 2021 17:22:20 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:35340) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lF2Wu-0001M7-9a for emacs-orgmode@gnu.org; Wed, 24 Feb 2021 17:21:12 -0500 Received: from mail-qk1-x72f.google.com ([2607:f8b0:4864:20::72f]:36261) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1lF2Ws-0002m2-II for emacs-orgmode@gnu.org; Wed, 24 Feb 2021 17:21:12 -0500 Received: by mail-qk1-x72f.google.com with SMTP id v206so3885005qkb.3 for ; Wed, 24 Feb 2021 14:21:09 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=sender:references:user-agent:from:to:cc:subject:in-reply-to :message-id:date:mime-version; bh=g9U+P19LwY6lmnmxa2K2WY8EoQWexdyWpPy/pv3977s=; b=nDVk98sA32jR10rFvun+4sOZ6n6OMeHHcrQCenzyO3UkIkbsSXxJYEy+vSt7njUMIX yjEQlRpUE2r7mysYdxGdCg+8aiD8/AGPkh9zYMFZVzYVuTRWxcU1IgbrLwKOywE6WttU TlRnehYlb5GeKo0tPOX7kZL7U5xwN9MeCRvnUDHKv9g3e9fNIX72aBE6qMVjhFIHyt0h 1CW9UWAj/wpUeztgHV0Gd5UJd7iA2PG+ZKbtmbI3gfxzLrbnE4jKbKiXgvJOdIAez/wB S8P7N93GvMAao7N4ymPZsmwDeeRKGtmNJ+jYvSmK3Jvf7hU/schZowhxfogxZuAs1bzV S09g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:sender:references:user-agent:from:to:cc:subject :in-reply-to:message-id:date:mime-version; bh=g9U+P19LwY6lmnmxa2K2WY8EoQWexdyWpPy/pv3977s=; b=qSv9ZWI/D4ych8+O/Tq8Ryn3jEP0jPWLvzT5mROneJsF0ygEpOMiYGS6IFTHkUQcvW RSUB+6T9oLh8MaK/h+mPIsnLs+VkRqmNF3vhMQlGy6FJBoaTf4GwWrnD8o5MDPDNyUjl gNpmgT9tCS3PFgAiWQ4DKfa9dsilHJZUimskTXPHBmoUEWtiHBbY1xddEEWuxI1rsZCJ UkJZmj89faFaNKQuOHHsoqfz1ag+1c2uqJgTOvpo6O1Ew/sXEHqRIFDFQV6g2lpv6lJb QQMbnu3jhYGNGQFQ0HmrlTNY5eLKcm9QhpfeItvU1dYTyW+prXt29lr0Ykkos21CoIPB OU2Q== X-Gm-Message-State: AOAM531rhOFUPKbtZwbCjeKxIcEk/+jFVVDOxM91FaFpyqlrvXGLl9sR 6fyS6ck3pbl4tcCC4ykpriOUAm4+jTbVnA== X-Google-Smtp-Source: ABdhPJzJl90X9+1o9Hke2DHwfr9FGSsMXevYlY5F9GCJJ4/EENRISPnqR+x9hvHALXR8i4SO3p/RyA== X-Received: by 2002:a05:620a:22e2:: with SMTP id p2mr167633qki.308.1614205268562; Wed, 24 Feb 2021 14:21:08 -0800 (PST) Received: from Johns-iMac.local ([2601:547:901:1830:b0aa:22e0:ae2b:dcba]) by smtp.gmail.com with ESMTPSA id b190sm2629919qkg.103.2021.02.24.14.21.07 (version=TLS1_2 cipher=ECDHE-ECDSA-CHACHA20-POLY1305 bits=256/256); Wed, 24 Feb 2021 14:21:08 -0800 (PST) References: <529055.1613882450@apollo2.minshall.org> <875z2lgbco.fsf@gmail.com> <87r1l8tsl5.fsf@psi.ch> User-agent: mu4e 1.4.13; emacs 27.1.90 From: John Kitchin To: Derek Feichtinger Subject: Re: state of the art in org-mode tables e.g. join, etc In-reply-to: <87r1l8tsl5.fsf@psi.ch> Message-ID: Date: Wed, 24 Feb 2021 17:21:06 -0500 MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2607:f8b0:4864:20::72f; envelope-from=johnrkitchin@gmail.com; helo=mail-qk1-x72f.google.com X-Spam_score_int: -14 X-Spam_score: -1.5 X-Spam_bar: - X-Spam_report: (-1.5 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FORGED_FROMDOMAIN=0.25, FREEMAIL_FROM=0.001, HEADER_FROM_DIFFERENT_DOMAINS=0.25, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 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: Tim Cross , emacs-orgmode@gnu.org Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN X-Migadu-Spam-Score: -1.27 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20161025 header.b=nDVk98sA; dmarc=fail reason="SPF not aligned (relaxed)" header.from=andrew.cmu.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: 6B312E571 X-Spam-Score: -1.27 X-Migadu-Scanner: scn0.migadu.com X-TUID: buJ+Nu52NQoQ Thanks for the link! It looks like some useful functions there. It would be nice to integrate some of those with the rich output of a Jupyter kernel so you could get native org tables automatically in org-mode. Derek Feichtinger writes: > Hi John, > > I invested time some years ago in preparing babel examples, and a lot of > the description went into using tables. The most detailed documents I > had for elisp and python. > > In order to be productive, e.g. for producing all kinds of scientific > graphs, but also for doing the finances and planning for our scientific > computing section I ended up the same as you with mostly going to python > and leveraging Pandas. I think all of us end up using ":colnames no" as > the most convenient solution. > > https://github.com/dfeich/org-babel-examples/blob/master/python3/python3-babel.org > > (especially look at the Pandas section 10) > > In that file I also tangle a python library "orgbabelhelper" that is > available in Conda and PyPi. I mainly use that to work with my tables. > > Best regards > Derek -- 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