balance histogram per community

[brenzi]

based on https://accounting.encointer.org/account-overview

• plot histogram over all balances
• label number of accounts with > 5 Leu

a quick python hack

import matplotlib.pyplot as plt
import pandas as pd
import numpy as np
data = pd.read_csv('Account_Overview_Tue, 12 Mar 2024 13_14_00 GMT_Leu Zürich.csv', sep=',',header=1, index_col =0)
fig, ax = plt.subplots()
hist = data.hist(ax=ax, bins=np.linspace(0,1000,num=100), log=True, )
nr_meaningful_accounts = data[data > 5].count().values[0]
plt.title(f"{nr_meaningful_accounts} accounts with > 5 Leu")
plt.ylim([.5,100])
plt.xlabel("balance [LEU]")
plt.ylabel("number of accounts")