Skip to content

Instantly share code, notes, and snippets.

@bburky

bburky/2018 podcast CPEs.ipynb

Last active March 21, 2020 15:41
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bburky/21baeec15f063027714f9089c9bb1d27 to your computer and use it in GitHub Desktop.
Save bburky/21baeec15f063027714f9089c9bb1d27 to your computer and use it in GitHub Desktop.
Download ZIP
Podcast CPEs
Display the source blob
Display the rendered blob
Raw
2018 podcast CPEs.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# CISSP Podcast CPEs 2018\n",
"_Blake Burkhart_\n",
"\n",
"The following documents listening to 39.5 hours of the [Risky Business](https://risky.biz/) podcast. The data below was extracted from the database of the [Podcast Addict](https://play.google.com/store/apps/details?id=com.bambuna.podcastaddict&hl=en_US) podcast app."
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import sqlalchemy\n",
"import pandas as pd\n",
"\n",
"pd.set_option('display.max_colwidth', -1)"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"engine = sqlalchemy.create_engine(\"sqlite:///podcastAddict.db\")"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"df = pd.read_sql(\"SELECT _id FROM podcasts WHERE name = 'Risky Business'\", engine)\n",
"podcast_id, = df[\"_id\"]"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"df = pd.read_sql(\"\"\"\n",
" SELECT\n",
" name,\n",
" -- Position_to_resume is zero if the podcast has been completely listened to\n",
" -- Use the total duration if position_to_resume is zero\n",
" COALESCE(NULLIF(position_to_resume, 0), duration_ms) AS position_ms,\n",
" duration_ms,\n",
" playbackDate,\n",
" publication_date\n",
" FROM episodes\n",
" WHERE podcast_id = ? AND\n",
" -- Only select podcsts where playbackDate is nonzero (has been listened to)\n",
" playbackDate != -1\"\"\",\n",
" engine,\n",
" params=[podcast_id])\n",
"df[\"duration_ms\"] = pd.to_timedelta(df[\"duration_ms\"], unit=\"ms\")\n",
"df[\"position_ms\"] = pd.to_timedelta(df[\"position_ms\"], unit=\"ms\")\n",
"df[\"playbackDate\"] = pd.to_datetime(df[\"playbackDate\"], unit=\"ms\")\n",
"df[\"publication_date\"] = pd.to_datetime(df[\"publication_date\"], unit=\"ms\")"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Total hours listened to in 2018: 39.526535\n"
]
},
{
"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>name</th>\n",
" <th>position_ms</th>\n",
" <th>duration_ms</th>\n",
" <th>playbackDate</th>\n",
" <th>publication_date</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>0</td>\n",
" <td>Risky Biz Soap Box: Alphabet Chronicle co-founder Mike Wiacek talks Virus Total Intelligence</td>\n",
" <td>00:26:49.628000</td>\n",
" <td>00:26:49.628000</td>\n",
" <td>2018-03-05 14:14:12.702</td>\n",
" <td>2018-03-02</td>\n",
" </tr>\n",
" <tr>\n",
" <td>1</td>\n",
" <td>Risky Business #489 -- (Deep) Fake News</td>\n",
" <td>00:53:47.171000</td>\n",
" <td>00:53:47.171000</td>\n",
" <td>2018-03-07 23:46:37.281</td>\n",
" <td>2018-03-07</td>\n",
" </tr>\n",
" <tr>\n",
" <td>2</td>\n",
" <td>Risky Business #490 -- North Korea, \"cyber norms\" and diplomacy</td>\n",
" <td>00:50:51.849000</td>\n",
" <td>00:50:51.849000</td>\n",
" <td>2018-03-15 02:01:40.369</td>\n",
" <td>2018-03-14</td>\n",
" </tr>\n",
" <tr>\n",
" <td>3</td>\n",
" <td>Snake Oilers #5 part 1: Rapid7 Insight Phish, VMRay's updated platform and mail filtering with Mimecast</td>\n",
" <td>00:34:57.857000</td>\n",
" <td>00:34:57.857000</td>\n",
" <td>2018-03-21 18:45:53.835</td>\n",
" <td>2018-03-19</td>\n",
" </tr>\n",
" <tr>\n",
" <td>4</td>\n",
" <td>Risky Business #491 -- The biggest infosec news week we've ever seen</td>\n",
" <td>00:48:53.316000</td>\n",
" <td>00:53:41.802000</td>\n",
" <td>2018-03-26 13:14:05.228</td>\n",
" <td>2018-03-21</td>\n",
" </tr>\n",
" <tr>\n",
" <td>5</td>\n",
" <td>Snake Oilers 5 part 2: Penten talks Honey Docs, Trend Micro on its latest</td>\n",
" <td>00:27:01.904000</td>\n",
" <td>00:27:01.904000</td>\n",
" <td>2018-04-05 02:21:11.660</td>\n",
" <td>2018-03-26</td>\n",
" </tr>\n",
" <tr>\n",
" <td>6</td>\n",
" <td>Risky Business #492 -- Thomas Rid on sloppy active measures</td>\n",
" <td>01:01:38.772000</td>\n",
" <td>01:01:38.772000</td>\n",
" <td>2018-03-30 13:17:43.629</td>\n",
" <td>2018-03-29</td>\n",
" </tr>\n",
" <tr>\n",
" <td>7</td>\n",
" <td>Risky Biz Soap Box: Network detection is dead! Long live network detection!</td>\n",
" <td>00:37:00.325000</td>\n",
" <td>00:37:00.325000</td>\n",
" <td>2018-04-05 21:59:50.823</td>\n",
" <td>2018-04-02</td>\n",
" </tr>\n",
" <tr>\n",
" <td>8</td>\n",
" <td>Risky Business #493 -- SWIFT, pipeline attacks, Chrome's AV feature and more</td>\n",
" <td>00:44:33.369000</td>\n",
" <td>00:44:33.369000</td>\n",
" <td>2018-04-04 23:01:36.806</td>\n",
" <td>2018-04-04</td>\n",
" </tr>\n",
" <tr>\n",
" <td>9</td>\n",
" <td>Risky Business #494 -- Cisco customers have a bad week, plus a deep dive on WebAuthn</td>\n",
" <td>00:40:54.418000</td>\n",
" <td>00:40:54.418000</td>\n",
" <td>2018-04-11 22:24:16.198</td>\n",
" <td>2018-04-10</td>\n",
" </tr>\n",
" <tr>\n",
" <td>10</td>\n",
" <td>Risky Business #495 -- Russian Internet users are having a bad time</td>\n",
" <td>00:46:55.175000</td>\n",
" <td>00:46:55.175000</td>\n",
" <td>2018-04-19 02:19:01.575</td>\n",
" <td>2018-04-18</td>\n",
" </tr>\n",
" <tr>\n",
" <td>11</td>\n",
" <td>Risky Business #496 -- The China supply chain problem</td>\n",
" <td>01:01:11.240000</td>\n",
" <td>01:01:11.240000</td>\n",
" <td>2018-04-27 16:33:41.287</td>\n",
" <td>2018-04-25</td>\n",
" </tr>\n",
" <tr>\n",
" <td>12</td>\n",
" <td>Risky Business #497 -- Silvio's greatest hits</td>\n",
" <td>01:06:21.342000</td>\n",
" <td>01:06:21.342000</td>\n",
" <td>2018-05-03 01:28:11.242</td>\n",
" <td>2018-05-02</td>\n",
" </tr>\n",
" <tr>\n",
" <td>13</td>\n",
" <td>Risky Biz Soap Box: Root9b on agentless threat hunting</td>\n",
" <td>00:31:02.148000</td>\n",
" <td>00:31:02.148000</td>\n",
" <td>2018-05-07 13:21:41.316</td>\n",
" <td>2018-05-04</td>\n",
" </tr>\n",
" <tr>\n",
" <td>14</td>\n",
" <td>Risky Business #498 -- There sure is a lot of Microsoft Defender out there these days</td>\n",
" <td>00:57:17.104000</td>\n",
" <td>00:57:17.104000</td>\n",
" <td>2018-05-10 12:59:57.825</td>\n",
" <td>2018-05-09</td>\n",
" </tr>\n",
" <tr>\n",
" <td>15</td>\n",
" <td>Risky Business #499 -- Is PGP actually busted and Signal pwnt? Noooope</td>\n",
" <td>01:13:13.911000</td>\n",
" <td>01:13:13.911000</td>\n",
" <td>2018-05-17 03:16:42.273</td>\n",
" <td>2018-05-16</td>\n",
" </tr>\n",
" <tr>\n",
" <td>16</td>\n",
" <td>Risky Business feature interview: Hacking PUBG</td>\n",
" <td>00:27:23.118000</td>\n",
" <td>00:27:23.118000</td>\n",
" <td>2018-05-18 17:41:59.965</td>\n",
" <td>2018-05-18</td>\n",
" </tr>\n",
" <tr>\n",
" <td>17</td>\n",
" <td>Risky Business #500 -- Web asset discovery is getting useful</td>\n",
" <td>00:59:58.822000</td>\n",
" <td>00:59:58.822000</td>\n",
" <td>2018-05-24 22:08:09.777</td>\n",
" <td>2018-05-23</td>\n",
" </tr>\n",
" <tr>\n",
" <td>18</td>\n",
" <td>Risky Biz Soap Box: Kill your own meat with EclecticIQ</td>\n",
" <td>00:29:04.762000</td>\n",
" <td>00:29:04.762000</td>\n",
" <td>2018-05-29 22:02:20.800</td>\n",
" <td>2018-05-28</td>\n",
" </tr>\n",
" <tr>\n",
" <td>19</td>\n",
" <td>Risky Business #501 -- Trisis: signalling, deterrence or escalation?</td>\n",
" <td>00:48:01.817000</td>\n",
" <td>00:48:01.817000</td>\n",
" <td>2018-05-31 22:01:04.839</td>\n",
" <td>2018-05-30</td>\n",
" </tr>\n",
" <tr>\n",
" <td>20</td>\n",
" <td>Risky Business #502 -- Inside China's hacker scene</td>\n",
" <td>01:01:48.650000</td>\n",
" <td>01:01:48.650000</td>\n",
" <td>2018-06-07 03:15:39.025</td>\n",
" <td>2018-06-06</td>\n",
" </tr>\n",
" <tr>\n",
" <td>21</td>\n",
" <td>Risky Business #503 -- North Korean tech in the global supply chain</td>\n",
" <td>01:02:15.937000</td>\n",
" <td>01:02:15.937000</td>\n",
" <td>2018-06-18 21:52:29.160</td>\n",
" <td>2018-06-13</td>\n",
" </tr>\n",
" <tr>\n",
" <td>22</td>\n",
" <td>Risky Business #504 -- Latest email frauds and changes to money muling</td>\n",
" <td>00:57:09.755000</td>\n",
" <td>00:57:09.755000</td>\n",
" <td>2018-06-21 22:38:07.493</td>\n",
" <td>2018-06-20</td>\n",
" </tr>\n",
" <tr>\n",
" <td>23</td>\n",
" <td>Snake Oilers 6 part 1: InsightIDR from Rapid7, whitelisting with Airlock Digital and testing your SOC personnel with AttackIQ</td>\n",
" <td>00:03:40.346000</td>\n",
" <td>00:40:12.379000</td>\n",
" <td>2018-06-22 16:35:22.529</td>\n",
" <td>2018-06-21</td>\n",
" </tr>\n",
" <tr>\n",
" <td>24</td>\n",
" <td>Risky Business #505 -- Sanger vs FireEye, Reality Winner cops a plea</td>\n",
" <td>00:44:47.912000</td>\n",
" <td>00:44:47.912000</td>\n",
" <td>2018-06-27 23:54:00.955</td>\n",
" <td>2018-06-27</td>\n",
" </tr>\n",
" <tr>\n",
" <td>25</td>\n",
" <td>Risky Business #506 -- How security teams can work with PR</td>\n",
" <td>00:59:05.968000</td>\n",
" <td>00:59:05.968000</td>\n",
" <td>2018-07-06 19:37:44.901</td>\n",
" <td>2018-07-04</td>\n",
" </tr>\n",
" <tr>\n",
" <td>26</td>\n",
" <td>Snake Oilers 6 part 2: Proofpoint on cred phishing, Exabeam defines next-gen SIEM</td>\n",
" <td>00:11:32.666000</td>\n",
" <td>00:25:57.659000</td>\n",
" <td>2018-07-13 21:20:32.056</td>\n",
" <td>2018-07-05</td>\n",
" </tr>\n",
" <tr>\n",
" <td>27</td>\n",
" <td>Risky Biz Soap Box: Cylance: Driving machine learning model development with threat research</td>\n",
" <td>00:00:06.542000</td>\n",
" <td>00:35:45.473000</td>\n",
" <td>2018-07-20 14:56:22.178</td>\n",
" <td>2018-07-18</td>\n",
" </tr>\n",
" <tr>\n",
" <td>28</td>\n",
" <td>Risky Business #507 -- For Vlad</td>\n",
" <td>00:55:42.810000</td>\n",
" <td>00:55:42.810000</td>\n",
" <td>2018-07-27 13:13:13.239</td>\n",
" <td>2018-07-25</td>\n",
" </tr>\n",
" <tr>\n",
" <td>29</td>\n",
" <td>Risky Business #508 -- Special guest Greg Shipley of In-Q-Tel's Cyber Reboot</td>\n",
" <td>01:00:34.740000</td>\n",
" <td>01:06:44.563000</td>\n",
" <td>2018-08-01 13:21:41.460</td>\n",
" <td>2018-07-31</td>\n",
" </tr>\n",
" <tr>\n",
" <td>30</td>\n",
" <td>Risky Business #509 -- Just the usual mayhem and ownage</td>\n",
" <td>00:53:17.773000</td>\n",
" <td>00:53:17.773000</td>\n",
" <td>2018-08-17 22:23:18.192</td>\n",
" <td>2018-08-16</td>\n",
" </tr>\n",
" <tr>\n",
" <td>31</td>\n",
" <td>Risky Business feature: Adam Boileau recaps Black Hat and DEF CON</td>\n",
" <td>00:24:54.614000</td>\n",
" <td>00:24:54.614000</td>\n",
" <td>2018-08-20 22:55:39.014</td>\n",
" <td>2018-08-20</td>\n",
" </tr>\n",
" <tr>\n",
" <td>32</td>\n",
" <td>Risky Business #510 -- Hacky hack hack</td>\n",
" <td>00:43:23.417000</td>\n",
" <td>00:43:23.417000</td>\n",
" <td>2018-08-22 20:45:23.707</td>\n",
" <td>2018-08-22</td>\n",
" </tr>\n",
" <tr>\n",
" <td>33</td>\n",
" <td>Risky Business feature interview: Bob Lord, CSO, Democratic National Committee</td>\n",
" <td>00:36:17.582000</td>\n",
" <td>00:36:17.582000</td>\n",
" <td>2018-08-24 17:34:56.876</td>\n",
" <td>2018-08-24</td>\n",
" </tr>\n",
" <tr>\n",
" <td>34</td>\n",
" <td>Snake Oilers 7 part 1: Rapid7 on changes to InsightVM, ITProTV on online training</td>\n",
" <td>00:17:40.978000</td>\n",
" <td>00:25:56.487000</td>\n",
" <td>2018-08-29 17:58:04.109</td>\n",
" <td>2018-08-27</td>\n",
" </tr>\n",
" <tr>\n",
" <td>35</td>\n",
" <td>Risky Business #511 -- Australia, Japan to ban Huawei, Struts drama, DNC lols and more</td>\n",
" <td>00:51:32.949000</td>\n",
" <td>00:51:32.949000</td>\n",
" <td>2018-08-30 13:05:56.893</td>\n",
" <td>2018-08-29</td>\n",
" </tr>\n",
" <tr>\n",
" <td>36</td>\n",
" <td>Risky Business feature interview: Linux malware is booming, thanks to IoT</td>\n",
" <td>00:18:32.382000</td>\n",
" <td>00:18:32.382000</td>\n",
" <td>2018-09-04 16:41:21.087</td>\n",
" <td>2018-08-31</td>\n",
" </tr>\n",
" <tr>\n",
" <td>37</td>\n",
" <td>Risky Business #512 -- Five Eyes nations send clear message on encryption</td>\n",
" <td>00:39:52.102000</td>\n",
" <td>00:39:52.102000</td>\n",
" <td>2018-09-06 22:28:19.039</td>\n",
" <td>2018-09-05</td>\n",
" </tr>\n",
" <tr>\n",
" <td>38</td>\n",
" <td>Snake Oilers 7 part 2: Assetnote.io launch, InQuest and Aiculus</td>\n",
" <td>00:35:21.618000</td>\n",
" <td>00:43:47.056000</td>\n",
" <td>2018-09-10 22:22:45.520</td>\n",
" <td>2018-09-06</td>\n",
" </tr>\n",
" <tr>\n",
" <td>39</td>\n",
" <td>Risky Business #513 -- The DPRK indictment, BA gets owned, Webauthn issues and more</td>\n",
" <td>00:55:54.408000</td>\n",
" <td>00:55:54.408000</td>\n",
" <td>2018-09-14 16:52:27.298</td>\n",
" <td>2018-09-12</td>\n",
" </tr>\n",
" <tr>\n",
" <td>40</td>\n",
" <td>Risky Business #514 -- New NSO Group report released and another State Department email breach. Drink!</td>\n",
" <td>00:55:09.033000</td>\n",
" <td>00:55:09.033000</td>\n",
" <td>2018-09-20 17:06:15.165</td>\n",
" <td>2018-09-19</td>\n",
" </tr>\n",
" <tr>\n",
" <td>41</td>\n",
" <td>Risky Business feature: iOS exploits just got a lot more expensive</td>\n",
" <td>00:27:23.744000</td>\n",
" <td>00:27:23.744000</td>\n",
" <td>2018-09-22 21:48:19.367</td>\n",
" <td>2018-09-21</td>\n",
" </tr>\n",
" <tr>\n",
" <td>42</td>\n",
" <td>Risky Biz Soap Box: Yubico launches Yubikey 5, ushers in passwordless Windows logins</td>\n",
" <td>00:31:45.203000</td>\n",
" <td>00:31:45.203000</td>\n",
" <td>2018-09-28 22:10:43.568</td>\n",
" <td>2018-09-24</td>\n",
" </tr>\n",
" <tr>\n",
" <td>43</td>\n",
" <td>Risky Business #515 -- NSA staffer at centre of Kaspersky scandal jailed</td>\n",
" <td>00:43:19.804000</td>\n",
" <td>00:56:33.580000</td>\n",
" <td>2018-09-27 22:52:04.319</td>\n",
" <td>2018-09-26</td>\n",
" </tr>\n",
" <tr>\n",
" <td>44</td>\n",
" <td>Risky Business #516 -- The Facebook breach, e2e VOIP court verdict, Uber's record fine and more</td>\n",
" <td>00:49:12.316000</td>\n",
" <td>00:55:15.992000</td>\n",
" <td>2018-10-09 02:11:06.229</td>\n",
" <td>2018-10-03</td>\n",
" </tr>\n",
" <tr>\n",
" <td>45</td>\n",
" <td>Risky Business feature: A podcast on Bloomberg's absolutely wild Supermicro story</td>\n",
" <td>00:23:11.876000</td>\n",
" <td>00:23:11.876000</td>\n",
" <td>2018-10-05 16:49:08.887</td>\n",
" <td>2018-10-05</td>\n",
" </tr>\n",
" <tr>\n",
" <td>46</td>\n",
" <td>Risky Business Feature: Named source in \"The Big Hack\" has doubts about the story</td>\n",
" <td>00:18:30.922000</td>\n",
" <td>00:18:30.922000</td>\n",
" <td>2018-10-11 22:42:51.476</td>\n",
" <td>2018-10-09</td>\n",
" </tr>\n",
" <tr>\n",
" <td>47</td>\n",
" <td>Risky Business #517 -- Bloomberg's dumpster fire lights up infosec</td>\n",
" <td>00:46:08.966000</td>\n",
" <td>00:46:08.966000</td>\n",
" <td>2018-10-11 23:30:06.531</td>\n",
" <td>2018-10-10</td>\n",
" </tr>\n",
" <tr>\n",
" <td>48</td>\n",
" <td>Risky Business #518 -- \"Russian Cambridge Analytica\" booted off Facebook after token hack</td>\n",
" <td>00:32:45.462000</td>\n",
" <td>00:48:17.663000</td>\n",
" <td>2018-10-17 11:54:44.425</td>\n",
" <td>2018-10-17</td>\n",
" </tr>\n",
" <tr>\n",
" <td>49</td>\n",
" <td>Risky Business #519 -- '90s IRC war between US and Russia intensifies</td>\n",
" <td>00:39:22.702000</td>\n",
" <td>00:47:22.541000</td>\n",
" <td>2018-10-24 22:40:35.254</td>\n",
" <td>2018-10-24</td>\n",
" </tr>\n",
" <tr>\n",
" <td>50</td>\n",
" <td>Risky Business #520 -- Tanya Janca talks security in the curriculum</td>\n",
" <td>00:45:01.950000</td>\n",
" <td>00:56:15.362000</td>\n",
" <td>2018-11-01 17:57:37.076</td>\n",
" <td>2018-10-31</td>\n",
" </tr>\n",
" <tr>\n",
" <td>51</td>\n",
" <td>Risky Business #521 -- Bears everywhere</td>\n",
" <td>01:01:22.874000</td>\n",
" <td>01:01:22.874000</td>\n",
" <td>2018-11-21 21:52:48.217</td>\n",
" <td>2018-11-21</td>\n",
" </tr>\n",
" <tr>\n",
" <td>52</td>\n",
" <td>Risky Business #522 -- Alex Stamos co-hosts the show, reflects on Snowden disclosures</td>\n",
" <td>01:08:33.895000</td>\n",
" <td>01:08:33.895000</td>\n",
" <td>2018-11-29 23:29:02.836</td>\n",
" <td>2018-11-28</td>\n",
" </tr>\n",
" <tr>\n",
" <td>53</td>\n",
" <td>Risky Business #523 -- So many breaches</td>\n",
" <td>00:59:54.574000</td>\n",
" <td>00:59:54.574000</td>\n",
" <td>2018-12-07 23:27:18.937</td>\n",
" <td>2018-12-05</td>\n",
" </tr>\n",
" <tr>\n",
" <td>54</td>\n",
" <td>Snake Oilers 8 part 2: Forticode's Cipherise, device features from Exabeam and SentinelOne on \"active EDR\"</td>\n",
" <td>00:00:05.929000</td>\n",
" <td>00:38:03.709000</td>\n",
" <td>2018-12-17 23:15:23.987</td>\n",
" <td>2018-12-10</td>\n",
" </tr>\n",
" <tr>\n",
" <td>55</td>\n",
" <td>Risky Business #524 -- Huawei CFO arrested, US Government dumps on Equifax</td>\n",
" <td>00:49:15.079000</td>\n",
" <td>00:49:15.079000</td>\n",
" <td>2018-12-14 18:42:01.933</td>\n",
" <td>2018-12-12</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" name \\\n",
"0 Risky Biz Soap Box: Alphabet Chronicle co-founder Mike Wiacek talks Virus Total Intelligence \n",
"1 Risky Business #489 -- (Deep) Fake News \n",
"2 Risky Business #490 -- North Korea, \"cyber norms\" and diplomacy \n",
"3 Snake Oilers #5 part 1: Rapid7 Insight Phish, VMRay's updated platform and mail filtering with Mimecast \n",
"4 Risky Business #491 -- The biggest infosec news week we've ever seen \n",
"5 Snake Oilers 5 part 2: Penten talks Honey Docs, Trend Micro on its latest \n",
"6 Risky Business #492 -- Thomas Rid on sloppy active measures \n",
"7 Risky Biz Soap Box: Network detection is dead! Long live network detection! \n",
"8 Risky Business #493 -- SWIFT, pipeline attacks, Chrome's AV feature and more \n",
"9 Risky Business #494 -- Cisco customers have a bad week, plus a deep dive on WebAuthn \n",
"10 Risky Business #495 -- Russian Internet users are having a bad time \n",
"11 Risky Business #496 -- The China supply chain problem \n",
"12 Risky Business #497 -- Silvio's greatest hits \n",
"13 Risky Biz Soap Box: Root9b on agentless threat hunting \n",
"14 Risky Business #498 -- There sure is a lot of Microsoft Defender out there these days \n",
"15 Risky Business #499 -- Is PGP actually busted and Signal pwnt? Noooope \n",
"16 Risky Business feature interview: Hacking PUBG \n",
"17 Risky Business #500 -- Web asset discovery is getting useful \n",
"18 Risky Biz Soap Box: Kill your own meat with EclecticIQ \n",
"19 Risky Business #501 -- Trisis: signalling, deterrence or escalation? \n",
"20 Risky Business #502 -- Inside China's hacker scene \n",
"21 Risky Business #503 -- North Korean tech in the global supply chain \n",
"22 Risky Business #504 -- Latest email frauds and changes to money muling \n",
"23 Snake Oilers 6 part 1: InsightIDR from Rapid7, whitelisting with Airlock Digital and testing your SOC personnel with AttackIQ \n",
"24 Risky Business #505 -- Sanger vs FireEye, Reality Winner cops a plea \n",
"25 Risky Business #506 -- How security teams can work with PR \n",
"26 Snake Oilers 6 part 2: Proofpoint on cred phishing, Exabeam defines next-gen SIEM \n",
"27 Risky Biz Soap Box: Cylance: Driving machine learning model development with threat research \n",
"28 Risky Business #507 -- For Vlad \n",
"29 Risky Business #508 -- Special guest Greg Shipley of In-Q-Tel's Cyber Reboot \n",
"30 Risky Business #509 -- Just the usual mayhem and ownage \n",
"31 Risky Business feature: Adam Boileau recaps Black Hat and DEF CON \n",
"32 Risky Business #510 -- Hacky hack hack \n",
"33 Risky Business feature interview: Bob Lord, CSO, Democratic National Committee \n",
"34 Snake Oilers 7 part 1: Rapid7 on changes to InsightVM, ITProTV on online training \n",
"35 Risky Business #511 -- Australia, Japan to ban Huawei, Struts drama, DNC lols and more \n",
"36 Risky Business feature interview: Linux malware is booming, thanks to IoT \n",
"37 Risky Business #512 -- Five Eyes nations send clear message on encryption \n",
"38 Snake Oilers 7 part 2: Assetnote.io launch, InQuest and Aiculus \n",
"39 Risky Business #513 -- The DPRK indictment, BA gets owned, Webauthn issues and more \n",
"40 Risky Business #514 -- New NSO Group report released and another State Department email breach. Drink! \n",
"41 Risky Business feature: iOS exploits just got a lot more expensive \n",
"42 Risky Biz Soap Box: Yubico launches Yubikey 5, ushers in passwordless Windows logins \n",
"43 Risky Business #515 -- NSA staffer at centre of Kaspersky scandal jailed \n",
"44 Risky Business #516 -- The Facebook breach, e2e VOIP court verdict, Uber's record fine and more \n",
"45 Risky Business feature: A podcast on Bloomberg's absolutely wild Supermicro story \n",
"46 Risky Business Feature: Named source in \"The Big Hack\" has doubts about the story \n",
"47 Risky Business #517 -- Bloomberg's dumpster fire lights up infosec \n",
"48 Risky Business #518 -- \"Russian Cambridge Analytica\" booted off Facebook after token hack \n",
"49 Risky Business #519 -- '90s IRC war between US and Russia intensifies \n",
"50 Risky Business #520 -- Tanya Janca talks security in the curriculum \n",
"51 Risky Business #521 -- Bears everywhere \n",
"52 Risky Business #522 -- Alex Stamos co-hosts the show, reflects on Snowden disclosures \n",
"53 Risky Business #523 -- So many breaches \n",
"54 Snake Oilers 8 part 2: Forticode's Cipherise, device features from Exabeam and SentinelOne on \"active EDR\" \n",
"55 Risky Business #524 -- Huawei CFO arrested, US Government dumps on Equifax \n",
"\n",
" position_ms duration_ms playbackDate publication_date \n",
"0 00:26:49.628000 00:26:49.628000 2018-03-05 14:14:12.702 2018-03-02 \n",
"1 00:53:47.171000 00:53:47.171000 2018-03-07 23:46:37.281 2018-03-07 \n",
"2 00:50:51.849000 00:50:51.849000 2018-03-15 02:01:40.369 2018-03-14 \n",
"3 00:34:57.857000 00:34:57.857000 2018-03-21 18:45:53.835 2018-03-19 \n",
"4 00:48:53.316000 00:53:41.802000 2018-03-26 13:14:05.228 2018-03-21 \n",
"5 00:27:01.904000 00:27:01.904000 2018-04-05 02:21:11.660 2018-03-26 \n",
"6 01:01:38.772000 01:01:38.772000 2018-03-30 13:17:43.629 2018-03-29 \n",
"7 00:37:00.325000 00:37:00.325000 2018-04-05 21:59:50.823 2018-04-02 \n",
"8 00:44:33.369000 00:44:33.369000 2018-04-04 23:01:36.806 2018-04-04 \n",
"9 00:40:54.418000 00:40:54.418000 2018-04-11 22:24:16.198 2018-04-10 \n",
"10 00:46:55.175000 00:46:55.175000 2018-04-19 02:19:01.575 2018-04-18 \n",
"11 01:01:11.240000 01:01:11.240000 2018-04-27 16:33:41.287 2018-04-25 \n",
"12 01:06:21.342000 01:06:21.342000 2018-05-03 01:28:11.242 2018-05-02 \n",
"13 00:31:02.148000 00:31:02.148000 2018-05-07 13:21:41.316 2018-05-04 \n",
"14 00:57:17.104000 00:57:17.104000 2018-05-10 12:59:57.825 2018-05-09 \n",
"15 01:13:13.911000 01:13:13.911000 2018-05-17 03:16:42.273 2018-05-16 \n",
"16 00:27:23.118000 00:27:23.118000 2018-05-18 17:41:59.965 2018-05-18 \n",
"17 00:59:58.822000 00:59:58.822000 2018-05-24 22:08:09.777 2018-05-23 \n",
"18 00:29:04.762000 00:29:04.762000 2018-05-29 22:02:20.800 2018-05-28 \n",
"19 00:48:01.817000 00:48:01.817000 2018-05-31 22:01:04.839 2018-05-30 \n",
"20 01:01:48.650000 01:01:48.650000 2018-06-07 03:15:39.025 2018-06-06 \n",
"21 01:02:15.937000 01:02:15.937000 2018-06-18 21:52:29.160 2018-06-13 \n",
"22 00:57:09.755000 00:57:09.755000 2018-06-21 22:38:07.493 2018-06-20 \n",
"23 00:03:40.346000 00:40:12.379000 2018-06-22 16:35:22.529 2018-06-21 \n",
"24 00:44:47.912000 00:44:47.912000 2018-06-27 23:54:00.955 2018-06-27 \n",
"25 00:59:05.968000 00:59:05.968000 2018-07-06 19:37:44.901 2018-07-04 \n",
"26 00:11:32.666000 00:25:57.659000 2018-07-13 21:20:32.056 2018-07-05 \n",
"27 00:00:06.542000 00:35:45.473000 2018-07-20 14:56:22.178 2018-07-18 \n",
"28 00:55:42.810000 00:55:42.810000 2018-07-27 13:13:13.239 2018-07-25 \n",
"29 01:00:34.740000 01:06:44.563000 2018-08-01 13:21:41.460 2018-07-31 \n",
"30 00:53:17.773000 00:53:17.773000 2018-08-17 22:23:18.192 2018-08-16 \n",
"31 00:24:54.614000 00:24:54.614000 2018-08-20 22:55:39.014 2018-08-20 \n",
"32 00:43:23.417000 00:43:23.417000 2018-08-22 20:45:23.707 2018-08-22 \n",
"33 00:36:17.582000 00:36:17.582000 2018-08-24 17:34:56.876 2018-08-24 \n",
"34 00:17:40.978000 00:25:56.487000 2018-08-29 17:58:04.109 2018-08-27 \n",
"35 00:51:32.949000 00:51:32.949000 2018-08-30 13:05:56.893 2018-08-29 \n",
"36 00:18:32.382000 00:18:32.382000 2018-09-04 16:41:21.087 2018-08-31 \n",
"37 00:39:52.102000 00:39:52.102000 2018-09-06 22:28:19.039 2018-09-05 \n",
"38 00:35:21.618000 00:43:47.056000 2018-09-10 22:22:45.520 2018-09-06 \n",
"39 00:55:54.408000 00:55:54.408000 2018-09-14 16:52:27.298 2018-09-12 \n",
"40 00:55:09.033000 00:55:09.033000 2018-09-20 17:06:15.165 2018-09-19 \n",
"41 00:27:23.744000 00:27:23.744000 2018-09-22 21:48:19.367 2018-09-21 \n",
"42 00:31:45.203000 00:31:45.203000 2018-09-28 22:10:43.568 2018-09-24 \n",
"43 00:43:19.804000 00:56:33.580000 2018-09-27 22:52:04.319 2018-09-26 \n",
"44 00:49:12.316000 00:55:15.992000 2018-10-09 02:11:06.229 2018-10-03 \n",
"45 00:23:11.876000 00:23:11.876000 2018-10-05 16:49:08.887 2018-10-05 \n",
"46 00:18:30.922000 00:18:30.922000 2018-10-11 22:42:51.476 2018-10-09 \n",
"47 00:46:08.966000 00:46:08.966000 2018-10-11 23:30:06.531 2018-10-10 \n",
"48 00:32:45.462000 00:48:17.663000 2018-10-17 11:54:44.425 2018-10-17 \n",
"49 00:39:22.702000 00:47:22.541000 2018-10-24 22:40:35.254 2018-10-24 \n",
"50 00:45:01.950000 00:56:15.362000 2018-11-01 17:57:37.076 2018-10-31 \n",
"51 01:01:22.874000 01:01:22.874000 2018-11-21 21:52:48.217 2018-11-21 \n",
"52 01:08:33.895000 01:08:33.895000 2018-11-29 23:29:02.836 2018-11-28 \n",
"53 00:59:54.574000 00:59:54.574000 2018-12-07 23:27:18.937 2018-12-05 \n",
"54 00:00:05.929000 00:38:03.709000 2018-12-17 23:15:23.987 2018-12-10 \n",
"55 00:49:15.079000 00:49:15.079000 2018-12-14 18:42:01.933 2018-12-12 "
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"podcasts_2018 = df[df[\"playbackDate\"].dt.year == 2018]\n",
"print(\"Total hours listened to in 2018:\", podcasts_2018[\"position_ms\"].sum().total_seconds()/60/60)\n",
"podcasts_2018"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.4"
}
},
"nbformat": 4,
"nbformat_minor": 4
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment