Skip to content

Instantly share code, notes, and snippets.

@shahifaqeer

shahifaqeer/MST-API-week-details.ipynb

Last active September 15, 2015 02:26
Show Gist options
  • Save shahifaqeer/fb368a6fac864aa5724f to your computer and use it in GitHub Desktop.
Save shahifaqeer/fb368a6fac864aa5724f to your computer and use it in GitHub Desktop.
Download ZIP
Prelim app usage details over a week
Display the source blob
Display the rendered blob
Raw
MST-API-week-details.ipynb
{
"metadata": {
"name": "",
"signature": "sha256:2b8051ced0b806a98ad341e65650e7b53ee6e76056f2669d83d6a2c78a973354"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"#MYSPEEDTEST data\n",
"\n",
"- 1 week random\n",
"- 1 Mar 2015 - 8 Mar 2015\n",
"- Related Doc: https://docs.google.com/document/d/17Ut6ovlCyaJfKnKeZ-DyBjdP6pKixovT6FXbjoWnDG8/edit?usp=sharing"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"from __future__ import division\n",
"\n",
"import time\n",
"import pandas as pd\n",
"from collections import defaultdict"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 1
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"from sqlalchemy import create_engine\n",
"engine = create_engine('postgresql:///androidperformance2')"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 2
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Measurement API\n",
"- measurement type: ping, traceroute, link, usage, etc.\n",
"\n",
"measurement_country_time\n",
"- Dates filter [join prev on measurementid with measurement table for 'time']\n",
"- Device details/country filter [join prev on measurementid with device for 'deviceid', 'networkcountry', 'datacap', 'manufacturer']\n",
"\n",
"network\n",
"- Network type/wifi filter [join prev on measurementid with network for 'wifistate', 'connectiontype']"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"date_start = '2015-03-01' \n",
"date_stop = '2015-03-08'\n",
"meas_table = 'ping'\n",
"\n",
"query = \"SELECT %s.*, m.deviceid, m.time, m.networkcountry FROM %s INNER JOIN \\\n",
" (SELECT * FROM measurement_country_time WHERE measurement_country_time.time>='%s' AND measurement_country_time.time<'%s') \\\n",
" AS m ON %s.measurementid=m.measurementid\" \\\n",
"%(meas_table, meas_table, date_start, date_stop, meas_table)\n",
"print query\n",
"\n",
"#ping_filtered = pd.read_sql_query(query,con=engine)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"SELECT ping.*, m.deviceid, m.time, m.networkcountry FROM ping INNER JOIN (SELECT * FROM measurement_country_time WHERE measurement_country_time.time>='2015-03-01' AND measurement_country_time.time<'2015-03-08') AS m ON ping.measurementid=m.measurementid\n"
]
}
],
"prompt_number": 3
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"def get_measurement_by_date(meas_table, date_start, date_stop):\n",
" \"\"\"\n",
" get measurement table filtered to dates\n",
" meas_table can be ping, traceroute, link, usage, network, device, etc\n",
" this is joined to measurement table filtered by dates\n",
" (for faster processing - prefilter measurement table to dates and then join)\n",
" returns panda dataframe with filtered results after INNER JOIN\n",
" \n",
" \n",
" CREATE TABLE measurement_country_time AS\n",
" (SELECT measurement.time, measurement.deviceid, measurement.measurementid,\n",
" device_sim_join.networkcountry, device_sim_join.manufacturer, device_sim_join.phonemodel,\n",
" device_sim_join.androidversion, device_sim_join.datacap FROM measurement\n",
" JOIN device_sim_join ON (measurement.deviceid=device_sim_join.deviceid));\n",
" \"\"\"\n",
" \n",
" query = \"SELECT %s.*, m.* FROM %s INNER JOIN \\\n",
" (SELECT * FROM measurement_country_time_network WHERE measurement_country_time_network.time>='%s' \\\n",
" AND measurement_country_time_network.time<'%s') \\\n",
" AS m ON %s.measurementid=m.measurementid\" \\\n",
" %(meas_table, meas_table, date_start, date_stop, meas_table)\n",
" \n",
" print \"query = \", query\n",
" \n",
" start_t = time.time()\n",
" filtered_meas = pd.read_sql_query(query,con=engine)\n",
" clock = time.time() - start_t\n",
" \n",
" print \"TIME TAKEN = \", clock, 's'\n",
" \n",
" return filtered_meas"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 11
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"application = pd.read_sql_query('SELECT * from application',con=engine)\n",
"application.head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>name</th>\n",
" <th>package</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> Google Backup Transp</td>\n",
" <td> com.google.android.backup</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> Hacker News</td>\n",
" <td> com.airlocksoftware.hackernews</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> Pulse</td>\n",
" <td> com.alphonso.pulse</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td> Browser</td>\n",
" <td> com.android.browser</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td> Dialer</td>\n",
" <td> com.android.phone</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 12,
"text": [
" name package\n",
"0 Google Backup Transp com.google.android.backup\n",
"1 Hacker News com.airlocksoftware.hackernews\n",
"2 Pulse com.alphonso.pulse\n",
"3 Browser com.android.browser\n",
"4 Dialer com.android.phone"
]
}
],
"prompt_number": 12
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## USAGE"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"usage = get_measurement_by_date('application_use', '2015-03-01', '2015-03-08')"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"query = SELECT application_use.*, m.* FROM application_use INNER JOIN (SELECT * FROM measurement_country_time_network WHERE measurement_country_time_network.time>='2015-03-01' AND measurement_country_time_network.time<'2015-03-08') AS m ON application_use.measurementid=m.measurementid\n",
"TIME TAKEN = "
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
" 882.47694397 s\n"
]
}
],
"prompt_number": 13
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"usage.head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>application_useid</th>\n",
" <th>package</th>\n",
" <th>total_sent</th>\n",
" <th>total_recv</th>\n",
" <th>isrunning</th>\n",
" <th>measurementid</th>\n",
" <th>total_diff</th>\n",
" <th>isforeground</th>\n",
" <th>time</th>\n",
" <th>deviceid</th>\n",
" <th>...</th>\n",
" <th>manufacturer</th>\n",
" <th>phonemodel</th>\n",
" <th>androidversion</th>\n",
" <th>datacap</th>\n",
" <th>networktype</th>\n",
" <th>connectiontype</th>\n",
" <th>signalstrength</th>\n",
" <th>celltype</th>\n",
" <th>longitude</th>\n",
" <th>latitude</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> 476106397</td>\n",
" <td> com.sec.android.app.DataCreate</td>\n",
" <td> 8384</td>\n",
" <td> 8384</td>\n",
" <td> False</td>\n",
" <td> 17676218</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td>2015-03-04 14:45:50</td>\n",
" <td> c9043a490890938108a0879d1c8113826004114a</td>\n",
" <td>...</td>\n",
" <td> samsung</td>\n",
" <td> SM-G900F</td>\n",
" <td> 4.4.2</td>\n",
" <td>-1</td>\n",
" <td> </td>\n",
" <td> Mobile: </td>\n",
" <td> 23</td>\n",
" <td> GSM</td>\n",
" <td>-99</td>\n",
" <td>-99</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> 476106398</td>\n",
" <td> com.sec.android.app.SecSetupWizard</td>\n",
" <td> 2490</td>\n",
" <td> 46104</td>\n",
" <td> True</td>\n",
" <td> 17676218</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td>2015-03-04 14:45:50</td>\n",
" <td> c9043a490890938108a0879d1c8113826004114a</td>\n",
" <td>...</td>\n",
" <td> samsung</td>\n",
" <td> SM-G900F</td>\n",
" <td> 4.4.2</td>\n",
" <td>-1</td>\n",
" <td> </td>\n",
" <td> Mobile: </td>\n",
" <td> 23</td>\n",
" <td> GSM</td>\n",
" <td>-99</td>\n",
" <td>-99</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> 476106399</td>\n",
" <td> com.zeroteam.zerolauncher</td>\n",
" <td> 18438</td>\n",
" <td> 4695</td>\n",
" <td> True</td>\n",
" <td> 17676218</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td>2015-03-04 14:45:50</td>\n",
" <td> c9043a490890938108a0879d1c8113826004114a</td>\n",
" <td>...</td>\n",
" <td> samsung</td>\n",
" <td> SM-G900F</td>\n",
" <td> 4.4.2</td>\n",
" <td>-1</td>\n",
" <td> </td>\n",
" <td> Mobile: </td>\n",
" <td> 23</td>\n",
" <td> GSM</td>\n",
" <td>-99</td>\n",
" <td>-99</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td> 476106400</td>\n",
" <td> com.google.android.googlequicksearchbox</td>\n",
" <td> 1940</td>\n",
" <td> 12246</td>\n",
" <td> False</td>\n",
" <td> 17676218</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td>2015-03-04 14:45:50</td>\n",
" <td> c9043a490890938108a0879d1c8113826004114a</td>\n",
" <td>...</td>\n",
" <td> samsung</td>\n",
" <td> SM-G900F</td>\n",
" <td> 4.4.2</td>\n",
" <td>-1</td>\n",
" <td> </td>\n",
" <td> Mobile: </td>\n",
" <td> 23</td>\n",
" <td> GSM</td>\n",
" <td>-99</td>\n",
" <td>-99</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td> 476106401</td>\n",
" <td> com.facebook.katana</td>\n",
" <td> 2003733</td>\n",
" <td> 20670317</td>\n",
" <td> True</td>\n",
" <td> 17676218</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td>2015-03-04 14:45:50</td>\n",
" <td> c9043a490890938108a0879d1c8113826004114a</td>\n",
" <td>...</td>\n",
" <td> samsung</td>\n",
" <td> SM-G900F</td>\n",
" <td> 4.4.2</td>\n",
" <td>-1</td>\n",
" <td> </td>\n",
" <td> Mobile: </td>\n",
" <td> 23</td>\n",
" <td> GSM</td>\n",
" <td>-99</td>\n",
" <td>-99</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows \u00d7 22 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 14,
"text": [
" application_useid package total_sent \\\n",
"0 476106397 com.sec.android.app.DataCreate 8384 \n",
"1 476106398 com.sec.android.app.SecSetupWizard 2490 \n",
"2 476106399 com.zeroteam.zerolauncher 18438 \n",
"3 476106400 com.google.android.googlequicksearchbox 1940 \n",
"4 476106401 com.facebook.katana 2003733 \n",
"\n",
" total_recv isrunning measurementid total_diff isforeground \\\n",
"0 8384 False 17676218 None None \n",
"1 46104 True 17676218 None None \n",
"2 4695 True 17676218 None None \n",
"3 12246 False 17676218 None None \n",
"4 20670317 True 17676218 None None \n",
"\n",
" time deviceid \\\n",
"0 2015-03-04 14:45:50 c9043a490890938108a0879d1c8113826004114a \n",
"1 2015-03-04 14:45:50 c9043a490890938108a0879d1c8113826004114a \n",
"2 2015-03-04 14:45:50 c9043a490890938108a0879d1c8113826004114a \n",
"3 2015-03-04 14:45:50 c9043a490890938108a0879d1c8113826004114a \n",
"4 2015-03-04 14:45:50 c9043a490890938108a0879d1c8113826004114a \n",
"\n",
" ... manufacturer phonemodel \\\n",
"0 ... samsung SM-G900F \n",
"1 ... samsung SM-G900F \n",
"2 ... samsung SM-G900F \n",
"3 ... samsung SM-G900F \n",
"4 ... samsung SM-G900F \n",
"\n",
" androidversion datacap networktype connectiontype signalstrength celltype \\\n",
"0 4.4.2 -1 Mobile: 23 GSM \n",
"1 4.4.2 -1 Mobile: 23 GSM \n",
"2 4.4.2 -1 Mobile: 23 GSM \n",
"3 4.4.2 -1 Mobile: 23 GSM \n",
"4 4.4.2 -1 Mobile: 23 GSM \n",
"\n",
" longitude latitude \n",
"0 -99 -99 \n",
"1 -99 -99 \n",
"2 -99 -99 \n",
"3 -99 -99 \n",
"4 -99 -99 \n",
"\n",
"[5 rows x 22 columns]"
]
}
],
"prompt_number": 14
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Number of vantage points"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"usage_ir = usage[usage['networkcountry']=='ir']"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 25
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"usage_app_ir = usage_ir.merge(application)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 26
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"print \"number of unique devices in IR in one random week: \", len(usage_app_ir['deviceid'].unique())"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"number of unique devices in IR in one random week: "
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"51\n"
]
}
],
"prompt_number": 27
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## QR Reader"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### All countries"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"del usage['measurementid']\n",
"usage.columns"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 18,
"text": [
"Index([u'application_useid', u'package', u'total_sent', u'total_recv', u'isrunning', u'total_diff', u'isforeground', u'time', u'deviceid', u'networkcountry', u'manufacturer', u'phonemodel', u'androidversion', u'datacap', u'networktype', u'connectiontype', u'signalstrength', u'celltype', u'longitude', u'latitude'], dtype='object')"
]
}
],
"prompt_number": 18
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"usage_app_all = usage.merge(application)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 19
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"len(usage_app_all['deviceid'].unique())"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 20,
"text": [
"174"
]
}
],
"prompt_number": 20
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"len( usage_app_all[usage_app_all['name']=='QR Droid']['deviceid'].unique() )"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 21,
"text": [
"4"
]
}
],
"prompt_number": 21
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"usage_app_all.groupby('networkcountry')['deviceid'].unique().apply(lambda x: len(x))"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 24,
"text": [
"networkcountry\n",
" 31\n",
"af 1\n",
"al 1\n",
"at 1\n",
"au 1\n",
"be 1\n",
"bg 1\n",
"ca 2\n",
"cn 1\n",
"de 3\n",
"es 1\n",
"fi 1\n",
"fr 1\n",
"gb 1\n",
"id 1\n",
"il 2\n",
"in 2\n",
"ir 51\n",
"it 3\n",
"kh 1\n",
"kr 2\n",
"ky 1\n",
"lb 1\n",
"mc 1\n",
"mm 2\n",
"mv 1\n",
"mx 3\n",
"my 3\n",
"nl 2\n",
"ru 3\n",
"sa 1\n",
"tn 1\n",
"ua 1\n",
"us 8\n",
"uz 1\n",
"za 1\n",
"Name: deviceid, dtype: int64"
]
}
],
"prompt_number": 24
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Only IRAN"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"apps = usage_app_ir['name'].unique()\n",
"apps.sort()\n",
"apps"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 28,
"text": [
"array([u'(ARMv6 VFP)\\u06a9\\u062f\\u06a9 \\u0627', u'*Battery Widget',\n",
" u'1 \\u0639\\u06a9\\u0633 1 \\u0644\\u0648\\u06af\\u0648',\n",
" u'1 \\u0639\\u06a9\\u0633 1 \\u067e\\u0631\\u0686\\u0645',\n",
" u'10 Pin Shuffle', u'118', u'1Mobile Market',\n",
" u'1Mobile Market Lite', u'2048', u'360MobileSecurity', u'4shared',\n",
" u'600 Fonts Galaxy', u'7digital', u'8 Ball Pool',\n",
" u'8 \\u06a9\\u0646\\u0633\\u0648\\u0644', u'ADM', u'ADM Pro', u'APUS',\n",
" u'ASTRO', u'AT Service', u'Account Manager', u'Add Line',\n",
" u'Administrador ctas. ', u'Adobe Reader', u'Advanced Task Killer',\n",
" u'Afarinesh', u'Aggiornamenti sistem', u'Air Strike 3D',\n",
" u'AirDroid', u'Album', u'AllShare FileShare S', u'AllShare Play',\n",
" u'AllShare Service', u'Almacenamiento de co', u'Android OS',\n",
" u'Android Weather', u'AndroidProvider', u'Angry Birds',\n",
" u'Anonymous Browser', u'Anonymous Usage Stat', u'Anti Theft',\n",
" u'AntiVirus', u'Antiv\\xedrus', u'Any Share', u'Any.DO', u'App 2 SD',\n",
" u'App Lock', u'App Share', u'Application installe', u'Atci_service',\n",
" u'AudioEffectService', u'Aviary', u'Avira Free Android S', u'BILD',\n",
" u'Baby DressUp', u'Baby Hazel Newborn B', u'Backgammon Free',\n",
" u'Baidu Browser', u'Banoo Yar', u'Battery Booster', u'Battery Disc',\n",
" u'Battery Doctor', u'Battery Info.', u'BatteryWarning', u'Bazaar',\n",
" u'Beach Buggy Blitz', u'BeeTalk', u'Best Apps Market (BA',\n",
" u'Bitcasa', u'Blobby Volleyball', u'Blocco vocale',\n",
" u'Bluetooth File Trans', u'BluetoothTest', u'Boat Browser Mini',\n",
" u'Box', u'Brief Lucency', u'Bright Weather', u'Browse Faster',\n",
" u'Browser', u'Bubble Shooter Viole', u'Bubble Witch Saga 2',\n",
" u'Businessweek+', u'CLocker', u'CM Security', u'CY AppLock',\n",
" u'CakeSalon', u'Calendar', u'Call Blocker', u'Call Info',\n",
" u'CamScanner', u'Camera', u'Camera Tattoo', u'Camera common',\n",
" u'Camera!', u'CanDo', u'Candy Crush', u'Candy Crush Saga',\n",
" u'Cardiograph', u'Catapult King', u'Charger', u'Charterz',\n",
" u'Chrome', u'Cigarette Smoke (Fre', u'Clash of Clans',\n",
" u'ClashFarming', u'Clavier Android', u'Clean Master', u'Clock',\n",
" u'CloudAgent', u'Clouds & Sheep', u'Coco Voice',\n",
" u'Color Splash Effect ', u'ColorNote', u'Common Data Service',\n",
" u'ConfigUpdater', u'Contacts', u'Contacts+', u'Correo',\n",
" u'CrashNotifier', u'Crazy Dentist', u'Crazy Kid Skater',\n",
" u'Creative Locker', u'CredentialManagerSer', u'Ctrl surchauffe',\n",
" u'Customised settings', u'Customized App Insta',\n",
" u'Cut the Rope Experim', u'Cymera', u'DM', u'DMSS-Pro', u'DS',\n",
" u'DSMForwarding', u'DSMLawmo', u'DX Battery Saver', u'Dancing Baby',\n",
" u'DataCreate', u'Death Moto 2', u'Design It!', u'Device Service',\n",
" u'Devices', u'DiDi', u'Dialer', u'Dialer storage',\n",
" u'Dirt Road Trucker 3D', u'Divan Hafiz', u'Divar',\n",
" u'Dolphin Browser', u'Download All Files', u'Download Manager',\n",
" u'DownloadAgent', u'DownloadManager', u'Downloads', u'Dr. Safety',\n",
" u'Dr.Web anti-virus Li', u'Drive', u'Dropbox', u'Du Speed Booster',\n",
" u'Dungeon Archer Run', u'ES File Explorer', u'Earth',\n",
" u'Earthquakes', u'Easy MP3 Downloader ', u'Easy settings',\n",
" u'Editor de Fotocollag', u'Email', u'Endomondo',\n",
" u'Enterprise Sim Pin S', u'Enterprise VPN Servi', u'Equalizer',\n",
" u'Error', u'Evernote', u'Exchange Services',\n",
" u'Extreme Pickup Crush', u'FLCommando', u'FUN&downloads',\n",
" u'FWUpgrade', u'Facebook', u'Factory Test', u'FactoryKeystring',\n",
" u'Fashion Design', u'Fast Racing', u'FastBoot', u'FastDic',\n",
" u'Field Compass', u'File Browser', u'File Commander', u'Films',\n",
" u'Find the Num', u'Fireflies Forest Nig', u'Firefox',\n",
" u'Firefox Beta', u'Fish Hajj ADS', u'FlashPlayer', u'Flashlight',\n",
" u'Flick Shoot Pro', u'Flickr', u'Flipboard', u'Floating Touch',\n",
" u'Flyne', u'Foot Spa', u'Football Fantasy', u'Free Zone Wi-Fi BETA',\n",
" u'Fruit Shoot', u'FunnyGif', u'Fused Location', u'GO Keyboard',\n",
" u'GO Launcher EX', u'GO Locker', u'GO Power Master',\n",
" u'GO SMS Emoji Plugin', u'GO SMS Language Pers', u'GO SMS Pro',\n",
" u'GO TaskManager EX', u'GO Weather EX', u'GPS Test',\n",
" u'GPS \\u05e8\\u05db\\u05d1 \\u05e9\\u05dc HTC', u'GTA: SA',\n",
" u'Galaxy Lock Screen', u'Galer\\xeda', u'Gallery',\n",
" u'Gauge Battery Widget', u'General Downloader', u'Genial Writing',\n",
" u'Ghasedak-Free', u'Ghosts in your Photo', u'Gmail',\n",
" u'Google Backup Transp', u'Google Calendar Sync',\n",
" u'Google Partner Setup', u'Google Play Books',\n",
" u'Google Play Magazine', u'Google Play Movies &',\n",
" u'Google Play Music', u'Google Play Store', u'Google Play-Dienste',\n",
" u'Google Search', u'Google Services', u'Google Services Fram',\n",
" u'Google lyrics extens', u'Google+', u'Google-kirjanmerkkie',\n",
" u'Guide for Clash of C', u'HRS Hotels', u'HTC Message Uploader',\n",
" u'HTC Sense', u'Handcent SMS', u'Happy Farm', u'Happy Winter',\n",
" u'Havashenas', u'Hideman', u'Hill Climb Racing', u'Hokm', u'Hola',\n",
" u'Hotspot Shield VPN', u'Htc Service Pack', u'HtcDLNAMiddleLayer',\n",
" u'Huawei IME', u'IM+', u'Ice Princess', u'IdeaDesktop',\n",
" u'Ideafriend', u'Informationen', u'Informer HTC', u'Input Devices',\n",
" u'InstaDown Demo', u'Instagram', u'Internet', u'Iran Sima',\n",
" u'IranApps', u'Irancell', u'IslandRaiders', u'Jewels',\n",
" u'Jewels Star', u'Jomlak', u'Jungle Run', u'KMPlayer',\n",
" u'Kaspersky Mobile Sec', u'Key Chain', u'Kid Mode',\n",
" u'Kids House Cleanup', u'Kii keyboard', u'Kik Messenger',\n",
" u\"King's Empire\", u'Kingsoft Office', u'LINE', u'LINE DECO',\n",
" u'LINE camera', u'LOVOO', u'Lampe', u'Lazy Swipe', u'LeSafe',\n",
" u'Lenovo Sync', u'License settings', u'Lie Detector HD',\n",
" u'Line Adder', u'Location-based Wi-Fi', u'LocationServices',\n",
" u'Lock Screen', u'Lock Screen Widget', u'MDMApp',\n",
" u'MEGA Flashlight', u'MMI Function Test', u'MP4 Video Player',\n",
" u'MTK Thermal Manager', u'MTP Application', u'MTP-Anwendung',\n",
" u'MX Player Codec (ARM', u'MX Reproductor', u'MagazineWidget',\n",
" u'Mail', u'Maps', u'Marble Legend', u'Marble Saga',\n",
" u'Maskan Mobile Paymen', u'McAfee Security', u'Media Storage',\n",
" u'Memorija', u'Messaging', u'Messenger', u'Messenger Voice and ',\n",
" u'Mini Nurse', u'Miniaplikacija zaklj', u'MixZing', u'Mobazi',\n",
" u'Mobile Banking', u'MobileCare', u'MobileGo\\u2122',\n",
" u'MobileInsight', u'Mobo Market', u'Mobo Video Player Pr',\n",
" u'MoboPlayer', u'Mobogenie', u'Modern air combat He',\n",
" u'Money or Death', u'Motor de s\\xedntesis d', u'Moy', u'Music',\n",
" u'Music Hub', u'Music Ma', u'Musica', u'Mutant Roadkill',\n",
" u'My Data Manager Free', u'My Pet Shop', u'My Speed Test',\n",
" u'My Talking Tom', u'MyXperia\\u2122', u'Myket', u'NRG Player',\n",
" u'NYTimes', u'Nabze Bazaar', u'Naj\\u010de\\u0161\\u0107i kontakti',\n",
" u'NerkheRooz', u'Netmonitor', u'Network Location', u'Neutron MP',\n",
" u'Newborn Baby Doctor', u'News & Weather', u'Next Launcher',\n",
" u'Nimbuzz', u'Ninesky Browser', u'Ninja Chicken',\n",
" u'Ninja Chicken Ooga B', u'Ninja Rush', u'Norton Mobile Securi',\n",
" u'Notification', u'OfficeSuite', u'One Browser', u'Online update',\n",
" u'Open Garden', u'Open Sense Plugin Ma', u'Open Signal Maps',\n",
" u'Opera Mini', u'Opera Mobile', u'Outlook.com',\n",
" u'POLARIS Office Viewe', u'Paper(Kaghaz) GOLaun',\n",
" u'Partage Wi-Fi Direct', u'Pasargad MBanking', u'Path', u'Peep',\n",
" u'Perfect App Protecto', u'Perfect365', u'PersianSMS', u'Perso',\n",
" u'Pet Rescue Saga', u'PhoneUtil', u'Photo Editor Pro',\n",
" u'Photo Funia', u'PhotoFunia', u'Photo\\xa0Editor', u'PicCollage',\n",
" u'PickupTutorial', u'Plants Vs Zombies', u'Play Tennis',\n",
" u'Polaris Office', u'Polaris Viewer 4.1', u'Pool Break Lite',\n",
" u'PopupuiReceiver', u'PornPlayer', u'Postman', u'Pou', u'Preconfig',\n",
" u'Premium Widgets', u'Princess Barbie 2', u'Princess Room Decora',\n",
" u'Princess Salon', u'Pro Pool 2012', u'Proxy Browser', u'Puffin',\n",
" u'Puffin Free', u'Pulse', u'QC SEMC Service', u'QQ Int\\u2019l',\n",
" u'QR Droid', u'QV Test', u'Quickoffice\\xae Pro', u'Quran',\n",
" u'R2R Client', u'Race the Traffic', u'Racing Air',\n",
" u'Racing Moto 2014', u'RacingMoto', u'Radio Hamrah', u'Radio\\xa0FM',\n",
" u'Real Guitar', u'Resource Manager', u'Rocket Player', u'Ronaldo',\n",
" u'RootPA', u'Rove', u\"Rwilco12's Wallpaper\",\n",
" u'Rx Networks PGPS See', u'S Voice', u'SIM Toolkit', u'SNS',\n",
" u'SYNCit HD', u'Samsung Apps', u'Samsung Push Service',\n",
" u'Samsung SetupWizard', u'Samsung Text-zu-Spra', u'Samsung WatchON',\n",
" u'Samsung account', u'SandroProxy', u'Santoor', u'SayHi',\n",
" u'Screen Mirroring', u'Screen mirroring', u'Sea GOLauncher EX Th',\n",
" u'SeaSide Spa Salon', u'Search', u'SecPhone', u'Self Test Mode',\n",
" u'Sensor music player', u'Service Framework', u'Settings',\n",
" u'Setup Wizard', u'Setup guide', u'SexyCrisis', u'Shadowsocks',\n",
" u'Shahnameh', u'Shazam', u'Shell', u'Sincronizaci\\xf3n de l',\n",
" u'Skater Boy', u'Skype', u'Skype Qik', u'SlideME Marketplace',\n",
" u'Smart App Protector', u'Smart App Protector ',\n",
" u'Smart Launcher Pro', u'Smart Lock Lite', u'Smart Office 2',\n",
" u'Snake', u'Soccer Stars', u'Software-Update', u'Solid Explorer',\n",
" u'Solo Lite', u'Sony Select Logger', u'Sound Recorder',\n",
" u'Speed Moto', u'Speed Night', u'Speed Test',\n",
" u'SpongeBob Diner Dash', u'SprayCan', u'Status Bar',\n",
" u'Stickman Tennis', u'Stockage des param\\xe8', u'Subway Surf',\n",
" u'Sunset', u'Super Flashlight', u'Super Zombie Hunter',\n",
" u'SuperPlayer', u'SydneyApps FireFly L', u'Sys Service',\n",
" u'SysScope', u'SysTask', u'System updates', u'TMServerApp',\n",
" u'TTPod', u'TV Remote Pro', u'TVSpielfilm', u'Talk', u'Tango',\n",
" u'Taschen lampe', u'TcpdumpService', u'Tehran Traffic', u'Telegram',\n",
" u'Telewebion', u'Temple Run', u'Temple Run 2', u'TempleRunOz',\n",
" u'Textra', u'Thermo', u'Tom Loves Angela', u'ToolBox',\n",
" u'Touch Timer', u'TouchPal Keyboard V5', u'Traffic Racer',\n",
" u'Translate', u'Translator', u'Transparent weather ',\n",
" u'Travel wallpaper', u'Trial X2', u'TripAdvisor',\n",
" u'Truck Parking 3D', u'Truecaller', u'Tutoriel', u'TwDVFSApp',\n",
" u'Twitter', u'UC Browser', u'UCBrowser', u'USB connectivity',\n",
" u'USB settings', u'Unified Daemon(EUR)', u'Update center',\n",
" u'User Experience', u'VA High Speed Downlo', u'VOA',\n",
" u'VPN Services', u'VPlayer', u'Vault', u'Viber',\n",
" u'Virtual Nose Surgery', u'Virtual Table Tennis', u'WEBTOON',\n",
" u'Water Your Body', u'WeChat', u'Weather', u'Weather Clock',\n",
" u'Weather Daemon', u'Weather Live', u'Weather Locker HD',\n",
" u'Weather Main', u'Weather Widget Main', u'WeatherBug', u'WhatsApp',\n",
" u'Whatsapp Connect', u'White Noise', u'Wi-Fi',\n",
" u'Wi-Fi \\u0433\\u0438\\u043f\\u0435\\u0440\\u043e\\u0431\\u044a\\u0435\\u043a\\u0442\\u043e\\u0432',\n",
" u'Wikipedia extension', u'Winamp', u'WlanTest', u'Wunderlist',\n",
" u'X-Ray Scanner', u'XModGames', u'XingPlayer', u'Xperia Lounge',\n",
" u'Xperia Proxy', u'Xperia\\u2122 extension ',\n",
" u'Xperia\\u2122 keyboard', u'YouTube', u'ZDbox', u'ZDclock',\n",
" u'Zalando', u'Zanashooee', u'Zapya', u'Zelzele Negar', u'Zoe',\n",
" u'Zombie Tsunami', u'aFarsi', u'avast! Mobile Securi', u'chompSMS',\n",
" u'com.android.ap.provi', u'com.android.provider',\n",
" u'com.android.provisio', u'com.cci.simmelock',\n",
" u'com.huawei.DiagReboo', u'com.mediatek', u'com.obakaka.swatshoo',\n",
" u'com.samsung.app.play', u'com.sec.android.prov',\n",
" u'com.sec.bcservice', u'com.sonyericsson.and',\n",
" u'com.sonyericsson.cus', u'com.sonyericsson.ill',\n",
" u'com.sonyericsson.set', u'com.sonyericsson.tet',\n",
" u'com.sonyericsson.uxp', u'com.sunway.holoo', u'com.system.patch',\n",
" u'hack wifi password', u'hike', u'iFighter 1945', u'imo',\n",
" u'imo beta', u'ir.iris.smsbank', u'ooVoo', u'org.apache.cordova.i',\n",
" u'ru.yandex.weatherplu', u'smsBlocker by Optinn', u'usbotg',\n",
" u'wedding', u'windows-BlueSky', u'wssyncmlnps', u'yooz',\n",
" u'\\xa0App Master\\xa0', u'\\xa0Solo Launcher Free',\n",
" u'\\xa0\\xa0ZERO\\xa0\\xa0',\n",
" u'\\u041f\\u043b\\u0430\\u0442\\u0444\\u043e\\u0440\\u043c\\u0430 A',\n",
" u'\\u041f\\u043e\\u0433\\u043e\\u0434\\u0430 Lenovo',\n",
" u'\\u0420\\u0430\\u0441\\u043f\\u0438\\u0441\\u0430\\u043d\\u0438\\u0435',\n",
" u'\\u0622\\u062e\\u0631\\u06cc\\u0646 \\u062e\\u0628\\u0631',\n",
" u'\\u0622\\u0632\\u0645\\u0648\\u0646 \\u0622\\u06cc\\u06cc\\u0646 \\u0646\\u0627\\u0645\\u0647 \\u067e\\u0648\\u06cc\\u0627',\n",
" u'\\u0622\\u0641\\u062a\\u0627\\u0628\\u0647',\n",
" u'\\u0622\\u0645\\u0648\\u0632\\u0634 \\u0627\\u0646\\u0648\\u0627\\u0639 \\u063a\\u0630\\u0627 \\u0647\\u0627',\n",
" u'\\u0622\\u0647\\u0646\\u06af \\u0628\\u0627 \\u0645\\u062a\\u0646 \\u0645\\u062d\\u0633\\u0646 \\u064a\\u06af\\u0627',\n",
" u'\\u0622\\u0647\\u0646\\u06af \\u0647\\u0627\\u06cc \\u0628\\u0644\\u0632',\n",
" u'\\u0622\\u0647\\u0646\\u06af \\u0647\\u0627\\u06cc \\u0648\\u06cc\\u0648\\u0644\\u0646',\n",
" u'\\u0622\\u0647\\u0646\\u06af\\u0640\\u0640\\u0647 \\u06cc\\u0627\\u062f\\u062a\\u0647 \\u061f',\n",
" u'\\u0622\\u0647\\u0646\\u06af\\u0647 \\u0631\\u0648 \\u06cc\\u0627\\u062f\\u062a\\u0647\\u061f',\n",
" u'\\u0622\\u067e\\u0627\\u0631\\u0627\\u062a 2',\n",
" u'\\u0627\\u0633\\u062a\\u062e\\u0627\\u0631\\u0647 \\u0627\\u0632\\u062f\\u0648\\u0627\\u062c',\n",
" u'\\u0627\\u0639\\u0644\\u0627\\u0645\\u06cc\\u0647',\n",
" u'\\u0627\\u0644\\u06a9\\u06cc \\u0645\\u062b\\u0644\\u0627',\n",
" u'\\u0627\\u0644\\u06a9\\u06cc \\u0645\\u062b\\u0644\\u0627....',\n",
" u'\\u0627\\u0646\\u0648\\u0627\\u0639 \\u0646\\u0627\\u0645\\u0647',\n",
" u'\\u0627\\u064a\\u0646 \\u0643\\u062f\\u0648\\u0645 \\u0645\\u0627\\u0634\\u064a\\u0646\\u0647\\u061f',\n",
" u'\\u0627\\u06cc\\u0646 \\u0647\\u0645\\u0633\\u0631 \\u06a9\\u06cc\\u0647\\u061f',\n",
" u'\\u0628\\u0627\\u062f\\u0635\\u0628\\u0627',\n",
" u'\\u0628\\u0627\\u0646\\u0643 \\u0631\\u064a\\u0646\\u06af\\u062a\\u0648\\u0646 \\u0633\\u0648\\u062a',\n",
" u'\\u0628\\u0627\\u0646\\u06a9 \\u067e\\u06cc\\u0627\\u0645\\u06a9 ',\n",
" u'\\u0628\\u0686\\u0647 \\u0643\\u062f\\u0648\\u0645\\u0634\\u0648\\u0646\\u0647\\u061f',\n",
" u'\\u0628\\u06cc\\u062f\\u0627\\u0631\\u0628\\u0627\\u0634...',\n",
" u'\\u062a\\u0627\\u0628\\u0646\\u0627\\u06a9',\n",
" u'\\u062a\\u0639\\u06cc\\u0646 \\u062c\\u0646\\u0633\\u06cc\\u062a',\n",
" u'\\u062c\\u0639\\u0628\\u0647 \\u0627\\u0628\\u0632\\u0627\\u0631',\n",
" u'\\u062c\\u0647\\u0627\\u0646\\u06af\\u0631\\u062f',\n",
" u'\\u062c\\u0648\\u06a9 \\u0628\\u0627\\u0632\\u0627\\u0631',\n",
" u'\\u062d\\u0628\\u0644 \\u0627\\u0644\\u0645\\u062a\\u06cc\\u0646',\n",
" u'\\u062e\\u062f\\u0645\\u0627\\u062a \\u0647\\u0645\\u0631\\u0627\\u0647 \\u0627\\u0648\\u0644',\n",
" u'\\u062f\\u0627\\u0633\\u062a\\u0627\\u0646 \\u0647\\u0627\\u06cc \\u0642\\u062f\\u06cc\\u0645\\u06cc',\n",
" u'\\u062f\\u0627\\u0646\\u0633\\u062a\\u0646\\u06cc\\u0647\\u0627\\u06cc \\u0628\\u0627\\u0631\\u062f\\u0627\\u0631\\u06cc \\u0648',\n",
" u'\\u062f\\u0646\\u062f\\u0647 5',\n",
" u'\\u0631\\u0642\\u0635 \\u0646\\u0648\\u0631',\n",
" u'\\u0631\\u0648\\u062d \\u062a\\u0648 \\u0639\\u06a9\\u0633\\u062a\\u0647',\n",
" u'\\u0631\\u0698\\u06cc\\u0645\\u060c\\u0627\\u0646\\u062f\\u0627\\u0645 \\u062f\\u0644\\u062e\\u0648\\u0627\\u0647',\n",
" u'\\u0632\\u0646\\u06af \\u062e\\u0648\\u0631 \\u067e\\u06cc\\u0627\\u0645',\n",
" u'\\u0632\\u0646\\u06af \\u0641\\u0627\\u0628\\u0631\\u06cc\\u06a9 \\u06af\\u0648\\u0634\\u06cc \\u0647\\u0627',\n",
" u'\\u0632\\u0646\\u06af \\u0647\\u0627\\u06cc \\u0633\\u0647 \\u0628\\u0639\\u062f\\u06cc',\n",
" u'\\u0633\\u0627\\u06cc\\u0641\\u0648\\u0646 \\u06f3',\n",
" u'\\u0633\\u0628\\u06cc\\u0644',\n",
" u'\\u0633\\u0631\\u064a\\u0627\\u0644\\u0647 \\u0631\\u0648 \\u064a\\u0627\\u062f\\u062a\\u0647\\u061f',\n",
" u'\\u0635\\u062f\\u0627\\u06cc \\u062d\\u06cc\\u0648\\u0627\\u0646\\u0627\\u062a',\n",
" u'\\u0636\\u0631\\u06cc\\u0628 \\u0647\\u0648\\u0634\\u06cc 2',\n",
" u'\\u0637\\u0627\\u0644\\u0639 \\u0628\\u06cc\\u0646\\u06cc',\n",
" u'\\u0639\\u0644\\u0627\\u0626\\u0645 \\u0631\\u0627\\u0647\\u0646\\u0645\\u0627\\u06cc\\u06cc \\u0631\\u0627 \\u0642\\u0648',\n",
" u'\\u0639\\u0644\\u06cc \\u06a9\\u0631\\u06cc\\u0645\\u06cc',\n",
" u'\\u0641\\u0633\\u0641\\u0631 \\u0628\\u0627\\u0632\\u06cc',\n",
" u'\\u0642\\u0641\\u0644 \\u0628\\u0631\\u0646\\u0627\\u0645\\u0647 \\u0647\\u0627',\n",
" u'\\u0642\\u0641\\u0644 \\u062d\\u0631\\u0641\\u0647 \\u0627\\u06cc',\n",
" u'\\u0642\\u0641\\u0644 \\u0635\\u0641\\u062d\\u0647 \\u0628\\u0627 \\u06cc\\u06a9 \\u06a9\\u0644\\u06cc\\u06a9',\n",
" u'\\u0643\\u0627\\u0631\\u062a\\u0648\\u0646\\u0647 \\u0631\\u0648 \\u064a\\u0627\\u062f\\u062a\\u0647\\u061f',\n",
" u'\\u0645\\u0627\\u0632\\u06cc\\u0627\\u0631 \\u0641\\u0644\\u0627\\u062d\\u06cc',\n",
" u'\\u0645\\u0631\\u0648\\u0631\\u06af\\u0631 \\u0645\\u0644\\u06cc',\n",
" u'\\u0645\\u0633\\u0627\\u0626\\u0644 \\u0632\\u0646\\u0627\\u0634\\u0648\\u06cc\\u06cc \\u0648 \\u062c\\u0646\\u0633\\u06cc',\n",
" u'\\u0645\\u0634\\u0647\\u062f \\u0646\\u0645\\u0627',\n",
" u'\\u0645\\u0641\\u0627\\u062a\\u06cc\\u062d \\u0628\\u0627\\u0628 \\u0627\\u0644\\u0646\\u0639\\u06cc\\u0645',\n",
" u'\\u0645\\u0647\\u0627\\u0631\\u062a\\u200c\\u0647\\u0627\\u06cc ',\n",
" u'\\u0645\\u0648\\u0628\\u0627\\u06cc\\u0644 \\u0628\\u0627\\u0646\\u06a9 \\u0627\\u0646\\u0635\\u0627\\u0631',\n",
" u'\\u0646\\u0631\\u062e \\u0627\\u0631\\u0632',\n",
" u'\\u0646\\u0642\\u0637\\u0647 \\u0628\\u0627\\u0632\\u06cc \\u067e\\u06cc\\u0634\\u0631\\u0641\\u062a\\u0647',\n",
" u'\\u0647\\u0646\\u062f\\u0648\\u0646\\u0647',\n",
" u'\\u067e\\u0627\\u067e\\u0627\\u0632\\u0644.\\u0628\\u0627\\u0632\\u06cc\\u06af\\u0631\\u0627\\u0646 \\u0632\\u0646',\n",
" u'\\u067e\\u06cc\\u0627\\u0645\\u06a9 \\u0648 \\u062a\\u0645\\u0627\\u0633 \\u062c\\u0639\\u0644\\u06cc',\n",
" u'\\u067e\\u06cc\\u0634\\u0648\\u0627\\u0632 \\u0622\\u0632\\u0645\\u0627\\u06cc\\u0634\\u06cc',\n",
" u'\\u06a9\\u0627\\u0641\\u0647 \\u0627\\u06cc\\u0646\\u0633\\u062a\\u0627\\u06af\\u0631\\u0627\\u0645',\n",
" u'\\u06a9\\u0641\\u0634\\u062f\\u0648\\u0632\\u06a9',\n",
" u'\\u06cc\\u0627\\u062f\\u0622\\u0648\\u0631',\n",
" u'\\u06cc\\u0647 \\u062c\\u06a9 \\u0628\\u06af\\u0645',\n",
" u'\\u8054\\u60f3\\u7279\\u5356',\n",
" u'\\u91d1\\u5c71\\u6e05\\u7406\\u5927\\u5e08',\n",
" u'\\u9b54\\u6f2b\\u76f8\\u673a', u'\\ub0b4 \\uce98\\ub9b0\\ub354',\n",
" u'\\ub3c4\\ub3cc \\ub7f0\\ucc98', u'\\uc8fc\\ud589\\uc758 \\ub2ec\\uc778',\n",
" u'\\uce74\\uce74\\uc624\\ud1a1', u'\\ud2f1\\ud1a1'], dtype=object)"
]
}
],
"prompt_number": 28
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"usage_app_ir[usage_app_ir['name']=='QR Droid']['deviceid']"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 29,
"text": [
"217554 6f465667fa3831c5721b90413e913b5ac0626631\n",
"217555 6f465667fa3831c5721b90413e913b5ac0626631\n",
"217556 6f465667fa3831c5721b90413e913b5ac0626631\n",
"217557 6f465667fa3831c5721b90413e913b5ac0626631\n",
"217558 6f465667fa3831c5721b90413e913b5ac0626631\n",
"217559 6f465667fa3831c5721b90413e913b5ac0626631\n",
"217560 6f465667fa3831c5721b90413e913b5ac0626631\n",
"217561 6f465667fa3831c5721b90413e913b5ac0626631\n",
"217562 6f465667fa3831c5721b90413e913b5ac0626631\n",
"217563 6f465667fa3831c5721b90413e913b5ac0626631\n",
"217564 6f465667fa3831c5721b90413e913b5ac0626631\n",
"Name: deviceid, dtype: object"
]
}
],
"prompt_number": 29
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### only one device out of 51 had QR Droid installed"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Frequency of apps"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"len(usage_app_ir['deviceid'].unique())"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 30,
"text": [
"51"
]
}
],
"prompt_number": 30
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"freq = usage_app_ir.groupby('name')['deviceid'].unique().apply(lambda x: len(x))"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 31
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"freq.sort(ascending=False)\n",
"with pd.option_context('display.max_rows', 999, 'display.max_columns', 3):\n",
" print freq"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"name\n",
"My Speed Test 51\n",
"Viber 43\n",
"Google Search 42\n",
"Bazaar 41\n",
"WhatsApp 35\n",
"LINE 31\n",
"YouTube 30\n",
"Maps 29\n",
"Google Play Store 28\n",
"Google Services Fram 27\n",
"Sincronizaci\u00f3n de l 25\n",
"Google Play-Dienste 24\n",
"Browser 23\n",
"Zapya 21\n",
"Tango 20\n",
"Chrome 20\n",
"Messenger 19\n",
"Administrador ctas. 19\n",
"Dropbox 19\n",
"Any Share 19\n",
"Google-kirjanmerkkie 18\n",
"Samsung Push Service 17\n",
"Facebook 17\n",
"Network Location 16\n",
"Download Manager 15\n",
"Software-Update 15\n",
"Clash of Clans 15\n",
"Mail 14\n",
"Instagram 14\n",
"S Voice 13\n",
"Mobo Market 12\n",
"Google+ 12\n",
"MX Reproductor 11\n",
"BeeTalk 11\n",
"\u041f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0430 A 11\n",
"AllShare Service 11\n",
"Almacenamiento de co 11\n",
"Samsung Apps 11\n",
"Motor de s\u00edntesis d 11\n",
"Downloads 10\n",
"Hotspot Shield VPN 10\n",
"\u0628\u0627\u062f\u0635\u0628\u0627 9\n",
"Gmail 9\n",
"Talk 8\n",
"Skype 8\n",
"WeChat 8\n",
"GO SMS Pro 8\n",
"GO Launcher EX 8\n",
"Firefox 7\n",
"Update center 7\n",
"Key Chain 7\n",
"Mobogenie 7\n",
"Weather Widget Main 7\n",
"Myket 7\n",
"Correo 7\n",
"Google Calendar Sync 7\n",
"\u0633\u0627\u06cc\u0641\u0648\u0646 \u06f3 6\n",
"Google Backup Transp 6\n",
"Subway Surf 6\n",
"Album 5\n",
"1Mobile Market 5\n",
"Telegram 5\n",
"Internet 5\n",
"News & Weather 5\n",
"ConfigUpdater 5\n",
"avast! Mobile Securi 5\n",
"Hill Climb Racing 5\n",
"\u00a0\u00a0ZERO\u00a0\u00a0 5\n",
"Flipboard 5\n",
"Google Partner Setup 5\n",
"Divar 5\n",
"AntiVirus 5\n",
"Clean Master 5\n",
"hike 5\n",
"ES File Explorer 5\n",
"Galer\u00eda 4\n",
"Weather Clock 4\n",
"\u0622\u062e\u0631\u06cc\u0646 \u062e\u0628\u0631 4\n",
"Settings 4\n",
"Hokm 4\n",
"Input Devices 4\n",
"Stockage des param\u00e8 4\n",
"McAfee Security 4\n",
"Media Storage 4\n",
"SlideME Marketplace 4\n",
"Path 4\n",
"\u0622\u067e\u0627\u0631\u0627\u062a 2 4\n",
"Firefox Beta 4\n",
"Samsung account 4\n",
"Kik Messenger 4\n",
"FWUpgrade 4\n",
"Messenger Voice and 3\n",
"Adobe Reader 3\n",
"Self Test Mode 3\n",
"GO SMS Language Pers 3\n",
"AndroidProvider 3\n",
"Status Bar 3\n",
"Memorija 3\n",
"Coco Voice 3\n",
"ooVoo 3\n",
"OfficeSuite 3\n",
"Preconfig 3\n",
"GO Locker 3\n",
"Best Apps Market (BA 3\n",
"wssyncmlnps 3\n",
"\u0622\u0641\u062a\u0627\u0628\u0647 3\n",
"Clock 3\n",
"Factory Test 3\n",
"\u062c\u0648\u06a9 \u0628\u0627\u0632\u0627\u0631 3\n",
"ASTRO 3\n",
"com.mediatek 3\n",
"APUS 3\n",
"Next Launcher 3\n",
"Google Play Magazine 3\n",
"DM 3\n",
"Temple Run 2 3\n",
"Havashenas 3\n",
"com.sec.bcservice 3\n",
"My Data Manager Free 3\n",
"Twitter 3\n",
"Pou 3\n",
"Weather Main 3\n",
"Anonymous Usage Stat 3\n",
"Opera Mini 3\n",
"USB settings 3\n",
"SIM Toolkit 3\n",
"KMPlayer 2\n",
"AllShare Play 2\n",
"Irancell 2\n",
"\u0642\u0641\u0644 \u062d\u0631\u0641\u0647 \u0627\u06cc 2\n",
"\u0643\u0627\u0631\u062a\u0648\u0646\u0647 \u0631\u0648 \u064a\u0627\u062f\u062a\u0647\u061f 2\n",
"360MobileSecurity 2\n",
"\u0647\u0646\u062f\u0648\u0646\u0647 2\n",
"\u06cc\u0647 \u062c\u06a9 \u0628\u06af\u0645 2\n",
"King's Empire 2\n",
"Antiv\u00edrus 2\n",
"Anonymous Browser 2\n",
"\u0420\u0430\u0441\u043f\u0438\u0441\u0430\u043d\u0438\u0435 2\n",
"App 2 SD 2\n",
"\u0628\u0686\u0647 \u0643\u062f\u0648\u0645\u0634\u0648\u0646\u0647\u061f 2\n",
"Application installe 2\n",
"AudioEffectService 2\n",
"\u0627\u0644\u06a9\u06cc \u0645\u062b\u0644\u0627 2\n",
"Mobile Banking 2\n",
"\u0622\u0647\u0646\u06af\u0647 \u0631\u0648 \u06cc\u0627\u062f\u062a\u0647\u061f 2\n",
"MobileCare 2\n",
"MobileGo\u2122 2\n",
"Mobo Video Player Pr 2\n",
"\u9b54\u6f2b\u76f8\u673a 2\n",
"\u8054\u60f3\u7279\u5356 2\n",
"Nimbuzz 2\n",
"Boat Browser Mini 2\n",
"Baidu Browser 2\n",
"ir.iris.smsbank 2\n",
"Call Blocker 2\n",
"Wikipedia extension 2\n",
"com.android.provider 2\n",
"com.android.ap.provi 2\n",
"Candy Crush Saga 2\n",
"com.sec.android.prov 2\n",
"CM Security 2\n",
"X-Ray Scanner 2\n",
"Contacts+ 2\n",
"Camera 2\n",
"Common Data Service 2\n",
"Handcent SMS 2\n",
"\uce74\uce74\uc624\ud1a1 2\n",
"Zombie Tsunami 2\n",
"Online update 2\n",
"Nabze Bazaar 2\n",
"Clavier Android 2\n",
"Xperia\u2122 keyboard 2\n",
"User Experience 2\n",
"Mutant Roadkill 2\n",
"\u041f\u043e\u0433\u043e\u0434\u0430 Lenovo 2\n",
"imo 2\n",
"Dolphin Browser 2\n",
"Evernote 2\n",
"GO TaskManager EX 2\n",
"Setup Wizard 2\n",
"Puffin 2\n",
"GO Power Master 2\n",
"Samsung WatchON 2\n",
"File Commander 2\n",
"Samsung SetupWizard 2\n",
"Find the Num 2\n",
"Flashlight 2\n",
"Race the Traffic 2\n",
"Smart App Protector 2\n",
"Google Play Movies & 2\n",
"DSMLawmo 2\n",
"Ctrl surchauffe 2\n",
"Pasargad MBanking 2\n",
"Cymera 2\n",
"Opera Mobile 2\n",
"Google Play Music 2\n",
"DSMForwarding 2\n",
"POLARIS Office Viewe 2\n",
"Huawei IME 2\n",
"Shahnameh 2\n",
"FastDic 2\n",
"Shell 2\n",
"PhoneUtil 2\n",
"com.system.patch 2\n",
"com.sonyericsson.tet 2\n",
"Open Signal Maps 2\n",
"RacingMoto 2\n",
"Drive 2\n",
"Endomondo 2\n",
"Telewebion 2\n",
"Devices 2\n",
"Taschen lampe 2\n",
"Dialer 2\n",
"Device Service 2\n",
"TTPod 2\n",
"PersianSMS 2\n",
"System updates 2\n",
"PickupTutorial 2\n",
"Dr.Web anti-virus Li 2\n",
"UC Browser 2\n",
"Du Speed Booster 2\n",
"Earth 2\n",
"Gallery 2\n",
"CLocker 1\n",
"CY AppLock 1\n",
"CakeSalon 1\n",
"Calendar 1\n",
"Call Info 1\n",
"CamScanner 1\n",
"App Share 1\n",
"Avira Free Android S 1\n",
"Atci_service 1\n",
"Flickr 1\n",
"1 \u0639\u06a9\u0633 1 \u0644\u0648\u06af\u0648 1\n",
"*Battery Widget 1\n",
"Bubble Witch Saga 2 1\n",
"Businessweek+ 1\n",
"Real Guitar 1\n",
"Bubble Shooter Viole 1\n",
"Browse Faster 1\n",
"Bright Weather 1\n",
"Brief Lucency 1\n",
"Box 1\n",
"BluetoothTest 1\n",
"Bluetooth File Trans 1\n",
"Blocco vocale 1\n",
"Blobby Volleyball 1\n",
"Bitcasa 1\n",
"Beach Buggy Blitz 1\n",
"BatteryWarning 1\n",
"Battery Info. 1\n",
"Battery Doctor 1\n",
"10 Pin Shuffle 1\n",
"1 \u0639\u06a9\u0633 1 \u067e\u0631\u0686\u0645 1\n",
"Anti Theft 1\n",
"118 1\n",
"Air Strike 3D 1\n",
"Download All Files 1\n",
"CanDo 1\n",
"Camera! 1\n",
"Camera common 1\n",
"Camera Tattoo 1\n",
"App Lock 1\n",
"Any.DO 1\n",
"Battery Booster 1\n",
"Angry Birds 1\n",
"Android Weather 1\n",
"Android OS 1\n",
"AllShare FileShare S 1\n",
"AirDroid 1\n",
"Aggiornamenti sistem 1\n",
"1Mobile Market Lite 1\n",
"Afarinesh 1\n",
"Advanced Task Killer 1\n",
"Add Line 1\n",
"Account Manager 1\n",
"AT Service 1\n",
"ADM Pro 1\n",
"ADM 1\n",
"8 \u06a9\u0646\u0633\u0648\u0644 1\n",
"8 Ball Pool 1\n",
"7digital 1\n",
"600 Fonts Galaxy 1\n",
"4shared 1\n",
"2048 1\n",
"Battery Disc 1\n",
"General Downloader 1\n",
"Banoo Yar 1\n",
"Kingsoft Office 1\n",
"Htc Service Pack 1\n",
"Gauge Battery Widget 1\n",
"IslandRaiders 1\n",
"GO Weather EX 1\n",
"Flyne 1\n",
"Foot Spa 1\n",
"LOVOO 1\n",
"LINE camera 1\n",
"Football Fantasy 1\n",
"LINE DECO 1\n",
"Free Zone Wi-Fi BETA 1\n",
"Fruit Shoot 1\n",
"FunnyGif 1\n",
"Fused Location 1\n",
"Backgammon Free 1\n",
"Jewels 1\n",
"Kii keyboard 1\n",
"Kids House Cleanup 1\n",
"Kid Mode 1\n",
"Kaspersky Mobile Sec 1\n",
"Google lyrics extens 1\n",
"GO Keyboard 1\n",
"GO SMS Emoji Plugin 1\n",
"Guide for Clash of C 1\n",
"Jungle Run 1\n",
"Jomlak 1\n",
"Jewels Star 1\n",
"HRS Hotels 1\n",
"Ghosts in your Photo 1\n",
"Hola 1\n",
"Ghasedak-Free 1\n",
"HtcDLNAMiddleLayer 1\n",
"Baby Hazel Newborn B 1\n",
"Baby DressUp 1\n",
"BILD 1\n",
"Aviary 1\n",
"Floating Touch 1\n",
"\ud2f1\ud1a1 1\n",
"HTC Message Uploader 1\n",
"HTC Sense 1\n",
"Iran Sima 1\n",
"Happy Farm 1\n",
"Google Play Books 1\n",
"GPS Test 1\n",
"InstaDown Demo 1\n",
"Happy Winter 1\n",
"GPS \u05e8\u05db\u05d1 \u05e9\u05dc HTC 1\n",
"Hideman 1\n",
"GTA: SA 1\n",
"Galaxy Lock Screen 1\n",
"Informer HTC 1\n",
"IranApps 1\n",
"Google Services 1\n",
"Informationen 1\n",
"Ideafriend 1\n",
"IdeaDesktop 1\n",
"Ice Princess 1\n",
"Genial Writing 1\n",
"IM+ 1\n",
"DownloadAgent 1\n",
"(ARMv6 VFP)\u06a9\u062f\u06a9 \u0627 1\n",
"Dr. Safety 1\n",
"Play Tennis 1\n",
"Perso 1\n",
"Pet Rescue Saga 1\n",
"Photo Editor Pro 1\n",
"Photo Funia 1\n",
"Peep 1\n",
"PhotoFunia 1\n",
"PicCollage 1\n",
"Plants Vs Zombies 1\n",
"Polaris Office 1\n",
"Perfect App Protecto 1\n",
"Polaris Viewer 4.1 1\n",
"Pool Break Lite 1\n",
"Photo\u00a0Editor 1\n",
"Partage Wi-Fi Direct 1\n",
"Paper(Kaghaz) GOLaun 1\n",
"Outlook.com 1\n",
"NRG Player 1\n",
"Naj\u010de\u0161\u0107i kontakti 1\n",
"Perfect365 1\n",
"MyXperia\u2122 1\n",
"Netmonitor 1\n",
"MagazineWidget 1\n",
"Marble Legend 1\n",
"MX Player Codec (ARM 1\n",
"License settings 1\n",
"Lie Detector HD 1\n",
"Line Adder 1\n",
"Location-based Wi-Fi 1\n",
"LocationServices 1\n",
"Lock Screen 1\n",
"Lock Screen Widget 1\n",
"My Talking Tom 1\n",
"MEGA Flashlight 1\n",
"MMI Function Test 1\n",
"MP4 Video Player 1\n",
"MTK Thermal Manager 1\n",
"MTP Application 1\n",
"MTP-Anwendung 1\n",
"MDMApp 1\n",
"My Pet Shop 1\n",
"NerkheRooz 1\n",
"Neutron MP 1\n",
"Dungeon Archer Run 1\n",
"\u0622\u0647\u0646\u06af\u0640\u0640\u0647 \u06cc\u0627\u062f\u062a\u0647 \u061f 1\n",
"\u062c\u0647\u0627\u0646\u06af\u0631\u062f 1\n",
"\u062d\u0628\u0644 \u0627\u0644\u0645\u062a\u06cc\u0646 1\n",
"\u062e\u062f\u0645\u0627\u062a \u0647\u0645\u0631\u0627\u0647 \u0627\u0648\u0644 1\n",
"\u062f\u0627\u0633\u062a\u0627\u0646 \u0647\u0627\u06cc \u0642\u062f\u06cc\u0645\u06cc 1\n",
"\u062f\u0627\u0646\u0633\u062a\u0646\u06cc\u0647\u0627\u06cc \u0628\u0627\u0631\u062f\u0627\u0631\u06cc \u0648 1\n",
"\u062a\u0639\u06cc\u0646 \u062c\u0646\u0633\u06cc\u062a 1\n",
"\u062f\u0646\u062f\u0647 5 1\n",
"\u0627\u0639\u0644\u0627\u0645\u06cc\u0647 1\n",
"org.apache.cordova.i 1\n",
"\u062a\u0627\u0628\u0646\u0627\u06a9 1\n",
"ru.yandex.weatherplu 1\n",
"smsBlocker by Optinn 1\n",
"usbotg 1\n",
"wedding 1\n",
"windows-BlueSky 1\n",
"\u0627\u0633\u062a\u062e\u0627\u0631\u0647 \u0627\u0632\u062f\u0648\u0627\u062c 1\n",
"yooz 1\n",
"\u00a0Solo Launcher Free 1\n",
"\u062c\u0639\u0628\u0647 \u0627\u0628\u0632\u0627\u0631 1\n",
"\u0627\u0644\u06a9\u06cc \u0645\u062b\u0644\u0627.... 1\n",
"Newborn Baby Doctor 1\n",
"Open Sense Plugin Ma 1\n",
"Ninesky Browser 1\n",
"Ninja Chicken 1\n",
"Ninja Chicken Ooga B 1\n",
"Ninja Rush 1\n",
"Norton Mobile Securi 1\n",
"Notification 1\n",
"One Browser 1\n",
"Open Garden 1\n",
"SysScope 1\n",
"\u0628\u06cc\u062f\u0627\u0631\u0628\u0627\u0634... 1\n",
"Lenovo Sync 1\n",
"SysTask 1\n",
"TV Remote Pro 1\n",
"\u0627\u0646\u0648\u0627\u0639 \u0646\u0627\u0645\u0647 1\n",
"\u0627\u064a\u0646 \u0643\u062f\u0648\u0645 \u0645\u0627\u0634\u064a\u0646\u0647\u061f 1\n",
"\u0627\u06cc\u0646 \u0647\u0645\u0633\u0631 \u06a9\u06cc\u0647\u061f 1\n",
"\u0628\u0627\u0646\u0643 \u0631\u064a\u0646\u06af\u062a\u0648\u0646 \u0633\u0648\u062a 1\n",
"\u0628\u0627\u0646\u06a9 \u067e\u06cc\u0627\u0645\u06a9 1\n",
"Musica 1\n",
"MoboPlayer 1\n",
"Music Ma 1\n",
"R2R Client 1\n",
"Puffin Free 1\n",
"Racing Moto 2014 1\n",
"Pulse 1\n",
"QQ Int\u2019l 1\n",
"QR Droid 1\n",
"QV Test 1\n",
"Quickoffice\u00ae Pro 1\n",
"Quran 1\n",
"QC SEMC Service 1\n",
"Pro Pool 2012 1\n",
"Premium Widgets 1\n",
"Screen mirroring 1\n",
"SeaSide Spa Salon 1\n",
"Sony Select Logger 1\n",
"Sound Recorder 1\n",
"Speed Moto 1\n",
"Speed Night 1\n",
"Speed Test 1\n",
"Proxy Browser 1\n",
"Princess Salon 1\n",
"Music Hub 1\n",
"SYNCit HD 1\n",
"Resource Manager 1\n",
"Rocket Player 1\n",
"Ronaldo 1\n",
"RootPA 1\n",
"Rove 1\n",
"Radio\u00a0FM 1\n",
"Rwilco12's Wallpaper 1\n",
"SNS 1\n",
"Samsung Text-zu-Spra 1\n",
"Princess Room Decora 1\n",
"SandroProxy 1\n",
"Santoor 1\n",
"SayHi 1\n",
"Rx Networks PGPS See 1\n",
"Screen Mirroring 1\n",
"Radio Hamrah 1\n",
"Racing Air 1\n",
"Princess Barbie 2 1\n",
"SpongeBob Diner Dash 1\n",
"Solo Lite 1\n",
"SprayCan 1\n",
"Mini Nurse 1\n",
"Smart Lock Lite 1\n",
"Smart Office 2 1\n",
"Shazam 1\n",
"Postman 1\n",
"PornPlayer 1\n",
"PopupuiReceiver 1\n",
"Maskan Mobile Paymen 1\n",
"Messaging 1\n",
"Miniaplikacija zaklj 1\n",
"Sunset 1\n",
"MixZing 1\n",
"Mobazi 1\n",
"Marble Saga 1\n",
"MobileInsight 1\n",
"Modern air combat He 1\n",
"Money or Death 1\n",
"Moy 1\n",
"Music 1\n",
"Smart Launcher Pro 1\n",
"Smart App Protector 1\n",
"Skype Qik 1\n",
"Skater Boy 1\n",
"Super Flashlight 1\n",
"Super Zombie Hunter 1\n",
"SuperPlayer 1\n",
"SydneyApps FireFly L 1\n",
"Sys Service 1\n",
"Stickman Tennis 1\n",
"Sea GOLauncher EX Th 1\n",
"Solid Explorer 1\n",
"Snake 1\n",
"Search 1\n",
"SecPhone 1\n",
"Sensor music player 1\n",
"Service Framework 1\n",
"Setup guide 1\n",
"SexyCrisis 1\n",
"Soccer Stars 1\n",
"Shadowsocks 1\n",
"\u0622\u0632\u0645\u0648\u0646 \u0622\u06cc\u06cc\u0646 \u0646\u0627\u0645\u0647 \u067e\u0648\u06cc\u0627 1\n",
"\u0622\u0645\u0648\u0632\u0634 \u0627\u0646\u0648\u0627\u0639 \u063a\u0630\u0627 \u0647\u0627 1\n",
"\u0622\u0647\u0646\u06af \u0628\u0627 \u0645\u062a\u0646 \u0645\u062d\u0633\u0646 \u064a\u06af\u0627 1\n",
"DataCreate 1\n",
"Xperia\u2122 extension 1\n",
"TMServerApp 1\n",
"LeSafe 1\n",
"NYTimes 1\n",
"Lampe 1\n",
"DiDi 1\n",
"Design It! 1\n",
"Death Moto 2 1\n",
"Dancing Baby 1\n",
"Xperia Lounge 1\n",
"DX Battery Saver 1\n",
"DS 1\n",
"DMSS-Pro 1\n",
"Cut the Rope Experim 1\n",
"Customized App Insta 1\n",
"Customised settings 1\n",
"CredentialManagerSer 1\n",
"Creative Locker 1\n",
"Xperia Proxy 1\n",
"XingPlayer 1\n",
"com.samsung.app.play 1\n",
"Weather Live 1\n",
"com.sonyericsson.cus 1\n",
"com.sonyericsson.ill 1\n",
"com.sonyericsson.set 1\n",
"com.sonyericsson.uxp 1\n",
"com.obakaka.swatshoo 1\n",
"Zalando 1\n",
"ZDclock 1\n",
"ZDbox 1\n",
"Weather Locker HD 1\n",
"XModGames 1\n",
"WeatherBug 1\n",
"Whatsapp Connect 1\n",
"White Noise 1\n",
"Wi-Fi 1\n",
"Wi-Fi \u0433\u0438\u043f\u0435\u0440\u043e\u0431\u044a\u0435\u043a\u0442\u043e\u0432 1\n",
"Winamp 1\n",
"WlanTest 1\n",
"Wunderlist 1\n",
"Dialer storage 1\n",
"Crazy Kid Skater 1\n",
"CrashNotifier 1\n",
"Exchange Services 1\n",
"Field Compass 1\n",
"FastBoot 1\n",
"Fast Racing 1\n",
"Fashion Design 1\n",
"FactoryKeystring 1\n",
"FUN&downloads 1\n",
"FLCommando 1\n",
"Extreme Pickup Crush 1\n",
"Error 1\n",
"Contacts 1\n",
"Equalizer 1\n",
"Enterprise VPN Servi 1\n",
"Enterprise Sim Pin S 1\n",
"Email 1\n",
"Editor de Fotocollag 1\n",
"Easy settings 1\n",
"Easy MP3 Downloader 1\n",
"Earthquakes 1\n",
"File Browser 1\n",
"Films 1\n",
"Fireflies Forest Nig 1\n",
"Fish Hajj ADS 1\n",
"ColorNote 1\n",
"Color Splash Effect 1\n",
"Clouds & Sheep 1\n",
"CloudAgent 1\n",
"ClashFarming 1\n",
"Cigarette Smoke (Fre 1\n",
"Charterz 1\n",
"Charger 1\n",
"Catapult King 1\n",
"Cardiograph 1\n",
"Candy Crush 1\n",
"Crazy Dentist 1\n",
"Dirt Road Trucker 3D 1\n",
"Divan Hafiz 1\n",
"Lazy Swipe 1\n",
"Flick Shoot Pro 1\n",
"FlashPlayer 1\n",
"com.sonyericsson.and 1\n",
"com.huawei.DiagReboo 1\n",
"\u0622\u0647\u0646\u06af \u0647\u0627\u06cc \u0628\u0644\u0632 1\n",
"\u0636\u0631\u06cc\u0628 \u0647\u0648\u0634\u06cc 2 1\n",
"\u0645\u0631\u0648\u0631\u06af\u0631 \u0645\u0644\u06cc 1\n",
"\u0632\u0646\u06af \u062e\u0648\u0631 \u067e\u06cc\u0627\u0645 1\n",
"\u0632\u0646\u06af \u0641\u0627\u0628\u0631\u06cc\u06a9 \u06af\u0648\u0634\u06cc \u0647\u0627 1\n",
"\u0632\u0646\u06af \u0647\u0627\u06cc \u0633\u0647 \u0628\u0639\u062f\u06cc 1\n",
"\u0633\u0628\u06cc\u0644 1\n",
"\u0633\u0631\u064a\u0627\u0644\u0647 \u0631\u0648 \u064a\u0627\u062f\u062a\u0647\u061f 1\n",
"\u0635\u062f\u0627\u06cc \u062d\u06cc\u0648\u0627\u0646\u0627\u062a 1\n",
"\u0645\u0633\u0627\u0626\u0644 \u0632\u0646\u0627\u0634\u0648\u06cc\u06cc \u0648 \u062c\u0646\u0633\u06cc 1\n",
"\u0639\u0644\u0627\u0626\u0645 \u0631\u0627\u0647\u0646\u0645\u0627\u06cc\u06cc \u0631\u0627 \u0642\u0648 1\n",
"\u0631\u0648\u062d \u062a\u0648 \u0639\u06a9\u0633\u062a\u0647 1\n",
"\u0639\u0644\u06cc \u06a9\u0631\u06cc\u0645\u06cc 1\n",
"\u0641\u0633\u0641\u0631 \u0628\u0627\u0632\u06cc 1\n",
"\u0642\u0641\u0644 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627 1\n",
"\u0642\u0641\u0644 \u0635\u0641\u062d\u0647 \u0628\u0627 \u06cc\u06a9 \u06a9\u0644\u06cc\u06a9 1\n",
"\u0645\u0627\u0632\u06cc\u0627\u0631 \u0641\u0644\u0627\u062d\u06cc 1\n",
"\u0637\u0627\u0644\u0639 \u0628\u06cc\u0646\u06cc 1\n",
"iFighter 1945 1\n",
"hack wifi password 1\n",
"\u0645\u0634\u0647\u062f \u0646\u0645\u0627 1\n",
"\u06a9\u0627\u0641\u0647 \u0627\u06cc\u0646\u0633\u062a\u0627\u06af\u0631\u0627\u0645 1\n",
"Zanashooee 1\n",
"\u0646\u0642\u0637\u0647 \u0628\u0627\u0632\u06cc \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 1\n",
"\u0622\u0647\u0646\u06af \u0647\u0627\u06cc \u0648\u06cc\u0648\u0644\u0646 1\n",
"\u00a0App Master\u00a0 1\n",
"imo beta 1\n",
"\u0631\u0642\u0635 \u0646\u0648\u0631 1\n",
"\u0631\u0698\u06cc\u0645\u060c\u0627\u0646\u062f\u0627\u0645 \u062f\u0644\u062e\u0648\u0627\u0647 1\n",
"\u0645\u0647\u0627\u0631\u062a\u200c\u0647\u0627\u06cc 1\n",
"\u0645\u0648\u0628\u0627\u06cc\u0644 \u0628\u0627\u0646\u06a9 \u0627\u0646\u0635\u0627\u0631 1\n",
"\u0646\u0631\u062e \u0627\u0631\u0632 1\n",
"\u067e\u0627\u067e\u0627\u0632\u0644.\u0628\u0627\u0632\u06cc\u06af\u0631\u0627\u0646 \u0632\u0646 1\n",
"\uc8fc\ud589\uc758 \ub2ec\uc778 1\n",
"\u067e\u06cc\u0627\u0645\u06a9 \u0648 \u062a\u0645\u0627\u0633 \u062c\u0639\u0644\u06cc 1\n",
"\u0645\u0641\u0627\u062a\u06cc\u062d \u0628\u0627\u0628 \u0627\u0644\u0646\u0639\u06cc\u0645 1\n",
"\u067e\u06cc\u0634\u0648\u0627\u0632 \u0622\u0632\u0645\u0627\u06cc\u0634\u06cc 1\n",
"\u06a9\u0641\u0634\u062f\u0648\u0632\u06a9 1\n",
"\u06cc\u0627\u062f\u0622\u0648\u0631 1\n",
"\u91d1\u5c71\u6e05\u7406\u5927\u5e08 1\n",
"\ub0b4 \uce98\ub9b0\ub354 1\n",
"\ub3c4\ub3cc \ub7f0\ucc98 1\n",
"com.sunway.holoo 1\n",
"Truck Parking 3D 1\n",
"Truecaller 1\n",
"Tom Loves Angela 1\n",
"Travel wallpaper 1\n",
"Thermo 1\n",
"ToolBox 1\n",
"Touch Timer 1\n",
"TouchPal Keyboard V5 1\n",
"Traffic Racer 1\n",
"Translate 1\n",
"Translator 1\n",
"Water Your Body 1\n",
"Tutoriel 1\n",
"Weather 1\n",
"Weather Daemon 1\n",
"Zelzele Negar 1\n",
"Zoe 1\n",
"aFarsi 1\n",
"chompSMS 1\n",
"com.android.provisio 1\n",
"com.cci.simmelock 1\n",
"Textra 1\n",
"TempleRunOz 1\n",
"Temple Run 1\n",
"Tehran Traffic 1\n",
"TwDVFSApp 1\n",
"UCBrowser 1\n",
"USB connectivity 1\n",
"TripAdvisor 1\n",
"Unified Daemon(EUR) 1\n",
"VOA 1\n",
"VPN Services 1\n",
"VPlayer 1\n",
"Vault 1\n",
"Virtual Nose Surgery 1\n",
"Virtual Table Tennis 1\n",
"VA High Speed Downlo 1\n",
"WEBTOON 1\n",
"Trial X2 1\n",
"Transparent weather 1\n",
"TVSpielfilm 1\n",
"TcpdumpService 1\n",
"DownloadManager 1\n",
"Name: deviceid, Length: 698, dtype: int64\n"
]
}
],
"prompt_number": 33
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## PHONE MODELS"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### IRAN"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"devices_ir = usage_app_ir.groupby('deviceid').first()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 35
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"devices_ir.groupby(['manufacturer', 'phonemodel', 'androidversion'])['name'].count()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 39,
"text": [
"manufacturer phonemodel androidversion\n",
"HTC HTC Desire 310 4.2.2 1\n",
" HTC One 5.0.2 1\n",
" HTC One X 4.2.2 1\n",
"HUAWEI HUAWEI G610-U20 4.2.1 1\n",
" HUAWEI G700-U10 4.2.1 1\n",
" HUAWEI Y530-U00 4.3 2\n",
"LENOVO Lenovo A3500-HV 4.2.2 1\n",
" Lenovo S5000-H 4.2.2 1\n",
" LenovoA3300-GV 4.2.2 1\n",
"Lenovo Lenovo A5500-HV 4.2.2 1\n",
"Sony C2105 4.2.2 1\n",
" C5303 4.3 1\n",
" C5502 4.2.2 1\n",
" C6602 4.4.2 1\n",
" C6603 4.2.2 1\n",
" LT29i 4.3 1\n",
" LT30p 4.1.2 1\n",
"Sony Ericsson ST25i 2.3.7 2\n",
"alps Gpad_201 4.2.2 1\n",
"samsung GT-I8190 4.1.1 1\n",
" GT-I9001 2.3.5 1\n",
" GT-I9082 4.1.2 1\n",
" GT-I9105 4.1.2 1\n",
" GT-I9105P 4.2.2 1\n",
" GT-I9152 4.2.2 1\n",
" GT-I9300 4.0.4 1\n",
" 4.1.2 3\n",
" GT-I9500 4.2.2 2\n",
" GT-I9505 4.4.2 1\n",
" GT-N5100 4.1.2 3\n",
" GT-N7100 4.1.1 1\n",
" 4.1.2 4\n",
" GT-P3100 4.0.4 2\n",
" GT-P6800 4.1.2 1\n",
" GT-S7262 4.1.2 3\n",
" SM-T211 4.1.2 2\n",
" SM-T705 4.4.2 1\n",
"Name: name, dtype: int64"
]
}
],
"prompt_number": 39
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### World"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"devices = usage_app_all.groupby('deviceid').first()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 41
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dev_count = devices.groupby(['manufacturer', 'phonemodel'])['name'].count()\n",
"dev_count.sort(ascending=False)\n",
"with pd.option_context('display.max_rows', 999, 'display.max_columns', 3):\n",
" print dev_count"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"manufacturer phonemodel \n",
"samsung GT-I9300 11\n",
" GT-N7100 9\n",
" GT-S7262 6\n",
" GT-I9100 5\n",
" GT-P6800 4\n",
" GT-P3100 4\n",
" GT-N8000 4\n",
" GT-N7000 4\n",
" GT-N5100 3\n",
" GT-I9505 3\n",
" SCH-I545 3\n",
" GT-I9500 3\n",
" GT-I9082 3\n",
"HTC HTC One 3\n",
"samsung SM-T211 3\n",
" GT-I9105P 2\n",
" Galaxy Nexus 2\n",
" GT-I9001 2\n",
" GT-I9301I 2\n",
" GT-P5100 2\n",
"Sony Ericsson ST25i 2\n",
"samsung GT-P5113 2\n",
"HTC HTC One X 2\n",
"HUAWEI HUAWEI Y530-U00 2\n",
"samsung SM-G900F 2\n",
" SM-G7102 2\n",
"HUAWEI HUAWEI G610-U20 2\n",
"Sony C5502 1\n",
" C6602 1\n",
" C6603 1\n",
" LT29i 1\n",
" LT30p 1\n",
"HTC HTC Desire 310 1\n",
"Sony Ericsson LT26i 1\n",
"LENOVO Lenovo A3500-HV 1\n",
"Fly IQ4410 Quad 1\n",
"EMC MX 1\n",
"Amazon KFTT 1\n",
"alps Gpad_201 1\n",
"asus ASUS_T00J 1\n",
" K00E 1\n",
" K00G 1\n",
" Nexus 7 1\n",
" Transformer TF101 1\n",
"huawei U8800-51 1\n",
"Sony Ericsson LT26ii 1\n",
"HTC myTouch_4G_Slide 1\n",
" HTC One mini 1\n",
"HUAWEI HUAWEI G525-U00 1\n",
"LENOVO Lenovo S5000-H 1\n",
" LenovoA3300-GV 1\n",
"LGE LG-E615f 1\n",
" LG-V500 1\n",
" LG-VS410PP 1\n",
"HUAWEI HUAWEI U9508 1\n",
"LGE Nexus 4 1\n",
"Lenovo Lenovo A5500-HV 1\n",
"motorola MZ601 1\n",
"Motorola XOOM 2 1\n",
"HUAWEI HUAWEI P7-L10 1\n",
"Sony C2105 1\n",
"HUAWEI HUAWEI G750-U10 1\n",
"Sony C5303 1\n",
"HUAWEI HUAWEI G700-U10 1\n",
"motorola MB520 1\n",
"unknown mw07 1\n",
"motorola XT905 1\n",
"samsung SHW-M110S 1\n",
" GT-S5830M 1\n",
" GT-S6500D 1\n",
" SAMSUNG-SGH-I717 1\n",
" SCH-I535 1\n",
" SCH-R530U 1\n",
" SGH-M919 1\n",
" SGH-T989D 1\n",
" SHV-E210S 1\n",
" SM-G850F 1\n",
" GT-S5282 1\n",
" SM-G900H 1\n",
" SM-G900S 1\n",
" SM-G900T 1\n",
" SM-T111 1\n",
" SM-T310 1\n",
" SM-T520 1\n",
" SM-T700 1\n",
" SM-T705 1\n",
" GT-S5300 1\n",
" GT-P7300 1\n",
"rockchip LT7035-J 1\n",
"samsung GT-I9105 1\n",
"rockchip MK808 1\n",
" Tab760 1\n",
" rk30sdk 1\n",
" rk31sdk 1\n",
"samsung GT-I8160 1\n",
" GT-I8190 1\n",
" SPH-L720T 1\n",
" GT-I9100T 1\n",
" GT-I9152 1\n",
" GT-P6200 1\n",
" GT-I9190 1\n",
" GT-I9192 1\n",
" GT-I9195 1\n",
" GT-I9210 1\n",
" GT-N8020 1\n",
" GT-P3113 1\n",
" GT-P5110 1\n",
" GT-P5200 1\n",
"Acer A200 1\n",
"Name: name, Length: 109, dtype: int64\n"
]
}
],
"prompt_number": 47
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Popular Android version"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dev_ver_count = devices.groupby(['androidversion'])['name'].count()\n",
"dev_ver_count.sort(ascending=False)\n",
"with pd.option_context('display.max_rows', 999, 'display.max_columns', 3):\n",
" print dev_ver_count"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"androidversion\n",
"4.1.2 43\n",
"4.2.2 30\n",
"4.4.2 27\n",
"4.3 15\n",
"4.0.4 14\n",
"4.1.1 6\n",
"2.3.6 6\n",
"4.0.3 6\n",
"2.3.5 5\n",
"4.2.1 5\n",
"4.4.4 3\n",
"3.2 2\n",
"2.3.7 2\n",
"2.2.2 2\n",
"5.0.1 2\n",
"5.0 2\n",
"3.0.1 1\n",
"4.4.3 1\n",
"2.3.4 1\n",
"5.0.2 1\n",
"Name: name, dtype: int64\n"
]
}
],
"prompt_number": 50
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## ZERO RATING APPS\n",
"- Wikipedia, Facebook, Google\n",
"- There may be others, not sure where to get the list"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"usage_app_all['name'].unique()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 52,
"text": [
"array([u'DataCreate', u'Samsung SetupWizard', u'\\xa0\\xa0ZERO\\xa0\\xa0', ...,\n",
" u'iStunt2', u'WiFi File Explorer', u'Offroad Legends FREE'], dtype=object)"
]
}
],
"prompt_number": 52
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"zero_rated = usage_app_all [ usage_app_all['name'].isin([ u'Google Search', u'Wikipedia extension', u'Facebook']) ] \n",
"non_zero_rated = usage_app_all.ix[ ~(usage_app_all.index.isin(zero_rated.index)) ]"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 70
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"print len(zero_rated)\n",
"print len(non_zero_rated)\n",
"print len(usage_app_all)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"40630\n",
"1049009\n",
"1089639\n"
]
}
],
"prompt_number": 71
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"zero_rated_us = zero_rated[zero_rated['networkcountry']=='us']\n",
"non_zero_rated_us = non_zero_rated[non_zero_rated['networkcountry']=='us']"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 77
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"zero_rated_us.groupby(['deviceid', 'name'])[['total_recv', 'total_sent']].sum()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th></th>\n",
" <th>total_recv</th>\n",
" <th>total_sent</th>\n",
" </tr>\n",
" <tr>\n",
" <th>deviceid</th>\n",
" <th>name</th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th rowspan=\"2\" valign=\"top\">13985053b1d717cba874855ea6f214360065cbdc</th>\n",
" <th>Facebook</th>\n",
" <td> 51933042515</td>\n",
" <td> 15005859317</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Google Search</th>\n",
" <td> 3065559951</td>\n",
" <td> 712079122</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45e4faf81eef839aa0e4020c3378faeb57d6a9f7</th>\n",
" <th>Google Search</th>\n",
" <td> 12189790279</td>\n",
" <td> 4630889339</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5ce617b16f63efdc75f4d6154cd414822c25a040</th>\n",
" <th>Google Search</th>\n",
" <td> 22346254</td>\n",
" <td> 32900002</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8cc4942b2f09a0184b662a7af56edc3029dbb473</th>\n",
" <th>Google Search</th>\n",
" <td> 59560</td>\n",
" <td> 9592</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"2\" valign=\"top\">c8e97aba7d854ae1cb8692b91fa3c73516b398a6</th>\n",
" <th>Facebook</th>\n",
" <td> 120443256509</td>\n",
" <td> 255369960273</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Google Search</th>\n",
" <td> 16960047722</td>\n",
" <td> 8355533565</td>\n",
" </tr>\n",
" <tr>\n",
" <th>dd4e9146d633d02834274c4df2f59df28f010d4f</th>\n",
" <th>Google Search</th>\n",
" <td> 370246</td>\n",
" <td> 60272</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"2\" valign=\"top\">f22764f1524d37de5b0909ba8ed9d838620a2665</th>\n",
" <th>Facebook</th>\n",
" <td> 12329739</td>\n",
" <td> 9904087</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Google Search</th>\n",
" <td> 69945913</td>\n",
" <td> 44342416</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 78,
"text": [
" total_recv \\\n",
"deviceid name \n",
"13985053b1d717cba874855ea6f214360065cbdc Facebook 51933042515 \n",
" Google Search 3065559951 \n",
"45e4faf81eef839aa0e4020c3378faeb57d6a9f7 Google Search 12189790279 \n",
"5ce617b16f63efdc75f4d6154cd414822c25a040 Google Search 22346254 \n",
"8cc4942b2f09a0184b662a7af56edc3029dbb473 Google Search 59560 \n",
"c8e97aba7d854ae1cb8692b91fa3c73516b398a6 Facebook 120443256509 \n",
" Google Search 16960047722 \n",
"dd4e9146d633d02834274c4df2f59df28f010d4f Google Search 370246 \n",
"f22764f1524d37de5b0909ba8ed9d838620a2665 Facebook 12329739 \n",
" Google Search 69945913 \n",
"\n",
" total_sent \n",
"deviceid name \n",
"13985053b1d717cba874855ea6f214360065cbdc Facebook 15005859317 \n",
" Google Search 712079122 \n",
"45e4faf81eef839aa0e4020c3378faeb57d6a9f7 Google Search 4630889339 \n",
"5ce617b16f63efdc75f4d6154cd414822c25a040 Google Search 32900002 \n",
"8cc4942b2f09a0184b662a7af56edc3029dbb473 Google Search 9592 \n",
"c8e97aba7d854ae1cb8692b91fa3c73516b398a6 Facebook 255369960273 \n",
" Google Search 8355533565 \n",
"dd4e9146d633d02834274c4df2f59df28f010d4f Google Search 60272 \n",
"f22764f1524d37de5b0909ba8ed9d838620a2665 Facebook 9904087 \n",
" Google Search 44342416 "
]
}
],
"prompt_number": 78
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Ratio by data per device"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data_zero_rated = zero_rated_us.groupby(['deviceid'])[['total_recv', 'total_sent']].sum()\n",
"data_zero_rated"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>total_recv</th>\n",
" <th>total_sent</th>\n",
" </tr>\n",
" <tr>\n",
" <th>deviceid</th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>13985053b1d717cba874855ea6f214360065cbdc</th>\n",
" <td> 54998602466</td>\n",
" <td> 15717938439</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45e4faf81eef839aa0e4020c3378faeb57d6a9f7</th>\n",
" <td> 12189790279</td>\n",
" <td> 4630889339</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5ce617b16f63efdc75f4d6154cd414822c25a040</th>\n",
" <td> 22346254</td>\n",
" <td> 32900002</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8cc4942b2f09a0184b662a7af56edc3029dbb473</th>\n",
" <td> 59560</td>\n",
" <td> 9592</td>\n",
" </tr>\n",
" <tr>\n",
" <th>c8e97aba7d854ae1cb8692b91fa3c73516b398a6</th>\n",
" <td> 137403304231</td>\n",
" <td> 263725493838</td>\n",
" </tr>\n",
" <tr>\n",
" <th>dd4e9146d633d02834274c4df2f59df28f010d4f</th>\n",
" <td> 370246</td>\n",
" <td> 60272</td>\n",
" </tr>\n",
" <tr>\n",
" <th>f22764f1524d37de5b0909ba8ed9d838620a2665</th>\n",
" <td> 82275652</td>\n",
" <td> 54246503</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 99,
"text": [
" total_recv total_sent\n",
"deviceid \n",
"13985053b1d717cba874855ea6f214360065cbdc 54998602466 15717938439\n",
"45e4faf81eef839aa0e4020c3378faeb57d6a9f7 12189790279 4630889339\n",
"5ce617b16f63efdc75f4d6154cd414822c25a040 22346254 32900002\n",
"8cc4942b2f09a0184b662a7af56edc3029dbb473 59560 9592\n",
"c8e97aba7d854ae1cb8692b91fa3c73516b398a6 137403304231 263725493838\n",
"dd4e9146d633d02834274c4df2f59df28f010d4f 370246 60272\n",
"f22764f1524d37de5b0909ba8ed9d838620a2665 82275652 54246503"
]
}
],
"prompt_number": 99
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data_non_zero_rated = non_zero_rated_us.groupby(['deviceid'])[['total_recv', 'total_sent']].sum()\n",
"data_non_zero_rated"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>total_recv</th>\n",
" <th>total_sent</th>\n",
" </tr>\n",
" <tr>\n",
" <th>deviceid</th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>13985053b1d717cba874855ea6f214360065cbdc</th>\n",
" <td> 544680014361</td>\n",
" <td> 24152437897</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45e4faf81eef839aa0e4020c3378faeb57d6a9f7</th>\n",
" <td> 913457718048</td>\n",
" <td> 584363453026</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5ce617b16f63efdc75f4d6154cd414822c25a040</th>\n",
" <td> 169584213859</td>\n",
" <td> 20976143093</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8cc4942b2f09a0184b662a7af56edc3029dbb473</th>\n",
" <td> 29717396</td>\n",
" <td> 645220</td>\n",
" </tr>\n",
" <tr>\n",
" <th>a4afae5798d2801a0b69de4f7663ff1f5ae017d8</th>\n",
" <td> 11662323872</td>\n",
" <td> 17143667978</td>\n",
" </tr>\n",
" <tr>\n",
" <th>c8e97aba7d854ae1cb8692b91fa3c73516b398a6</th>\n",
" <td> 1106691304997</td>\n",
" <td> 273369863269</td>\n",
" </tr>\n",
" <tr>\n",
" <th>dd4e9146d633d02834274c4df2f59df28f010d4f</th>\n",
" <td> 619138449</td>\n",
" <td> 130834731</td>\n",
" </tr>\n",
" <tr>\n",
" <th>f22764f1524d37de5b0909ba8ed9d838620a2665</th>\n",
" <td> 34512258036</td>\n",
" <td> 7355928203</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 100,
"text": [
" total_recv total_sent\n",
"deviceid \n",
"13985053b1d717cba874855ea6f214360065cbdc 544680014361 24152437897\n",
"45e4faf81eef839aa0e4020c3378faeb57d6a9f7 913457718048 584363453026\n",
"5ce617b16f63efdc75f4d6154cd414822c25a040 169584213859 20976143093\n",
"8cc4942b2f09a0184b662a7af56edc3029dbb473 29717396 645220\n",
"a4afae5798d2801a0b69de4f7663ff1f5ae017d8 11662323872 17143667978\n",
"c8e97aba7d854ae1cb8692b91fa3c73516b398a6 1106691304997 273369863269\n",
"dd4e9146d633d02834274c4df2f59df28f010d4f 619138449 130834731\n",
"f22764f1524d37de5b0909ba8ed9d838620a2665 34512258036 7355928203"
]
}
],
"prompt_number": 100
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data_zero_rated/data_non_zero_rated"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>total_recv</th>\n",
" <th>total_sent</th>\n",
" </tr>\n",
" <tr>\n",
" <th>deviceid</th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>13985053b1d717cba874855ea6f214360065cbdc</th>\n",
" <td> 0.100974</td>\n",
" <td> 0.650781</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45e4faf81eef839aa0e4020c3378faeb57d6a9f7</th>\n",
" <td> 0.013345</td>\n",
" <td> 0.007925</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5ce617b16f63efdc75f4d6154cd414822c25a040</th>\n",
" <td> 0.000132</td>\n",
" <td> 0.001568</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8cc4942b2f09a0184b662a7af56edc3029dbb473</th>\n",
" <td> 0.002004</td>\n",
" <td> 0.014866</td>\n",
" </tr>\n",
" <tr>\n",
" <th>a4afae5798d2801a0b69de4f7663ff1f5ae017d8</th>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>c8e97aba7d854ae1cb8692b91fa3c73516b398a6</th>\n",
" <td> 0.124157</td>\n",
" <td> 0.964720</td>\n",
" </tr>\n",
" <tr>\n",
" <th>dd4e9146d633d02834274c4df2f59df28f010d4f</th>\n",
" <td> 0.000598</td>\n",
" <td> 0.000461</td>\n",
" </tr>\n",
" <tr>\n",
" <th>f22764f1524d37de5b0909ba8ed9d838620a2665</th>\n",
" <td> 0.002384</td>\n",
" <td> 0.007375</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 101,
"text": [
" total_recv total_sent\n",
"deviceid \n",
"13985053b1d717cba874855ea6f214360065cbdc 0.100974 0.650781\n",
"45e4faf81eef839aa0e4020c3378faeb57d6a9f7 0.013345 0.007925\n",
"5ce617b16f63efdc75f4d6154cd414822c25a040 0.000132 0.001568\n",
"8cc4942b2f09a0184b662a7af56edc3029dbb473 0.002004 0.014866\n",
"a4afae5798d2801a0b69de4f7663ff1f5ae017d8 NaN NaN\n",
"c8e97aba7d854ae1cb8692b91fa3c73516b398a6 0.124157 0.964720\n",
"dd4e9146d633d02834274c4df2f59df28f010d4f 0.000598 0.000461\n",
"f22764f1524d37de5b0909ba8ed9d838620a2665 0.002384 0.007375"
]
}
],
"prompt_number": 101
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Separated by 3g/wifi"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data_zero_rated_3g = zero_rated_us[zero_rated_us['connectiontype']!='Wifi'].groupby(['deviceid'])[['total_recv', 'total_sent']].sum()\n",
"data_zero_rated_wifi = zero_rated_us[zero_rated_us['connectiontype']=='Wifi'].groupby(['deviceid'])[['total_recv', 'total_sent']].sum()\n",
"data_non_zero_rated_3g = non_zero_rated_us[non_zero_rated_us['connectiontype']!='Wifi'].groupby(['deviceid'])[['total_recv', 'total_sent']].sum()\n",
"data_non_zero_rated_wifi = non_zero_rated_us[non_zero_rated_us['connectiontype']=='Wifi'].groupby(['deviceid'])[['total_recv', 'total_sent']].sum()\n"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 107
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data_zero_rated_3g/data_non_zero_rated_3g"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>total_recv</th>\n",
" <th>total_sent</th>\n",
" </tr>\n",
" <tr>\n",
" <th>deviceid</th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>13985053b1d717cba874855ea6f214360065cbdc</th>\n",
" <td> 0.104341</td>\n",
" <td> 0.702866</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45e4faf81eef839aa0e4020c3378faeb57d6a9f7</th>\n",
" <td> 0.009029</td>\n",
" <td> 0.003791</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5ce617b16f63efdc75f4d6154cd414822c25a040</th>\n",
" <td> 0.000102</td>\n",
" <td> 0.001315</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8cc4942b2f09a0184b662a7af56edc3029dbb473</th>\n",
" <td> 0.002004</td>\n",
" <td> 0.014866</td>\n",
" </tr>\n",
" <tr>\n",
" <th>a4afae5798d2801a0b69de4f7663ff1f5ae017d8</th>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>c8e97aba7d854ae1cb8692b91fa3c73516b398a6</th>\n",
" <td> 0.015618</td>\n",
" <td> 0.880767</td>\n",
" </tr>\n",
" <tr>\n",
" <th>dd4e9146d633d02834274c4df2f59df28f010d4f</th>\n",
" <td> 0.000598</td>\n",
" <td> 0.000461</td>\n",
" </tr>\n",
" <tr>\n",
" <th>f22764f1524d37de5b0909ba8ed9d838620a2665</th>\n",
" <td> 0.002539</td>\n",
" <td> 0.008197</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 108,
"text": [
" total_recv total_sent\n",
"deviceid \n",
"13985053b1d717cba874855ea6f214360065cbdc 0.104341 0.702866\n",
"45e4faf81eef839aa0e4020c3378faeb57d6a9f7 0.009029 0.003791\n",
"5ce617b16f63efdc75f4d6154cd414822c25a040 0.000102 0.001315\n",
"8cc4942b2f09a0184b662a7af56edc3029dbb473 0.002004 0.014866\n",
"a4afae5798d2801a0b69de4f7663ff1f5ae017d8 NaN NaN\n",
"c8e97aba7d854ae1cb8692b91fa3c73516b398a6 0.015618 0.880767\n",
"dd4e9146d633d02834274c4df2f59df28f010d4f 0.000598 0.000461\n",
"f22764f1524d37de5b0909ba8ed9d838620a2665 0.002539 0.008197"
]
}
],
"prompt_number": 108
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data_zero_rated_wifi/data_non_zero_rated_wifi"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>total_recv</th>\n",
" <th>total_sent</th>\n",
" </tr>\n",
" <tr>\n",
" <th>deviceid</th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>13985053b1d717cba874855ea6f214360065cbdc</th>\n",
" <td> 0.072433</td>\n",
" <td> 0.212099</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45e4faf81eef839aa0e4020c3378faeb57d6a9f7</th>\n",
" <td> 0.013457</td>\n",
" <td> 0.008068</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5ce617b16f63efdc75f4d6154cd414822c25a040</th>\n",
" <td> 0.000144</td>\n",
" <td> 0.001662</td>\n",
" </tr>\n",
" <tr>\n",
" <th>a4afae5798d2801a0b69de4f7663ff1f5ae017d8</th>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>c8e97aba7d854ae1cb8692b91fa3c73516b398a6</th>\n",
" <td> 0.731071</td>\n",
" <td> 1.937077</td>\n",
" </tr>\n",
" <tr>\n",
" <th>f22764f1524d37de5b0909ba8ed9d838620a2665</th>\n",
" <td> 0.002374</td>\n",
" <td> 0.007324</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 109,
"text": [
" total_recv total_sent\n",
"deviceid \n",
"13985053b1d717cba874855ea6f214360065cbdc 0.072433 0.212099\n",
"45e4faf81eef839aa0e4020c3378faeb57d6a9f7 0.013457 0.008068\n",
"5ce617b16f63efdc75f4d6154cd414822c25a040 0.000144 0.001662\n",
"a4afae5798d2801a0b69de4f7663ff1f5ae017d8 NaN NaN\n",
"c8e97aba7d854ae1cb8692b91fa3c73516b398a6 0.731071 1.937077\n",
"f22764f1524d37de5b0909ba8ed9d838620a2665 0.002374 0.007324"
]
}
],
"prompt_number": 109
},
{
"cell_type": "code",
"collapsed": false,
"input": [],
"language": "python",
"metadata": {},
"outputs": []
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment