Did either of you end up making some end to end flows with this that you'd be willing to share? I'm looking to make a pivot-table of account rollup balances over time and something like PETL would be a great fit.
On Fri, Jan 29, 2021 at 6:50 PM [email protected] <[email protected]> wrote: > Excellent find. I've been wanting to refactor my importers to separate the > source parser (ofx, csv, txt, etc.) from the transaction constructor (for > investments, banking, etc.), which can be somewhat complex and filled with > special cases, especially for investments. petl was just what I'd been > waiting for. I'll post an an importer framework I've created with it in a > minute. > > Thanks for sharing! > > On Monday, January 25, 2021 at 1:40:37 PM UTC-8 [email protected] wrote: > >> Here's another absolute source of joy: petl >> https://petl.readthedocs.io/en/stable/ >> >> While I like Pandas, I find its various attempts to leverage Python >> syntax difficult to remember and I always fumble with dataframes and >> indices. >> A while ago I wanted something more predictable, using just regular >> Python tuples and lambdas using a single chaining syntax. >> Not to do any (or much) computation, but rather, just to do CSV file >> cleanup and normalization. >> I came up with this "one-file Pandas" proof-of-concept (warning: >> not-so-great unfinished code ahead): >> https://github.com/blais/baskets/blob/master/baskets/table.py >> >> The resemblance with petl could not be overstated. >> petl is a pleasure to use if you deal with dirty tables (e.g. writing >> importers). >> I'm going to delete my half-assed table.py and start using petl library. >> I've been processing options chains all day with it and working with >> tables has never felt so liberating... >> >> Enjoy, >> >> >> On Fri, Jul 31, 2020 at 12:56 PM Red S <[email protected]> wrote: >> >>> That is indeed a killer feature, as as the diff; and the -f fixed for >>> processing command output. >>> >>> This really fills a hole in terminal processing, thanks for sharing, >>> Martin. >>> >>> Speaking of awesome terminal clients, I hope most folks are familiar >>> with tig (git ncurses client)? If not, let me say I switched to it years >>> ago, and it instantly replaced some 90% of my command line git interaction. >>> Includes fully customizable keyboard shortcuts, and arbitrary command >>> mappings. >>> >>> Also noticed Visidata allows for creating new terminal programs, and one >>> that's been created is vgit, though I haven't tried it yet (tig does >>> everything I need). >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Beancount" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> >> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/beancount/a47c6128-1536-4311-a33f-c753f4e22ecdo%40googlegroups.com >>> . >>> >> -- > You received this message because you are subscribed to the Google Groups > "Beancount" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/beancount/eb01f850-dcbb-4f2f-8af0-7585b15a92d6n%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/eb01f850-dcbb-4f2f-8af0-7585b15a92d6n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CACGEkZtgioG_77zGnbLhYoqU%3DEnmA2vPWD-cV9OMAoRK9pW3Vw%40mail.gmail.com.
