watcard A Python module for working with transaction and balance data from University of Waterloo's Watcard
Download

watcard Ranking & Summary

watcard Tags

Python library Python transaction balance

watcard Description

watcard is a Python module for working with transaction and balance data from University of Waterloo's Watcard. To access your Watcard's transaction data you must have your student ID and your Watcard PIN. To create/reset your PIN visit http://www.watcard.uwaterloo.ca/account.htmlInstallationTo install watcard: pip install watcardBasic UsageCreate a new Watcard:>>> import watcard>>> w = watcard.Watcard(userid, pin)Access mealplan and flex balances:>>> w.mealplan523.14>>> w.flex65.23Access transaction records. Optionally filter by account and date. Since tablib Datasets are returned, exporting to JSON, YAML, CSV, HTML, and Excel is easy.>>> t = w.transactions()>>> print t.csvDatetime,Amount,Account,Terminal2012-02-11 20:27:55,-3.19,mealplan,(00033)WAT-FS-V1-C-RIGHT2012-02-11 12:07:52,-2.05,mealplan,(00043)WAT-FS-REV-LEFT 2012-02-11 12:06:15,-1.0,flex,(00608)REV LAUNDRY (DRYE2012-02-11 12:06:02,-1.0,flex,(00608)REV LAUNDRY (DRYE...Access and filter balance history, which contains the balance at each date. Default interval between dates is a day.>>> bh = w.balance_history("mealplan")>>> print bh.csvDate,Balance2012-02-24,381.482012-02-23,394.29...>>> w.balance_history("mealplan", start=datetime(...))>>> w.balance_history("mealplan, coalesce="day")Calculate the mean daily expenditure for the given period of days.>>> w.mean(14)12.15>>> w.mean(14, account="mealplan")10.35>>> w.mean(14, account="flex")1.80Get information on the number of transactions per day of the week and hour.>>> p = w.punchcard(account="mealplan")>>> print p.csvMonday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday1,0,1,0,1,2,20,0,2,0,0,1,2... (one row per hour)Visualize punchard data:>>> watcard.punchcard_url(w.punchcard())'https://chart.googleapis.com/...'Product's homepage

watcard Related Software