import matplotlib.pyplot as plt
import pandas as pd

df = pd.read_csv("data.tsv", index_col=0 , sep = "\t")
df = df.fillna(0)
df = df.assign(key=df["Prescription"]  + df["OTC medicines"]).sort_values("key", ascending=False)
print(df)

fig, ax = plt.subplots(figsize=(14, 8))
ax.bar(df.index, df["Prescription"] , color="#3b95d3", width=0.7, bottom=0)
ax.bar(df.index, df["OTC medicines"], color="#C0504D", width=0.7, bottom=df["Prescription"] )

ax.legend(df.columns, fontsize=20,  loc='upper right')
ax.set_axisbelow(True)

plt.rcParams['font.family'] = 'sans-serif'
plt.rcParams['font.sans-serif'] = ['Noto Sans Display']
plt.subplots_adjust(left=0.08, bottom=0.15, right=0.96, top=0.92)

plt.title("Expenditure on pharmaceuticals per capita,2022 (OECD Health stat)", fontsize=25)
plt.tick_params(labelsize=10, pad=4)
plt.xticks(df.index, rotation=70, size=11)

plt.ylabel("PPD USD/capita", size=13)
plt.ylim([0,1600])
plt.yticks(fontsize=15)
plt.margins(0.02)

plt.grid(which='major',color='#cccccc',linestyle='-', axis="y")
plt.minorticks_on()
plt.grid(which='major',color='#999999',linestyle='-', axis="y")
plt.grid(which='minor',color='#cccccc',linestyle='--', axis="y")

plt.savefig("image.svg")