live_auctions.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "import requests\n",
    "import datetime\n",
    "import pandas as pd\n",
    "\n",
    "catalog = input(\"Please enter catalog number: \")\n",
    "url = f'https://auctionsplus.com.au/auctionmanagement/api/catalogue/{catalog}'\n",
    "data = requests.get(url)\n",
    "if data.status_code == 200:\n",
    "    auctions = json.loads(data.content)\n",
    "#     with open(f\"auction_{auctions['auctionId']}.json\", 'w') as f:\n",
    "#         json.dump(auctions, f)\n",
    "\n",
    "#print(f\"Lot, Description, Head, Live wgt, Dressed wgt, Age, StartPrice, Reserve, Reserve/dressed, Town, RegionName\")\n",
    "lot_data = {}\n",
    "for mob in auctions['assessedLots']:\n",
    "    if mob['reservePrice']:\n",
    "        if not mob['age']['high'] and not mob['age']['low']:\n",
    "            if mob['dropDetail']['earliestDrop']['day']:\n",
    "                earliest = datetime.datetime(year=mob['dropDetail']['earliestDrop']['year'],\n",
    "                              month=mob['dropDetail']['earliestDrop']['month'],\n",
    "                              day=mob['dropDetail']['earliestDrop']['day'])\n",
    "            else:\n",
    "                earliest = datetime.datetime(year=mob['dropDetail']['earliestDrop']['year'],\n",
    "                                             month=mob['dropDetail']['earliestDrop']['month'], day=1)\n",
    "            if mob['dropDetail']['latestDrop']['day']:\n",
    "                latest = datetime.datetime(year=mob['dropDetail']['latestDrop']['year'],\n",
    "                              month=mob['dropDetail']['latestDrop']['month'],\n",
    "                              day=mob['dropDetail']['latestDrop']['day'])\n",
    "            else:\n",
    "                latest = datetime.datetime(year=mob['dropDetail']['latestDrop']['year'],\n",
    "                              month=mob['dropDetail']['latestDrop']['month'], day=1)\n",
    "            age = (datetime.datetime.now() - earliest).days / 365\n",
    "        else:\n",
    "            age_hi = mob['age']['high']\n",
    "            age_lo = mob['age']['low']\n",
    "            if mob['age']['rangeDescription'] == 'Months':\n",
    "                divisor = 12\n",
    "            else:\n",
    "                divisor = 1\n",
    "            if age_hi and age_lo:\n",
    "                age = (age_hi + age_lo) / 2 / divisor\n",
    "            elif age_hi and not age_lo:\n",
    "                age = age_hi / divisor\n",
    "            elif age_lo and not age_hi:\n",
    "                age = age_lo / divisor\n",
    "            else:\n",
    "                age = 'Unknown'\n",
    "        live_avg = mob['deliveryLiveWeight']['avg']\n",
    "        dressed_avg = mob['deliveryDressedWeight']['avg']\n",
    "        res_price = mob['reservePrice']\n",
    "        lot_data[mob['lotIdentifier']] = [mob['lotBestDescription'], mob['numberOfHead'], live_avg, dressed_avg, age,\n",
    "                                          mob['startPrice'], res_price, res_price / dressed_avg,\n",
    "                                          mob['deliveryLocation']['townName'], mob['deliveryLocation']['regionName']]\n",
    "\n",
    "lots = pd.DataFrame.from_dict(lot_data, orient='index',\n",
    "                              columns=[\"Description\", \"Head\", \"Live wgt\", \"Dressed wgt\", \"Age\", \"StartPrice\",\n",
    "                                       \"Reserve\", \"Reserve/dressed\", \"Town\", \"RegionName\"])\n",
    "from IPython.display import display, HTML\n",
    "\n",
    "display(HTML(lots.to_html()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}