I use pandas to do some analysis of my beancount file. I use beancount
query mechanism to extract interesting entries and then stuff them into
dataframe. I typed example below (beware, I didn't test it and I'm not
doing error checking)
from beancount import loader
from beancount.query import query
import pandas as pd
q = "SELECT account, date, number WHERE year = {}"
entries, errors, options_map = loader.load_file(PATH_TO_FILE)
rtypes, rrows = query.run_query(entries, options_map, q, 2019)
df = pd.DataFrame(rrows)
...
On Sunday, June 2, 2019 at 5:12:57 PM UTC+2, Chary Chary wrote:
>
> Hello everybody,
>
> I am just wondering whether there is possibility to use a broad python
> data analysis tools (like pandas) with beancount?
>
> Importing data in pandas and then analyzing it using pandas further?
>
> Or the answer is the same as with SQL, that pandas are not good for double
> entry accounting type of data?
>
--
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 post to this group, send email to beancount@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/6f381f69-20cb-4c22-8952-84936ccb065a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
