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.
