Nice. What would be terrific is if this workflow (query -> pandas -> Jupyter + Visualization) got integrated seamlessly into Fava.
On Thursday, December 21, 2023 at 4:01:52 AM UTC-8 char...@gmail.com wrote: > I tend to use beancount and beanquery to extract interesting data and to > do further processing in pandas in Jupyter Notebook, where data processing > and visualization tools are very developed. > > > https://www.isabekov.pro/multiperiod-hledger-style-reports-in-beancount-pivoting-a-table/ > > I think what you are asking for is effectively pivot table subtotals. This > can be done pandas > <https://www.statology.org/pandas-pivot-table-subtotals/> > > On Thursday, December 21, 2023 at 11:51:57 AM UTC+1 t...@cyrius.com wrote: > >> bean-report is deprecated. >> >> You can do the following in bean-query: >> >> SELECT PARENT(account), position, balance WHERE account ~ >> 'Expenses:Test:' >> >> you can also use PARENT(PARENT(account)) >> >> This is for register report. For balance report, something like that: >> >> SELECT PARENT(account), SUM(position) WHERE account ~ 'Expenses:Test:' >> GROUP BY PARENT(account) >> >> (There might be more elegant ways of doing this, but the queries above >> work for me.) >> >> Martin >> >> >> * Dan Andersson <danande...@gmail.com> [2023-12-21 02:38]: >> > Hi, >> > >> > Example bean-report output: >> > >> > Expenses:Test:Foo 2 USD >> > >> > Expenses:Test:Foo 4 USD >> > >> > How can I automatically show summations for all super-accounts? For >> > example >> > >> > Expenses 6 USD >> > >> > Expenses:Test 6 USD >> > >> > Expenses:Test:Foo 2 USD >> > Expenses:Test:Foo 4 USD >> > Thanks, >> > Dan >> > >> > -- >> > 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 [1]beancount+...@googlegroups.com. >> > To view this discussion on the web visit >> > [2]https://groups.google.com/d/msgid/beancount/ff1ad476-8e0c-4cd2-ac1c- >> > 4eec19af8554n%40googlegroups.com. >> > >> > References >> > >> > 1. mailto:beancount+...@googlegroups.com >> > 2. >> https://groups.google.com/d/msgid/beancount/ff1ad476-8e0c-4cd2...@googlegroups.com?utm_medium=email&utm_source=footer >> >> <https://groups.google.com/d/msgid/beancount/ff1ad476-8e0c-4cd2-ac1c-4eec19af85...@googlegroups.com?utm_medium=email&utm_source=footer> >> >> >> -- >> Martin Michlmayr >> https://www.cyrius.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 beancount+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/02246ad4-10bb-47e6-bc3b-f76b86d7e89cn%40googlegroups.com.
