{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![Callysto.ca Banner](https://github.com/callysto/curriculum-notebooks/blob/master/callysto-notebook-banner-top.jpg?raw=true)\n",
    "\n",
    "<a href=\"https://hub.callysto.ca/jupyter/hub/user-redirect/git-pull?repo=https%3A%2F%2Fgithub.com%2Fcallysto%2Fcurriculum-notebooks&branch=master&subPath=Mathematics/StatisticsProject/AccessingData/spotify-popularity.ipynb&depth=1\" target=\"_parent\"><img src=\"https://raw.githubusercontent.com/callysto/curriculum-notebooks/master/open-in-callysto-button.svg?sanitize=true\" width=\"123\" height=\"24\" alt=\"Open in Callysto\"/></a>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Spotify Popularity\n",
    "\n",
    "Using [Spotify data](https://spotifycharts.com/regional) we can see which songs are the most popular.\n",
    "\n",
    "To look at just Canadian data, use the url `https://spotifycharts.com/regional/ca/daily/latest`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Position</th>\n",
       "      <th>Track Name</th>\n",
       "      <th>Artist</th>\n",
       "      <th>Streams</th>\n",
       "      <th>URL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Mood (feat. Iann Dior)</td>\n",
       "      <td>24kGoldn</td>\n",
       "      <td>6261261</td>\n",
       "      <td>https://open.spotify.com/track/3tjFYV6RSFtuktY...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>WAP (feat. Megan Thee Stallion)</td>\n",
       "      <td>Cardi B</td>\n",
       "      <td>6238079</td>\n",
       "      <td>https://open.spotify.com/track/4Oun2ylbjFKMPTi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Hawái</td>\n",
       "      <td>Maluma</td>\n",
       "      <td>4934392</td>\n",
       "      <td>https://open.spotify.com/track/1yoMvmasuxZfqHE...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>Holy (feat. Chance The Rapper)</td>\n",
       "      <td>Justin Bieber</td>\n",
       "      <td>4217945</td>\n",
       "      <td>https://open.spotify.com/track/5u1n1kITHCxxp8t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>Lemonade (feat. Gunna, Don Toliver &amp; NAV)</td>\n",
       "      <td>Internet Money</td>\n",
       "      <td>4018915</td>\n",
       "      <td>https://open.spotify.com/track/7hxHWCCAIIxFLCz...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>195</td>\n",
       "      <td>196</td>\n",
       "      <td>RITMO (Bad Boys For Life)</td>\n",
       "      <td>Black Eyed Peas</td>\n",
       "      <td>677270</td>\n",
       "      <td>https://open.spotify.com/track/4NCsrTzgVfsDo8n...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>196</td>\n",
       "      <td>197</td>\n",
       "      <td>Alane</td>\n",
       "      <td>Robin Schulz</td>\n",
       "      <td>675869</td>\n",
       "      <td>https://open.spotify.com/track/2u6Jm2klS4yvAlb...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>197</td>\n",
       "      <td>198</td>\n",
       "      <td>Savage Remix (feat. Beyoncé)</td>\n",
       "      <td>Megan Thee Stallion</td>\n",
       "      <td>674390</td>\n",
       "      <td>https://open.spotify.com/track/5v4GgrXPMghOnBB...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>198</td>\n",
       "      <td>199</td>\n",
       "      <td>Mr. Brightside</td>\n",
       "      <td>The Killers</td>\n",
       "      <td>672452</td>\n",
       "      <td>https://open.spotify.com/track/003vvx7Niy0yvhv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>199</td>\n",
       "      <td>200</td>\n",
       "      <td>Quero Você do Jeito Que Quiser</td>\n",
       "      <td>Marília Mendonça</td>\n",
       "      <td>671326</td>\n",
       "      <td>https://open.spotify.com/track/64I6t2tuUGnIlaD...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Position                                 Track Name               Artist  \\\n",
       "0           1                     Mood (feat. Iann Dior)             24kGoldn   \n",
       "1           2            WAP (feat. Megan Thee Stallion)              Cardi B   \n",
       "2           3                                      Hawái               Maluma   \n",
       "3           4             Holy (feat. Chance The Rapper)        Justin Bieber   \n",
       "4           5  Lemonade (feat. Gunna, Don Toliver & NAV)       Internet Money   \n",
       "..        ...                                        ...                  ...   \n",
       "195       196                  RITMO (Bad Boys For Life)      Black Eyed Peas   \n",
       "196       197                                      Alane         Robin Schulz   \n",
       "197       198               Savage Remix (feat. Beyoncé)  Megan Thee Stallion   \n",
       "198       199                             Mr. Brightside          The Killers   \n",
       "199       200             Quero Você do Jeito Que Quiser     Marília Mendonça   \n",
       "\n",
       "     Streams                                                URL  \n",
       "0    6261261  https://open.spotify.com/track/3tjFYV6RSFtuktY...  \n",
       "1    6238079  https://open.spotify.com/track/4Oun2ylbjFKMPTi...  \n",
       "2    4934392  https://open.spotify.com/track/1yoMvmasuxZfqHE...  \n",
       "3    4217945  https://open.spotify.com/track/5u1n1kITHCxxp8t...  \n",
       "4    4018915  https://open.spotify.com/track/7hxHWCCAIIxFLCz...  \n",
       "..       ...                                                ...  \n",
       "195   677270  https://open.spotify.com/track/4NCsrTzgVfsDo8n...  \n",
       "196   675869  https://open.spotify.com/track/2u6Jm2klS4yvAlb...  \n",
       "197   674390  https://open.spotify.com/track/5v4GgrXPMghOnBB...  \n",
       "198   672452  https://open.spotify.com/track/003vvx7Niy0yvhv...  \n",
       "199   671326  https://open.spotify.com/track/64I6t2tuUGnIlaD...  \n",
       "\n",
       "[200 rows x 5 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "csv_url = 'https://spotifycharts.com/regional/global/daily/latest/download'\n",
    "\n",
    "import pandas as pd\n",
    "import requests\n",
    "import io\n",
    "\n",
    "r = requests.get(csv_url)\n",
    "df = pd.read_csv(io.StringIO(r.text), skiprows=1)\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "[![Callysto.ca License](https://github.com/callysto/curriculum-notebooks/blob/master/callysto-notebook-banner-bottom.jpg?raw=true)](https://github.com/callysto/curriculum-notebooks/blob/master/LICENSE.md)"
   ]
  }
 ],
 "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
}