Basic Class in Python.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# BabyPandas Class\n",
    "### We will be creating a baby version of the pandas class called BabyPandas.  This class will allow us to use Spotify data to help us to answer the question:\n",
    "- Which song had the highest number of plays in one day?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "BabyPandas -> **Class**  \n",
    "Load -> **Method**  \n",
    "Data -> **Attribute**  \n",
    "Columns -> **Attribute**\n",
    "\n",
    "Preview  \n",
    "View the first five rows -> **Method**  \n",
    "View number of rows/cols in our data -> **Method**  \n",
    "View the data types for each column -> **Method**\n",
    "\n",
    "Manipulate  \n",
    "Add new columns -> **Method**  \n",
    "Apply values to columns -> **Method**  \n",
    "Subset our data -> **Method**  \n",
    "Change the data type -> **Method**\n",
    "\n",
    "Calculations  \n",
    "Minimum -> **Method**  \n",
    "Maximum -> **Method**  \n",
    "Mean -> **Method**  \n",
    "Standard deviation -> **Method**  \n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import statistics\n",
    "\n",
    "class BabyPandas():\n",
    "    \n",
    "    def __init__(self,filename):\n",
    "        self.filename = filename\n",
    "        \n",
    "    def read_data(self):\n",
    "        file = open(self.filename,\"r\")\n",
    "        filestring = file.read()\n",
    "        stringlist = filestring.split(\"\\n\")\n",
    "        data = []\n",
    "        for row in stringlist:\n",
    "            data.append(row.split(\",\"))\n",
    "        ncol = len(data[0])\n",
    "        final_data = []\n",
    "        for row in data:\n",
    "            if len(row)==ncol:\n",
    "                final_data.append(row)\n",
    "        self.columns = final_data[0]\n",
    "        self.data = final_data\n",
    "        \n",
    "    def head(self):\n",
    "        return self.data[0:5]\n",
    "    \n",
    "    def info(self):\n",
    "        types = []\n",
    "        for col in self.data[1]:\n",
    "            types.append(type(col))\n",
    "        return types\n",
    "    \n",
    "    def shape(self):\n",
    "        nrow = 0\n",
    "        for row in self.data[1:]:\n",
    "            nrow += 1\n",
    "        ncol = len(self.data[1])\n",
    "        return (nrow, ncol)\n",
    "\n",
    "    def new_column(self,colname):\n",
    "        for pos,d in enumerate(self.data):\n",
    "            if pos==0:\n",
    "                d.append(colname)\n",
    "            else:\n",
    "                d.append(\"N/A\")\n",
    "    \n",
    "    def apply(self,index,values,row):\n",
    "        if row==True:\n",
    "            self.data[index]=values\n",
    "        else:\n",
    "            i=0\n",
    "            for row in self.data:\n",
    "                row[index] = values[i]\n",
    "                i += 1\n",
    "    \n",
    "    def subset(self,col_index,rowval):\n",
    "        # keep rows where column has rowval\n",
    "        new_data = []\n",
    "        for row in self.data:\n",
    "            if row[col_index]==rowval:\n",
    "                new_data.append(row)\n",
    "        self.data = new_data\n",
    "    \n",
    "    def change_type(self,index,new_type):\n",
    "        for row in self.data:\n",
    "            row[index] = new_type(row[index])\n",
    "            \n",
    "    def summary_stats(self,col_index):\n",
    "        col = []\n",
    "        for row in self.data:\n",
    "            col.append(row[col_index])\n",
    "        mean = statistics.mean(col)\n",
    "        median = statistics.median(col)\n",
    "        try:\n",
    "            mode = statistics.mode(col)\n",
    "        except:\n",
    "            mode = \"undefined, likely all values different\"\n",
    "        stdev = statistics.stdev(col)\n",
    "        string = \"The {} is {}.\\n\"\n",
    "        print(string.format(\"mean\",str(mean)) + string.format(\"median\",str(median)) + string.format(\"mode\",str(mode)) + string.format(\"stdev\",str(stdev)))\n",
    "        \n",
    "    def maximum(self,col_index):\n",
    "        col = []\n",
    "        for row in self.data:\n",
    "            col.append(row[col_index])\n",
    "        return max(col)\n",
    "    \n",
    "    def minimum(self,col_index):\n",
    "        col = []\n",
    "        for row in self.data:\n",
    "            col.append(row[col_index])\n",
    "        return min(col)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Test out the functionality"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "music = BabyPandas(\"music_data.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'music_data.csv'"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.filename"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "music.read_data()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['', 'Track Name', 'Artist', 'Streams', 'Date', 'Region']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.columns\n",
    "# looks like the columns are weird...oh well, \n",
    "# work around this for now"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['', 'Track Name', 'Artist', 'Streams', 'Date', 'Region'],\n",
       " ['0', 'Reggaetón Lento (Bailemos)', 'CNCO', '19272', '2017-01-01', 'ec'],\n",
       " ['1', 'Chantaje', 'Shakira', '19270', '2017-01-01', 'ec'],\n",
       " ['2',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '15761',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['3', \"Vente Pa' Ca\", 'Ricky Martin', '14954', '2017-01-01', 'ec'],\n",
       " ['4', 'Safari', 'J Balvin', '14269', '2017-01-01', 'ec'],\n",
       " ['5', 'La Bicicleta', 'Carlos Vives', '12843', '2017-01-01', 'ec'],\n",
       " ['6', 'Ay Mi Dios', 'IAmChino', '10986', '2017-01-01', 'ec'],\n",
       " ['7', 'Andas En Mi Cabeza', 'Chino & Nacho', '10653', '2017-01-01', 'ec'],\n",
       " ['8', 'Traicionera', 'Sebastian Yatra', '9807', '2017-01-01', 'ec'],\n",
       " ['9', 'Shaky Shaky', 'Daddy Yankee', '9612', '2017-01-01', 'ec'],\n",
       " ['10', 'Vacaciones', 'Wisin', '9611', '2017-01-01', 'ec'],\n",
       " ['11', 'Dile Que Tu Me Quieres', 'Ozuna', '8982', '2017-01-01', 'ec'],\n",
       " ['12', 'Let Me Love You', 'DJ Snake', '8834', '2017-01-01', 'ec'],\n",
       " ['13', 'DUELE EL CORAZON', 'Enrique Iglesias', '8309', '2017-01-01', 'ec'],\n",
       " ['14', 'Chillax', 'Farruko', '7822', '2017-01-01', 'ec'],\n",
       " ['15', 'Borro Cassette', 'Maluma', '7586', '2017-01-01', 'ec'],\n",
       " ['16', 'One Dance', 'Drake', '7472', '2017-01-01', 'ec'],\n",
       " ['17', 'Closer', 'The Chainsmokers', '7416', '2017-01-01', 'ec'],\n",
       " ['18', 'Starboy', 'The Weeknd', '7006', '2017-01-01', 'ec'],\n",
       " ['19', 'Desde Esa Noche', 'Thalía', '6779', '2017-01-01', 'ec'],\n",
       " ['20', \"Don't Wanna Know\", 'Maroon 5', '6582', '2017-01-01', 'ec'],\n",
       " ['21', 'La Gozadera', 'Gente De Zona', '6521', '2017-01-01', 'ec'],\n",
       " ['22', '24K Magic', 'Bruno Mars', '6261', '2017-01-01', 'ec'],\n",
       " ['23',\n",
       "  'Me Llamas (feat. Maluma) - Remix',\n",
       "  'Piso 21',\n",
       "  '6237',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['24', 'Cuatro Babys', 'Maluma', '6028', '2017-01-01', 'ec'],\n",
       " ['25', 'My Way', 'Calvin Harris', '5723', '2017-01-01', 'ec'],\n",
       " ['26', 'Gyal You A Party Animal', 'Charly Black', '5601', '2017-01-01', 'ec'],\n",
       " ['27', 'Baila Conmigo', 'Juan Magán', '5586', '2017-01-01', 'ec'],\n",
       " ['28',\n",
       "  'Gyal You A Party Animal - Remix',\n",
       "  'Charly Black',\n",
       "  '5541',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['29',\n",
       "  \"We Don't Talk Anymore (feat. Selena Gomez)\",\n",
       "  'Charlie Puth',\n",
       "  '5362',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['30', 'Por Fin Te Encontré', 'Cali Y El Dandee', '5259', '2017-01-01', 'ec'],\n",
       " ['31',\n",
       "  '\"CAN\\'T STOP THE FEELING! (Original Song from DreamWorks Animation\\'s \"\"TROLLS\"\")\"',\n",
       "  'Justin Timberlake',\n",
       "  '5198',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['32', 'Bailame Despacio', 'Xantos', '5160', '2017-01-01', 'ec'],\n",
       " ['33',\n",
       "  'I Took A Pill In Ibiza - Seeb Remix',\n",
       "  'Mike Posner',\n",
       "  '5025',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['34', 'Hasta el Amanecer', 'Nicky Jam', '5001', '2017-01-01', 'ec'],\n",
       " ['35',\n",
       "  'Cold Water (feat. Justin Bieber & MØ)',\n",
       "  'Major Lazer',\n",
       "  '4933',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['36', 'Bobo', 'J Balvin', '4781', '2017-01-01', 'ec'],\n",
       " ['37',\n",
       "  'Ya Me Enteré (feat. Nicky Jam) - Urban Version',\n",
       "  'Reik',\n",
       "  '4644',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['38', 'In the Name of Love', 'Martin Garrix', '4609', '2017-01-01', 'ec'],\n",
       " ['39', \"Don't Let Me Down\", 'The Chainsmokers', '4379', '2017-01-01', 'ec'],\n",
       " ['40', 'Cheap Thrills', 'Sia', '4300', '2017-01-01', 'ec'],\n",
       " ['41', 'Fuego', 'Juanes', '4286', '2017-01-01', 'ec'],\n",
       " ['42', 'Tan Fácil', 'CNCO', '4205', '2017-01-01', 'ec'],\n",
       " ['43',\n",
       "  'Rockabye (feat. Sean Paul & Anne-Marie)',\n",
       "  'Clean Bandit',\n",
       "  '4103',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['44', 'Treat You Better', 'Shawn Mendes', '3941', '2017-01-01', 'ec'],\n",
       " ['45', 'Enamorándonos', 'Cabas', '3734', '2017-01-01', 'ec'],\n",
       " ['46', 'Te Vas', 'Ozuna', '3721', '2017-01-01', 'ec'],\n",
       " ['47',\n",
       "  'No Quiere Enamorarse (Remix) [feat. Daddy Yankee]',\n",
       "  'Ozuna',\n",
       "  '3467',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['48', 'Te Quiero Pa´Mi', 'Don Omar', '3467', '2017-01-01', 'ec'],\n",
       " ['49', 'Heathens', 'Twenty One Pilots', '3376', '2017-01-01', 'ec'],\n",
       " ['50',\n",
       "  'Hasta Que Se Seque el Malecón - Remix',\n",
       "  'Jacob Forever',\n",
       "  '3368',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['52', 'Deja Que Te Bese', 'Alejandro Sanz', '3321', '2017-01-01', 'ec'],\n",
       " ['53', 'Side To Side', 'Ariana Grande', '3275', '2017-01-01', 'ec'],\n",
       " ['54', 'Manicomio', 'Cosculluela', '3180', '2017-01-01', 'ec'],\n",
       " ['55', 'Ruleta Rusa', 'Kevin Roldan', '3085', '2017-01-01', 'ec'],\n",
       " ['56', 'I Feel It Coming', 'The Weeknd', '3022', '2017-01-01', 'ec'],\n",
       " ['57', 'Ginza', 'J Balvin', '3005', '2017-01-01', 'ec'],\n",
       " ['58', 'Work', 'Rihanna', '2967', '2017-01-01', 'ec'],\n",
       " ['59', 'Cake By The Ocean', 'DNCE', '2955', '2017-01-01', 'ec'],\n",
       " ['60', 'Picky', 'Joey Montana', '2922', '2017-01-01', 'ec'],\n",
       " ['61',\n",
       "  'Light It Up (feat. Nyla & Fuse ODG) - Remix',\n",
       "  'Major Lazer',\n",
       "  '2863',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['62',\n",
       "  'This Is What You Came For',\n",
       "  'Calvin Harris',\n",
       "  '2860',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['63',\n",
       "  'Bailando - Spanish Version',\n",
       "  'Enrique Iglesias',\n",
       "  '2817',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['64',\n",
       "  'Corazon De Seda (feat. Ozuna)',\n",
       "  'Klasico',\n",
       "  '2815',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['65', 'El Perdón', 'Nicky Jam', '2801', '2017-01-01', 'ec'],\n",
       " ['66', 'El Perdedor', 'Maluma', '2684', '2017-01-01', 'ec'],\n",
       " ['67', 'Traicionera - Remix', 'Sebastian Yatra', '2663', '2017-01-01', 'ec'],\n",
       " ['68', 'Encantadora', 'Yandel', '2611', '2017-01-01', 'ec'],\n",
       " ['69', 'Ride', 'Twenty One Pilots', '2604', '2017-01-01', 'ec'],\n",
       " ['70', 'Love Yourself', 'Justin Bieber', '2581', '2017-01-01', 'ec'],\n",
       " ['71', 'Encantadora - Remix', 'Yandel', '2554', '2017-01-01', 'ec'],\n",
       " ['72', 'Materialista', 'Silvestre Dangond', '2493', '2017-01-01', 'ec'],\n",
       " ['73',\n",
       "  'Me Voy Enamorando - Remix',\n",
       "  'Chino & Nacho',\n",
       "  '2482',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['74', 'Vivir Mi Vida', 'Marc Anthony', '2446', '2017-01-01', 'ec'],\n",
       " ['75', 'Faded', 'Alan Walker', '2442', '2017-01-01', 'ec'],\n",
       " ['76', 'Work from Home', 'Fifth Harmony', '2440', '2017-01-01', 'ec'],\n",
       " ['77', 'El Perdedor - The Remix', 'Maluma', '2429', '2017-01-01', 'ec'],\n",
       " ['78', 'Stressed Out', 'Twenty One Pilots', '2370', '2017-01-01', 'ec'],\n",
       " ['79', 'De Pies a Cabeza', 'Maná', '2351', '2017-01-01', 'ec'],\n",
       " ['80', 'Quisiera', 'CNCO', '2347', '2017-01-01', 'ec'],\n",
       " ['81',\n",
       "  'Te Busco (feat. Nicky Jam)',\n",
       "  'Cosculluela',\n",
       "  '2330',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['82', 'Perfect Strangers', 'Jonas Blue', '2329', '2017-01-01', 'ec'],\n",
       " ['83',\n",
       "  'Hymn For The Weekend - Seeb Remix',\n",
       "  'Coldplay',\n",
       "  '2327',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['84', 'El Chisme', 'Reykon', '2312', '2017-01-01', 'ec'],\n",
       " ['85', 'Noche Loca', 'Marama', '2304', '2017-01-01', 'ec'],\n",
       " ['86', 'La Bicicleta - Remix', 'Carlos Vives', '2292', '2017-01-01', 'ec'],\n",
       " ['87', 'La Mordidita', 'Ricky Martin', '2290', '2017-01-01', 'ec'],\n",
       " ['89', 'Sin Contrato', 'Maluma', '2212', '2017-01-01', 'ec'],\n",
       " ['90', 'Locuras contigo', 'Rombai', '2212', '2017-01-01', 'ec'],\n",
       " ['91',\n",
       "  'Mi Tesoro (feat. Nicky Jam)',\n",
       "  'Zion & Lennox',\n",
       "  '2202',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['92', 'Trumpets', 'Sak Noel & Salvi', '2183', '2017-01-01', 'ec'],\n",
       " ['93', 'Me Rehúso', 'Danny Ocean', '2175', '2017-01-01', 'ec'],\n",
       " ['95', 'Nota de Amor', 'Wisin', '2150', '2017-01-01', 'ec'],\n",
       " ['96', 'Me Ama Me Odia', 'Ozuna', '2140', '2017-01-01', 'ec'],\n",
       " ['97',\n",
       "  'Valió la Pena - Salsa Version',\n",
       "  'Marc Anthony',\n",
       "  '2135',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['98', 'Me llamas', 'Piso 21', '2109', '2017-01-01', 'ec'],\n",
       " ['99', 'Time of Our Lives', 'Pitbull', '2101', '2017-01-01', 'ec'],\n",
       " ['100', 'Reggaetón Lento (Bailemos)', 'CNCO', '16672', '2017-01-02', 'ec'],\n",
       " ['101', 'Chantaje', 'Shakira', '15594', '2017-01-02', 'ec'],\n",
       " ['102',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '13507',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['103', 'Safari', 'J Balvin', '11958', '2017-01-02', 'ec'],\n",
       " ['104', \"Vente Pa' Ca\", 'Ricky Martin', '11590', '2017-01-02', 'ec'],\n",
       " ['105', 'Let Me Love You', 'DJ Snake', '9096', '2017-01-02', 'ec'],\n",
       " ['106', 'Ay Mi Dios', 'IAmChino', '9023', '2017-01-02', 'ec'],\n",
       " ['107', 'Traicionera', 'Sebastian Yatra', '8511', '2017-01-02', 'ec'],\n",
       " ['108', 'La Bicicleta', 'Carlos Vives', '8288', '2017-01-02', 'ec'],\n",
       " ['109', 'Vacaciones', 'Wisin', '8205', '2017-01-02', 'ec'],\n",
       " ['110', 'Closer', 'The Chainsmokers', '8075', '2017-01-02', 'ec'],\n",
       " ['111', 'Dile Que Tu Me Quieres', 'Ozuna', '8048', '2017-01-02', 'ec'],\n",
       " ['112', 'Andas En Mi Cabeza', 'Chino & Nacho', '7732', '2017-01-02', 'ec'],\n",
       " ['113', 'One Dance', 'Drake', '7437', '2017-01-02', 'ec'],\n",
       " ['114', 'Starboy', 'The Weeknd', '7330', '2017-01-02', 'ec'],\n",
       " ['115', 'Shaky Shaky', 'Daddy Yankee', '6974', '2017-01-02', 'ec'],\n",
       " ['116', 'Chillax', 'Farruko', '6905', '2017-01-02', 'ec'],\n",
       " ['117', \"Don't Wanna Know\", 'Maroon 5', '6883', '2017-01-02', 'ec'],\n",
       " ['118', 'Cuatro Babys', 'Maluma', '6370', '2017-01-02', 'ec'],\n",
       " ['119', '24K Magic', 'Bruno Mars', '6287', '2017-01-02', 'ec'],\n",
       " ['120', 'DUELE EL CORAZON', 'Enrique Iglesias', '6205', '2017-01-02', 'ec'],\n",
       " ['121', 'My Way', 'Calvin Harris', '6032', '2017-01-02', 'ec'],\n",
       " ['122',\n",
       "  'Me Llamas (feat. Maluma) - Remix',\n",
       "  'Piso 21',\n",
       "  '5875',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['123', 'Borro Cassette', 'Maluma', '5822', '2017-01-02', 'ec'],\n",
       " ['124',\n",
       "  \"We Don't Talk Anymore (feat. Selena Gomez)\",\n",
       "  'Charlie Puth',\n",
       "  '5643',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['125',\n",
       "  'I Took A Pill In Ibiza - Seeb Remix',\n",
       "  'Mike Posner',\n",
       "  '5500',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['126',\n",
       "  'Cold Water (feat. Justin Bieber & MØ)',\n",
       "  'Major Lazer',\n",
       "  '5363',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['127', 'In the Name of Love', 'Martin Garrix', '4915', '2017-01-02', 'ec'],\n",
       " ['128', 'Desde Esa Noche', 'Thalía', '4912', '2017-01-02', 'ec'],\n",
       " ['129',\n",
       "  'Gyal You A Party Animal - Remix',\n",
       "  'Charly Black',\n",
       "  '4894',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['130', 'Baila Conmigo', 'Juan Magán', '4888', '2017-01-02', 'ec'],\n",
       " ['131', \"Don't Let Me Down\", 'The Chainsmokers', '4879', '2017-01-02', 'ec'],\n",
       " ['132',\n",
       "  '\"CAN\\'T STOP THE FEELING! (Original Song from DreamWorks Animation\\'s \"\"TROLLS\"\")\"',\n",
       "  'Justin Timberlake',\n",
       "  '4762',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['133',\n",
       "  'Ya Me Enteré (feat. Nicky Jam) - Urban Version',\n",
       "  'Reik',\n",
       "  '4708',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['134', 'Bailame Despacio', 'Xantos', '4692', '2017-01-02', 'ec'],\n",
       " ['135', 'Cheap Thrills', 'Sia', '4569', '2017-01-02', 'ec'],\n",
       " ['136', 'Bobo', 'J Balvin', '4520', '2017-01-02', 'ec'],\n",
       " ['137', 'Treat You Better', 'Shawn Mendes', '4498', '2017-01-02', 'ec'],\n",
       " ['138',\n",
       "  'Gyal You A Party Animal',\n",
       "  'Charly Black',\n",
       "  '4417',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['139', 'La Gozadera', 'Gente De Zona', '4309', '2017-01-02', 'ec'],\n",
       " ['140',\n",
       "  'Rockabye (feat. Sean Paul & Anne-Marie)',\n",
       "  'Clean Bandit',\n",
       "  '4284',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['141', 'Hasta el Amanecer', 'Nicky Jam', '4149', '2017-01-02', 'ec'],\n",
       " ['142', 'Fuego', 'Juanes', '3976', '2017-01-02', 'ec'],\n",
       " ['143', 'Tan Fácil', 'CNCO', '3975', '2017-01-02', 'ec'],\n",
       " ['144', 'Heathens', 'Twenty One Pilots', '3970', '2017-01-02', 'ec'],\n",
       " ['145', 'Te Vas', 'Ozuna', '3910', '2017-01-02', 'ec'],\n",
       " ['146',\n",
       "  'Por Fin Te Encontré',\n",
       "  'Cali Y El Dandee',\n",
       "  '3751',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['147', 'Te Quiero Pa´Mi', 'Don Omar', '3618', '2017-01-02', 'ec'],\n",
       " ['149', 'I Feel It Coming', 'The Weeknd', '3484', '2017-01-02', 'ec'],\n",
       " ['150',\n",
       "  'No Quiere Enamorarse (Remix) [feat. Daddy Yankee]',\n",
       "  'Ozuna',\n",
       "  '3450',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['151', 'Side To Side', 'Ariana Grande', '3361', '2017-01-02', 'ec'],\n",
       " ['152', 'Enamorándonos', 'Cabas', '3321', '2017-01-02', 'ec'],\n",
       " ['153',\n",
       "  'This Is What You Came For',\n",
       "  'Calvin Harris',\n",
       "  '3194',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['154', 'Ride', 'Twenty One Pilots', '3126', '2017-01-02', 'ec'],\n",
       " ['155', 'Manicomio', 'Cosculluela', '3118', '2017-01-02', 'ec'],\n",
       " ['156', 'Deja Que Te Bese', 'Alejandro Sanz', '3081', '2017-01-02', 'ec'],\n",
       " ['157', 'Faded', 'Alan Walker', '3060', '2017-01-02', 'ec'],\n",
       " ['158', 'Ruleta Rusa', 'Kevin Roldan', '3052', '2017-01-02', 'ec'],\n",
       " ['159', 'Work', 'Rihanna', '3001', '2017-01-02', 'ec'],\n",
       " ['160', 'Cake By The Ocean', 'DNCE', '2996', '2017-01-02', 'ec'],\n",
       " ['161', 'Photograph', 'Ed Sheeran', '2919', '2017-01-02', 'ec'],\n",
       " ['162',\n",
       "  'Hasta Que Se Seque el Malecón - Remix',\n",
       "  'Jacob Forever',\n",
       "  '2912',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['163', 'Work from Home', 'Fifth Harmony', '2805', '2017-01-02', 'ec'],\n",
       " ['164', 'Stressed Out', 'Twenty One Pilots', '2797', '2017-01-02', 'ec'],\n",
       " ['165',\n",
       "  'Light It Up (feat. Nyla & Fuse ODG) - Remix',\n",
       "  'Major Lazer',\n",
       "  '2673',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['166', 'Love Yourself', 'Justin Bieber', '2652', '2017-01-02', 'ec'],\n",
       " ['167',\n",
       "  'Corazon De Seda (feat. Ozuna)',\n",
       "  'Klasico',\n",
       "  '2602',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['168',\n",
       "  'Hymn For The Weekend - Seeb Remix',\n",
       "  'Coldplay',\n",
       "  '2519',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['170', 'Me Rehúso', 'Danny Ocean', '2460', '2017-01-02', 'ec'],\n",
       " ['171', 'Perfect Strangers', 'Jonas Blue', '2436', '2017-01-02', 'ec'],\n",
       " ['173', 'Thinking Out Loud', 'Ed Sheeran', '2430', '2017-01-02', 'ec'],\n",
       " ['174', 'Quisiera', 'CNCO', '2429', '2017-01-02', 'ec'],\n",
       " ['175', 'Encantadora - Remix', 'Yandel', '2355', '2017-01-02', 'ec'],\n",
       " ['176', 'Bajo el agua', 'Manuel Medrano', '2344', '2017-01-02', 'ec'],\n",
       " ['177', 'El Chisme', 'Reykon', '2335', '2017-01-02', 'ec'],\n",
       " ['178', 'Traicionera - Remix', 'Sebastian Yatra', '2317', '2017-01-02', 'ec'],\n",
       " ['179', 'Me Ama Me Odia', 'Ozuna', '2293', '2017-01-02', 'ec'],\n",
       " ['180', 'Just Hold On', 'Steve Aoki', '2269', '2017-01-02', 'ec'],\n",
       " ['181', 'Que Raro', 'Feid', '2260', '2017-01-02', 'ec'],\n",
       " ['182',\n",
       "  'Te Busco (feat. Nicky Jam)',\n",
       "  'Cosculluela',\n",
       "  '2255',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['183', 'Encantadora', 'Yandel', '2238', '2017-01-02', 'ec'],\n",
       " ['184',\n",
       "  '\"I Don’t Wanna Live Forever (Fifty Shades Darker) - From \"\"Fifty Shades Darker (Original Motion Picture Soundtrack)\"\"\"',\n",
       "  'ZAYN',\n",
       "  '2220',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['185', 'Ya Me Enteré', 'Reik', '2183', '2017-01-02', 'ec'],\n",
       " ['186',\n",
       "  'Mi Tesoro (feat. Nicky Jam)',\n",
       "  'Zion & Lennox',\n",
       "  '2173',\n",
       "  '2017-01-02',\n",
       "  'ec'],\n",
       " ['187', 'Una y otra vez', 'Manuel Medrano', '2138', '2017-01-02', 'ec'],\n",
       " ['188', 'Ginza', 'J Balvin', '2135', '2017-01-02', 'ec'],\n",
       " ['189', 'Black Beatles', 'Rae Sremmurd', '2123', '2017-01-02', 'ec'],\n",
       " ['190', 'Middle', 'DJ Snake', '2119', '2017-01-02', 'ec'],\n",
       " ['191', 'The Greatest', 'Sia', '2112', '2017-01-02', 'ec'],\n",
       " ['192', 'El Perdedor - The Remix', 'Maluma', '2084', '2017-01-02', 'ec'],\n",
       " ['193', 'De Pies a Cabeza', 'Maná', '2067', '2017-01-02', 'ec'],\n",
       " ['194', 'Me llamas', 'Piso 21', '2051', '2017-01-02', 'ec'],\n",
       " ['195', \"Say You Won't Let Go\", 'James Arthur', '2051', '2017-01-02', 'ec'],\n",
       " ['196', 'All We Know', 'The Chainsmokers', '2047', '2017-01-02', 'ec'],\n",
       " ['197', 'Mercy', 'Shawn Mendes', '2038', '2017-01-02', 'ec'],\n",
       " ['198', 'El Perdedor', 'Maluma', '2035', '2017-01-02', 'ec'],\n",
       " ['199', 'Starving', 'Hailee Steinfeld', '2019', '2017-01-02', 'ec'],\n",
       " ['200', 'Reggaetón Lento (Bailemos)', 'CNCO', '17258', '2017-01-03', 'ec'],\n",
       " ['201', 'Chantaje', 'Shakira', '16614', '2017-01-03', 'ec'],\n",
       " ['202',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '14148',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['203', 'Safari', 'J Balvin', '12336', '2017-01-03', 'ec'],\n",
       " ['204', \"Vente Pa' Ca\", 'Ricky Martin', '12280', '2017-01-03', 'ec'],\n",
       " ['205', 'Let Me Love You', 'DJ Snake', '10652', '2017-01-03', 'ec'],\n",
       " ['206', 'Ay Mi Dios', 'IAmChino', '9519', '2017-01-03', 'ec'],\n",
       " ['207', 'Closer', 'The Chainsmokers', '9244', '2017-01-03', 'ec'],\n",
       " ['208', 'Vacaciones', 'Wisin', '9032', '2017-01-03', 'ec'],\n",
       " ['209', 'Traicionera', 'Sebastian Yatra', '8993', '2017-01-03', 'ec'],\n",
       " ['210', 'Starboy', 'The Weeknd', '8676', '2017-01-03', 'ec'],\n",
       " ['211', 'Dile Que Tu Me Quieres', 'Ozuna', '8425', '2017-01-03', 'ec'],\n",
       " ['212', 'One Dance', 'Drake', '8357', '2017-01-03', 'ec'],\n",
       " ['213', \"Don't Wanna Know\", 'Maroon 5', '8281', '2017-01-03', 'ec'],\n",
       " ['214', 'La Bicicleta', 'Carlos Vives', '8039', '2017-01-03', 'ec'],\n",
       " ['215', 'Andas En Mi Cabeza', 'Chino & Nacho', '7821', '2017-01-03', 'ec'],\n",
       " ['216', 'Chillax', 'Farruko', '7772', '2017-01-03', 'ec'],\n",
       " ['217', '24K Magic', 'Bruno Mars', '7395', '2017-01-03', 'ec'],\n",
       " ['218', 'My Way', 'Calvin Harris', '7229', '2017-01-03', 'ec'],\n",
       " ['219', 'Cuatro Babys', 'Maluma', '6990', '2017-01-03', 'ec'],\n",
       " ['220', 'Shaky Shaky', 'Daddy Yankee', '6854', '2017-01-03', 'ec'],\n",
       " ['221',\n",
       "  \"We Don't Talk Anymore (feat. Selena Gomez)\",\n",
       "  'Charlie Puth',\n",
       "  '6686',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['222',\n",
       "  'Cold Water (feat. Justin Bieber & MØ)',\n",
       "  'Major Lazer',\n",
       "  '6646',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['223',\n",
       "  'Me Llamas (feat. Maluma) - Remix',\n",
       "  'Piso 21',\n",
       "  '6118',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['224', 'DUELE EL CORAZON', 'Enrique Iglesias', '6106', '2017-01-03', 'ec'],\n",
       " ['225',\n",
       "  'I Took A Pill In Ibiza - Seeb Remix',\n",
       "  'Mike Posner',\n",
       "  '6050',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['226', 'Borro Cassette', 'Maluma', '5927', '2017-01-03', 'ec'],\n",
       " ['227', 'In the Name of Love', 'Martin Garrix', '5791', '2017-01-03', 'ec'],\n",
       " ['228', \"Don't Let Me Down\", 'The Chainsmokers', '5602', '2017-01-03', 'ec'],\n",
       " ['229',\n",
       "  'Rockabye (feat. Sean Paul & Anne-Marie)',\n",
       "  'Clean Bandit',\n",
       "  '5535',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['230', 'Treat You Better', 'Shawn Mendes', '5436', '2017-01-03', 'ec'],\n",
       " ['231', 'Bailame Despacio', 'Xantos', '5430', '2017-01-03', 'ec'],\n",
       " ['232',\n",
       "  '\"CAN\\'T STOP THE FEELING! (Original Song from DreamWorks Animation\\'s \"\"TROLLS\"\")\"',\n",
       "  'Justin Timberlake',\n",
       "  '5361',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['233', 'Cheap Thrills', 'Sia', '5108', '2017-01-03', 'ec'],\n",
       " ['234',\n",
       "  'Gyal You A Party Animal - Remix',\n",
       "  'Charly Black',\n",
       "  '5102',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['235',\n",
       "  'Ya Me Enteré (feat. Nicky Jam) - Urban Version',\n",
       "  'Reik',\n",
       "  '5014',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['236', 'Baila Conmigo', 'Juan Magán', '4984', '2017-01-03', 'ec'],\n",
       " ['237', 'Desde Esa Noche', 'Thalía', '4974', '2017-01-03', 'ec'],\n",
       " ['238', 'I Feel It Coming', 'The Weeknd', '4891', '2017-01-03', 'ec'],\n",
       " ['239', 'Bobo', 'J Balvin', '4629', '2017-01-03', 'ec'],\n",
       " ['240', 'Heathens', 'Twenty One Pilots', '4443', '2017-01-03', 'ec'],\n",
       " ['241',\n",
       "  'Gyal You A Party Animal',\n",
       "  'Charly Black',\n",
       "  '4442',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['242', 'Fuego', 'Juanes', '4345', '2017-01-03', 'ec'],\n",
       " ['243', 'Te Quiero Pa´Mi', 'Don Omar', '4244', '2017-01-03', 'ec'],\n",
       " ['244', 'La Gozadera', 'Gente De Zona', '4233', '2017-01-03', 'ec'],\n",
       " ['245', 'Tan Fácil', 'CNCO', '4173', '2017-01-03', 'ec'],\n",
       " ['246', 'Hasta el Amanecer', 'Nicky Jam', '4085', '2017-01-03', 'ec'],\n",
       " ['248', 'Te Vas', 'Ozuna', '3935', '2017-01-03', 'ec'],\n",
       " ['249', 'Side To Side', 'Ariana Grande', '3904', '2017-01-03', 'ec'],\n",
       " ['250',\n",
       "  'Por Fin Te Encontré',\n",
       "  'Cali Y El Dandee',\n",
       "  '3626',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['251', 'Photograph', 'Ed Sheeran', '3582', '2017-01-03', 'ec'],\n",
       " ['252',\n",
       "  'This Is What You Came For',\n",
       "  'Calvin Harris',\n",
       "  '3554',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['253', 'Ride', 'Twenty One Pilots', '3467', '2017-01-03', 'ec'],\n",
       " ['254', 'Cake By The Ocean', 'DNCE', '3448', '2017-01-03', 'ec'],\n",
       " ['255',\n",
       "  'No Quiere Enamorarse (Remix) [feat. Daddy Yankee]',\n",
       "  'Ozuna',\n",
       "  '3336',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['256', 'Enamorándonos', 'Cabas', '3327', '2017-01-03', 'ec'],\n",
       " ['257', 'Work from Home', 'Fifth Harmony', '3300', '2017-01-03', 'ec'],\n",
       " ['258', 'Deja Que Te Bese', 'Alejandro Sanz', '3254', '2017-01-03', 'ec'],\n",
       " ['259',\n",
       "  '\"I Don’t Wanna Live Forever (Fifty Shades Darker) - From \"\"Fifty Shades Darker (Original Motion Picture Soundtrack)\"\"\"',\n",
       "  'ZAYN',\n",
       "  '3191',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['260', 'Ruleta Rusa', 'Kevin Roldan', '3185', '2017-01-03', 'ec'],\n",
       " ['261', 'Faded', 'Alan Walker', '3176', '2017-01-03', 'ec'],\n",
       " ['262', 'Manicomio', 'Cosculluela', '3160', '2017-01-03', 'ec'],\n",
       " ['263', 'Work', 'Rihanna', '3105', '2017-01-03', 'ec'],\n",
       " ['264', 'Stressed Out', 'Twenty One Pilots', '3095', '2017-01-03', 'ec'],\n",
       " ['265', 'Thinking Out Loud', 'Ed Sheeran', '3076', '2017-01-03', 'ec'],\n",
       " ['266', 'Una y otra vez', 'Manuel Medrano', '3017', '2017-01-03', 'ec'],\n",
       " ['267', 'Me Rehúso', 'Danny Ocean', '3008', '2017-01-03', 'ec'],\n",
       " ['268', 'Love Yourself', 'Justin Bieber', '2997', '2017-01-03', 'ec'],\n",
       " ['269',\n",
       "  'Hymn For The Weekend - Seeb Remix',\n",
       "  'Coldplay',\n",
       "  '2946',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['270',\n",
       "  'Light It Up (feat. Nyla & Fuse ODG) - Remix',\n",
       "  'Major Lazer',\n",
       "  '2830',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['272', 'Bajo el agua', 'Manuel Medrano', '2761', '2017-01-03', 'ec'],\n",
       " ['273',\n",
       "  'Hasta Que Se Seque el Malecón - Remix',\n",
       "  'Jacob Forever',\n",
       "  '2738',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['274', 'Perfect Strangers', 'Jonas Blue', '2732', '2017-01-03', 'ec'],\n",
       " ['275', \"Say You Won't Let Go\", 'James Arthur', '2683', '2017-01-03', 'ec'],\n",
       " ['276', 'Quisiera', 'CNCO', '2651', '2017-01-03', 'ec'],\n",
       " ['277', 'Just Hold On', 'Steve Aoki', '2641', '2017-01-03', 'ec'],\n",
       " ['278', 'Ya Me Enteré', 'Reik', '2594', '2017-01-03', 'ec'],\n",
       " ['279', 'Starving', 'Hailee Steinfeld', '2588', '2017-01-03', 'ec'],\n",
       " ['281',\n",
       "  'Corazon De Seda (feat. Ozuna)',\n",
       "  'Klasico',\n",
       "  '2573',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['282', 'Que Raro', 'Feid', '2541', '2017-01-03', 'ec'],\n",
       " ['283', 'El Chisme', 'Reykon', '2538', '2017-01-03', 'ec'],\n",
       " ['284', 'All We Know', 'The Chainsmokers', '2523', '2017-01-03', 'ec'],\n",
       " ['285', 'Black Beatles', 'Rae Sremmurd', '2502', '2017-01-03', 'ec'],\n",
       " ['286', 'Encantadora - Remix', 'Yandel', '2491', '2017-01-03', 'ec'],\n",
       " ['287', 'Dueles', 'Jesse & Joy', '2464', '2017-01-03', 'ec'],\n",
       " ['288', 'Encantadora', 'Yandel', '2455', '2017-01-03', 'ec'],\n",
       " ['289', 'Mercy', 'Shawn Mendes', '2425', '2017-01-03', 'ec'],\n",
       " ['290', 'The Greatest', 'Sia', '2411', '2017-01-03', 'ec'],\n",
       " ['291', 'Middle', 'DJ Snake', '2361', '2017-01-03', 'ec'],\n",
       " ['292', 'Fake Love', 'Drake', '2357', '2017-01-03', 'ec'],\n",
       " ['293',\n",
       "  'Mi Tesoro (feat. Nicky Jam)',\n",
       "  'Zion & Lennox',\n",
       "  '2355',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['294', 'Traicionera - Remix', 'Sebastian Yatra', '2296', '2017-01-03', 'ec'],\n",
       " ['295', 'Me Ama Me Odia', 'Ozuna', '2234', '2017-01-03', 'ec'],\n",
       " ['296', 'Me llamas', 'Piso 21', '2227', '2017-01-03', 'ec'],\n",
       " ['297',\n",
       "  'Te Busco (feat. Nicky Jam)',\n",
       "  'Cosculluela',\n",
       "  '2165',\n",
       "  '2017-01-03',\n",
       "  'ec'],\n",
       " ['298', 'El Perdedor - The Remix', 'Maluma', '2159', '2017-01-03', 'ec'],\n",
       " ['299', 'The Scientist', 'Coldplay', '2151', '2017-01-03', 'ec'],\n",
       " ['300', 'Reggaetón Lento (Bailemos)', 'CNCO', '18146', '2017-01-04', 'ec'],\n",
       " ['301', 'Chantaje', 'Shakira', '16582', '2017-01-04', 'ec'],\n",
       " ['302',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '14602',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['303', \"Vente Pa' Ca\", 'Ricky Martin', '12413', '2017-01-04', 'ec'],\n",
       " ['304', 'Safari', 'J Balvin', '12386', '2017-01-04', 'ec'],\n",
       " ['305', 'Let Me Love You', 'DJ Snake', '11303', '2017-01-04', 'ec'],\n",
       " ['306', 'Ay Mi Dios', 'IAmChino', '10134', '2017-01-04', 'ec'],\n",
       " ['307', 'Closer', 'The Chainsmokers', '9747', '2017-01-04', 'ec'],\n",
       " ['308', 'Vacaciones', 'Wisin', '9544', '2017-01-04', 'ec'],\n",
       " ['309', 'Traicionera', 'Sebastian Yatra', '9073', '2017-01-04', 'ec'],\n",
       " ['310', 'Starboy', 'The Weeknd', '8903', '2017-01-04', 'ec'],\n",
       " ['311', 'Dile Que Tu Me Quieres', 'Ozuna', '8808', '2017-01-04', 'ec'],\n",
       " ['312', \"Don't Wanna Know\", 'Maroon 5', '8241', '2017-01-04', 'ec'],\n",
       " ['313', '24K Magic', 'Bruno Mars', '7978', '2017-01-04', 'ec'],\n",
       " ['314', 'One Dance', 'Drake', '7901', '2017-01-04', 'ec'],\n",
       " ['315', 'La Bicicleta', 'Carlos Vives', '7794', '2017-01-04', 'ec'],\n",
       " ['316', 'Chillax', 'Farruko', '7708', '2017-01-04', 'ec'],\n",
       " ['317', 'Andas En Mi Cabeza', 'Chino & Nacho', '7621', '2017-01-04', 'ec'],\n",
       " ['318', 'My Way', 'Calvin Harris', '7338', '2017-01-04', 'ec'],\n",
       " ['319', 'Cuatro Babys', 'Maluma', '7116', '2017-01-04', 'ec'],\n",
       " ['320',\n",
       "  'Cold Water (feat. Justin Bieber & MØ)',\n",
       "  'Major Lazer',\n",
       "  '6856',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['321',\n",
       "  'Me Llamas (feat. Maluma) - Remix',\n",
       "  'Piso 21',\n",
       "  '6757',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['322', 'Shaky Shaky', 'Daddy Yankee', '6700', '2017-01-04', 'ec'],\n",
       " ['323',\n",
       "  \"We Don't Talk Anymore (feat. Selena Gomez)\",\n",
       "  'Charlie Puth',\n",
       "  '6466',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['324', 'In the Name of Love', 'Martin Garrix', '6358', '2017-01-04', 'ec'],\n",
       " ['325',\n",
       "  'Rockabye (feat. Sean Paul & Anne-Marie)',\n",
       "  'Clean Bandit',\n",
       "  '6240',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['326',\n",
       "  'I Took A Pill In Ibiza - Seeb Remix',\n",
       "  'Mike Posner',\n",
       "  '6153',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['327', 'DUELE EL CORAZON', 'Enrique Iglesias', '5814', '2017-01-04', 'ec'],\n",
       " ['328', 'Bailame Despacio', 'Xantos', '5798', '2017-01-04', 'ec'],\n",
       " ['329', 'I Feel It Coming', 'The Weeknd', '5772', '2017-01-04', 'ec'],\n",
       " ['330', 'Borro Cassette', 'Maluma', '5706', '2017-01-04', 'ec'],\n",
       " ['331', \"Don't Let Me Down\", 'The Chainsmokers', '5623', '2017-01-04', 'ec'],\n",
       " ['332', 'Treat You Better', 'Shawn Mendes', '5445', '2017-01-04', 'ec'],\n",
       " ['333',\n",
       "  'Gyal You A Party Animal - Remix',\n",
       "  'Charly Black',\n",
       "  '5429',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['334',\n",
       "  '\"CAN\\'T STOP THE FEELING! (Original Song from DreamWorks Animation\\'s \"\"TROLLS\"\")\"',\n",
       "  'Justin Timberlake',\n",
       "  '5272',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['335', 'Cheap Thrills', 'Sia', '5137', '2017-01-04', 'ec'],\n",
       " ['336',\n",
       "  'Ya Me Enteré (feat. Nicky Jam) - Urban Version',\n",
       "  'Reik',\n",
       "  '5100',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['337', 'Side To Side', 'Ariana Grande', '4993', '2017-01-04', 'ec'],\n",
       " ['338', 'Te Quiero Pa´Mi', 'Don Omar', '4791', '2017-01-04', 'ec'],\n",
       " ['339', 'Desde Esa Noche', 'Thalía', '4742', '2017-01-04', 'ec'],\n",
       " ['340', 'Heathens', 'Twenty One Pilots', '4699', '2017-01-04', 'ec'],\n",
       " ['341', 'Baila Conmigo', 'Juan Magán', '4686', '2017-01-04', 'ec'],\n",
       " ['342', 'Bobo', 'J Balvin', '4557', '2017-01-04', 'ec'],\n",
       " ['343', 'Fuego', 'Juanes', '4483', '2017-01-04', 'ec'],\n",
       " ['345', 'Tan Fácil', 'CNCO', '4289', '2017-01-04', 'ec'],\n",
       " ['346',\n",
       "  'This Is What You Came For',\n",
       "  'Calvin Harris',\n",
       "  '4236',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['347',\n",
       "  'Gyal You A Party Animal',\n",
       "  'Charly Black',\n",
       "  '4219',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['348', 'La Gozadera', 'Gente De Zona', '4105', '2017-01-04', 'ec'],\n",
       " ['349', 'Te Vas', 'Ozuna', '4103', '2017-01-04', 'ec'],\n",
       " ['350', 'Hasta el Amanecer', 'Nicky Jam', '3974', '2017-01-04', 'ec'],\n",
       " ['351', 'Photograph', 'Ed Sheeran', '3566', '2017-01-04', 'ec'],\n",
       " ['352',\n",
       "  '\"I Don’t Wanna Live Forever (Fifty Shades Darker) - From \"\"Fifty Shades Darker (Original Motion Picture Soundtrack)\"\"\"',\n",
       "  'ZAYN',\n",
       "  '3551',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['353', 'Just Hold On', 'Steve Aoki', '3445', '2017-01-04', 'ec'],\n",
       " ['354', 'Ride', 'Twenty One Pilots', '3420', '2017-01-04', 'ec'],\n",
       " ['355', 'Ruleta Rusa', 'Kevin Roldan', '3405', '2017-01-04', 'ec'],\n",
       " ['356', 'Cake By The Ocean', 'DNCE', '3344', '2017-01-04', 'ec'],\n",
       " ['357', 'Manicomio', 'Cosculluela', '3336', '2017-01-04', 'ec'],\n",
       " ['358', 'Work from Home', 'Fifth Harmony', '3327', '2017-01-04', 'ec'],\n",
       " ['359',\n",
       "  'No Quiere Enamorarse (Remix) [feat. Daddy Yankee]',\n",
       "  'Ozuna',\n",
       "  '3257',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['360', 'Deja Que Te Bese', 'Alejandro Sanz', '3243', '2017-01-04', 'ec'],\n",
       " ['361', 'Thinking Out Loud', 'Ed Sheeran', '3211', '2017-01-04', 'ec'],\n",
       " ['362',\n",
       "  'Por Fin Te Encontré',\n",
       "  'Cali Y El Dandee',\n",
       "  '3158',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['363',\n",
       "  'Hymn For The Weekend - Seeb Remix',\n",
       "  'Coldplay',\n",
       "  '3141',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['364', 'Work', 'Rihanna', '3090', '2017-01-04', 'ec'],\n",
       " ['365', 'Faded', 'Alan Walker', '3074', '2017-01-04', 'ec'],\n",
       " ['366', 'Stressed Out', 'Twenty One Pilots', '3060', '2017-01-04', 'ec'],\n",
       " ['367', 'Enamorándonos', 'Cabas', '2986', '2017-01-04', 'ec'],\n",
       " ['368', 'Una y otra vez', 'Manuel Medrano', '2969', '2017-01-04', 'ec'],\n",
       " ['369', 'Me Rehúso', 'Danny Ocean', '2949', '2017-01-04', 'ec'],\n",
       " ['370', 'Bajo el agua', 'Manuel Medrano', '2944', '2017-01-04', 'ec'],\n",
       " ['371', \"Say You Won't Let Go\", 'James Arthur', '2940', '2017-01-04', 'ec'],\n",
       " ['372', 'Que Raro', 'Feid', '2891', '2017-01-04', 'ec'],\n",
       " ['373', 'Love Yourself', 'Justin Bieber', '2873', '2017-01-04', 'ec'],\n",
       " ['375',\n",
       "  'Hasta Que Se Seque el Malecón - Remix',\n",
       "  'Jacob Forever',\n",
       "  '2843',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['376', 'El Chisme', 'Reykon', '2838', '2017-01-04', 'ec'],\n",
       " ['377', 'Ya Me Enteré', 'Reik', '2814', '2017-01-04', 'ec'],\n",
       " ['378',\n",
       "  'Light It Up (feat. Nyla & Fuse ODG) - Remix',\n",
       "  'Major Lazer',\n",
       "  '2782',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['379', 'Encantadora - Remix', 'Yandel', '2757', '2017-01-04', 'ec'],\n",
       " ['380', 'All We Know', 'The Chainsmokers', '2713', '2017-01-04', 'ec'],\n",
       " ['381', 'Mercy', 'Shawn Mendes', '2679', '2017-01-04', 'ec'],\n",
       " ['382', 'Perfect Strangers', 'Jonas Blue', '2665', '2017-01-04', 'ec'],\n",
       " ['383', 'Quisiera', 'CNCO', '2644', '2017-01-04', 'ec'],\n",
       " ['384', 'Traicionera - Remix', 'Sebastian Yatra', '2644', '2017-01-04', 'ec'],\n",
       " ['385', 'By Your Side', 'Jonas Blue', '2620', '2017-01-04', 'ec'],\n",
       " ['386',\n",
       "  'Mi Tesoro (feat. Nicky Jam)',\n",
       "  'Zion & Lennox',\n",
       "  '2605',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['387', 'Starving', 'Hailee Steinfeld', '2534', '2017-01-04', 'ec'],\n",
       " ['388', 'Hear Me Now', 'Alok', '2518', '2017-01-04', 'ec'],\n",
       " ['389',\n",
       "  'Call On Me - Ryan Riback Extended Remix',\n",
       "  'Starley',\n",
       "  '2503',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['391', 'Black Beatles', 'Rae Sremmurd', '2495', '2017-01-04', 'ec'],\n",
       " ['392',\n",
       "  'Corazon De Seda (feat. Ozuna)',\n",
       "  'Klasico',\n",
       "  '2489',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['393', 'Fake Love', 'Drake', '2455', '2017-01-04', 'ec'],\n",
       " ['394',\n",
       "  'Quiero Que Vuelvas',\n",
       "  'Alejandro Fernandez',\n",
       "  '2436',\n",
       "  '2017-01-04',\n",
       "  'ec'],\n",
       " ['395', 'The Greatest', 'Sia', '2417', '2017-01-04', 'ec'],\n",
       " ['396', 'Middle', 'DJ Snake', '2338', '2017-01-04', 'ec'],\n",
       " ['397', 'Shed a Light', 'Robin Schulz', '2318', '2017-01-04', 'ec'],\n",
       " ['398', 'Para Enamorarte', 'CNCO', '2305', '2017-01-04', 'ec'],\n",
       " ['399', 'Me Ama Me Odia', 'Ozuna', '2292', '2017-01-04', 'ec'],\n",
       " ['400', 'Reggaetón Lento (Bailemos)', 'CNCO', '17788', '2017-01-05', 'ec'],\n",
       " ['401', 'Chantaje', 'Shakira', '16254', '2017-01-05', 'ec'],\n",
       " ['402',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '14529',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['403', \"Vente Pa' Ca\", 'Ricky Martin', '12337', '2017-01-05', 'ec'],\n",
       " ['404', 'Safari', 'J Balvin', '12102', '2017-01-05', 'ec'],\n",
       " ['405', 'Let Me Love You', 'DJ Snake', '10765', '2017-01-05', 'ec'],\n",
       " ['406', 'Ay Mi Dios', 'IAmChino', '10379', '2017-01-05', 'ec'],\n",
       " ['407', 'Vacaciones', 'Wisin', '9666', '2017-01-05', 'ec'],\n",
       " ['408', 'Closer', 'The Chainsmokers', '9384', '2017-01-05', 'ec'],\n",
       " ['409', 'Traicionera', 'Sebastian Yatra', '8874', '2017-01-05', 'ec'],\n",
       " ['410', 'Dile Que Tu Me Quieres', 'Ozuna', '8307', '2017-01-05', 'ec'],\n",
       " ['411', 'Starboy', 'The Weeknd', '8305', '2017-01-05', 'ec'],\n",
       " ['412', \"Don't Wanna Know\", 'Maroon 5', '8162', '2017-01-05', 'ec'],\n",
       " ['413', 'Chillax', 'Farruko', '7900', '2017-01-05', 'ec'],\n",
       " ['414', 'Cuatro Babys', 'Maluma', '7749', '2017-01-05', 'ec'],\n",
       " ['415', 'La Bicicleta', 'Carlos Vives', '7706', '2017-01-05', 'ec'],\n",
       " ['416', 'My Way', 'Calvin Harris', '7578', '2017-01-05', 'ec'],\n",
       " ['417', 'One Dance', 'Drake', '7569', '2017-01-05', 'ec'],\n",
       " ['418', 'Andas En Mi Cabeza', 'Chino & Nacho', '7523', '2017-01-05', 'ec'],\n",
       " ['419', '24K Magic', 'Bruno Mars', '7399', '2017-01-05', 'ec'],\n",
       " ['420', 'Shaky Shaky', 'Daddy Yankee', '6594', '2017-01-05', 'ec'],\n",
       " ['421',\n",
       "  'Me Llamas (feat. Maluma) - Remix',\n",
       "  'Piso 21',\n",
       "  '6483',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['422',\n",
       "  'Cold Water (feat. Justin Bieber & MØ)',\n",
       "  'Major Lazer',\n",
       "  '6360',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['423', 'In the Name of Love', 'Martin Garrix', '6279', '2017-01-05', 'ec'],\n",
       " ['424',\n",
       "  \"We Don't Talk Anymore (feat. Selena Gomez)\",\n",
       "  'Charlie Puth',\n",
       "  '6221',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['425',\n",
       "  'Rockabye (feat. Sean Paul & Anne-Marie)',\n",
       "  'Clean Bandit',\n",
       "  '6107',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['426',\n",
       "  'I Took A Pill In Ibiza - Seeb Remix',\n",
       "  'Mike Posner',\n",
       "  '5966',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['427', 'Bailame Despacio', 'Xantos', '5826', '2017-01-05', 'ec'],\n",
       " ['428', 'DUELE EL CORAZON', 'Enrique Iglesias', '5822', '2017-01-05', 'ec'],\n",
       " ['429', 'Borro Cassette', 'Maluma', '5782', '2017-01-05', 'ec'],\n",
       " ['430', 'I Feel It Coming', 'The Weeknd', '5730', '2017-01-05', 'ec'],\n",
       " ['431', 'Treat You Better', 'Shawn Mendes', '5460', '2017-01-05', 'ec'],\n",
       " ['432',\n",
       "  'Ya Me Enteré (feat. Nicky Jam) - Urban Version',\n",
       "  'Reik',\n",
       "  '5407',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['433',\n",
       "  'Gyal You A Party Animal - Remix',\n",
       "  'Charly Black',\n",
       "  '5265',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['434', \"Don't Let Me Down\", 'The Chainsmokers', '5106', '2017-01-05', 'ec'],\n",
       " ['435', 'Side To Side', 'Ariana Grande', '5070', '2017-01-05', 'ec'],\n",
       " ['436',\n",
       "  '\"CAN\\'T STOP THE FEELING! (Original Song from DreamWorks Animation\\'s \"\"TROLLS\"\")\"',\n",
       "  'Justin Timberlake',\n",
       "  '5066',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['437', 'Cheap Thrills', 'Sia', '4922', '2017-01-05', 'ec'],\n",
       " ['438', 'Heathens', 'Twenty One Pilots', '4855', '2017-01-05', 'ec'],\n",
       " ['439', 'Desde Esa Noche', 'Thalía', '4727', '2017-01-05', 'ec'],\n",
       " ['440', 'Bobo', 'J Balvin', '4714', '2017-01-05', 'ec'],\n",
       " ['441',\n",
       "  'This Is What You Came For',\n",
       "  'Calvin Harris',\n",
       "  '4544',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['442', 'Te Quiero Pa´Mi', 'Don Omar', '4430', '2017-01-05', 'ec'],\n",
       " ['443', 'Baila Conmigo', 'Juan Magán', '4420', '2017-01-05', 'ec'],\n",
       " ['444', 'Fuego', 'Juanes', '4396', '2017-01-05', 'ec'],\n",
       " ['446', 'Tan Fácil', 'CNCO', '4252', '2017-01-05', 'ec'],\n",
       " ['447',\n",
       "  'Gyal You A Party Animal',\n",
       "  'Charly Black',\n",
       "  '4243',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['448', 'La Gozadera', 'Gente De Zona', '4070', '2017-01-05', 'ec'],\n",
       " ['449', 'Just Hold On', 'Steve Aoki', '4006', '2017-01-05', 'ec'],\n",
       " ['450', 'Te Vas', 'Ozuna', '3998', '2017-01-05', 'ec'],\n",
       " ['451', 'Hasta el Amanecer', 'Nicky Jam', '3700', '2017-01-05', 'ec'],\n",
       " ['452', 'Photograph', 'Ed Sheeran', '3608', '2017-01-05', 'ec'],\n",
       " ['453',\n",
       "  '\"I Don’t Wanna Live Forever (Fifty Shades Darker) - From \"\"Fifty Shades Darker (Original Motion Picture Soundtrack)\"\"\"',\n",
       "  'ZAYN',\n",
       "  '3596',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['454', 'Cake By The Ocean', 'DNCE', '3446', '2017-01-05', 'ec'],\n",
       " ['455', 'Ruleta Rusa', 'Kevin Roldan', '3302', '2017-01-05', 'ec'],\n",
       " ['456', 'Manicomio', 'Cosculluela', '3296', '2017-01-05', 'ec'],\n",
       " ['457', 'Deja Que Te Bese', 'Alejandro Sanz', '3273', '2017-01-05', 'ec'],\n",
       " ['458', 'Thinking Out Loud', 'Ed Sheeran', '3258', '2017-01-05', 'ec'],\n",
       " ['459', 'Faded', 'Alan Walker', '3235', '2017-01-05', 'ec'],\n",
       " ['460', 'Me Rehúso', 'Danny Ocean', '3228', '2017-01-05', 'ec'],\n",
       " ['461', 'Ride', 'Twenty One Pilots', '3180', '2017-01-05', 'ec'],\n",
       " ['462',\n",
       "  'No Quiere Enamorarse (Remix) [feat. Daddy Yankee]',\n",
       "  'Ozuna',\n",
       "  '3119',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['463', 'Stressed Out', 'Twenty One Pilots', '3084', '2017-01-05', 'ec'],\n",
       " ['464',\n",
       "  'Hymn For The Weekend - Seeb Remix',\n",
       "  'Coldplay',\n",
       "  '3078',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['465', 'Ya Me Enteré', 'Reik', '3040', '2017-01-05', 'ec'],\n",
       " ['466', 'Una y otra vez', 'Manuel Medrano', '2980', '2017-01-05', 'ec'],\n",
       " ['467',\n",
       "  'Por Fin Te Encontré',\n",
       "  'Cali Y El Dandee',\n",
       "  '2970',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['468',\n",
       "  'Hasta Que Se Seque el Malecón - Remix',\n",
       "  'Jacob Forever',\n",
       "  '2964',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['469',\n",
       "  'Call On Me - Ryan Riback Extended Remix',\n",
       "  'Starley',\n",
       "  '2960',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['471', 'Work from Home', 'Fifth Harmony', '2923', '2017-01-05', 'ec'],\n",
       " ['472', 'Enamorándonos', 'Cabas', '2919', '2017-01-05', 'ec'],\n",
       " ['473', 'Love Yourself', 'Justin Bieber', '2910', '2017-01-05', 'ec'],\n",
       " ['474', 'Work', 'Rihanna', '2869', '2017-01-05', 'ec'],\n",
       " ['475', 'Bajo el agua', 'Manuel Medrano', '2825', '2017-01-05', 'ec'],\n",
       " ['476', 'Encantadora - Remix', 'Yandel', '2811', '2017-01-05', 'ec'],\n",
       " ['477', 'El Chisme', 'Reykon', '2804', '2017-01-05', 'ec'],\n",
       " ['478', 'Quisiera', 'CNCO', '2799', '2017-01-05', 'ec'],\n",
       " ['479',\n",
       "  'Light It Up (feat. Nyla & Fuse ODG) - Remix',\n",
       "  'Major Lazer',\n",
       "  '2788',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['480', \"Say You Won't Let Go\", 'James Arthur', '2778', '2017-01-05', 'ec'],\n",
       " ['481', 'Hear Me Now', 'Alok', '2748', '2017-01-05', 'ec'],\n",
       " ['482', 'All We Know', 'The Chainsmokers', '2677', '2017-01-05', 'ec'],\n",
       " ['484', 'Que Raro', 'Feid', '2646', '2017-01-05', 'ec'],\n",
       " ['485',\n",
       "  'Corazon De Seda (feat. Ozuna)',\n",
       "  'Klasico',\n",
       "  '2595',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['486', 'Starving', 'Hailee Steinfeld', '2571', '2017-01-05', 'ec'],\n",
       " ['487',\n",
       "  'Mi Tesoro (feat. Nicky Jam)',\n",
       "  'Zion & Lennox',\n",
       "  '2567',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['488', 'Shed a Light', 'Robin Schulz', '2541', '2017-01-05', 'ec'],\n",
       " ['489', 'Perfect Strangers', 'Jonas Blue', '2515', '2017-01-05', 'ec'],\n",
       " ['490',\n",
       "  'Quiero Que Vuelvas',\n",
       "  'Alejandro Fernandez',\n",
       "  '2506',\n",
       "  '2017-01-05',\n",
       "  'ec'],\n",
       " ['491', 'By Your Side', 'Jonas Blue', '2505', '2017-01-05', 'ec'],\n",
       " ['492', 'Black Beatles', 'Rae Sremmurd', '2500', '2017-01-05', 'ec'],\n",
       " ['493', 'Mercy', 'Shawn Mendes', '2475', '2017-01-05', 'ec'],\n",
       " ['494', 'Too Good', 'Drake', '2455', '2017-01-05', 'ec'],\n",
       " ['495', 'The Greatest', 'Sia', '2395', '2017-01-05', 'ec'],\n",
       " ['496', 'Traicionera - Remix', 'Sebastian Yatra', '2395', '2017-01-05', 'ec'],\n",
       " ['497', 'Fake Love', 'Drake', '2389', '2017-01-05', 'ec'],\n",
       " ['498', 'Me Ama Me Odia', 'Ozuna', '2369', '2017-01-05', 'ec'],\n",
       " ['499', 'El Perdedor - The Remix', 'Maluma', '2328', '2017-01-05', 'ec'],\n",
       " ['500', 'Reggaetón Lento (Bailemos)', 'CNCO', '18579', '2017-01-06', 'ec'],\n",
       " ['501', 'Chantaje', 'Shakira', '17215', '2017-01-06', 'ec'],\n",
       " ['502',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '15447',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['503', \"Vente Pa' Ca\", 'Ricky Martin', '12770', '2017-01-06', 'ec'],\n",
       " ['504', 'Safari', 'J Balvin', '12766', '2017-01-06', 'ec'],\n",
       " ['505', 'Ay Mi Dios', 'IAmChino', '10841', '2017-01-06', 'ec'],\n",
       " ['506', 'Let Me Love You', 'DJ Snake', '10578', '2017-01-06', 'ec'],\n",
       " ['507', 'Vacaciones', 'Wisin', '10318', '2017-01-06', 'ec'],\n",
       " ['508', 'Traicionera', 'Sebastian Yatra', '9457', '2017-01-06', 'ec'],\n",
       " ['509', 'Closer', 'The Chainsmokers', '9090', '2017-01-06', 'ec'],\n",
       " ['510', 'Dile Que Tu Me Quieres', 'Ozuna', '9089', '2017-01-06', 'ec'],\n",
       " ['511', 'Chillax', 'Farruko', '8255', '2017-01-06', 'ec'],\n",
       " ['512', 'Starboy', 'The Weeknd', '8229', '2017-01-06', 'ec'],\n",
       " ['513', \"Don't Wanna Know\", 'Maroon 5', '7933', '2017-01-06', 'ec'],\n",
       " ['514', 'La Bicicleta', 'Carlos Vives', '7914', '2017-01-06', 'ec'],\n",
       " ['515', 'Cuatro Babys', 'Maluma', '7746', '2017-01-06', 'ec'],\n",
       " ['516', 'My Way', 'Calvin Harris', '7575', '2017-01-06', 'ec'],\n",
       " ['517', 'Andas En Mi Cabeza', 'Chino & Nacho', '7528', '2017-01-06', 'ec'],\n",
       " ['518', 'One Dance', 'Drake', '7433', '2017-01-06', 'ec'],\n",
       " ['519', '24K Magic', 'Bruno Mars', '7133', '2017-01-06', 'ec'],\n",
       " ['520', 'Shape of You', 'Ed Sheeran', '7099', '2017-01-06', 'ec'],\n",
       " ['521',\n",
       "  'Me Llamas (feat. Maluma) - Remix',\n",
       "  'Piso 21',\n",
       "  '7042',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['522', 'Shaky Shaky', 'Daddy Yankee', '7010', '2017-01-06', 'ec'],\n",
       " ['523',\n",
       "  'Cold Water (feat. Justin Bieber & MØ)',\n",
       "  'Major Lazer',\n",
       "  '6370',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['524',\n",
       "  'Rockabye (feat. Sean Paul & Anne-Marie)',\n",
       "  'Clean Bandit',\n",
       "  '6242',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['525', 'In the Name of Love', 'Martin Garrix', '6083', '2017-01-06', 'ec'],\n",
       " ['526', 'Bailame Despacio', 'Xantos', '6043', '2017-01-06', 'ec'],\n",
       " ['527',\n",
       "  \"We Don't Talk Anymore (feat. Selena Gomez)\",\n",
       "  'Charlie Puth',\n",
       "  '6034',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['528', 'DUELE EL CORAZON', 'Enrique Iglesias', '5937', '2017-01-06', 'ec'],\n",
       " ['529', 'Borro Cassette', 'Maluma', '5930', '2017-01-06', 'ec'],\n",
       " ['530', 'Castle on the Hill', 'Ed Sheeran', '5890', '2017-01-06', 'ec'],\n",
       " ['531',\n",
       "  'I Took A Pill In Ibiza - Seeb Remix',\n",
       "  'Mike Posner',\n",
       "  '5808',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['532',\n",
       "  'Gyal You A Party Animal - Remix',\n",
       "  'Charly Black',\n",
       "  '5690',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['533',\n",
       "  'Ya Me Enteré (feat. Nicky Jam) - Urban Version',\n",
       "  'Reik',\n",
       "  '5674',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['534', 'I Feel It Coming', 'The Weeknd', '5638', '2017-01-06', 'ec'],\n",
       " ['535', 'Treat You Better', 'Shawn Mendes', '5170', '2017-01-06', 'ec'],\n",
       " ['536', 'Desde Esa Noche', 'Thalía', '5020', '2017-01-06', 'ec'],\n",
       " ['537', \"Don't Let Me Down\", 'The Chainsmokers', '4980', '2017-01-06', 'ec'],\n",
       " ['538', 'Side To Side', 'Ariana Grande', '4956', '2017-01-06', 'ec'],\n",
       " ['539', 'Cheap Thrills', 'Sia', '4954', '2017-01-06', 'ec'],\n",
       " ['540',\n",
       "  '\"CAN\\'T STOP THE FEELING! (Original Song from DreamWorks Animation\\'s \"\"TROLLS\"\")\"',\n",
       "  'Justin Timberlake',\n",
       "  '4948',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['541', 'Bobo', 'J Balvin', '4831', '2017-01-06', 'ec'],\n",
       " ['542', 'Te Quiero Pa´Mi', 'Don Omar', '4811', '2017-01-06', 'ec'],\n",
       " ['544', 'Heathens', 'Twenty One Pilots', '4679', '2017-01-06', 'ec'],\n",
       " ['545', 'Baila Conmigo', 'Juan Magán', '4588', '2017-01-06', 'ec'],\n",
       " ['546', 'Fuego', 'Juanes', '4576', '2017-01-06', 'ec'],\n",
       " ['547',\n",
       "  'This Is What You Came For',\n",
       "  'Calvin Harris',\n",
       "  '4564',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['548', 'Tan Fácil', 'CNCO', '4548', '2017-01-06', 'ec'],\n",
       " ['549',\n",
       "  'Gyal You A Party Animal',\n",
       "  'Charly Black',\n",
       "  '4520',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['550', 'La Gozadera', 'Gente De Zona', '4328', '2017-01-06', 'ec'],\n",
       " ['551', 'Te Vas', 'Ozuna', '4164', '2017-01-06', 'ec'],\n",
       " ['552', 'Photograph', 'Ed Sheeran', '4138', '2017-01-06', 'ec'],\n",
       " ['553', 'Hasta el Amanecer', 'Nicky Jam', '3738', '2017-01-06', 'ec'],\n",
       " ['554', 'Just Hold On', 'Steve Aoki', '3699', '2017-01-06', 'ec'],\n",
       " ['555',\n",
       "  '\"I Don’t Wanna Live Forever (Fifty Shades Darker) - From \"\"Fifty Shades Darker (Original Motion Picture Soundtrack)\"\"\"',\n",
       "  'ZAYN',\n",
       "  '3552',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['556', 'Manicomio', 'Cosculluela', '3543', '2017-01-06', 'ec'],\n",
       " ['557',\n",
       "  'No Quiere Enamorarse (Remix) [feat. Daddy Yankee]',\n",
       "  'Ozuna',\n",
       "  '3538',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['558', 'Thinking Out Loud', 'Ed Sheeran', '3460', '2017-01-06', 'ec'],\n",
       " ['559', 'Me Rehúso', 'Danny Ocean', '3456', '2017-01-06', 'ec'],\n",
       " ['560', 'Deja Que Te Bese', 'Alejandro Sanz', '3399', '2017-01-06', 'ec'],\n",
       " ['561', 'Ruleta Rusa', 'Kevin Roldan', '3384', '2017-01-06', 'ec'],\n",
       " ['563', 'Cake By The Ocean', 'DNCE', '3269', '2017-01-06', 'ec'],\n",
       " ['564',\n",
       "  'Por Fin Te Encontré',\n",
       "  'Cali Y El Dandee',\n",
       "  '3222',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['565', 'Faded', 'Alan Walker', '3199', '2017-01-06', 'ec'],\n",
       " ['566',\n",
       "  'Hasta Que Se Seque el Malecón - Remix',\n",
       "  'Jacob Forever',\n",
       "  '3188',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['567', 'Enamorándonos', 'Cabas', '3097', '2017-01-06', 'ec'],\n",
       " ['568', 'Ride', 'Twenty One Pilots', '3093', '2017-01-06', 'ec'],\n",
       " ['569', 'Stressed Out', 'Twenty One Pilots', '3073', '2017-01-06', 'ec'],\n",
       " ['570', 'El Chisme', 'Reykon', '3059', '2017-01-06', 'ec'],\n",
       " ['571',\n",
       "  'Hymn For The Weekend - Seeb Remix',\n",
       "  'Coldplay',\n",
       "  '3035',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['572',\n",
       "  'Corazon De Seda (feat. Ozuna)',\n",
       "  'Klasico',\n",
       "  '2995',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['573', \"Say You Won't Let Go\", 'James Arthur', '2949', '2017-01-06', 'ec'],\n",
       " ['574', 'Ya Me Enteré', 'Reik', '2903', '2017-01-06', 'ec'],\n",
       " ['575', 'Encantadora - Remix', 'Yandel', '2882', '2017-01-06', 'ec'],\n",
       " ['576', 'Bajo el agua', 'Manuel Medrano', '2870', '2017-01-06', 'ec'],\n",
       " ['577',\n",
       "  'Light It Up (feat. Nyla & Fuse ODG) - Remix',\n",
       "  'Major Lazer',\n",
       "  '2828',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['578', 'Quisiera', 'CNCO', '2812', '2017-01-06', 'ec'],\n",
       " ['579', 'Una y otra vez', 'Manuel Medrano', '2808', '2017-01-06', 'ec'],\n",
       " ['580',\n",
       "  'Call On Me - Ryan Riback Extended Remix',\n",
       "  'Starley',\n",
       "  '2769',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['581', 'Work', 'Rihanna', '2741', '2017-01-06', 'ec'],\n",
       " ['582',\n",
       "  'Mi Tesoro (feat. Nicky Jam)',\n",
       "  'Zion & Lennox',\n",
       "  '2726',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['583', 'Traicionera - Remix', 'Sebastian Yatra', '2707', '2017-01-06', 'ec'],\n",
       " ['585', 'Love Yourself', 'Justin Bieber', '2663', '2017-01-06', 'ec'],\n",
       " ['586', 'Que Raro', 'Feid', '2649', '2017-01-06', 'ec'],\n",
       " ['587', 'Me Ama Me Odia', 'Ozuna', '2612', '2017-01-06', 'ec'],\n",
       " ['588', 'Work from Home', 'Fifth Harmony', '2594', '2017-01-06', 'ec'],\n",
       " ['589', 'Hear Me Now', 'Alok', '2530', '2017-01-06', 'ec'],\n",
       " ['590', 'Perfect Strangers', 'Jonas Blue', '2528', '2017-01-06', 'ec'],\n",
       " ['591', 'El Perdedor - The Remix', 'Maluma', '2525', '2017-01-06', 'ec'],\n",
       " ['592',\n",
       "  'Si Me Dices Que Si (feat. Nicky Jam)',\n",
       "  'Cosculluela',\n",
       "  '2520',\n",
       "  '2017-01-06',\n",
       "  'ec'],\n",
       " ['593', 'All We Know', 'The Chainsmokers', '2497', '2017-01-06', 'ec'],\n",
       " ['594', 'Black Beatles', 'Rae Sremmurd', '2408', '2017-01-06', 'ec'],\n",
       " ['595', 'By Your Side', 'Jonas Blue', '2406', '2017-01-06', 'ec'],\n",
       " ['596', 'Mercy', 'Shawn Mendes', '2373', '2017-01-06', 'ec'],\n",
       " ['597', 'Shed a Light', 'Robin Schulz', '2357', '2017-01-06', 'ec'],\n",
       " ['598', 'Para Enamorarte', 'CNCO', '2352', '2017-01-06', 'ec'],\n",
       " ['599', 'Encantadora', 'Yandel', '2343', '2017-01-06', 'ec'],\n",
       " ['600', 'Reggaetón Lento (Bailemos)', 'CNCO', '21438', '2017-01-07', 'ec'],\n",
       " ['601', 'Chantaje', 'Shakira', '19357', '2017-01-07', 'ec'],\n",
       " ['602',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '17095',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['603', 'Safari', 'J Balvin', '14493', '2017-01-07', 'ec'],\n",
       " ['604', \"Vente Pa' Ca\", 'Ricky Martin', '14144', '2017-01-07', 'ec'],\n",
       " ['605', 'Ay Mi Dios', 'IAmChino', '11781', '2017-01-07', 'ec'],\n",
       " ['606', 'Vacaciones', 'Wisin', '11553', '2017-01-07', 'ec'],\n",
       " ['607', 'Let Me Love You', 'DJ Snake', '10762', '2017-01-07', 'ec'],\n",
       " ['608', 'Dile Que Tu Me Quieres', 'Ozuna', '10552', '2017-01-07', 'ec'],\n",
       " ['609', 'Traicionera', 'Sebastian Yatra', '10335', '2017-01-07', 'ec'],\n",
       " ['610', 'Shape of You', 'Ed Sheeran', '9695', '2017-01-07', 'ec'],\n",
       " ['611', 'Closer', 'The Chainsmokers', '9118', '2017-01-07', 'ec'],\n",
       " ['612', 'La Bicicleta', 'Carlos Vives', '8998', '2017-01-07', 'ec'],\n",
       " ['613', 'Chillax', 'Farruko', '8994', '2017-01-07', 'ec'],\n",
       " ['614', 'Andas En Mi Cabeza', 'Chino & Nacho', '8882', '2017-01-07', 'ec'],\n",
       " ['615', 'Shaky Shaky', 'Daddy Yankee', '8257', '2017-01-07', 'ec'],\n",
       " ['616', 'Cuatro Babys', 'Maluma', '8168', '2017-01-07', 'ec'],\n",
       " ['617', \"Don't Wanna Know\", 'Maroon 5', '8050', '2017-01-07', 'ec'],\n",
       " ['618', 'Starboy', 'The Weeknd', '8020', '2017-01-07', 'ec'],\n",
       " ['619',\n",
       "  'Me Llamas (feat. Maluma) - Remix',\n",
       "  'Piso 21',\n",
       "  '7719',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['620', '24K Magic', 'Bruno Mars', '7714', '2017-01-07', 'ec'],\n",
       " ['621', 'One Dance', 'Drake', '7502', '2017-01-07', 'ec'],\n",
       " ['622', 'My Way', 'Calvin Harris', '7396', '2017-01-07', 'ec'],\n",
       " ['623', 'Borro Cassette', 'Maluma', '6706', '2017-01-07', 'ec'],\n",
       " ['624', 'Bailame Despacio', 'Xantos', '6553', '2017-01-07', 'ec'],\n",
       " ['625', 'DUELE EL CORAZON', 'Enrique Iglesias', '6483', '2017-01-07', 'ec'],\n",
       " ['626',\n",
       "  'Cold Water (feat. Justin Bieber & MØ)',\n",
       "  'Major Lazer',\n",
       "  '6356',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['627',\n",
       "  'Rockabye (feat. Sean Paul & Anne-Marie)',\n",
       "  'Clean Bandit',\n",
       "  '6350',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['628',\n",
       "  'Gyal You A Party Animal - Remix',\n",
       "  'Charly Black',\n",
       "  '6343',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['629', 'In the Name of Love', 'Martin Garrix', '6199', '2017-01-07', 'ec'],\n",
       " ['630', 'Castle on the Hill', 'Ed Sheeran', '6079', '2017-01-07', 'ec'],\n",
       " ['631',\n",
       "  \"We Don't Talk Anymore (feat. Selena Gomez)\",\n",
       "  'Charlie Puth',\n",
       "  '6039',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['632',\n",
       "  'I Took A Pill In Ibiza - Seeb Remix',\n",
       "  'Mike Posner',\n",
       "  '5896',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['633',\n",
       "  'Ya Me Enteré (feat. Nicky Jam) - Urban Version',\n",
       "  'Reik',\n",
       "  '5602',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['634', 'I Feel It Coming', 'The Weeknd', '5563', '2017-01-07', 'ec'],\n",
       " ['635', 'Desde Esa Noche', 'Thalía', '5559', '2017-01-07', 'ec'],\n",
       " ['636', 'Te Quiero Pa´Mi', 'Don Omar', '5307', '2017-01-07', 'ec'],\n",
       " ['637', 'Bobo', 'J Balvin', '5150', '2017-01-07', 'ec'],\n",
       " ['638', 'Treat You Better', 'Shawn Mendes', '5131', '2017-01-07', 'ec'],\n",
       " ['640', 'Side To Side', 'Ariana Grande', '5129', '2017-01-07', 'ec'],\n",
       " ['641', \"Don't Let Me Down\", 'The Chainsmokers', '5044', '2017-01-07', 'ec'],\n",
       " ['642',\n",
       "  '\"CAN\\'T STOP THE FEELING! (Original Song from DreamWorks Animation\\'s \"\"TROLLS\"\")\"',\n",
       "  'Justin Timberlake',\n",
       "  '5028',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['643', 'Cheap Thrills', 'Sia', '4980', '2017-01-07', 'ec'],\n",
       " ['644', 'Tan Fácil', 'CNCO', '4880', '2017-01-07', 'ec'],\n",
       " ['645', 'Baila Conmigo', 'Juan Magán', '4869', '2017-01-07', 'ec'],\n",
       " ['646',\n",
       "  'Gyal You A Party Animal',\n",
       "  'Charly Black',\n",
       "  '4831',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['647', 'Heathens', 'Twenty One Pilots', '4778', '2017-01-07', 'ec'],\n",
       " ['648', 'Fuego', 'Juanes', '4682', '2017-01-07', 'ec'],\n",
       " ['649', 'La Gozadera', 'Gente De Zona', '4652', '2017-01-07', 'ec'],\n",
       " ['650',\n",
       "  'This Is What You Came For',\n",
       "  'Calvin Harris',\n",
       "  '4367',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['651', 'Te Vas', 'Ozuna', '4307', '2017-01-07', 'ec'],\n",
       " ['652', 'Hasta el Amanecer', 'Nicky Jam', '4094', '2017-01-07', 'ec'],\n",
       " ['653', 'Manicomio', 'Cosculluela', '3945', '2017-01-07', 'ec'],\n",
       " ['654', 'Photograph', 'Ed Sheeran', '3935', '2017-01-07', 'ec'],\n",
       " ['655',\n",
       "  'No Quiere Enamorarse (Remix) [feat. Daddy Yankee]',\n",
       "  'Ozuna',\n",
       "  '3917',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['656', 'Ruleta Rusa', 'Kevin Roldan', '3893', '2017-01-07', 'ec'],\n",
       " ['657', 'Just Hold On', 'Steve Aoki', '3827', '2017-01-07', 'ec'],\n",
       " ['658', 'Me Rehúso', 'Danny Ocean', '3759', '2017-01-07', 'ec'],\n",
       " ['659', 'Deja Que Te Bese', 'Alejandro Sanz', '3755', '2017-01-07', 'ec'],\n",
       " ['661',\n",
       "  'Por Fin Te Encontré',\n",
       "  'Cali Y El Dandee',\n",
       "  '3606',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['662',\n",
       "  'Hasta Que Se Seque el Malecón - Remix',\n",
       "  'Jacob Forever',\n",
       "  '3516',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['663', 'Enamorándonos', 'Cabas', '3483', '2017-01-07', 'ec'],\n",
       " ['664',\n",
       "  '\"I Don’t Wanna Live Forever (Fifty Shades Darker) - From \"\"Fifty Shades Darker (Original Motion Picture Soundtrack)\"\"\"',\n",
       "  'ZAYN',\n",
       "  '3444',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['665', 'Faded', 'Alan Walker', '3345', '2017-01-07', 'ec'],\n",
       " ['666',\n",
       "  'Corazon De Seda (feat. Ozuna)',\n",
       "  'Klasico',\n",
       "  '3333',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['667', 'El Chisme', 'Reykon', '3329', '2017-01-07', 'ec'],\n",
       " ['668', 'Cake By The Ocean', 'DNCE', '3322', '2017-01-07', 'ec'],\n",
       " ['669', 'Traicionera - Remix', 'Sebastian Yatra', '3315', '2017-01-07', 'ec'],\n",
       " ['670', 'Ride', 'Twenty One Pilots', '3268', '2017-01-07', 'ec'],\n",
       " ['671',\n",
       "  'Si Me Dices Que Si (feat. Nicky Jam)',\n",
       "  'Cosculluela',\n",
       "  '3244',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['672', 'Thinking Out Loud', 'Ed Sheeran', '3240', '2017-01-07', 'ec'],\n",
       " ['673', 'Stressed Out', 'Twenty One Pilots', '3236', '2017-01-07', 'ec'],\n",
       " ['674',\n",
       "  'Light It Up (feat. Nyla & Fuse ODG) - Remix',\n",
       "  'Major Lazer',\n",
       "  '3186',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['675', 'Encantadora - Remix', 'Yandel', '3021', '2017-01-07', 'ec'],\n",
       " ['676', 'Quisiera', 'CNCO', '3013', '2017-01-07', 'ec'],\n",
       " ['677', 'Que Raro', 'Feid', '3002', '2017-01-07', 'ec'],\n",
       " ['678',\n",
       "  'Mi Tesoro (feat. Nicky Jam)',\n",
       "  'Zion & Lennox',\n",
       "  '2982',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['679', 'Work', 'Rihanna', '2966', '2017-01-07', 'ec'],\n",
       " ['680', 'Me Ama Me Odia', 'Ozuna', '2950', '2017-01-07', 'ec'],\n",
       " ['681', 'Ya Me Enteré', 'Reik', '2779', '2017-01-07', 'ec'],\n",
       " ['682', 'El Perdedor - The Remix', 'Maluma', '2778', '2017-01-07', 'ec'],\n",
       " ['683',\n",
       "  'Hymn For The Weekend - Seeb Remix',\n",
       "  'Coldplay',\n",
       "  '2773',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['684',\n",
       "  'Tu No Vive Asi (feat. Mambo Kingz & DJ Luian)',\n",
       "  'Arcangel',\n",
       "  '2703',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['685',\n",
       "  'Call On Me - Ryan Riback Extended Remix',\n",
       "  'Starley',\n",
       "  '2700',\n",
       "  '2017-01-07',\n",
       "  'ec'],\n",
       " ['686', 'Bajo el agua', 'Manuel Medrano', '2666', '2017-01-07', 'ec'],\n",
       " ['687', 'Work from Home', 'Fifth Harmony', '2655', '2017-01-07', 'ec'],\n",
       " ['688', \"Say You Won't Let Go\", 'James Arthur', '2610', '2017-01-07', 'ec'],\n",
       " ['689', 'Ginza', 'J Balvin', '2610', '2017-01-07', 'ec'],\n",
       " ['690', 'Love Yourself', 'Justin Bieber', '2588', '2017-01-07', 'ec'],\n",
       " ['691', 'Hear Me Now', 'Alok', '2576', '2017-01-07', 'ec'],\n",
       " ['692', 'Perfect Strangers', 'Jonas Blue', '2573', '2017-01-07', 'ec'],\n",
       " ['693', 'Ando buscando', 'Carlos Baute', '2569', '2017-01-07', 'ec'],\n",
       " ['694', 'By Your Side', 'Jonas Blue', '2557', '2017-01-07', 'ec'],\n",
       " ['695', 'Alone', 'Alan Walker', '2547', '2017-01-07', 'ec'],\n",
       " ['696', 'Shed a Light', 'Robin Schulz', '2539', '2017-01-07', 'ec'],\n",
       " ['697', 'De Pies a Cabeza', 'Maná', '2536', '2017-01-07', 'ec'],\n",
       " ['698', 'All We Know', 'The Chainsmokers', '2502', '2017-01-07', 'ec'],\n",
       " ['699', 'Para Enamorarte', 'CNCO', '2502', '2017-01-07', 'ec'],\n",
       " ['700', 'Reggaetón Lento (Bailemos)', 'CNCO', '20146', '2017-01-08', 'ec'],\n",
       " ['701', 'Chantaje', 'Shakira', '17974', '2017-01-08', 'ec'],\n",
       " ['702',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '15763',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['703', 'Safari', 'J Balvin', '13383', '2017-01-08', 'ec'],\n",
       " ['704', \"Vente Pa' Ca\", 'Ricky Martin', '12998', '2017-01-08', 'ec'],\n",
       " ['705', 'Ay Mi Dios', 'IAmChino', '11044', '2017-01-08', 'ec'],\n",
       " ['706', 'Vacaciones', 'Wisin', '10702', '2017-01-08', 'ec'],\n",
       " ['707', 'Shape of You', 'Ed Sheeran', '10382', '2017-01-08', 'ec'],\n",
       " ['708', 'Let Me Love You', 'DJ Snake', '10045', '2017-01-08', 'ec'],\n",
       " ['709', 'Dile Que Tu Me Quieres', 'Ozuna', '9895', '2017-01-08', 'ec'],\n",
       " ['710', 'Traicionera', 'Sebastian Yatra', '9746', '2017-01-08', 'ec'],\n",
       " ['711', 'La Bicicleta', 'Carlos Vives', '8474', '2017-01-08', 'ec'],\n",
       " ['712', 'Chillax', 'Farruko', '8334', '2017-01-08', 'ec'],\n",
       " ['713', 'Closer', 'The Chainsmokers', '8328', '2017-01-08', 'ec'],\n",
       " ['714', 'Andas En Mi Cabeza', 'Chino & Nacho', '8248', '2017-01-08', 'ec'],\n",
       " ['715', 'Shaky Shaky', 'Daddy Yankee', '7811', '2017-01-08', 'ec'],\n",
       " ['716', \"Don't Wanna Know\", 'Maroon 5', '7591', '2017-01-08', 'ec'],\n",
       " ['717', 'Cuatro Babys', 'Maluma', '7498', '2017-01-08', 'ec'],\n",
       " ['718',\n",
       "  'Me Llamas (feat. Maluma) - Remix',\n",
       "  'Piso 21',\n",
       "  '7300',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['719', 'Starboy', 'The Weeknd', '7212', '2017-01-08', 'ec'],\n",
       " ['720', '24K Magic', 'Bruno Mars', '7146', '2017-01-08', 'ec'],\n",
       " ['721', 'One Dance', 'Drake', '7024', '2017-01-08', 'ec'],\n",
       " ['722', 'My Way', 'Calvin Harris', '6662', '2017-01-08', 'ec'],\n",
       " ['723',\n",
       "  'Cold Water (feat. Justin Bieber & MØ)',\n",
       "  'Major Lazer',\n",
       "  '6103',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['724',\n",
       "  'Rockabye (feat. Sean Paul & Anne-Marie)',\n",
       "  'Clean Bandit',\n",
       "  '6102',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['725', 'Borro Cassette', 'Maluma', '6067', '2017-01-08', 'ec'],\n",
       " ['726', 'Bailame Despacio', 'Xantos', '6062', '2017-01-08', 'ec'],\n",
       " ['727', 'In the Name of Love', 'Martin Garrix', '5945', '2017-01-08', 'ec'],\n",
       " ['728',\n",
       "  'Gyal You A Party Animal - Remix',\n",
       "  'Charly Black',\n",
       "  '5938',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['729', 'DUELE EL CORAZON', 'Enrique Iglesias', '5817', '2017-01-08', 'ec'],\n",
       " ['730', 'Castle on the Hill', 'Ed Sheeran', '5654', '2017-01-08', 'ec'],\n",
       " ['731',\n",
       "  \"We Don't Talk Anymore (feat. Selena Gomez)\",\n",
       "  'Charlie Puth',\n",
       "  '5591',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['732',\n",
       "  'I Took A Pill In Ibiza - Seeb Remix',\n",
       "  'Mike Posner',\n",
       "  '5475',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['733', 'I Feel It Coming', 'The Weeknd', '5470', '2017-01-08', 'ec'],\n",
       " ['734', 'Desde Esa Noche', 'Thalía', '5267', '2017-01-08', 'ec'],\n",
       " ['735', 'Te Quiero Pa´Mi', 'Don Omar', '5258', '2017-01-08', 'ec'],\n",
       " ['736',\n",
       "  'Ya Me Enteré (feat. Nicky Jam) - Urban Version',\n",
       "  'Reik',\n",
       "  '5240',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['737', 'Side To Side', 'Ariana Grande', '4907', '2017-01-08', 'ec'],\n",
       " ['738', 'Bobo', 'J Balvin', '4871', '2017-01-08', 'ec'],\n",
       " ['740', 'Cheap Thrills', 'Sia', '4706', '2017-01-08', 'ec'],\n",
       " ['741', 'Treat You Better', 'Shawn Mendes', '4704', '2017-01-08', 'ec'],\n",
       " ['742',\n",
       "  '\"CAN\\'T STOP THE FEELING! (Original Song from DreamWorks Animation\\'s \"\"TROLLS\"\")\"',\n",
       "  'Justin Timberlake',\n",
       "  '4633',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['743', 'Tan Fácil', 'CNCO', '4594', '2017-01-08', 'ec'],\n",
       " ['744', \"Don't Let Me Down\", 'The Chainsmokers', '4588', '2017-01-08', 'ec'],\n",
       " ['745', 'Heathens', 'Twenty One Pilots', '4559', '2017-01-08', 'ec'],\n",
       " ['746',\n",
       "  'Gyal You A Party Animal',\n",
       "  'Charly Black',\n",
       "  '4556',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['747', 'Fuego', 'Juanes', '4417', '2017-01-08', 'ec'],\n",
       " ['748', 'La Gozadera', 'Gente De Zona', '4393', '2017-01-08', 'ec'],\n",
       " ['749', 'Baila Conmigo', 'Juan Magán', '4267', '2017-01-08', 'ec'],\n",
       " ['750', 'Te Vas', 'Ozuna', '4064', '2017-01-08', 'ec'],\n",
       " ['751', 'Photograph', 'Ed Sheeran', '3982', '2017-01-08', 'ec'],\n",
       " ['752',\n",
       "  'This Is What You Came For',\n",
       "  'Calvin Harris',\n",
       "  '3761',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['753', 'Hasta el Amanecer', 'Nicky Jam', '3752', '2017-01-08', 'ec'],\n",
       " ['754', 'Ruleta Rusa', 'Kevin Roldan', '3701', '2017-01-08', 'ec'],\n",
       " ['755',\n",
       "  'No Quiere Enamorarse (Remix) [feat. Daddy Yankee]',\n",
       "  'Ozuna',\n",
       "  '3700',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['756', 'Just Hold On', 'Steve Aoki', '3619', '2017-01-08', 'ec'],\n",
       " ['757', 'Manicomio', 'Cosculluela', '3587', '2017-01-08', 'ec'],\n",
       " ['758',\n",
       "  'Por Fin Te Encontré',\n",
       "  'Cali Y El Dandee',\n",
       "  '3553',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['759', 'Me Rehúso', 'Danny Ocean', '3441', '2017-01-08', 'ec'],\n",
       " ['760',\n",
       "  'Si Me Dices Que Si (feat. Nicky Jam)',\n",
       "  'Cosculluela',\n",
       "  '3374',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['761',\n",
       "  '\"I Don’t Wanna Live Forever (Fifty Shades Darker) - From \"\"Fifty Shades Darker (Original Motion Picture Soundtrack)\"\"\"',\n",
       "  'ZAYN',\n",
       "  '3315',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['762',\n",
       "  'Hasta Que Se Seque el Malecón - Remix',\n",
       "  'Jacob Forever',\n",
       "  '3289',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['764', 'Deja Que Te Bese', 'Alejandro Sanz', '3267', '2017-01-08', 'ec'],\n",
       " ['765', 'Enamorándonos', 'Cabas', '3264', '2017-01-08', 'ec'],\n",
       " ['766', 'Traicionera - Remix', 'Sebastian Yatra', '3260', '2017-01-08', 'ec'],\n",
       " ['767', 'Thinking Out Loud', 'Ed Sheeran', '3128', '2017-01-08', 'ec'],\n",
       " ['768', 'El Chisme', 'Reykon', '3116', '2017-01-08', 'ec'],\n",
       " ['769', 'Faded', 'Alan Walker', '3068', '2017-01-08', 'ec'],\n",
       " ['770', 'Stressed Out', 'Twenty One Pilots', '3020', '2017-01-08', 'ec'],\n",
       " ['771',\n",
       "  'Light It Up (feat. Nyla & Fuse ODG) - Remix',\n",
       "  'Major Lazer',\n",
       "  '3014',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['772',\n",
       "  'Corazon De Seda (feat. Ozuna)',\n",
       "  'Klasico',\n",
       "  '3011',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['773', 'Cake By The Ocean', 'DNCE', '3000', '2017-01-08', 'ec'],\n",
       " ['774', 'Ride', 'Twenty One Pilots', '2935', '2017-01-08', 'ec'],\n",
       " ['775', 'Que Raro', 'Feid', '2912', '2017-01-08', 'ec'],\n",
       " ['776',\n",
       "  'Mi Tesoro (feat. Nicky Jam)',\n",
       "  'Zion & Lennox',\n",
       "  '2869',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['777', 'Quisiera', 'CNCO', '2843', '2017-01-08', 'ec'],\n",
       " ['778', 'Encantadora - Remix', 'Yandel', '2834', '2017-01-08', 'ec'],\n",
       " ['779', 'Work', 'Rihanna', '2726', '2017-01-08', 'ec'],\n",
       " ['780', 'Ya Me Enteré', 'Reik', '2692', '2017-01-08', 'ec'],\n",
       " ['781', 'Me Ama Me Odia', 'Ozuna', '2692', '2017-01-08', 'ec'],\n",
       " ['782',\n",
       "  'Hymn For The Weekend - Seeb Remix',\n",
       "  'Coldplay',\n",
       "  '2687',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['783', 'Bajo el agua', 'Manuel Medrano', '2675', '2017-01-08', 'ec'],\n",
       " ['784', 'Love Yourself', 'Justin Bieber', '2625', '2017-01-08', 'ec'],\n",
       " ['785',\n",
       "  'Call On Me - Ryan Riback Extended Remix',\n",
       "  'Starley',\n",
       "  '2555',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['786', 'El Perdedor - The Remix', 'Maluma', '2551', '2017-01-08', 'ec'],\n",
       " ['787', 'Shed a Light', 'Robin Schulz', '2545', '2017-01-08', 'ec'],\n",
       " ['788', 'Hear Me Now', 'Alok', '2537', '2017-01-08', 'ec'],\n",
       " ['789', 'Work from Home', 'Fifth Harmony', '2478', '2017-01-08', 'ec'],\n",
       " ['790', \"Say You Won't Let Go\", 'James Arthur', '2464', '2017-01-08', 'ec'],\n",
       " ['791', 'By Your Side', 'Jonas Blue', '2455', '2017-01-08', 'ec'],\n",
       " ['792', 'Ando buscando', 'Carlos Baute', '2446', '2017-01-08', 'ec'],\n",
       " ['793', 'El Perdedor', 'Maluma', '2429', '2017-01-08', 'ec'],\n",
       " ['794',\n",
       "  'Tu No Vive Asi (feat. Mambo Kingz & DJ Luian)',\n",
       "  'Arcangel',\n",
       "  '2425',\n",
       "  '2017-01-08',\n",
       "  'ec'],\n",
       " ['795', 'Una y otra vez', 'Manuel Medrano', '2421', '2017-01-08', 'ec'],\n",
       " ['796', 'Encantadora', 'Yandel', '2392', '2017-01-08', 'ec'],\n",
       " ['797', 'Para Enamorarte', 'CNCO', '2390', '2017-01-08', 'ec'],\n",
       " ['798', 'Perfect Strangers', 'Jonas Blue', '2386', '2017-01-08', 'ec'],\n",
       " ['799', 'Dueles', 'Jesse & Joy', '2381', '2017-01-08', 'ec'],\n",
       " ['800', 'Reggaetón Lento (Bailemos)', 'CNCO', '16652', '2017-01-09', 'ec'],\n",
       " ['801', 'Chantaje', 'Shakira', '15212', '2017-01-09', 'ec'],\n",
       " ['802',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '13197',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['803', 'Shape of You', 'Ed Sheeran', '12200', '2017-01-09', 'ec'],\n",
       " ['804', 'Safari', 'J Balvin', '11144', '2017-01-09', 'ec'],\n",
       " ['805', \"Vente Pa' Ca\", 'Ricky Martin', '10843', '2017-01-09', 'ec'],\n",
       " ['806', 'Let Me Love You', 'DJ Snake', '9479', '2017-01-09', 'ec'],\n",
       " ['807', 'Vacaciones', 'Wisin', '9441', '2017-01-09', 'ec'],\n",
       " ['808', 'Ay Mi Dios', 'IAmChino', '9411', '2017-01-09', 'ec'],\n",
       " ['809', 'Dile Que Tu Me Quieres', 'Ozuna', '8410', '2017-01-09', 'ec'],\n",
       " ['810', 'Traicionera', 'Sebastian Yatra', '8402', '2017-01-09', 'ec'],\n",
       " ['811', 'Closer', 'The Chainsmokers', '8146', '2017-01-09', 'ec'],\n",
       " ['812', 'Chillax', 'Farruko', '7679', '2017-01-09', 'ec'],\n",
       " ['813', 'Starboy', 'The Weeknd', '7568', '2017-01-09', 'ec'],\n",
       " ['814', \"Don't Wanna Know\", 'Maroon 5', '7442', '2017-01-09', 'ec'],\n",
       " ['815', 'Andas En Mi Cabeza', 'Chino & Nacho', '7134', '2017-01-09', 'ec'],\n",
       " ['816', 'La Bicicleta', 'Carlos Vives', '7125', '2017-01-09', 'ec'],\n",
       " ['817', '24K Magic', 'Bruno Mars', '6925', '2017-01-09', 'ec'],\n",
       " ['818', 'One Dance', 'Drake', '6780', '2017-01-09', 'ec'],\n",
       " ['819', 'Cuatro Babys', 'Maluma', '6688', '2017-01-09', 'ec'],\n",
       " ['820',\n",
       "  'Me Llamas (feat. Maluma) - Remix',\n",
       "  'Piso 21',\n",
       "  '6567',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['821', 'Shaky Shaky', 'Daddy Yankee', '6375', '2017-01-09', 'ec'],\n",
       " ['822', 'My Way', 'Calvin Harris', '6368', '2017-01-09', 'ec'],\n",
       " ['823',\n",
       "  'Rockabye (feat. Sean Paul & Anne-Marie)',\n",
       "  'Clean Bandit',\n",
       "  '6049',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['824', 'Castle on the Hill', 'Ed Sheeran', '5851', '2017-01-09', 'ec'],\n",
       " ['825',\n",
       "  'Cold Water (feat. Justin Bieber & MØ)',\n",
       "  'Major Lazer',\n",
       "  '5806',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['826', 'I Feel It Coming', 'The Weeknd', '5741', '2017-01-09', 'ec'],\n",
       " ['827', 'In the Name of Love', 'Martin Garrix', '5533', '2017-01-09', 'ec'],\n",
       " ['828',\n",
       "  \"We Don't Talk Anymore (feat. Selena Gomez)\",\n",
       "  'Charlie Puth',\n",
       "  '5525',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['829', 'Borro Cassette', 'Maluma', '5415', '2017-01-09', 'ec'],\n",
       " ['830',\n",
       "  'I Took A Pill In Ibiza - Seeb Remix',\n",
       "  'Mike Posner',\n",
       "  '5388',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['831', 'Bailame Despacio', 'Xantos', '5312', '2017-01-09', 'ec'],\n",
       " ['832', 'DUELE EL CORAZON', 'Enrique Iglesias', '5126', '2017-01-09', 'ec'],\n",
       " ['833',\n",
       "  'Gyal You A Party Animal - Remix',\n",
       "  'Charly Black',\n",
       "  '4968',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['834', 'Side To Side', 'Ariana Grande', '4883', '2017-01-09', 'ec'],\n",
       " ['835', 'Te Quiero Pa´Mi', 'Don Omar', '4721', '2017-01-09', 'ec'],\n",
       " ['836', 'Treat You Better', 'Shawn Mendes', '4710', '2017-01-09', 'ec'],\n",
       " ['837',\n",
       "  'Ya Me Enteré (feat. Nicky Jam) - Urban Version',\n",
       "  'Reik',\n",
       "  '4668',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['838', 'Photograph', 'Ed Sheeran', '4627', '2017-01-09', 'ec'],\n",
       " ['839', 'Desde Esa Noche', 'Thalía', '4603', '2017-01-09', 'ec'],\n",
       " ['840', \"Don't Let Me Down\", 'The Chainsmokers', '4486', '2017-01-09', 'ec'],\n",
       " ['841', 'Cheap Thrills', 'Sia', '4476', '2017-01-09', 'ec'],\n",
       " ['843', 'Heathens', 'Twenty One Pilots', '4421', '2017-01-09', 'ec'],\n",
       " ['844',\n",
       "  '\"CAN\\'T STOP THE FEELING! (Original Song from DreamWorks Animation\\'s \"\"TROLLS\"\")\"',\n",
       "  'Justin Timberlake',\n",
       "  '4377',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['845', 'Bobo', 'J Balvin', '4264', '2017-01-09', 'ec'],\n",
       " ['846', 'Fuego', 'Juanes', '4232', '2017-01-09', 'ec'],\n",
       " ['847',\n",
       "  'Gyal You A Party Animal',\n",
       "  'Charly Black',\n",
       "  '4125',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['848', 'Tan Fácil', 'CNCO', '3907', '2017-01-09', 'ec'],\n",
       " ['849',\n",
       "  '\"I Don’t Wanna Live Forever (Fifty Shades Darker) - From \"\"Fifty Shades Darker (Original Motion Picture Soundtrack)\"\"\"',\n",
       "  'ZAYN',\n",
       "  '3875',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['850', 'Baila Conmigo', 'Juan Magán', '3856', '2017-01-09', 'ec'],\n",
       " ['851', 'La Gozadera', 'Gente De Zona', '3841', '2017-01-09', 'ec'],\n",
       " ['852', 'Just Hold On', 'Steve Aoki', '3608', '2017-01-09', 'ec'],\n",
       " ['853', 'Te Vas', 'Ozuna', '3521', '2017-01-09', 'ec'],\n",
       " ['854',\n",
       "  'This Is What You Came For',\n",
       "  'Calvin Harris',\n",
       "  '3498',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['855', 'Hasta el Amanecer', 'Nicky Jam', '3424', '2017-01-09', 'ec'],\n",
       " ['856', 'Deja Que Te Bese', 'Alejandro Sanz', '3302', '2017-01-09', 'ec'],\n",
       " ['857', \"Say You Won't Let Go\", 'James Arthur', '3289', '2017-01-09', 'ec'],\n",
       " ['858', 'Manicomio', 'Cosculluela', '3283', '2017-01-09', 'ec'],\n",
       " ['859', 'Ruleta Rusa', 'Kevin Roldan', '3235', '2017-01-09', 'ec'],\n",
       " ['860', 'Me Rehúso', 'Danny Ocean', '3181', '2017-01-09', 'ec'],\n",
       " ['861', 'Thinking Out Loud', 'Ed Sheeran', '3137', '2017-01-09', 'ec'],\n",
       " ['862',\n",
       "  'Si Me Dices Que Si (feat. Nicky Jam)',\n",
       "  'Cosculluela',\n",
       "  '3109',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['864',\n",
       "  'Por Fin Te Encontré',\n",
       "  'Cali Y El Dandee',\n",
       "  '3040',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['865',\n",
       "  'No Quiere Enamorarse (Remix) [feat. Daddy Yankee]',\n",
       "  'Ozuna',\n",
       "  '3037',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['866', 'Faded', 'Alan Walker', '2962', '2017-01-09', 'ec'],\n",
       " ['867', 'Bajo el agua', 'Manuel Medrano', '2910', '2017-01-09', 'ec'],\n",
       " ['868',\n",
       "  'Hasta Que Se Seque el Malecón - Remix',\n",
       "  'Jacob Forever',\n",
       "  '2896',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['869', 'Ride', 'Twenty One Pilots', '2888', '2017-01-09', 'ec'],\n",
       " ['870', 'Cake By The Ocean', 'DNCE', '2861', '2017-01-09', 'ec'],\n",
       " ['871',\n",
       "  'Light It Up (feat. Nyla & Fuse ODG) - Remix',\n",
       "  'Major Lazer',\n",
       "  '2850',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['872', 'Ya Me Enteré', 'Reik', '2841', '2017-01-09', 'ec'],\n",
       " ['873', 'Mercy', 'Shawn Mendes', '2815', '2017-01-09', 'ec'],\n",
       " ['874', 'Una y otra vez', 'Manuel Medrano', '2815', '2017-01-09', 'ec'],\n",
       " ['875', 'El Chisme', 'Reykon', '2814', '2017-01-09', 'ec'],\n",
       " ['876', 'Stressed Out', 'Twenty One Pilots', '2809', '2017-01-09', 'ec'],\n",
       " ['877', 'Enamorándonos', 'Cabas', '2808', '2017-01-09', 'ec'],\n",
       " ['878',\n",
       "  'Call On Me - Ryan Riback Extended Remix',\n",
       "  'Starley',\n",
       "  '2715',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['879', 'Dueles', 'Jesse & Joy', '2703', '2017-01-09', 'ec'],\n",
       " ['880',\n",
       "  'Hymn For The Weekend - Seeb Remix',\n",
       "  'Coldplay',\n",
       "  '2678',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['881', 'Work', 'Rihanna', '2649', '2017-01-09', 'ec'],\n",
       " ['882', 'Hear Me Now', 'Alok', '2648', '2017-01-09', 'ec'],\n",
       " ['883', 'By Your Side', 'Jonas Blue', '2612', '2017-01-09', 'ec'],\n",
       " ['884', 'Quisiera', 'CNCO', '2605', '2017-01-09', 'ec'],\n",
       " ['885', 'All We Know', 'The Chainsmokers', '2583', '2017-01-09', 'ec'],\n",
       " ['886',\n",
       "  'Mi Tesoro (feat. Nicky Jam)',\n",
       "  'Zion & Lennox',\n",
       "  '2568',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['887', 'Traicionera - Remix', 'Sebastian Yatra', '2560', '2017-01-09', 'ec'],\n",
       " ['888', 'Que Raro', 'Feid', '2549', '2017-01-09', 'ec'],\n",
       " ['889', 'Love Yourself', 'Justin Bieber', '2537', '2017-01-09', 'ec'],\n",
       " ['890', 'Encantadora - Remix', 'Yandel', '2523', '2017-01-09', 'ec'],\n",
       " ['891', 'Shed a Light', 'Robin Schulz', '2514', '2017-01-09', 'ec'],\n",
       " ['892', 'The Scientist', 'Coldplay', '2484', '2017-01-09', 'ec'],\n",
       " ['893', 'Me Ama Me Odia', 'Ozuna', '2414', '2017-01-09', 'ec'],\n",
       " ['894', 'Alone', 'Alan Walker', '2392', '2017-01-09', 'ec'],\n",
       " ['895', 'Fake Love', 'Drake', '2383', '2017-01-09', 'ec'],\n",
       " ['896', 'Soy Peor', 'Bad Bunny', '2366', '2017-01-09', 'ec'],\n",
       " ['897', 'Work from Home', 'Fifth Harmony', '2339', '2017-01-09', 'ec'],\n",
       " ['898',\n",
       "  'Quiero Que Vuelvas',\n",
       "  'Alejandro Fernandez',\n",
       "  '2298',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['899',\n",
       "  'Corazon De Seda (feat. Ozuna)',\n",
       "  'Klasico',\n",
       "  '2295',\n",
       "  '2017-01-09',\n",
       "  'ec'],\n",
       " ['900', 'Reggaetón Lento (Bailemos)', 'CNCO', '16595', '2017-01-10', 'ec'],\n",
       " ['901', 'Chantaje', 'Shakira', '14851', '2017-01-10', 'ec'],\n",
       " ['902',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '12774',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['903', 'Shape of You', 'Ed Sheeran', '12360', '2017-01-10', 'ec'],\n",
       " ['904', 'Safari', 'J Balvin', '11212', '2017-01-10', 'ec'],\n",
       " ['905', \"Vente Pa' Ca\", 'Ricky Martin', '10633', '2017-01-10', 'ec'],\n",
       " ['906', 'Let Me Love You', 'DJ Snake', '10042', '2017-01-10', 'ec'],\n",
       " ['907', 'Ay Mi Dios', 'IAmChino', '9296', '2017-01-10', 'ec'],\n",
       " ['908', 'Vacaciones', 'Wisin', '9099', '2017-01-10', 'ec'],\n",
       " ['909', 'Traicionera', 'Sebastian Yatra', '8411', '2017-01-10', 'ec'],\n",
       " ['910', 'Closer', 'The Chainsmokers', '8357', '2017-01-10', 'ec'],\n",
       " ['911', 'Dile Que Tu Me Quieres', 'Ozuna', '8068', '2017-01-10', 'ec'],\n",
       " ['912', 'Starboy', 'The Weeknd', '7986', '2017-01-10', 'ec'],\n",
       " ['913', \"Don't Wanna Know\", 'Maroon 5', '7953', '2017-01-10', 'ec'],\n",
       " ['914', 'Chillax', 'Farruko', '7256', '2017-01-10', 'ec'],\n",
       " ['915', '24K Magic', 'Bruno Mars', '7038', '2017-01-10', 'ec'],\n",
       " ['916', 'La Bicicleta', 'Carlos Vives', '6931', '2017-01-10', 'ec'],\n",
       " ['917', 'My Way', 'Calvin Harris', '6900', '2017-01-10', 'ec'],\n",
       " ['918', 'Andas En Mi Cabeza', 'Chino & Nacho', '6763', '2017-01-10', 'ec'],\n",
       " ['919', 'One Dance', 'Drake', '6702', '2017-01-10', 'ec'],\n",
       " ['920', 'Cuatro Babys', 'Maluma', '6562', '2017-01-10', 'ec'],\n",
       " ['921',\n",
       "  'Me Llamas (feat. Maluma) - Remix',\n",
       "  'Piso 21',\n",
       "  '6279',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['922',\n",
       "  'Rockabye (feat. Sean Paul & Anne-Marie)',\n",
       "  'Clean Bandit',\n",
       "  '6221',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['923', 'Castle on the Hill', 'Ed Sheeran', '6071', '2017-01-10', 'ec'],\n",
       " ['924', 'Shaky Shaky', 'Daddy Yankee', '5946', '2017-01-10', 'ec'],\n",
       " ['925', 'I Feel It Coming', 'The Weeknd', '5945', '2017-01-10', 'ec'],\n",
       " ['926',\n",
       "  \"We Don't Talk Anymore (feat. Selena Gomez)\",\n",
       "  'Charlie Puth',\n",
       "  '5816',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['927',\n",
       "  'Cold Water (feat. Justin Bieber & MØ)',\n",
       "  'Major Lazer',\n",
       "  '5752',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['928', 'In the Name of Love', 'Martin Garrix', '5616', '2017-01-10', 'ec'],\n",
       " ['929',\n",
       "  'I Took A Pill In Ibiza - Seeb Remix',\n",
       "  'Mike Posner',\n",
       "  '5542',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['930', 'Side To Side', 'Ariana Grande', '5175', '2017-01-10', 'ec'],\n",
       " ['931', 'Bailame Despacio', 'Xantos', '5081', '2017-01-10', 'ec'],\n",
       " ['932', 'Treat You Better', 'Shawn Mendes', '5007', '2017-01-10', 'ec'],\n",
       " ['933', 'Borro Cassette', 'Maluma', '4995', '2017-01-10', 'ec'],\n",
       " ['934', 'Photograph', 'Ed Sheeran', '4922', '2017-01-10', 'ec'],\n",
       " ['935', 'DUELE EL CORAZON', 'Enrique Iglesias', '4868', '2017-01-10', 'ec'],\n",
       " ['936',\n",
       "  'Gyal You A Party Animal - Remix',\n",
       "  'Charly Black',\n",
       "  '4737',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['937',\n",
       "  'Ya Me Enteré (feat. Nicky Jam) - Urban Version',\n",
       "  'Reik',\n",
       "  '4673',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['938', 'Cheap Thrills', 'Sia', '4633', '2017-01-10', 'ec'],\n",
       " ['939', \"Don't Let Me Down\", 'The Chainsmokers', '4540', '2017-01-10', 'ec'],\n",
       " ['940', 'Te Quiero Pa´Mi', 'Don Omar', '4526', '2017-01-10', 'ec'],\n",
       " ['941', 'Heathens', 'Twenty One Pilots', '4490', '2017-01-10', 'ec'],\n",
       " ['943',\n",
       "  '\"I Don’t Wanna Live Forever (Fifty Shades Darker) - From \"\"Fifty Shades Darker (Original Motion Picture Soundtrack)\"\"\"',\n",
       "  'ZAYN',\n",
       "  '4404',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['944',\n",
       "  '\"CAN\\'T STOP THE FEELING! (Original Song from DreamWorks Animation\\'s \"\"TROLLS\"\")\"',\n",
       "  'Justin Timberlake',\n",
       "  '4404',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['945', 'Desde Esa Noche', 'Thalía', '4348', '2017-01-10', 'ec'],\n",
       " ['946', 'Bobo', 'J Balvin', '4079', '2017-01-10', 'ec'],\n",
       " ['947', 'Tan Fácil', 'CNCO', '4067', '2017-01-10', 'ec'],\n",
       " ['948', 'Fuego', 'Juanes', '3909', '2017-01-10', 'ec'],\n",
       " ['949',\n",
       "  'Gyal You A Party Animal',\n",
       "  'Charly Black',\n",
       "  '3888',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['950',\n",
       "  'This Is What You Came For',\n",
       "  'Calvin Harris',\n",
       "  '3684',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['951', 'Just Hold On', 'Steve Aoki', '3649', '2017-01-10', 'ec'],\n",
       " ['952', 'Thinking Out Loud', 'Ed Sheeran', '3474', '2017-01-10', 'ec'],\n",
       " ['953', 'La Gozadera', 'Gente De Zona', '3445', '2017-01-10', 'ec'],\n",
       " ['954', 'Baila Conmigo', 'Juan Magán', '3426', '2017-01-10', 'ec'],\n",
       " ['955', 'Me Rehúso', 'Danny Ocean', '3343', '2017-01-10', 'ec'],\n",
       " ['956', 'Te Vas', 'Ozuna', '3199', '2017-01-10', 'ec'],\n",
       " ['957', \"Say You Won't Let Go\", 'James Arthur', '3165', '2017-01-10', 'ec'],\n",
       " ['958', 'Manicomio', 'Cosculluela', '3118', '2017-01-10', 'ec'],\n",
       " ['959', 'Faded', 'Alan Walker', '3105', '2017-01-10', 'ec'],\n",
       " ['960', 'Cake By The Ocean', 'DNCE', '3100', '2017-01-10', 'ec'],\n",
       " ['961', 'Stressed Out', 'Twenty One Pilots', '3097', '2017-01-10', 'ec'],\n",
       " ['962', 'Deja Que Te Bese', 'Alejandro Sanz', '3095', '2017-01-10', 'ec'],\n",
       " ['963', 'Hasta el Amanecer', 'Nicky Jam', '3066', '2017-01-10', 'ec'],\n",
       " ['964',\n",
       "  'Si Me Dices Que Si (feat. Nicky Jam)',\n",
       "  'Cosculluela',\n",
       "  '3031',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['965', 'Una y otra vez', 'Manuel Medrano', '3007', '2017-01-10', 'ec'],\n",
       " ['967', 'Bajo el agua', 'Manuel Medrano', '2924', '2017-01-10', 'ec'],\n",
       " ['968', 'Ruleta Rusa', 'Kevin Roldan', '2924', '2017-01-10', 'ec'],\n",
       " ['969',\n",
       "  'No Quiere Enamorarse (Remix) [feat. Daddy Yankee]',\n",
       "  'Ozuna',\n",
       "  '2923',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['970',\n",
       "  'Call On Me - Ryan Riback Extended Remix',\n",
       "  'Starley',\n",
       "  '2917',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['971', 'Ride', 'Twenty One Pilots', '2844', '2017-01-10', 'ec'],\n",
       " ['972',\n",
       "  'Por Fin Te Encontré',\n",
       "  'Cali Y El Dandee',\n",
       "  '2829',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['973', 'Enamorándonos', 'Cabas', '2818', '2017-01-10', 'ec'],\n",
       " ['974', 'Ya Me Enteré', 'Reik', '2799', '2017-01-10', 'ec'],\n",
       " ['975', 'By Your Side', 'Jonas Blue', '2787', '2017-01-10', 'ec'],\n",
       " ['976',\n",
       "  'Hymn For The Weekend - Seeb Remix',\n",
       "  'Coldplay',\n",
       "  '2783',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['977', 'Mercy', 'Shawn Mendes', '2753', '2017-01-10', 'ec'],\n",
       " ['978',\n",
       "  'Light It Up (feat. Nyla & Fuse ODG) - Remix',\n",
       "  'Major Lazer',\n",
       "  '2716',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['979', 'Quisiera', 'CNCO', '2682', '2017-01-10', 'ec'],\n",
       " ['980', 'El Chisme', 'Reykon', '2665', '2017-01-10', 'ec'],\n",
       " ['981',\n",
       "  'Hasta Que Se Seque el Malecón - Remix',\n",
       "  'Jacob Forever',\n",
       "  '2662',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['982', 'Hear Me Now', 'Alok', '2638', '2017-01-10', 'ec'],\n",
       " ['983', 'Love Yourself', 'Justin Bieber', '2606', '2017-01-10', 'ec'],\n",
       " ['984', 'Shed a Light', 'Robin Schulz', '2573', '2017-01-10', 'ec'],\n",
       " ['985', 'Dueles', 'Jesse & Joy', '2527', '2017-01-10', 'ec'],\n",
       " ['986', 'Work', 'Rihanna', '2503', '2017-01-10', 'ec'],\n",
       " ['987', 'Starving', 'Hailee Steinfeld', '2493', '2017-01-10', 'ec'],\n",
       " ['988', 'Fake Love', 'Drake', '2474', '2017-01-10', 'ec'],\n",
       " ['989', 'All We Know', 'The Chainsmokers', '2448', '2017-01-10', 'ec'],\n",
       " ['990', 'Soy Peor', 'Bad Bunny', '2446', '2017-01-10', 'ec'],\n",
       " ['991', 'Black Beatles', 'Rae Sremmurd', '2443', '2017-01-10', 'ec'],\n",
       " ['992', 'Traicionera - Remix', 'Sebastian Yatra', '2439', '2017-01-10', 'ec'],\n",
       " ['993', 'Que Raro', 'Feid', '2419', '2017-01-10', 'ec'],\n",
       " ['994', 'Work from Home', 'Fifth Harmony', '2408', '2017-01-10', 'ec'],\n",
       " ['995', 'Encantadora - Remix', 'Yandel', '2402', '2017-01-10', 'ec'],\n",
       " ['996',\n",
       "  'Mi Tesoro (feat. Nicky Jam)',\n",
       "  'Zion & Lennox',\n",
       "  '2385',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['997', 'Alone', 'Alan Walker', '2384', '2017-01-10', 'ec'],\n",
       " ['998',\n",
       "  'Tu No Vive Asi (feat. Mambo Kingz & DJ Luian)',\n",
       "  'Arcangel',\n",
       "  '2363',\n",
       "  '2017-01-10',\n",
       "  'ec'],\n",
       " ['999', 'Me Ama Me Odia', 'Ozuna', '2356', '2017-01-10', 'ec'],\n",
       " ['1000', 'Reggaetón Lento (Bailemos)', 'CNCO', '18000', '2017-01-11', 'ec'],\n",
       " ['1001', 'Chantaje', 'Shakira', '15980', '2017-01-11', 'ec'],\n",
       " ['1002',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '13781',\n",
       "  '2017-01-11',\n",
       "  'ec'],\n",
       " ['1003', 'Shape of You', 'Ed Sheeran', '13070', '2017-01-11', 'ec'],\n",
       " ['1004', 'Safari', 'J Balvin', '12057', '2017-01-11', 'ec'],\n",
       " ['1005', \"Vente Pa' Ca\", 'Ricky Martin', '11417', '2017-01-11', 'ec'],\n",
       " ['1006', 'Let Me Love You', 'DJ Snake', '10429', '2017-01-11', 'ec'],\n",
       " ['1007', 'Vacaciones', 'Wisin', '10132', '2017-01-11', 'ec'],\n",
       " ['1008', 'Ay Mi Dios', 'IAmChino', '10097', '2017-01-11', 'ec'],\n",
       " ['1009', 'Traicionera', 'Sebastian Yatra', '9105', '2017-01-11', 'ec'],\n",
       " ['1010', 'Dile Que Tu Me Quieres', 'Ozuna', '8767', '2017-01-11', 'ec'],\n",
       " ['1011', 'Closer', 'The Chainsmokers', '8506', '2017-01-11', 'ec'],\n",
       " ['1012', \"Don't Wanna Know\", 'Maroon 5', '8162', '2017-01-11', 'ec'],\n",
       " ['1013', 'Starboy', 'The Weeknd', '8130', '2017-01-11', 'ec'],\n",
       " ['1014', 'Chillax', 'Farruko', '7942', '2017-01-11', 'ec'],\n",
       " ['1015', '24K Magic', 'Bruno Mars', '7509', '2017-01-11', 'ec'],\n",
       " ['1016', 'La Bicicleta', 'Carlos Vives', '7212', '2017-01-11', 'ec'],\n",
       " ['1017', 'Andas En Mi Cabeza', 'Chino & Nacho', '7185', '2017-01-11', 'ec'],\n",
       " ['1018', 'Cuatro Babys', 'Maluma', '7051', '2017-01-11', 'ec'],\n",
       " ['1019',\n",
       "  'Me Llamas (feat. Maluma) - Remix',\n",
       "  'Piso 21',\n",
       "  '7047',\n",
       "  '2017-01-11',\n",
       "  'ec'],\n",
       " ['1020', 'My Way', 'Calvin Harris', '7001', '2017-01-11', 'ec'],\n",
       " ['1021', 'One Dance', 'Drake', '6960', '2017-01-11', 'ec'],\n",
       " ['1022',\n",
       "  'Rockabye (feat. Sean Paul & Anne-Marie)',\n",
       "  'Clean Bandit',\n",
       "  '6831',\n",
       "  '2017-01-11',\n",
       "  'ec'],\n",
       " ['1023', 'I Feel It Coming', 'The Weeknd', '6532', '2017-01-11', 'ec'],\n",
       " ['1024', 'Shaky Shaky', 'Daddy Yankee', '6385', '2017-01-11', 'ec'],\n",
       " ...]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['', 'Track Name', 'Artist', 'Streams', 'Date', 'Region'],\n",
       " ['0', 'Reggaetón Lento (Bailemos)', 'CNCO', '19272', '2017-01-01', 'ec'],\n",
       " ['1', 'Chantaje', 'Shakira', '19270', '2017-01-01', 'ec'],\n",
       " ['2',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '15761',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['3', \"Vente Pa' Ca\", 'Ricky Martin', '14954', '2017-01-01', 'ec']]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['37099', 'Alguien Robo', 'Sebastian Yatra', '2950', '2018-01-09', 'ec']"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.data[-1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[str, str, str, str, str, str]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(36121, 6)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.shape()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "music.new_column(\"test_column\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['', 'Track Name', 'Artist', 'Streams', 'Date', 'Region', 'test_column'],\n",
       " ['0',\n",
       "  'Reggaetón Lento (Bailemos)',\n",
       "  'CNCO',\n",
       "  '19272',\n",
       "  '2017-01-01',\n",
       "  'ec',\n",
       "  'N/A'],\n",
       " ['1', 'Chantaje', 'Shakira', '19270', '2017-01-01', 'ec', 'N/A'],\n",
       " ['2',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '15761',\n",
       "  '2017-01-01',\n",
       "  'ec',\n",
       "  'N/A'],\n",
       " ['3', \"Vente Pa' Ca\", 'Ricky Martin', '14954', '2017-01-01', 'ec', 'N/A']]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(36121, 7)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.shape()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "36122\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "['new_vals',\n",
       " '0.526189235720525',\n",
       " '0.16142277019008977',\n",
       " '0.5859931394940241',\n",
       " '0.5976895515830822']"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from random import random\n",
    "\n",
    "(nrow,ncol) = music.shape()\n",
    "new_vals = []\n",
    "for i in range(nrow+1):\n",
    "    if i==0:\n",
    "        new_vals.append(\"new_vals\")\n",
    "    else:\n",
    "        new_vals.append(str(random()))\n",
    "\n",
    "print(len(new_vals))        \n",
    "new_vals[0:5] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['', 'Track Name', 'Artist', 'Streams', 'Date', 'Region', 'new_vals'],\n",
       " ['0',\n",
       "  'Reggaetón Lento (Bailemos)',\n",
       "  'CNCO',\n",
       "  '19272',\n",
       "  '2017-01-01',\n",
       "  'ec',\n",
       "  '0.526189235720525'],\n",
       " ['1',\n",
       "  'Chantaje',\n",
       "  'Shakira',\n",
       "  '19270',\n",
       "  '2017-01-01',\n",
       "  'ec',\n",
       "  '0.16142277019008977'],\n",
       " ['2',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '15761',\n",
       "  '2017-01-01',\n",
       "  'ec',\n",
       "  '0.5859931394940241'],\n",
       " ['3',\n",
       "  \"Vente Pa' Ca\",\n",
       "  'Ricky Martin',\n",
       "  '14954',\n",
       "  '2017-01-01',\n",
       "  'ec',\n",
       "  '0.5976895515830822']]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.apply(6,new_vals,False)\n",
    "music.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['37099',\n",
       " 'Alguien Robo',\n",
       " 'Sebastian Yatra',\n",
       " '2950',\n",
       " '2018-01-09',\n",
       " 'ec',\n",
       " '0.4140713543305111']"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.data[-1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def apply(data,index,values,row):\n",
    "    if row==True:\n",
    "        data[index]=values\n",
    "    else:\n",
    "        i=0\n",
    "        for row in data:\n",
    "            row[index] = values[i]\n",
    "            i += 1\n",
    "    return data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[['1', '2', '3'], ['10', '20']]\n"
     ]
    }
   ],
   "source": [
    "test = [[\"1\",\"2\",\"3\"],[\"4\",\"5\",\"6\"]]\n",
    "test2 = apply(test,1,[\"10\",\"20\"],True)\n",
    "print(test2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "music.subset(2,\"Shakira\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['1',\n",
       "  'Chantaje',\n",
       "  'Shakira',\n",
       "  '19270',\n",
       "  '2017-01-01',\n",
       "  'ec',\n",
       "  '0.16142277019008977'],\n",
       " ['101',\n",
       "  'Chantaje',\n",
       "  'Shakira',\n",
       "  '15594',\n",
       "  '2017-01-02',\n",
       "  'ec',\n",
       "  '0.15584184581085303'],\n",
       " ['201',\n",
       "  'Chantaje',\n",
       "  'Shakira',\n",
       "  '16614',\n",
       "  '2017-01-03',\n",
       "  'ec',\n",
       "  '0.4399478643341229'],\n",
       " ['301',\n",
       "  'Chantaje',\n",
       "  'Shakira',\n",
       "  '16582',\n",
       "  '2017-01-04',\n",
       "  'ec',\n",
       "  '0.16425612560089675'],\n",
       " ['401',\n",
       "  'Chantaje',\n",
       "  'Shakira',\n",
       "  '16254',\n",
       "  '2017-01-05',\n",
       "  'ec',\n",
       "  '0.6053222968888792']]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "music.change_type(6,lambda x: float(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['1',\n",
       "  'Chantaje',\n",
       "  'Shakira',\n",
       "  '19270',\n",
       "  '2017-01-01',\n",
       "  'ec',\n",
       "  0.16142277019008977],\n",
       " ['101',\n",
       "  'Chantaje',\n",
       "  'Shakira',\n",
       "  '15594',\n",
       "  '2017-01-02',\n",
       "  'ec',\n",
       "  0.15584184581085303],\n",
       " ['201',\n",
       "  'Chantaje',\n",
       "  'Shakira',\n",
       "  '16614',\n",
       "  '2017-01-03',\n",
       "  'ec',\n",
       "  0.4399478643341229],\n",
       " ['301',\n",
       "  'Chantaje',\n",
       "  'Shakira',\n",
       "  '16582',\n",
       "  '2017-01-04',\n",
       "  'ec',\n",
       "  0.16425612560089675],\n",
       " ['401',\n",
       "  'Chantaje',\n",
       "  'Shakira',\n",
       "  '16254',\n",
       "  '2017-01-05',\n",
       "  'ec',\n",
       "  0.6053222968888792]]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The mean is 0.5083549934064555.\n",
      "The median is 0.5163719177497641.\n",
      "The mode is undefined, likely all values different.\n",
      "The stdev is 0.2864735362460558.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "music.summary_stats(6)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.9969422654876078"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.maximum(6)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.0027587279323803005"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "music.minimum(6)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Use BabyPandas to answer the following question:\n",
    "- Which song was the top song of 2017?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['', 'Track Name', 'Artist', 'Streams', 'Date', 'Region'],\n",
       " ['0', 'Reggaetón Lento (Bailemos)', 'CNCO', '19272', '2017-01-01', 'ec'],\n",
       " ['1', 'Chantaje', 'Shakira', '19270', '2017-01-01', 'ec'],\n",
       " ['2',\n",
       "  'Otra Vez (feat. J Balvin)',\n",
       "  'Zion & Lennox',\n",
       "  '15761',\n",
       "  '2017-01-01',\n",
       "  'ec'],\n",
       " ['3', \"Vente Pa' Ca\", 'Ricky Martin', '14954', '2017-01-01', 'ec']]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# read in the data\n",
    "music = BabyPandas(\"music_data.csv\")\n",
    "music.read_data()\n",
    "music.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "time data 'Date' does not match format '%Y-%d-%m'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m\u001b[0m",
      "\u001b[1;31mValueError\u001b[0mTraceback (most recent call last)",
      "\u001b[1;32m<ipython-input-30-dc317302a8ff>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[0;32m      2\u001b[0m \u001b[1;32mfrom\u001b[0m \u001b[0mdatetime\u001b[0m \u001b[1;32mimport\u001b[0m \u001b[0mdatetime\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      3\u001b[0m \u001b[0mmusic\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mnew_column\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"year\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 4\u001b[1;33m \u001b[0mmusic\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mchange_type\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;36m4\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;32mlambda\u001b[0m \u001b[0mx\u001b[0m\u001b[1;33m:\u001b[0m \u001b[0mdatetime\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstrptime\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mx\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m\"%Y-%d-%m\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32m<ipython-input-1-821eb78a79e7>\u001b[0m in \u001b[0;36mchange_type\u001b[1;34m(self, index, new_type)\u001b[0m\n\u001b[0;32m     63\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mchange_type\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mindex\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mnew_type\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     64\u001b[0m         \u001b[1;32mfor\u001b[0m \u001b[0mrow\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdata\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 65\u001b[1;33m             \u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mindex\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mnew_type\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mrow\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mindex\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     66\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     67\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0msummary_stats\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mcol_index\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m<ipython-input-30-dc317302a8ff>\u001b[0m in \u001b[0;36m<lambda>\u001b[1;34m(x)\u001b[0m\n\u001b[0;32m      2\u001b[0m \u001b[1;32mfrom\u001b[0m \u001b[0mdatetime\u001b[0m \u001b[1;32mimport\u001b[0m \u001b[0mdatetime\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      3\u001b[0m \u001b[0mmusic\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mnew_column\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"year\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 4\u001b[1;33m \u001b[0mmusic\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mchange_type\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;36m4\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;32mlambda\u001b[0m \u001b[0mx\u001b[0m\u001b[1;33m:\u001b[0m \u001b[0mdatetime\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstrptime\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mx\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m\"%Y-%d-%m\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32m/usr/lib/python3.4/_strptime.py\u001b[0m in \u001b[0;36m_strptime_datetime\u001b[1;34m(cls, data_string, format)\u001b[0m\n\u001b[0;32m    498\u001b[0m     \"\"\"Return a class cls instance based on the input string and the\n\u001b[0;32m    499\u001b[0m     format string.\"\"\"\n\u001b[1;32m--> 500\u001b[1;33m     \u001b[0mtt\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mfraction\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0m_strptime\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdata_string\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mformat\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    501\u001b[0m     \u001b[0mtzname\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mgmtoff\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mtt\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m-\u001b[0m\u001b[1;36m2\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    502\u001b[0m     \u001b[0margs\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mtt\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;36m6\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m+\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mfraction\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m/usr/lib/python3.4/_strptime.py\u001b[0m in \u001b[0;36m_strptime\u001b[1;34m(data_string, format)\u001b[0m\n\u001b[0;32m    335\u001b[0m     \u001b[1;32mif\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0mfound\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    336\u001b[0m         raise ValueError(\"time data %r does not match format %r\" %\n\u001b[1;32m--> 337\u001b[1;33m                          (data_string, format))\n\u001b[0m\u001b[0;32m    338\u001b[0m     \u001b[1;32mif\u001b[0m \u001b[0mlen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdata_string\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;33m!=\u001b[0m \u001b[0mfound\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    339\u001b[0m         raise ValueError(\"unconverted data remains: %s\" %\n",
      "\u001b[1;31mValueError\u001b[0m: time data 'Date' does not match format '%Y-%d-%m'"
     ]
    }
   ],
   "source": [
    "# add a year column and subset to songs in 2017\n",
    "from datetime import datetime\n",
    "music.new_column(\"year\")\n",
    "music.change_type(4,lambda x: datetime.strptime(x,\"%Y-%m-%d\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# create a dictionary with track name and\n",
    "# stream counts for 2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "datetime.datetime(2017, 1, 1, 0, 0)"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datetime.strptime('2017-01-01',\"%Y-%m-%d\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "'BabyPandas' object does not support indexing",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m\u001b[0m",
      "\u001b[1;31mTypeError\u001b[0mTraceback (most recent call last)",
      "\u001b[1;32m<ipython-input-31-92da21626910>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0myears\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mmusic\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m4\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mTypeError\u001b[0m: 'BabyPandas' object does not support indexing"
     ]
    }
   ],
   "source": [
    "years=music.subset(4,rowval)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "file = open(\"music_data.csv\",\"r\")\n",
    "filestring = file.read()\n",
    "stringlist = filestring.split(\"\\n\")\n",
    "data = []\n",
    "for row in stringlist:\n",
    "    data.append(row.split(\",\"))\n",
    "data=data[:-1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " 'Farruko',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2218',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " ' Zion & Lennox]\"',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-01',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " 'Farruko',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2497',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " ' Zion & Lennox]\"',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-02',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " 'Farruko',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " ' Zion & Lennox]\"',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2574',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-03',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " 'Farruko',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " ' Zion & Lennox]\"',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2497',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-04',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " 'Farruko',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " ' Zion & Lennox]\"',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2650',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-05',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " 'Farruko',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " ' Zion & Lennox]\"',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2690',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-06',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " 'Farruko',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " ' Zion & Lennox]\"',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-07',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " 'Farruko',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " ' Zion & Lennox]\"',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-08',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " 'Farruko',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " ' Zion & Lennox]\"',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-09',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " 'Farruko',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " ' Zion & Lennox]\"',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " '2017-01-10',\n",
       " ...]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dates=[]\n",
    "for row in data[1:]:\n",
    "    dates.append(row[4])\n",
    "dates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 7,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 4,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 16,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 7,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 4,\n",
       " 10,\n",
       " 10,\n",
       " 16,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 7,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 16,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 4,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 7,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 16,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 4,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 7,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 16,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 4,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 7,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 16,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 4,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 7,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 16,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 7,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 16,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 7,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 16,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 7,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 16,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " 10,\n",
       " ...]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lengths = []\n",
    "for date in dates:\n",
    "    lengths.append(len(date))\n",
    "lengths"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "23"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "max(lengths)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "min(lengths)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Farruko',\n",
       " '2218',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '2497',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " '2574',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " '2497',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " '2650',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " '2690',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Messiah & Baby Rasta]\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3721',\n",
       " ' Zion & Lennox]\"',\n",
       " '4045',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " '4347',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " '4371',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " '4097',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " '4729',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '4768',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '4090',\n",
       " ' Zion & Lennox]\"',\n",
       " '4068',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " '4141',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " '4129',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3948',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3949',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '4288',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3674',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3716',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3540',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3807',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3837',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3986',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '4138',\n",
       " ' Cosculluela)\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3807',\n",
       " ' Cosculluela)\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3569',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3731',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3705',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3702',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3968',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '4191',\n",
       " ' Cosculluela)\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3589',\n",
       " ' Cosculluela)\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3321',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3277',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3222',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3369',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3755',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3746',\n",
       " ' Cosculluela)\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3178',\n",
       " ' Cosculluela)\"',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3085',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3067',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3224',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3358',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3649',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3816',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3369',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3127',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3350',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3491',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3246',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3729',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3538',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3221',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3149',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3311',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3394',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3399',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3691',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3570',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3277',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '2928',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3172',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3330',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3494',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3559',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3762',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3096',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3159',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3144',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3254',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3316',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3438',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3650',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3286',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3018',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3062',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3235',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3527',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3544',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3930',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3489',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3337',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3328',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3236',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3553',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3682',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3999',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3557',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3486',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3649',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3401',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3397',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3630',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3526',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3349',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3032',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3164',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3146',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3279',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3567',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3549',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3239',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '2969',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3007',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3134',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3211',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3251',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3646',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3276',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3213',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '2830',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '2708',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '2953',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3305',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3329',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3047',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '2766',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '2831',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '2911',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3025',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3267',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3550',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '2949',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '2708',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3005',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3025',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '2967',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3141',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3267',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '2891',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3272',\n",
       " ' Zion & Lennox]\"',\n",
       " '3922',\n",
       " 'Farruko',\n",
       " '2900',\n",
       " ' Zion & Lennox]\"',\n",
       " '3986',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '4042',\n",
       " '3141',\n",
       " ' Zion & Lennox]\"',\n",
       " '3885',\n",
       " 'Farruko',\n",
       " '3062',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3565',\n",
       " '2861',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3500',\n",
       " ' Zion & Lennox]\"',\n",
       " '3640',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " '3872',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " '3922',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " '3751',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3951',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '4046',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " '3560',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " 'Jennifer Lopez',\n",
       " '3245',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " 'Jennifer Lopez',\n",
       " '3200',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " 'Jennifer Lopez',\n",
       " '3324',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " '3129',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " '3770',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " 'Jennifer Lopez',\n",
       " '3623',\n",
       " '3011',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " 'Jennifer Lopez',\n",
       " '2873',\n",
       " '2803',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " 'Jennifer Lopez',\n",
       " '2902',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " '3081',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " '3461',\n",
       " 'Farruko',\n",
       " '6322',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " 'Farruko',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez',\n",
       " '2971',\n",
       " ' Zion & Lennox]\"',\n",
       " 'Jennifer Lopez']"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weird_dates=[]\n",
    "for date in dates:\n",
    "    if len(date) != 10:\n",
    "        weird_dates.append(date)\n",
    "weird_dates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(weird_dates[1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}