Skip to content

Instantly share code, notes, and snippets.

@petehughes

petehughes/run a single query.py

Last active July 12, 2022 19:07
Show Gist options
  • Save petehughes/bb37301438a751136776a704e7e71455 to your computer and use it in GitHub Desktop.
Save petehughes/bb37301438a751136776a704e7e71455 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
run a single query.py
# assume that
# pip install matplotlib seaborn
p= %cypher match (t:Transfer) where t.numericFee is not null and t.numericFee > 0 return t.numericFee as numericFee, t.season as season
# create anew year value based on the start year of the season
p['year'] = p['season'].str[:4]
p['numericFee'] = p['numericFee'].divide(1000000)
gb = p.groupby("season").sum()
gb.plot.bar()
gb
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment