stats.ipynb

{
 "metadata": {
  "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.8.4-final"
  },
  "orig_nbformat": 2,
  "kernelspec": {
   "name": "python3",
   "display_name": "Python 3.8.4 64-bit ('listening-analysis-_rwRS6J3-py3.8': venv)",
   "metadata": {
    "interpreter": {
     "hash": "e85d407c5e6377acc22c75bda570bea5002f956bfcfcd37c4bd67d7795879c64"
    }
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2,
 "cells": [
  {
   "source": [
    "# Stats\n",
    "\n",
    "Some easy numbers about habits"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "source": [
    "# % of scrobbles with attached URIs"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "94.67%\n"
     ]
    },
    {
     "output_type": "display_data",
     "data": {
      "text/plain": "<Figure size 432x288 with 1 Axes>",
      "image/svg+xml": "<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"no\"?>\r\n<!DOCTYPE svg PUBLIC \"-//W3C//DTD SVG 1.1//EN\"\r\n  \"http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd\">\r\n<!-- Created with matplotlib (https://matplotlib.org/) -->\r\n<svg height=\"231.84pt\" version=\"1.1\" viewBox=\"0 0 302.436865 231.84\" width=\"302.436865pt\" xmlns=\"http://www.w3.org/2000/svg\" xmlns:xlink=\"http://www.w3.org/1999/xlink\">\r\n <metadata>\r\n  <rdf:RDF xmlns:cc=\"http://creativecommons.org/ns#\" xmlns:dc=\"http://purl.org/dc/elements/1.1/\" xmlns:rdf=\"http://www.w3.org/1999/02/22-rdf-syntax-ns#\">\r\n   <cc:Work>\r\n    <dc:type rdf:resource=\"http://purl.org/dc/dcmitype/StillImage\"/>\r\n    <dc:date>2021-01-31T21:11:06.218715</dc:date>\r\n    <dc:format>image/svg+xml</dc:format>\r\n    <dc:creator>\r\n     <cc:Agent>\r\n      <dc:title>Matplotlib v3.3.4, https://matplotlib.org/</dc:title>\r\n     </cc:Agent>\r\n    </dc:creator>\r\n   </cc:Work>\r\n  </rdf:RDF>\r\n </metadata>\r\n <defs>\r\n  <style type=\"text/css\">*{stroke-linecap:butt;stroke-linejoin:round;}</style>\r\n </defs>\r\n <g id=\"figure_1\">\r\n  <g id=\"patch_1\">\r\n   <path d=\"M 0 231.84 \r\nL 302.436865 231.84 \r\nL 302.436865 0 \r\nL 0 0 \r\nz\r\n\" style=\"fill:none;\"/>\r\n  </g>\r\n  <g id=\"axes_1\">\r\n   <g id=\"patch_2\">\r\n    <path d=\"M 222.508494 115.92 \r\nC 222.508494 105.110361 220.493313 94.394848 216.566431 84.323707 \r\nC 212.639548 74.252566 206.869352 65.001186 199.552144 57.044631 \r\nC 192.234936 49.088077 183.498147 42.564911 173.790414 37.810102 \r\nC 164.082681 33.055293 153.573065 30.151645 142.801241 29.248264 \r\nC 132.029418 28.344882 121.182977 29.457498 110.81889 32.528979 \r\nC 100.454804 35.60046 90.753561 40.577316 82.213328 47.203982 \r\nC 73.673095 53.830648 66.442599 61.991722 60.89313 71.268126 \r\nC 55.343661 80.544531 51.571863 90.774718 49.77142 101.433362 \r\nC 47.970977 112.092006 48.173244 122.993487 50.367834 133.578006 \r\nC 52.562424 144.162526 56.711119 154.245756 62.60088 163.309916 \r\nC 68.490641 172.374077 76.018899 180.261315 84.799073 186.566617 \r\nC 93.579246 192.871919 103.45843 197.485478 113.929321 200.170386 \r\nC 124.400212 202.855293 135.28046 203.564791 146.011359 202.262446 \r\nC 156.742257 200.960101 167.136928 197.668594 176.661598 192.556946 \r\nC 186.186268 187.445297 194.675065 180.602526 201.692085 172.380014 \r\nC 208.709105 164.157501 214.132147 154.698441 217.682734 144.488563 \r\nL 135.532494 115.92 \r\nL 222.508494 115.92 \r\nz\r\n\" style=\"fill:#1f77b4;\"/>\r\n   </g>\r\n   <g id=\"patch_3\">\r\n    <path d=\"M 217.682734 144.488563 \r\nC 219.277208 139.903578 220.485039 135.193144 221.29357 130.406631 \r\nC 222.102101 125.620118 222.508495 120.774307 222.508494 115.919986 \r\nL 135.532494 115.92 \r\nL 217.682734 144.488563 \r\nz\r\n\" style=\"fill:#ff7f0e;\"/>\r\n   </g>\r\n   <g id=\"matplotlib.axis_1\"/>\r\n   <g id=\"matplotlib.axis_2\"/>\r\n   <g id=\"text_1\">\r\n    <!-- No URI -->\r\n    <g transform=\"translate(7.2 102.744073)scale(0.1 -0.1)\">\r\n     <defs>\r\n      <path d=\"M 9.8125 72.90625 \r\nL 23.09375 72.90625 \r\nL 55.421875 11.921875 \r\nL 55.421875 72.90625 \r\nL 64.984375 72.90625 \r\nL 64.984375 0 \r\nL 51.703125 0 \r\nL 19.390625 60.984375 \r\nL 19.390625 0 \r\nL 9.8125 0 \r\nz\r\n\" id=\"DejaVuSans-78\"/>\r\n      <path d=\"M 30.609375 48.390625 \r\nQ 23.390625 48.390625 19.1875 42.75 \r\nQ 14.984375 37.109375 14.984375 27.296875 \r\nQ 14.984375 17.484375 19.15625 11.84375 \r\nQ 23.34375 6.203125 30.609375 6.203125 \r\nQ 37.796875 6.203125 41.984375 11.859375 \r\nQ 46.1875 17.53125 46.1875 27.296875 \r\nQ 46.1875 37.015625 41.984375 42.703125 \r\nQ 37.796875 48.390625 30.609375 48.390625 \r\nz\r\nM 30.609375 56 \r\nQ 42.328125 56 49.015625 48.375 \r\nQ 55.71875 40.765625 55.71875 27.296875 \r\nQ 55.71875 13.875 49.015625 6.21875 \r\nQ 42.328125 -1.421875 30.609375 -1.421875 \r\nQ 18.84375 -1.421875 12.171875 6.21875 \r\nQ 5.515625 13.875 5.515625 27.296875 \r\nQ 5.515625 40.765625 12.171875 48.375 \r\nQ 18.84375 56 30.609375 56 \r\nz\r\n\" id=\"DejaVuSans-111\"/>\r\n      <path id=\"DejaVuSans-32\"/>\r\n      <path d=\"M 8.6875 72.90625 \r\nL 18.609375 72.90625 \r\nL 18.609375 28.609375 \r\nQ 18.609375 16.890625 22.84375 11.734375 \r\nQ 27.09375 6.59375 36.625 6.59375 \r\nQ 46.09375 6.59375 50.34375 11.734375 \r\nQ 54.59375 16.890625 54.59375 28.609375 \r\nL 54.59375 72.90625 \r\nL 64.5 72.90625 \r\nL 64.5 27.390625 \r\nQ 64.5 13.140625 57.4375 5.859375 \r\nQ 50.390625 -1.421875 36.625 -1.421875 \r\nQ 22.796875 -1.421875 15.734375 5.859375 \r\nQ 8.6875 13.140625 8.6875 27.390625 \r\nz\r\n\" id=\"DejaVuSans-85\"/>\r\n      <path d=\"M 44.390625 34.1875 \r\nQ 47.5625 33.109375 50.5625 29.59375 \r\nQ 53.5625 26.078125 56.59375 19.921875 \r\nL 66.609375 0 \r\nL 56 0 \r\nL 46.6875 18.703125 \r\nQ 43.0625 26.03125 39.671875 28.421875 \r\nQ 36.28125 30.8125 30.421875 30.8125 \r\nL 19.671875 30.8125 \r\nL 19.671875 0 \r\nL 9.8125 0 \r\nL 9.8125 72.90625 \r\nL 32.078125 72.90625 \r\nQ 44.578125 72.90625 50.734375 67.671875 \r\nQ 56.890625 62.453125 56.890625 51.90625 \r\nQ 56.890625 45.015625 53.6875 40.46875 \r\nQ 50.484375 35.9375 44.390625 34.1875 \r\nz\r\nM 19.671875 64.796875 \r\nL 19.671875 38.921875 \r\nL 32.078125 38.921875 \r\nQ 39.203125 38.921875 42.84375 42.21875 \r\nQ 46.484375 45.515625 46.484375 51.90625 \r\nQ 46.484375 58.296875 42.84375 61.546875 \r\nQ 39.203125 64.796875 32.078125 64.796875 \r\nz\r\n\" id=\"DejaVuSans-82\"/>\r\n      <path d=\"M 9.8125 72.90625 \r\nL 19.671875 72.90625 \r\nL 19.671875 0 \r\nL 9.8125 0 \r\nz\r\n\" id=\"DejaVuSans-73\"/>\r\n     </defs>\r\n     <use xlink:href=\"#DejaVuSans-78\"/>\r\n     <use x=\"74.804688\" xlink:href=\"#DejaVuSans-111\"/>\r\n     <use x=\"135.986328\" xlink:href=\"#DejaVuSans-32\"/>\r\n     <use x=\"167.773438\" xlink:href=\"#DejaVuSans-85\"/>\r\n     <use x=\"240.966797\" xlink:href=\"#DejaVuSans-82\"/>\r\n     <use x=\"310.449219\" xlink:href=\"#DejaVuSans-73\"/>\r\n    </g>\r\n   </g>\r\n   <g id=\"text_2\">\r\n    <!-- Attached URI -->\r\n    <g transform=\"translate(229.869678 134.614669)scale(0.1 -0.1)\">\r\n     <defs>\r\n      <path d=\"M 34.1875 63.1875 \r\nL 20.796875 26.90625 \r\nL 47.609375 26.90625 \r\nz\r\nM 28.609375 72.90625 \r\nL 39.796875 72.90625 \r\nL 67.578125 0 \r\nL 57.328125 0 \r\nL 50.6875 18.703125 \r\nL 17.828125 18.703125 \r\nL 11.1875 0 \r\nL 0.78125 0 \r\nz\r\n\" id=\"DejaVuSans-65\"/>\r\n      <path d=\"M 18.3125 70.21875 \r\nL 18.3125 54.6875 \r\nL 36.8125 54.6875 \r\nL 36.8125 47.703125 \r\nL 18.3125 47.703125 \r\nL 18.3125 18.015625 \r\nQ 18.3125 11.328125 20.140625 9.421875 \r\nQ 21.96875 7.515625 27.59375 7.515625 \r\nL 36.8125 7.515625 \r\nL 36.8125 0 \r\nL 27.59375 0 \r\nQ 17.1875 0 13.234375 3.875 \r\nQ 9.28125 7.765625 9.28125 18.015625 \r\nL 9.28125 47.703125 \r\nL 2.6875 47.703125 \r\nL 2.6875 54.6875 \r\nL 9.28125 54.6875 \r\nL 9.28125 70.21875 \r\nz\r\n\" id=\"DejaVuSans-116\"/>\r\n      <path d=\"M 34.28125 27.484375 \r\nQ 23.390625 27.484375 19.1875 25 \r\nQ 14.984375 22.515625 14.984375 16.5 \r\nQ 14.984375 11.71875 18.140625 8.90625 \r\nQ 21.296875 6.109375 26.703125 6.109375 \r\nQ 34.1875 6.109375 38.703125 11.40625 \r\nQ 43.21875 16.703125 43.21875 25.484375 \r\nL 43.21875 27.484375 \r\nz\r\nM 52.203125 31.203125 \r\nL 52.203125 0 \r\nL 43.21875 0 \r\nL 43.21875 8.296875 \r\nQ 40.140625 3.328125 35.546875 0.953125 \r\nQ 30.953125 -1.421875 24.3125 -1.421875 \r\nQ 15.921875 -1.421875 10.953125 3.296875 \r\nQ 6 8.015625 6 15.921875 \r\nQ 6 25.140625 12.171875 29.828125 \r\nQ 18.359375 34.515625 30.609375 34.515625 \r\nL 43.21875 34.515625 \r\nL 43.21875 35.40625 \r\nQ 43.21875 41.609375 39.140625 45 \r\nQ 35.0625 48.390625 27.6875 48.390625 \r\nQ 23 48.390625 18.546875 47.265625 \r\nQ 14.109375 46.140625 10.015625 43.890625 \r\nL 10.015625 52.203125 \r\nQ 14.9375 54.109375 19.578125 55.046875 \r\nQ 24.21875 56 28.609375 56 \r\nQ 40.484375 56 46.34375 49.84375 \r\nQ 52.203125 43.703125 52.203125 31.203125 \r\nz\r\n\" id=\"DejaVuSans-97\"/>\r\n      <path d=\"M 48.78125 52.59375 \r\nL 48.78125 44.1875 \r\nQ 44.96875 46.296875 41.140625 47.34375 \r\nQ 37.3125 48.390625 33.40625 48.390625 \r\nQ 24.65625 48.390625 19.8125 42.84375 \r\nQ 14.984375 37.3125 14.984375 27.296875 \r\nQ 14.984375 17.28125 19.8125 11.734375 \r\nQ 24.65625 6.203125 33.40625 6.203125 \r\nQ 37.3125 6.203125 41.140625 7.25 \r\nQ 44.96875 8.296875 48.78125 10.40625 \r\nL 48.78125 2.09375 \r\nQ 45.015625 0.34375 40.984375 -0.53125 \r\nQ 36.96875 -1.421875 32.421875 -1.421875 \r\nQ 20.0625 -1.421875 12.78125 6.34375 \r\nQ 5.515625 14.109375 5.515625 27.296875 \r\nQ 5.515625 40.671875 12.859375 48.328125 \r\nQ 20.21875 56 33.015625 56 \r\nQ 37.15625 56 41.109375 55.140625 \r\nQ 45.0625 54.296875 48.78125 52.59375 \r\nz\r\n\" id=\"DejaVuSans-99\"/>\r\n      <path d=\"M 54.890625 33.015625 \r\nL 54.890625 0 \r\nL 45.90625 0 \r\nL 45.90625 32.71875 \r\nQ 45.90625 40.484375 42.875 44.328125 \r\nQ 39.84375 48.1875 33.796875 48.1875 \r\nQ 26.515625 48.1875 22.3125 43.546875 \r\nQ 18.109375 38.921875 18.109375 30.90625 \r\nL 18.109375 0 \r\nL 9.078125 0 \r\nL 9.078125 75.984375 \r\nL 18.109375 75.984375 \r\nL 18.109375 46.1875 \r\nQ 21.34375 51.125 25.703125 53.5625 \r\nQ 30.078125 56 35.796875 56 \r\nQ 45.21875 56 50.046875 50.171875 \r\nQ 54.890625 44.34375 54.890625 33.015625 \r\nz\r\n\" id=\"DejaVuSans-104\"/>\r\n      <path d=\"M 56.203125 29.59375 \r\nL 56.203125 25.203125 \r\nL 14.890625 25.203125 \r\nQ 15.484375 15.921875 20.484375 11.0625 \r\nQ 25.484375 6.203125 34.421875 6.203125 \r\nQ 39.59375 6.203125 44.453125 7.46875 \r\nQ 49.3125 8.734375 54.109375 11.28125 \r\nL 54.109375 2.78125 \r\nQ 49.265625 0.734375 44.1875 -0.34375 \r\nQ 39.109375 -1.421875 33.890625 -1.421875 \r\nQ 20.796875 -1.421875 13.15625 6.1875 \r\nQ 5.515625 13.8125 5.515625 26.8125 \r\nQ 5.515625 40.234375 12.765625 48.109375 \r\nQ 20.015625 56 32.328125 56 \r\nQ 43.359375 56 49.78125 48.890625 \r\nQ 56.203125 41.796875 56.203125 29.59375 \r\nz\r\nM 47.21875 32.234375 \r\nQ 47.125 39.59375 43.09375 43.984375 \r\nQ 39.0625 48.390625 32.421875 48.390625 \r\nQ 24.90625 48.390625 20.390625 44.140625 \r\nQ 15.875 39.890625 15.1875 32.171875 \r\nz\r\n\" id=\"DejaVuSans-101\"/>\r\n      <path d=\"M 45.40625 46.390625 \r\nL 45.40625 75.984375 \r\nL 54.390625 75.984375 \r\nL 54.390625 0 \r\nL 45.40625 0 \r\nL 45.40625 8.203125 \r\nQ 42.578125 3.328125 38.25 0.953125 \r\nQ 33.9375 -1.421875 27.875 -1.421875 \r\nQ 17.96875 -1.421875 11.734375 6.484375 \r\nQ 5.515625 14.40625 5.515625 27.296875 \r\nQ 5.515625 40.1875 11.734375 48.09375 \r\nQ 17.96875 56 27.875 56 \r\nQ 33.9375 56 38.25 53.625 \r\nQ 42.578125 51.265625 45.40625 46.390625 \r\nz\r\nM 14.796875 27.296875 \r\nQ 14.796875 17.390625 18.875 11.75 \r\nQ 22.953125 6.109375 30.078125 6.109375 \r\nQ 37.203125 6.109375 41.296875 11.75 \r\nQ 45.40625 17.390625 45.40625 27.296875 \r\nQ 45.40625 37.203125 41.296875 42.84375 \r\nQ 37.203125 48.484375 30.078125 48.484375 \r\nQ 22.953125 48.484375 18.875 42.84375 \r\nQ 14.796875 37.203125 14.796875 27.296875 \r\nz\r\n\" id=\"DejaVuSans-100\"/>\r\n     </defs>\r\n     <use xlink:href=\"#DejaVuSans-65\"/>\r\n     <use x=\"66.658203\" xlink:href=\"#DejaVuSans-116\"/>\r\n     <use x=\"105.867188\" xlink:href=\"#DejaVuSans-116\"/>\r\n     <use x=\"145.076172\" xlink:href=\"#DejaVuSans-97\"/>\r\n     <use x=\"206.355469\" xlink:href=\"#DejaVuSans-99\"/>\r\n     <use x=\"261.335938\" xlink:href=\"#DejaVuSans-104\"/>\r\n     <use x=\"324.714844\" xlink:href=\"#DejaVuSans-101\"/>\r\n     <use x=\"386.238281\" xlink:href=\"#DejaVuSans-100\"/>\r\n     <use x=\"449.714844\" xlink:href=\"#DejaVuSans-32\"/>\r\n     <use x=\"481.501953\" xlink:href=\"#DejaVuSans-85\"/>\r\n     <use x=\"554.695312\" xlink:href=\"#DejaVuSans-82\"/>\r\n     <use x=\"624.177734\" xlink:href=\"#DejaVuSans-73\"/>\r\n    </g>\r\n   </g>\r\n  </g>\r\n </g>\r\n</svg>\r\n",
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAS4AAADnCAYAAACg0LuLAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAV1UlEQVR4nO3deZgcVb3G8e8vMyREtrBfQKBQ2SFMWJRFIqJBSQkohE2QRUAQBURQyqteRgQsvfogV5BFNkERRQGFQgkoIYIECJKERYEHKVkEEULCEpjJTM79oyowGTKZnpnuPl1V7+d5+klP093zJs/wzqnTp06Zcw4RkSIZ5TuAiMhQqbhEpHBUXCJSOCouESkcFZeIFI6KS0QKR8UlIoWj4hKRwlFxiUjhqLhEpHBUXCJSOCouESkcFZeIFI6KS0QKR8UlIoWj4hKRwlFxiUjhqLhEpHBUXCJSOCouESkcFZeIFI6KS0QKR8UlIoWj4hKRwlFxiUjhqLhEpHBUXCJSOO2+A0hzBFFiwBrAesC6fW6Lv14LWI7sl1lb/mff+w54BZgLvAy8BDwPPJffngEeTeNwQdP+UlJZ5pzznUHqLIiS0cDWwLbAdvltK2D5Bn/rRcATwJw+tweBf6RxqB80qRsVVwkEUbIR8FHg/WQltSUw2muoJb0GzAb+CEwFZqRx2Os3khSZiquAgigZA+wO7Al8HNjYb6Ihm8/bJXZLGoep3zhSNCquggiiZGXgE8AnycpqJa+B6usx4EbgijQOH/IdRlqfiqvFBVGyI/A54EDgXZ7jNMNM4HLgF2kcvuw7jLQmFVcLykdXhwLHAuM9x/GlC7iBrMRuTeNwkd840kpUXC0kiJIdgOOAg6jG6KpWzwA/Ai5I4/BV32HEPxVXC8gPB79N9smgDGwecAHwwzQOX/CcRTxScXkURMm2ZIU12XeWglkA/Bj4bhqHL/oOI82n4vIgiJKtgTPIPiGU4XsNOI+swOZ5ziJNpOJqoiBKNgRisk8IzXOcMnkB+Eoah1f6DiLNoeJqgiBK2oATyQ4LV/Acp8ymA59P4/AR30GksVRcDRZEyTbAJcD2vrNUxELgHOCMNA5f9x1GGkPF1SBBlIwFTgdOQbtw+PAUcFIahzf4DiL1p+JqgCBKdgcuBt7rO4vwc+C4NA5f8x1E6kfFVUdBlLQD3yEbZWnyvXU8ChyQxuEc30GkPlRcdRJEyfrANcDOvrPIUr1Jduh4se8gMnIqrjoIomQP4Gpgdd9ZZFDXAJ/TqUPFpj3nRyiIkq8CN6PSKoqDgPuDKOnwHUSGTyOuYQqi5F3AZWSLSaV4XgempHH4B99BZOhUXMMQRMk4slHWTp6jyMgsBI5K4/Aq30FkaHSoOERBlKwNTEOlVQbLAT8NouQrvoPI0GjENQRBlGwA3Ebx9niXwZ0DnKKrERWDiqtGQZRsCtwKrO87izTM1cARaRwu9B1Elk3FVYMgSiYAtwBr+s4iDfd74JNpHHb7DiID0xzXIIIo2R64HZVWVewJ/CLf0UNalIprGYIoeS+QAKv4ziJNtS9wWRAlOm2rRam4BhBEyRpkhw1r+c4iXhwGnOs7hCydimsp8i1pbkSfHlbdCfmZEdJiNDnfTz63cR2wt+8s0hIc8Jk0Dn/uO4i8TSOudzoPlZa8zYDLgyjRrh8tRMXVRxAlp5JdkFWkr+WAX+bzntICdKiYC6JkJ7KLLWibZRnILcDkNA4X+Q5SdRpx8dZJ01ej0pJl+xjwdd8hRMW12E+AwHcIKYTO/JoC4lHliyuIkmOBKb5zSGGMAq4OomQd30GqrNJzXEGUbAXcC4z1nUUKZzrwYc13+VHZEVe+yPQaVFoyPBOBz/sOUVWVLS7gW8CWvkNIoZ2tQ0Y/KllcQZRsDZzsO4cU3srofEYvKldc+Rn/F6KlD1If+wdRMtl3iKqpXHEBn0UXbZX6Oj+/6pM0SaWKK4iSVYCzfeeQ0gmA032HqJJKFRfwP2h/LWmMLwdRsoXvEFVRmeIKomQT4ATfOaS02oFO3yGqojLFRfZDtZzvEFJqU4Io0RKbJqhEcQVR8j7gAN85pPQMzXU1RSWKCzgN0FVbpBmm5KeSSQOVvriCKHk32YUPRJpBo64mKH1xAacCo32HkErZT6Ouxip1ceVb7R7jO4dUjpEtvZEGKXVxAV8CtKJZfNg3iJL1fYcoq9IWVxAlY4DjfeeQympDo/2GKW1xAfsAq/oOIZV2VBAlOpm/AcpcXPokUXxbF12jsyFKWVxBlKxFdkUWEd+O8B2gjEpZXMAhaL8taQ175r9IpY7KWlw6TJRW0U72i1TqqHTFFUTJeKDDdw6RPg72HaBsSldcwGd8BxDpZ3sdLtZXGYtrL98BRPox4OO+Q5RJqYorP6F6U985RJZiT98ByqRUxQVM8h1AZAB7BFGirZXqpGzF9VHfAUQGsBrwft8hyqJsxfUR3wFElkHXX6yT0hRXfnXqtX3nEFkGzXPVyaDFZWbOzH7Q5+tTzayz1m9gZp1mdmq/x1IzWyO/32tms8zsITO70czG5Y8HZvZQrd8HzW9J69s2iJIVfYcog1pGXF3AvouLpgHecM51OOe2AuYCXxjm++xex0wijWDAeN8hyqCW4uoBLgZO7v8f8lHRn8xsjpn90cw2GGGeu4H1hvna7Ub4vUWaocN3gDKodY7rfOAQM1ul3+M/An7qnBsP/Bz4v+EGMbM2ssn13w31tfmq5P8a7vcWaaIJvgOUQU3F5Zx7BbgSOLHff9oJuDq/fxXwwaW9fKC3zf8ca2azgOfJJtdvrSVTP9sM4zUiPnT4DlAGQ/lU8YfAUcAKQ/weL/HOnUhXAubl999wznUAG5LNAQxnjkvzBlIUW2kh6sjVXFzOubnAr8jKa7G/AAfl9w8B/ryUl04H9jazlQDMbF9gtnOut9/7LyAb0Z1iZkPdS2uLIT5fxJflgc18hyi6oa7j+gHQ99PFE4AjzWwO2a4MJ/V/gXNuDnAecGd+SHgccPTS3tw59wAwh6FvA6LzE6VIOnwHKLpBRzbOuRX73P83fS735Zz7JzUsQ3DOXQRcNNj751/33d2h1otqqrikSN7nO0DRFX7lfBAl41hyFCjS6vQJ+AgVvrjQaT5SPPqZHaEyFNfqvgOIDJFGXCNUhuLSYaIUjYprhMpQXBpxSdHoUHGEVFwizfeuIEpW9h2iyFRcIn7ocHEEVFwifmjENQJlKK7+50GKFMFQT2uTPspQXOY7gMgwqLhGoAzFtdB3AJFhUHGNQBn+8VRcDbIG8/5zXPtNf9u/bdq4lXjj3b7zlMlrjF0Ez/mOUVhlKK4e3wHK6kXGrXlmz6FrntlzKNvaY38/qf2653cZ9dAm7bZoXd/Zim5lFgy0wabUoAzFpRFXE/zVbbLZ4QujzcC53UbNnvPF9hvmbWuPbzHKnM5cGJ7ewZ8iA1FxyRCZTVvUMX5adwdt9PZMHnXPzOPbf/fmZvbUeDN9xD8E+rkdARWXDFsvbe03Ltp5+xu7d2YM3W8e0HbHjKPbEjawFzrMWN53vhb3su8ARVaG4ur2HUCgi9HLX9U7acereiexIgteObxt6szD2qcuvxbzOsxK8XNWb//xHaDIzLlizxEGUXIK8H3fOWTpVmP+S8e23/TwAW3Txo3j9a3NtO4O6KZz/hjfIYqsDOu4nvYdQAY2l1VW/07PIRMndP1k/K7d5z73i54P3/G6G/M337k802hrhMpQXM/4DiC1ecatue7Xeo750JZdl2++R9d3n7yp9wPTulz7k75zeaDiGqEyzD1oxFVAj7n1N/riwpM2Aqq4RkzFNUJlKK5/ka2J0UU2C6qCa8Re8B2g6Ao/OQ8QRMkzwHq+c0j95GvEZpV0jdjZdM7/uu8QRVaGOS7Q4WLpLF4jtmd3/MHNuq4Y/Y2FR85IF619t3O86TtbHTxa6xPN7JNm5sxssz6PdZjZ5D5f72ZmOw83jJm9NtzX5q9Pzewdo+P+72tmR5jZefn9TjN71sxmmdkjZnZwn+ddYWZTlvU9VVzS8roYvfzPeiftuFv3OTtt1XXpwu8tPPCu592qM50r7Hmqfx/Ccw8G7mTJq7t3AJP7fL0bMOzi8ugc51wHsA9wkZktV+sLy1JcD/sOIM3xOmNX+nHvPrvs2HX+9tt1XTD/wp5PTH/ZrTjbOYo051FTcZnZisAHgaOAg/LHRgNnAAfmo5XTgOOAk/OvdzWzvczsHjN7wMxuM7O1F7+fmV1uZg+a2Rwz26/P9zrLzGab2Yw+z1/TzH5jZvflt13yx1c3s6lm9rCZXcII98Rzzj0OLGAIm4KWpbge8B1Amm8uq6we93x64oSui7cp0BqxlM75r9T43H2APzjnHgNeMrPtnHPdwP8Av3TOdTjnvgtcSD56cc79mWyEtqNzbgJwDfDV/P2+Ccx3zm3tnBsP/Cl/fAVghnNuG2A6cEz++Ln5++4A7Adckj9+OnCnc25L4Hpgg+H8QyxmZtsCjzvnav7QogyfKoKKq/LyNWLrfq3nGDaxp588sf26f04adf+GY6xnI9/Z+pk9hOceTFYekBXQwcD9Nbzu3cAvzWwdYDSweK3cR8lHbgDOucXnS3YDN+X37wcm9Xn+FmZvDahWzkeBE4F98/dIzGwo5132HRmfbGZHApsAew3hPcox4krj8GngJd85pDXka8R227Tryo327er8+x2946f1uFH/8p0rV1NxmdlqwO7AJWaWAl8BDrA+LbIMPwLOc85tDRwLg57wvtC9vbygl7cHNKPIRm4d+W0959xQJvLfyA9tF1sNeLHP1+fko7b9gEvNrOYT80tRXLl7fAeQ1pOvEdvtfV1XrXNE91fnzFy0yfRFzl4c/JUNc1+Nz5sCXOWc29A5Fzjn1icbOe0KvAqs1Oe5/b9eBXg2v394n8dvBb6w+AszG2xOaSpwQp/nd+R3pwOfzh/bk4Hnpu4ADs2fNxY4ALi9/5Occ78DZvbLukxlKq67fQeQVpbtIzalu3Pixl1Xjjuh+4sz/7Zogzudo9b5pnroJfufvhYHk80f9fWb/PHbyQ7hZpnZgcCNwKcWT84DncC1ZnY/S45wzgRWNbOHzGw28OFBMpwIbJ9P5D9C9iEAwLeAiWb2MNkh41MDvP4kYF8zmwXMAK51zg309z8D+LKZ1dRJpViAChBEyUeA23znkGIZQ/eb+7fdMevotpvdhvbvCQ3eR+xeOud/oIHvXxllmZyH7FCxh3L9naTBFq8R+1nvJFbgjVcPb5t6/2HtU8eszcuN2EfsHYdJMjylGXEBBFFyO9liPJERWY35L32uPXn4wLZpq4zjtfF12kfsY3TOn1qH96m8shXXl4BzfOeQclmP/zz3hfbfPrZP21/WWsHe3HyYb9MNrErn/AX1zFZVZSuu9wBP+M4h5bWJPf3kCe3X/3OPUTM3GGM97xnCS++kc/6uDQtWMaUqLoAgSh4CtvSdQ8pvgj3+6Int1z2366gHN263RYPtTvINOuef1ZRgFVDGiezfouKSJnjAbbzpkQtP27TGfcSubXrAEivjiOsDZGtGRJpugH3E5tA5fxvf2cqkjCOue4HngHV8B5Hq6X+tyf3b7pix56h7r97Fd7CSKd2ICyCIkvOB433nECE7qfi9aRxW8aIgDVOmU376ush3AJHcnSqt+itlcaVxOAf4i+8cIsCVvgOUUSmLK3eB7wBSea+jTxMboszFdS1Lnhkv0myXpnE433eIMiptcaVx2AVc5juHVFYvOv2sYUpbXLmLgEW+Q0gl/TqNw9R3iLIqdXGlcfgP4BbfOaSS/td3gDIrdXHldH6YNNvtaRzWclELGabSF1cah3cBN/vOIZXyfd8Byq70xZX7OhTqgqFSXA8Dv/cdouwqUVxpHM4CfuU7h1RClMahfkk2WCWKK/dNsj3pRRplahqHNw3+NBmpyhRXGoePA1f4ziGl1QOc7DtEVVSmuHLfArp8h5BSujCNw0d8h6iKShVXGofPAN/znUNKZy5wuu8QVVKp4sqdBTzmO4SUSmcah3N9h6iSyhVXfg7jcYM+UaQ2j6CdSJqucsUFkMbh7cDlvnNI4fUAR6RxqE+rm6ySxZU7GXjWdwgptDPSOLzPd4gqqmxx5fskHe07hxTWXcDZvkNUVWWLCyCNwz8Al/jOIYXzKvCZNA57fQepqkoXV+4kYLbvEFIoJ+oCGH6V8vJkQxVEyXuAmcCqvrNIy/t1Gof7+w5RdRpx8daGg59Gu6XKsqXAsb5DiIrrLfl8l1Y/y0BeA/bWQtPWoOJa0lnAb32HkJbjgEPTOHzQdxDJqLj6yPdROgx41HcWaSn/ncahfqG1EE3OL0UQJRsDfwbW9p1FvLs4jUPNa7UYjbiWIt+7axLZWf9SXQlwvO8Q8k4acS1DECXbA38EVvadRZruHuAjaRy+7juIvJNGXMuQxuFMIAQW+M4iTXUXMEml1bpUXINI4/BOYB+0c2pVTAM+lsbhq76DyMBUXDVI4/A2YH9goe8s0lC3ApM10mp9Kq4apXF4I7A32UJEKZ8E2CuNwzd8B5HBaXJ+iIIo6QBuAtbzHEXq5wbgwDQOu30HkdpoxDVE+cVldwS0irocLgb2V2kVi0ZcwxREycrAr8nWe0nxLAROSOPwIt9BZOhUXCMQREk7cBHwWd9ZZEieB6akcXiX7yAyPCquOgii5FTgO0C77ywyqPuAT6VxqOsNFJiKq06CKNkRuAbY0HcWGdBPgWPzS9RJgam46iiIklWBS4FP+c4iS3gVODWNw4t9B5H6UHE1QBAlnwV+CKzkOYpki0qPTuPwKd9BpH5UXA0SRMlGwJXAB31nqahXyEZZP/EdROpP67gaJL8KzIeA44AXPcepmluArVRa5aURVxPkc19nAJ8H2jzHKbOXyUZZl/kOIo2l4mqiIEq2As4FdvedpWS6gfOBb6dx+LLvMNJ4Ki4PgijZD/gBWjoxUg74DRClcfiE7zDSPCouT4IoWR44GjgFCPymKaSbgW+mcfhX30Gk+VRcnuWnDR0InAZs7TlOq3PA74Ez0zi823cY8UfF1UKCKJkMRMCuvrO0mHnAZcCPdUgooOJqSUGU7AScSLZl9FjPcXyaQzbp/rM0DrXvv7xFxdXCgihZCdgXOJTsk8gqrLtbANxINrqa7juMtCYVV0EEUbIOcDBZiU3wHKfe5pKV1fXAVG2fLINRcRVQECWbA58A9iCbDxvjN9GwPEO2ZfL1wPQ0Dnv8xpEiUXEVXBAlY4GJZKcXTQR2AEZ7DfVODngMmEF2odW7gdlpHOqHT4ZFxVUy+fqwHciWVmwObJb/2cyLe/wb+CtZSc0A7knjcF4Tv7+UnIqrIvI98jfLb5sCawKrAuPyPxffH8eSHwIsIrsYbt/bm8ALwLN9bk8CTwD/SONQl3CThlJxyRKCKDFgRfLC0tyTtCIVl4gUThXWBYlIyai4RKRwVFwiUjgqLhEpHBWXiBSOiktECkfFJSKFo+ISkcJRcYlI4ai4RKRwVFwiUjgqLhEpHBWXiBSOiktECkfFJSKFo+ISkcJRcYlI4ai4RKRwVFwiUjgqLhEpHBWXiBSOiktECkfFJSKFo+ISkcJRcYlI4ai4RKRwVFwiUjj/D0J4GA9B8vxpAAAAAElFTkSuQmCC\n"
     },
     "metadata": {}
    }
   ],
   "source": [
    "no_uri = (\n",
    "    'SELECT ' \n",
    "    '   COUNT(track) '\n",
    "    'FROM `sarsooxyz.scrobbles.*` '\n",
    "    'WHERE '\n",
    "    '  uri IS NOT NULL '\n",
    ")\n",
    "\n",
    "uri = (\n",
    "    'SELECT ' \n",
    "    '   COUNT(track) '\n",
    "    'FROM `sarsooxyz.scrobbles.*` '\n",
    ")\n",
    "\n",
    "no_uri_count = list(client.query(no_uri).result())[0][0]\n",
    "uri_count = list(client.query(uri).result())[0][0]\n",
    "\n",
    "print(f'{( no_uri_count / uri_count ) * 100:.2f}% joined tracks')\n",
    "plt.pie([no_uri_count, uri_count - no_uri_count], labels=[\"No URI\", \"Attached URI\"])\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "from google.cloud import bigquery\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "client = bigquery.Client()"
   ]
  }
 ]
}