Facebook PAC Disbursements

#!/bin/env python3
import pandas as pd
import seaborn as sns
import matplotlib.pyplot as plt

# https://pastebin.com/wMEU8ddq
t = pd.read_csv("fbpac.csv", converters={"Vote": lambda s: float(s.rstrip("%"))})
r = t.groupby(["Incumbent", "Chamber", "P.", "St.", "Vote"]).sum().reset_index()

bins = [0, 40, 50, 60, 70, 80, 90, 100]
r["Support"] = pd.cut(r["Vote"], bins, labels=bins[1:])
d = r.groupby(["Chamber", "P.", "Support"]).sum().reset_index()

g = sns.FacetGrid(d, col="Chamber", hue="P.", palette={"D": "tab:blue", "R": "tab:red"})
g.map(sns.barplot, "Support", "Amount", alpha=0.7)
g.savefig("fbpac.png")

print(r[r["Support"] <= 70].groupby(["Chamber", "P."]).sum().Amount)