Last active
March 21, 2020 15:41
-
-
Save bburky/21baeec15f063027714f9089c9bb1d27 to your computer and use it in GitHub Desktop.
Podcast CPEs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"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