user-artist-data-preprocessing.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>user_id</th>\n",
       "      <th>artist_mbid</th>\n",
       "      <th>artist_name</th>\n",
       "      <th>plays</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>b7ffd2af-418f-4be2-bdd1-22f8b48613da</td>\n",
       "      <td>nine inch nails</td>\n",
       "      <td>11092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>8ca01f46-53ac-4af2-8516-55a909c0905e</td>\n",
       "      <td>my bloody valentine</td>\n",
       "      <td>1671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>e795e03d-b5d5-4a5f-834d-162cfb308a2c</td>\n",
       "      <td>pj harvey</td>\n",
       "      <td>1603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>69ee3720-a7cb-4402-b48d-a02c366f2bcf</td>\n",
       "      <td>the cure</td>\n",
       "      <td>1588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>90cc2464-234e-4da0-b39b-576f36e633bc</td>\n",
       "      <td>antony and the johnsons</td>\n",
       "      <td>1039</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0                                   user_id  \\\n",
       "0           0  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "1           1  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "2           2  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "3           3  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "4           4  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "\n",
       "                            artist_mbid              artist_name  plays  \n",
       "0  b7ffd2af-418f-4be2-bdd1-22f8b48613da          nine inch nails  11092  \n",
       "1  8ca01f46-53ac-4af2-8516-55a909c0905e      my bloody valentine   1671  \n",
       "2  e795e03d-b5d5-4a5f-834d-162cfb308a2c                pj harvey   1603  \n",
       "3  69ee3720-a7cb-4402-b48d-a02c366f2bcf                 the cure   1588  \n",
       "4  90cc2464-234e-4da0-b39b-576f36e633bc  antony and the johnsons   1039  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=pd.read_csv('lastfm_9000_users.csv')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(438346, 5)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop(['Unnamed: 0'],axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>artist_mbid</th>\n",
       "      <th>artist_name</th>\n",
       "      <th>plays</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>b7ffd2af-418f-4be2-bdd1-22f8b48613da</td>\n",
       "      <td>nine inch nails</td>\n",
       "      <td>11092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>8ca01f46-53ac-4af2-8516-55a909c0905e</td>\n",
       "      <td>my bloody valentine</td>\n",
       "      <td>1671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>e795e03d-b5d5-4a5f-834d-162cfb308a2c</td>\n",
       "      <td>pj harvey</td>\n",
       "      <td>1603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>69ee3720-a7cb-4402-b48d-a02c366f2bcf</td>\n",
       "      <td>the cure</td>\n",
       "      <td>1588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>90cc2464-234e-4da0-b39b-576f36e633bc</td>\n",
       "      <td>antony and the johnsons</td>\n",
       "      <td>1039</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    user_id  \\\n",
       "0  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "1  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "2  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "3  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "4  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "\n",
       "                            artist_mbid              artist_name  plays  \n",
       "0  b7ffd2af-418f-4be2-bdd1-22f8b48613da          nine inch nails  11092  \n",
       "1  8ca01f46-53ac-4af2-8516-55a909c0905e      my bloody valentine   1671  \n",
       "2  e795e03d-b5d5-4a5f-834d-162cfb308a2c                pj harvey   1603  \n",
       "3  69ee3720-a7cb-4402-b48d-a02c366f2bcf                 the cure   1588  \n",
       "4  90cc2464-234e-4da0-b39b-576f36e633bc  antony and the johnsons   1039  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>artist_mbid</th>\n",
       "      <th>artist_name</th>\n",
       "      <th>plays</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</th>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000a1585c5f65532a9c9187a882892982d345a5c</th>\n",
       "      <td>46</td>\n",
       "      <td>47</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000fd8e3929fdab3c872a0c850fe4f3a3368af38</th>\n",
       "      <td>49</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0018c29f20d69d17a14ba01089ec997acaffbb46</th>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>001eb13513650a4e21664965bac63d60e44be8a5</th>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002953eed5afd0a047b8f3e3a6301a7071b5f942</th>\n",
       "      <td>28</td>\n",
       "      <td>29</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002b5d4a2aea86f2b52103393398409aa28d435a</th>\n",
       "      <td>75</td>\n",
       "      <td>76</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002e3b163344124259c8ed8f8ebecbcdfc186b4a</th>\n",
       "      <td>49</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0033de80a55a7be53bd86034ca32cc3b2e2a85d3</th>\n",
       "      <td>46</td>\n",
       "      <td>47</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>00349d64e8306f6a89e6cf852239082773fc7f5c</th>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0039b1adabf4032af4da32e79bd0d7307e71b854</th>\n",
       "      <td>60</td>\n",
       "      <td>60</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>004471b7e2b4fc470ca9a0e327d81dddce3e6574</th>\n",
       "      <td>62</td>\n",
       "      <td>63</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>00456ba983e5d59c62459149b7662dcf10d72e69</th>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>004b05cfb04c5f880470838adaf2a8d8b8fe6176</th>\n",
       "      <td>47</td>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>004e4e1831d13564c7c9ab3f21a8bcbfe5bb9f94</th>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0056f9124c776ff1dd158c2d12440cee874ff3cb</th>\n",
       "      <td>59</td>\n",
       "      <td>60</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>005749da9449348f6f3a6adaefd9f4d9c788acd4</th>\n",
       "      <td>47</td>\n",
       "      <td>47</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>006e098abb3f7ddce96fa311e7568aa29154effa</th>\n",
       "      <td>44</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>008687c07718221268fc4763b17d72b76c3f1f3c</th>\n",
       "      <td>41</td>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0093e72c75f5a0c36dd47073e104a3ae4ba96cef</th>\n",
       "      <td>63</td>\n",
       "      <td>63</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>00a1b2cc5145f07366a1c56221ae31e34501e46d</th>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>00a996baa9064cc4e372d316e28ab845b2ba3506</th>\n",
       "      <td>47</td>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>00ad7e173f9ed914d22098afee8517fce445044b</th>\n",
       "      <td>35</td>\n",
       "      <td>36</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>00b11f68e73c73351fe154d54b3f75b78b5cc8b2</th>\n",
       "      <td>45</td>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>00b34ec7a274a554458d7cce49548af655c3da10</th>\n",
       "      <td>40</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>00bc63222366cf663d328a274e01694f188a8040</th>\n",
       "      <td>60</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>00c256519bf928d4403998fcf3428a398bbd01b6</th>\n",
       "      <td>37</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>00c6f24c89ccf5c215909b66c1dc5909ddcebf4b</th>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>00d16d500004a79ade76cad5e8bbbf1fae920321</th>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>00d1b42eacef56e113cb9a9ce7befc84c8677e14</th>\n",
       "      <td>29</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff4a5eba8c56c5c4a78bad5a66c53de6b3721c1f</th>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff51f97529dd03b45c2f498797017d5fe174fdd9</th>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff54b094a6a6095d8208bb8daa5833f282c5be20</th>\n",
       "      <td>43</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff63be5119072afd12fb238ea7b1fd05f9916f93</th>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff64d50d503770d2f69327c9313b9231403d7262</th>\n",
       "      <td>48</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff650770116ae527fc3035176d439676fd7b4f3b</th>\n",
       "      <td>59</td>\n",
       "      <td>60</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff6a096b03ed872b4a092dcd8241a2a72e2e8ed0</th>\n",
       "      <td>47</td>\n",
       "      <td>47</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff72ada3862c202aadff2c4689de722739d9a29e</th>\n",
       "      <td>50</td>\n",
       "      <td>51</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff76645706ed8176e18e76eba9e97f4121574d29</th>\n",
       "      <td>55</td>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff775907c7cc123cdd4fd9df62b5cddf57a82dfa</th>\n",
       "      <td>49</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff7bc34efbf595133e01e62a70f29a53c0704477</th>\n",
       "      <td>45</td>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff835d23392cb3127fe97e00fdd2d76a376807cc</th>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff85c5226323bf2dcb124657833bfa8ee2bc450d</th>\n",
       "      <td>43</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff8e18d8b4195b11a244403e508dca92a15447d5</th>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ff909aedf8de338113cb7dd34f7fd87fbeeca5cd</th>\n",
       "      <td>47</td>\n",
       "      <td>47</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ffa056fe912c16cbb8a86ee7d79aa9eae0867422</th>\n",
       "      <td>27</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ffacdbe6584054a48647ce94253a923c9b74bb32</th>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ffad163ba010f19c405ef2d3952b9e18fc53b732</th>\n",
       "      <td>48</td>\n",
       "      <td>49</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ffb5f556433d30ebe5fe4bf524eb493540fe1377</th>\n",
       "      <td>49</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ffb675bf47413af2bb82151904a61e3dbbd5fb1d</th>\n",
       "      <td>40</td>\n",
       "      <td>41</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ffbd73db809368a08d593767abe0facc34ce18e3</th>\n",
       "      <td>39</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ffc3f10a37fe9d91a17c107d2746de59d7ad36a1</th>\n",
       "      <td>42</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ffd2fde868aede3f54b35a00ac1ab5c67feaad1c</th>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ffd9e5830d4a945dfbd392ea247f5461a3dc039b</th>\n",
       "      <td>42</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ffdbff74a33187f2fdd63acc951788e89f3a30ce</th>\n",
       "      <td>39</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ffe7caf6f84055040914052e95c2ceabd58116f2</th>\n",
       "      <td>25</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ffeb193e80fabff1804e71cc2b6bb6bb2a31ac03</th>\n",
       "      <td>46</td>\n",
       "      <td>47</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fff58a5c95280b7af63f9c552f9159b58ae5efa3</th>\n",
       "      <td>54</td>\n",
       "      <td>55</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fffafd71aa24298dbd5a1be22f6be1512a7d7fab</th>\n",
       "      <td>63</td>\n",
       "      <td>63</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fffe356b9dab2fae1f887fabb1f08ab4976c91bb</th>\n",
       "      <td>44</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9000 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          artist_mbid  artist_name  plays\n",
       "user_id                                                                  \n",
       "00029d80b8af94f2d5e3349ceb28b7304f80c1c4           49           49     49\n",
       "000a1585c5f65532a9c9187a882892982d345a5c           46           47     47\n",
       "000fd8e3929fdab3c872a0c850fe4f3a3368af38           49           50     50\n",
       "0018c29f20d69d17a14ba01089ec997acaffbb46           48           48     48\n",
       "001eb13513650a4e21664965bac63d60e44be8a5           48           48     48\n",
       "002953eed5afd0a047b8f3e3a6301a7071b5f942           28           29     29\n",
       "002b5d4a2aea86f2b52103393398409aa28d435a           75           76     76\n",
       "002e3b163344124259c8ed8f8ebecbcdfc186b4a           49           50     50\n",
       "0033de80a55a7be53bd86034ca32cc3b2e2a85d3           46           47     47\n",
       "00349d64e8306f6a89e6cf852239082773fc7f5c           48           48     48\n",
       "0039b1adabf4032af4da32e79bd0d7307e71b854           60           60     60\n",
       "004471b7e2b4fc470ca9a0e327d81dddce3e6574           62           63     63\n",
       "00456ba983e5d59c62459149b7662dcf10d72e69           49           49     49\n",
       "004b05cfb04c5f880470838adaf2a8d8b8fe6176           47           48     48\n",
       "004e4e1831d13564c7c9ab3f21a8bcbfe5bb9f94           50           50     50\n",
       "0056f9124c776ff1dd158c2d12440cee874ff3cb           59           60     60\n",
       "005749da9449348f6f3a6adaefd9f4d9c788acd4           47           47     47\n",
       "006e098abb3f7ddce96fa311e7568aa29154effa           44           45     45\n",
       "008687c07718221268fc4763b17d72b76c3f1f3c           41           42     42\n",
       "0093e72c75f5a0c36dd47073e104a3ae4ba96cef           63           63     63\n",
       "00a1b2cc5145f07366a1c56221ae31e34501e46d           50           50     50\n",
       "00a996baa9064cc4e372d316e28ab845b2ba3506           47           48     48\n",
       "00ad7e173f9ed914d22098afee8517fce445044b           35           36     36\n",
       "00b11f68e73c73351fe154d54b3f75b78b5cc8b2           45           46     46\n",
       "00b34ec7a274a554458d7cce49548af655c3da10           40           41     41\n",
       "00bc63222366cf663d328a274e01694f188a8040           60           61     61\n",
       "00c256519bf928d4403998fcf3428a398bbd01b6           37           38     38\n",
       "00c6f24c89ccf5c215909b66c1dc5909ddcebf4b           49           49     49\n",
       "00d16d500004a79ade76cad5e8bbbf1fae920321           49           49     49\n",
       "00d1b42eacef56e113cb9a9ce7befc84c8677e14           29           30     30\n",
       "...                                               ...          ...    ...\n",
       "ff4a5eba8c56c5c4a78bad5a66c53de6b3721c1f           38           38     38\n",
       "ff51f97529dd03b45c2f498797017d5fe174fdd9           48           48     48\n",
       "ff54b094a6a6095d8208bb8daa5833f282c5be20           43           44     44\n",
       "ff63be5119072afd12fb238ea7b1fd05f9916f93           49           49     49\n",
       "ff64d50d503770d2f69327c9313b9231403d7262           48           49     49\n",
       "ff650770116ae527fc3035176d439676fd7b4f3b           59           60     60\n",
       "ff6a096b03ed872b4a092dcd8241a2a72e2e8ed0           47           47     47\n",
       "ff72ada3862c202aadff2c4689de722739d9a29e           50           51     51\n",
       "ff76645706ed8176e18e76eba9e97f4121574d29           55           56     56\n",
       "ff775907c7cc123cdd4fd9df62b5cddf57a82dfa           49           50     50\n",
       "ff7bc34efbf595133e01e62a70f29a53c0704477           45           46     46\n",
       "ff835d23392cb3127fe97e00fdd2d76a376807cc           42           42     42\n",
       "ff85c5226323bf2dcb124657833bfa8ee2bc450d           43           44     44\n",
       "ff8e18d8b4195b11a244403e508dca92a15447d5            5            6      6\n",
       "ff909aedf8de338113cb7dd34f7fd87fbeeca5cd           47           47     47\n",
       "ffa056fe912c16cbb8a86ee7d79aa9eae0867422           27           28     28\n",
       "ffacdbe6584054a48647ce94253a923c9b74bb32           50           50     50\n",
       "ffad163ba010f19c405ef2d3952b9e18fc53b732           48           49     49\n",
       "ffb5f556433d30ebe5fe4bf524eb493540fe1377           49           50     50\n",
       "ffb675bf47413af2bb82151904a61e3dbbd5fb1d           40           41     41\n",
       "ffbd73db809368a08d593767abe0facc34ce18e3           39           40     40\n",
       "ffc3f10a37fe9d91a17c107d2746de59d7ad36a1           42           43     43\n",
       "ffd2fde868aede3f54b35a00ac1ab5c67feaad1c           50           50     50\n",
       "ffd9e5830d4a945dfbd392ea247f5461a3dc039b           42           43     43\n",
       "ffdbff74a33187f2fdd63acc951788e89f3a30ce           39           40     40\n",
       "ffe7caf6f84055040914052e95c2ceabd58116f2           25           26     26\n",
       "ffeb193e80fabff1804e71cc2b6bb6bb2a31ac03           46           47     47\n",
       "fff58a5c95280b7af63f9c552f9159b58ae5efa3           54           55     55\n",
       "fffafd71aa24298dbd5a1be22f6be1512a7d7fab           63           63     63\n",
       "fffe356b9dab2fae1f887fabb1f08ab4976c91bb           44           45     45\n",
       "\n",
       "[9000 rows x 3 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby(['user_id']).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_mat=df.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_mat.drop(['artist_name'],axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_mat=df_mat.reset_index(drop=True)\n",
    "df_mat['List Index']=df_mat.index\n",
    "users_group=df_mat.groupby('user_id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>artist_mbid</th>\n",
       "      <th>plays</th>\n",
       "      <th>List Index</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>b7ffd2af-418f-4be2-bdd1-22f8b48613da</td>\n",
       "      <td>11092</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>8ca01f46-53ac-4af2-8516-55a909c0905e</td>\n",
       "      <td>1671</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>e795e03d-b5d5-4a5f-834d-162cfb308a2c</td>\n",
       "      <td>1603</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>69ee3720-a7cb-4402-b48d-a02c366f2bcf</td>\n",
       "      <td>1588</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>90cc2464-234e-4da0-b39b-576f36e633bc</td>\n",
       "      <td>1039</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    user_id  \\\n",
       "0  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "1  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "2  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "3  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "4  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "\n",
       "                            artist_mbid  plays  List Index  \n",
       "0  b7ffd2af-418f-4be2-bdd1-22f8b48613da  11092           0  \n",
       "1  8ca01f46-53ac-4af2-8516-55a909c0905e   1671           1  \n",
       "2  e795e03d-b5d5-4a5f-834d-162cfb308a2c   1603           2  \n",
       "3  69ee3720-a7cb-4402-b48d-a02c366f2bcf   1588           3  \n",
       "4  90cc2464-234e-4da0-b39b-576f36e633bc   1039           4  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_mat.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "norm_plays=df_mat[['user_id','plays']].groupby('user_id').transform(lambda x: ((x - x.min())) /(x.max()-x.min()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.000000    23466\n",
       "1.000000     9197\n",
       "0.200000     1034\n",
       "0.333333      933\n",
       "0.142857      926\n",
       "0.166667      924\n",
       "0.250000      882\n",
       "0.500000      812\n",
       "0.090909      762\n",
       "0.125000      734\n",
       "0.100000      732\n",
       "0.066667      668\n",
       "0.076923      665\n",
       "0.111111      655\n",
       "0.083333      626\n",
       "0.058824      613\n",
       "0.071429      607\n",
       "0.055556      512\n",
       "0.038462      506\n",
       "0.052632      501\n",
       "0.285714      468\n",
       "0.045455      451\n",
       "0.047619      449\n",
       "0.181818      429\n",
       "0.400000      422\n",
       "0.062500      417\n",
       "0.043478      415\n",
       "0.040000      393\n",
       "0.153846      379\n",
       "0.033333      376\n",
       "            ...  \n",
       "0.479835        1\n",
       "0.201509        1\n",
       "0.850820        1\n",
       "0.048918        1\n",
       "0.298587        1\n",
       "0.537249        1\n",
       "0.725768        1\n",
       "0.943554        1\n",
       "0.137858        1\n",
       "0.370563        1\n",
       "0.852921        1\n",
       "0.054731        1\n",
       "0.245798        1\n",
       "0.014510        1\n",
       "0.128159        1\n",
       "0.133043        1\n",
       "0.035182        1\n",
       "0.031719        1\n",
       "0.056707        1\n",
       "0.036382        1\n",
       "0.798942        1\n",
       "0.102868        1\n",
       "0.184656        1\n",
       "0.007167        1\n",
       "0.000143        1\n",
       "0.027366        1\n",
       "0.102324        1\n",
       "0.030033        1\n",
       "0.067618        1\n",
       "0.432007        1\n",
       "Name: plays, Length: 150611, dtype: int64"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "norm_plays.plays.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_mat['norm_plays']=norm_plays"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_mat.to_csv('user_song_rating.csv',index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>artist_mbid</th>\n",
       "      <th>plays</th>\n",
       "      <th>List Index</th>\n",
       "      <th>norm_plays</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>b7ffd2af-418f-4be2-bdd1-22f8b48613da</td>\n",
       "      <td>11092</td>\n",
       "      <td>0</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>8ca01f46-53ac-4af2-8516-55a909c0905e</td>\n",
       "      <td>1671</td>\n",
       "      <td>1</td>\n",
       "      <td>0.145875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>e795e03d-b5d5-4a5f-834d-162cfb308a2c</td>\n",
       "      <td>1603</td>\n",
       "      <td>2</td>\n",
       "      <td>0.139710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>69ee3720-a7cb-4402-b48d-a02c366f2bcf</td>\n",
       "      <td>1588</td>\n",
       "      <td>3</td>\n",
       "      <td>0.138350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>90cc2464-234e-4da0-b39b-576f36e633bc</td>\n",
       "      <td>1039</td>\n",
       "      <td>4</td>\n",
       "      <td>0.088577</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    user_id  \\\n",
       "0  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "1  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "2  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "3  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "4  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "\n",
       "                            artist_mbid  plays  List Index  norm_plays  \n",
       "0  b7ffd2af-418f-4be2-bdd1-22f8b48613da  11092           0    1.000000  \n",
       "1  8ca01f46-53ac-4af2-8516-55a909c0905e   1671           1    0.145875  \n",
       "2  e795e03d-b5d5-4a5f-834d-162cfb308a2c   1603           2    0.139710  \n",
       "3  69ee3720-a7cb-4402-b48d-a02c366f2bcf   1588           3    0.138350  \n",
       "4  90cc2464-234e-4da0-b39b-576f36e633bc   1039           4    0.088577  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_mat.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matrix=df_mat.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matrix.drop(['plays','List Index'],axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>artist_mbid</th>\n",
       "      <th>norm_plays</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>b7ffd2af-418f-4be2-bdd1-22f8b48613da</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>8ca01f46-53ac-4af2-8516-55a909c0905e</td>\n",
       "      <td>0.145875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>e795e03d-b5d5-4a5f-834d-162cfb308a2c</td>\n",
       "      <td>0.139710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>69ee3720-a7cb-4402-b48d-a02c366f2bcf</td>\n",
       "      <td>0.138350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>00029d80b8af94f2d5e3349ceb28b7304f80c1c4</td>\n",
       "      <td>90cc2464-234e-4da0-b39b-576f36e633bc</td>\n",
       "      <td>0.088577</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    user_id  \\\n",
       "0  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "1  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "2  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "3  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "4  00029d80b8af94f2d5e3349ceb28b7304f80c1c4   \n",
       "\n",
       "                            artist_mbid  norm_plays  \n",
       "0  b7ffd2af-418f-4be2-bdd1-22f8b48613da    1.000000  \n",
       "1  8ca01f46-53ac-4af2-8516-55a909c0905e    0.145875  \n",
       "2  e795e03d-b5d5-4a5f-834d-162cfb308a2c    0.139710  \n",
       "3  69ee3720-a7cb-4402-b48d-a02c366f2bcf    0.138350  \n",
       "4  90cc2464-234e-4da0-b39b-576f36e633bc    0.088577  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matrix.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "user_id           0\n",
       "artist_mbid    5731\n",
       "norm_plays       48\n",
       "dtype: int64"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matrix.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matrix.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1    298823\n",
       "2     60924\n",
       "3     23888\n",
       "0     23011\n",
       "5     14720\n",
       "4     11203\n",
       "Name: norm_plays, dtype: int64"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matrix.norm_plays=df_matrix.norm_plays.apply(lambda x:math.ceil(x*5))"
   ]
  }
 ],
 "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.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}