Summarise github actions billing report

actions_billing_summary.py

# To use, download GitHub usage report from the organisation
# billing tab then run e.g.:
# `python actions_billing_summary.py file.csv`

import sys
import pandas as pd

actions_csv = sys.argv[1]

df = pd.read_csv(actions_csv)
df = df[df['Product'] == 'Actions']
df["Total"] = df["Quantity"] * df["Multiplier"]
df = df.groupby(["Repository Slug"]).sum()
df = df.sort_values(by=['Total'], ascending=False)
print(df)