{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Addendum: how many views for how many videos? " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "While writing the above article, I was wondering what the most watched videos of 33C3 were. This information is not easily accessible, so let's extract it from the individual video pages." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "First, let's find all the links to the single episodes." ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import requests" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": true }, "outputs": [], "source": [ "r = requests.get('https://media.ccc.de/c/33c3')" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "r" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Let's parse the result:" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": true }, "outputs": [], "source": [ "from bs4 import BeautifulSoup" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": false }, "outputs": [], "source": [ "soup = BeautifulSoup(r.text, 'html.parser')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Now, let's build the link list:" ] }, { "cell_type": "code", "execution_count": 24, "metadata": { "collapsed": false }, "outputs": [], "source": [ "links = []\n", "for item in soup.select(\"h3 > a\"):\n", " links.append(\"https://media.ccc.de\" + item.attrs['href'])" ] }, { "cell_type": "code", "execution_count": 25, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "144" ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(links)" ] }, { "cell_type": "code", "execution_count": 26, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "'https://media.ccc.de/v/33c3-8428-33c3_closing_ceremony'" ] }, "execution_count": 26, "metadata": {}, "output_type": "execute_result" } ], "source": [ "links[0]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Let's download each link content:" ] }, { "cell_type": "code", "execution_count": 27, "metadata": { "collapsed": true }, "outputs": [], "source": [ "contents = {}\n", "for link in links:\n", " r = requests.get(link)\n", " contents[link] = r" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Let's check that each request went fine:" ] }, { "cell_type": "code", "execution_count": 42, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "True" ] }, "execution_count": 42, "metadata": {}, "output_type": "execute_result" } ], "source": [ "all([item.status_code == 200 for item in contents.values()])" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Now, let's extract the number of views from each webpage." ] }, { "cell_type": "code", "execution_count": 308, "metadata": { "collapsed": true }, "outputs": [], "source": [ "def metadata(content):\n", " \"Returns metadata from url content.\"\n", " soup = BeautifulSoup(content, 'html.parser')\n", " tag = soup.find('ul', class_='metadata')\n", " meta = dict(zip([\"duration\", \"date\", \"views\", \"description\"],\n", " [item.text.strip() for item in tag.find_all('li')]))\n", " meta['description'] = str(tag.find('a'))\n", " meta['views'] = int(meta['views'])\n", " meta['title'] = soup.title.text.replace('\\n', '')\n", " return meta" ] }, { "cell_type": "code", "execution_count": 309, "metadata": { "collapsed": true }, "outputs": [], "source": [ "first = list(contents.values())[0].text" ] }, { "cell_type": "code", "execution_count": 310, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "{'date': '2016-12-28',\n", " 'description': '\\nfahrplan.events.ccc.de\\n',\n", " 'duration': '61 min',\n", " 'title': 'C3TV -Netzpolitik in Österreich',\n", " 'views': 813}" ] }, "execution_count": 310, "metadata": {}, "output_type": "execute_result" } ], "source": [ "metadata(first)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Let's build a dataframe with this data:" ] }, { "cell_type": "code", "execution_count": 311, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 312, "metadata": { "collapsed": false }, "outputs": [], "source": [ "all_metadata = []\n", "for item in contents:\n", " meta = metadata(contents[item].text)\n", " meta['video_link'] = 'video link'.format(item)\n", " all_metadata.append(meta)" ] }, { "cell_type": "code", "execution_count": 313, "metadata": { "collapsed": false }, "outputs": [], "source": [ "df = pd.DataFrame(all_metadata)\n", "df = df.set_index(df.pop('title'))" ] }, { "cell_type": "code", "execution_count": 314, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Index(['date', 'description', 'duration', 'video_link', 'views'], dtype='object')" ] }, "execution_count": 314, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.columns" ] }, { "cell_type": "code", "execution_count": 315, "metadata": { "collapsed": true }, "outputs": [], "source": [ "df['description'] = df.description.apply(lambda s: s.replace('\\n', ''))" ] }, { "cell_type": "code", "execution_count": 316, "metadata": { "collapsed": false, "scrolled": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
datedescriptiondurationvideo_linkviews
title
C3TV -Netzpolitik in Österreich2016-12-28<a href=\"https://fahrplan.events.ccc.de/congress/2016/Fahrplan/events/8293.html\">fahrplan.events.ccc.de</a>61 min<a href=\"https://media.ccc.de/v/33c3-8293-netzpolitik_in_osterreich\">video link</a>813
C3TV -Predicting and Abusing WPA2/802.11 Group Keys2016-12-27<a href=\"https://fahrplan.events.ccc.de/congress/2016/Fahrplan/events/8195.html\">fahrplan.events.ccc.de</a>60 min<a href=\"https://media.ccc.de/v/33c3-8195-predicting_and_abusing_wpa2_802_11_group_keys\">video link</a>708
C3TV -Formal Verification of Verilog HDL with Yosys-SMTBMC2016-12-28<a href=\"https://fahrplan.events.ccc.de/congress/2016/Fahrplan/events/7922.html\">fahrplan.events.ccc.de</a>52 min<a href=\"https://media.ccc.de/v/33c3-7922-formal_verification_of_verilog_hdl_with_yosys-smtbmc\">video link</a>235
C3TV -The Zcash anonymous cryptocurrency2016-12-30<a href=\"https://fahrplan.events.ccc.de/congress/2016/Fahrplan/events/8330.html\">fahrplan.events.ccc.de</a>31 min<a href=\"https://media.ccc.de/v/33c3-8330-the_zcash_anonymous_cryptocurrency\">video link</a>611
C3TV -The Global Assassination Grid2016-12-27<a href=\"https://fahrplan.events.ccc.de/congress/2016/Fahrplan/events/8425.html\">fahrplan.events.ccc.de</a>63 min<a href=\"https://media.ccc.de/v/33c3-8425-the_global_assassination_grid\">video link</a>4498
\n", "
" ], "text/plain": [ " date \\\n", "title \n", "C3TV -Netzpolitik in Österreich 2016-12-28 \n", "C3TV -Predicting and Abusing WPA2/802.11 Group Keys 2016-12-27 \n", "C3TV -Formal Verification of Verilog HDL with Yosys-SMTBMC 2016-12-28 \n", "C3TV -The Zcash anonymous cryptocurrency 2016-12-30 \n", "C3TV -The Global Assassination Grid 2016-12-27 \n", "\n", " description \\\n", "title \n", "C3TV -Netzpolitik in Österreich fahrplan.events.ccc.de \n", "C3TV -Predicting and Abusing WPA2/802.11 Group Keys fahrplan.events.ccc.de \n", "C3TV -Formal Verification of Verilog HDL with Yosys-SMTBMC fahrplan.events.ccc.de \n", "C3TV -The Zcash anonymous cryptocurrency fahrplan.events.ccc.de \n", "C3TV -The Global Assassination Grid fahrplan.events.ccc.de \n", "\n", " duration \\\n", "title \n", "C3TV -Netzpolitik in Österreich 61 min \n", "C3TV -Predicting and Abusing WPA2/802.11 Group Keys 60 min \n", "C3TV -Formal Verification of Verilog HDL with Yosys-SMTBMC 52 min \n", "C3TV -The Zcash anonymous cryptocurrency 31 min \n", "C3TV -The Global Assassination Grid 63 min \n", "\n", " video_link \\\n", "title \n", "C3TV -Netzpolitik in Österreich video link \n", "C3TV -Predicting and Abusing WPA2/802.11 Group Keys video link \n", "C3TV -Formal Verification of Verilog HDL with Yosys-SMTBMC video link \n", "C3TV -The Zcash anonymous cryptocurrency video link \n", "C3TV -The Global Assassination Grid video link \n", "\n", " views \n", "title \n", "C3TV -Netzpolitik in Österreich 813 \n", "C3TV -Predicting and Abusing WPA2/802.11 Group Keys 708 \n", "C3TV -Formal Verification of Verilog HDL with Yosys-SMTBMC 235 \n", "C3TV -The Zcash anonymous cryptocurrency 611 \n", "C3TV -The Global Assassination Grid 4498 " ] }, "execution_count": 316, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.head()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Let's now export this to HTML:" ] }, { "cell_type": "code", "execution_count": 317, "metadata": { "collapsed": true }, "outputs": [], "source": [ "pd.set_option('display.max_colwidth', -1)" ] }, { "cell_type": "code", "execution_count": 318, "metadata": { "collapsed": true }, "outputs": [], "source": [ "from IPython.display import HTML" ] }, { "cell_type": "code", "execution_count": 319, "metadata": { "collapsed": false, "scrolled": false }, "outputs": [ { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
datedescriptiondurationvideo_linkviews
title
C3TV -Console Hacking 20162016-12-28fahrplan.events.ccc.de53 minvideo link21020
C3TV -Fnord-Jahresrückblick2016-12-29fahrplan.events.ccc.de99 minvideo link14297
C3TV -Shut Up and Take My Money!2016-12-27fahrplan.events.ccc.de30 minvideo link12451
C3TV -SpiegelMining – Reverse Engineering von Spiegel-Online2016-12-29fahrplan.events.ccc.de58 minvideo link12162
C3TV -Where in the World Is Carmen Sandiego?2016-12-28fahrplan.events.ccc.de59 minvideo link8630
C3TV -How Do I Crack Satellite and Cable Pay TV?2016-12-27fahrplan.events.ccc.de62 minvideo link7880
C3TV -Copywrongs 2.02016-12-28fahrplan.events.ccc.de61 minvideo link7042
C3TV -Nintendo Hacking 20162016-12-27fahrplan.events.ccc.de61 minvideo link6073
C3TV -33C3 Opening Ceremony2016-12-27fahrplan.events.ccc.de15 minvideo link6005
C3TV -Die Sprache der Populisten2016-12-28fahrplan.events.ccc.de59 minvideo link5884
C3TV -Security Nightmares 0x112016-12-30fahrplan.events.ccc.de70 minvideo link5877
C3TV -The Untold Story of Edward Snowden’s Escape from Hong Kong2016-12-29fahrplan.events.ccc.de65 minvideo link5602
C3TV -Dieselgate – A year later2016-12-28fahrplan.events.ccc.de40 minvideo link4977
C3TV -Nicht öffentlich.2016-12-28fahrplan.events.ccc.de65 minvideo link4766
C3TV -Check Your Police Record!2016-12-27fahrplan.events.ccc.de31 minvideo link4594
C3TV -The Global Assassination Grid2016-12-27fahrplan.events.ccc.de63 minvideo link4498
C3TV -Machine Dreams2016-12-29fahrplan.events.ccc.de62 minvideo link4201
C3TV -Methodisch inkorrekt!2016-12-30fahrplan.events.ccc.de113 minvideo link4192
C3TV -33C3 Closing Ceremony2016-12-30fahrplan.events.ccc.de46 minvideo link3955
C3TV -A look into the Mobile Messaging Black Box2016-12-28fahrplan.events.ccc.de63 minvideo link3879
C3TV -Bonsai Kitten waren mir lieber - Rechte Falschmeldungen in sozialen Netzwerken2016-12-27fahrplan.events.ccc.de34 minvideo link3649
C3TV -Gone in 60 Milliseconds2016-12-28fahrplan.events.ccc.de33 minvideo link3584
C3TV -33C3 Infrastructure Review2016-12-30fahrplan.events.ccc.de62 minvideo link3099
C3TV -Software Defined Emissions2016-12-27fahrplan.events.ccc.de60 minvideo link3015
C3TV -3 Years After Snowden: Is Germany fighting State Surveillance?2016-12-28fahrplan.events.ccc.de64 minvideo link2868
C3TV -Es sind die kleinen Dinge im Leben2016-12-28fahrplan.events.ccc.de32 minvideo link2859
C3TV -Eine kleine Geschichte der Parlamentsschlägerei2016-12-29fahrplan.events.ccc.de26 minvideo link2853
C3TV -The Ultimate Game Boy Talk2016-12-30fahrplan.events.ccc.de61 minvideo link2826
C3TV -Build your own NSA2016-12-29fahrplan.events.ccc.de60 minvideo link2758
C3TV -Make Wi-Fi fast again2016-12-27fahrplan.events.ccc.de57 minvideo link2707
C3TV -Der 33 Jahrerückblick2016-12-28fahrplan.events.ccc.de26 minvideo link2527
C3TV -Bootstraping a slightly more secure laptop2016-12-27fahrplan.events.ccc.de47 minvideo link2221
C3TV -Einführung zu Blockchains2016-12-28fahrplan.events.ccc.de61 minvideo link2215
C3TV -Exploiting PHP7 unserialize2016-12-27fahrplan.events.ccc.de44 minvideo link2181
C3TV -The 12 Networking Truths2016-12-30fahrplan.events.ccc.de32 minvideo link2172
C3TV -Deploying TLS 1.3: the great, the good and the bad2016-12-28fahrplan.events.ccc.de61 minvideo link2120
C3TV -Kampf dem Abmahnunwesen2016-12-27fahrplan.events.ccc.de33 minvideo link2103
C3TV -The Transhumanist Paradox2016-12-30fahrplan.events.ccc.de33 minvideo link2094
C3TV -A Data Point Walks Into a Bar2016-12-27fahrplan.events.ccc.de32 minvideo link2053
C3TV -Hochsicherheits-Generalschlüssel Marke Eigenbau2016-12-29fahrplan.events.ccc.de64 minvideo link2004
C3TV -Shining some light on the Amazon Dash button2016-12-29fahrplan.events.ccc.de53 minvideo link1930
C3TV -Hacking the World2016-12-28fahrplan.events.ccc.de26 minvideo link1927
C3TV -Lockpicking in the IoT2016-12-28fahrplan.events.ccc.de60 minvideo link1835
C3TV -Surveilling the surveillers2016-12-30fahrplan.events.ccc.de53 minvideo link1775
C3TV -What could possibly go wrong with ?2016-12-27fahrplan.events.ccc.de55 minvideo link1746
C3TV -Dissecting modern (3G/4G) cellular modems2016-12-30fahrplan.events.ccc.de58 minvideo link1686
C3TV -Law Enforcement Are Hacking the Planet2016-12-27fahrplan.events.ccc.de31 minvideo link1654
C3TV -Durchmarsch von Rechts2016-12-29fahrplan.events.ccc.de60 minvideo link1646
C3TV -Woolim – Lifting the Fog on DPRK’s Latest Tablet PC2016-12-28fahrplan.events.ccc.de63 minvideo link1642
C3TV -ATMs how to break them to stop the fraud2016-12-29fahrplan.events.ccc.de54 minvideo link1636
C3TV -Recount 2016: An Uninvited Security Audit of the U.S. Presidential Election2016-12-28fahrplan.events.ccc.de60 minvideo link1567
C3TV -Von Kaffeeriechern, Abtrittanbietern und Fischbeinreißern2016-12-28fahrplan.events.ccc.de27 minvideo link1551
C3TV -Routerzwang und Funkabschottung2016-12-27fahrplan.events.ccc.de33 minvideo link1531
C3TV -International exchange of tax information2016-12-28fahrplan.events.ccc.de28 minvideo link1514
C3TV -Reverse engineering Outernet2016-12-27fahrplan.events.ccc.de52 minvideo link1498
C3TV -How physicists analyze massive data: LHC + brain + ROOT = Higgs2016-12-28fahrplan.events.ccc.de31 minvideo link1490
C3TV -You can -j REJECT but you can not hide: Global scanning of the IPv6 Internet2016-12-28fahrplan.events.ccc.de46 minvideo link1463
C3TV -Everything you always wanted to know about Certificate Transparency2016-12-27fahrplan.events.ccc.de60 minvideo link1427
C3TV -Berechnete Welt2016-12-29fahrplan.events.ccc.de31 minvideo link1418
C3TV -Talking Behind Your Back2016-12-29fahrplan.events.ccc.de59 minvideo link1414
C3TV -radare demystified2016-12-29fahrplan.events.ccc.de62 minvideo link1383
C3TV -Retail Surveillance / Retail Countersurveillance2016-12-30fahrplan.events.ccc.de33 minvideo link1360
C3TV -A world without blockchain2016-12-28fahrplan.events.ccc.de42 minvideo link1347
C3TV -Irren ist staatlich2016-12-30fahrplan.events.ccc.de32 minvideo link1344
C3TV -Geolocation methods in mobile networks2016-12-27fahrplan.events.ccc.de30 minvideo link1334
C3TV -The Fight for Encryption in 20162016-12-27fahrplan.events.ccc.de60 minvideo link1310
C3TV -Zwischen Technikbegeisterung und kritischer Reflexion: Chaos macht Schule2016-12-27fahrplan.events.ccc.de62 minvideo link1303
C3TV -Pegasus internals2016-12-27fahrplan.events.ccc.de29 minvideo link1300
C3TV -The Moon and European Space Exploration2016-12-30fahrplan.events.ccc.de32 minvideo link1284
C3TV -The Universe Is, Like, Seriously Huge2016-12-30fahrplan.events.ccc.de32 minvideo link1234
C3TV -Dissecting HDMI2016-12-29fahrplan.events.ccc.de63 minvideo link1219
C3TV -The Clash of Digitalizations2016-12-28fahrplan.events.ccc.de31 minvideo link1162
C3TV -In Search of Evidence-Based IT-Security2016-12-28fahrplan.events.ccc.de30 minvideo link1136
C3TV -Visiting The Bear Den2016-12-28fahrplan.events.ccc.de59 minvideo link1125
C3TV -Building a high throughput low-latency PCIe based SDR2016-12-27fahrplan.events.ccc.de60 minvideo link1099
C3TV -Downgrading iOS: From past to present2016-12-28fahrplan.events.ccc.de52 minvideo link1081
C3TV -A New Dark Age2016-12-29fahrplan.events.ccc.de57 minvideo link1045
C3TV -An Elevator to the Moon (and back)2016-12-29fahrplan.events.ccc.de61 minvideo link1026
C3TV -Intercoms Hacking2016-12-29fahrplan.events.ccc.de40 minvideo link1019
C3TV -No USB? No problem.2016-12-28fahrplan.events.ccc.de57 minvideo link1005
C3TV -Untrusting the CPU2016-12-27fahrplan.events.ccc.de61 minvideo link998
C3TV -Corporate surveillance, digital tracking, big data & privacy2016-12-30fahrplan.events.ccc.de62 minvideo link996
C3TV -Warum in die Ferne schweifen, wenn das Ausland liegt so nah?2016-12-30fahrplan.events.ccc.de60 minvideo link990
C3TV -What's It Doing Now?2016-12-28fahrplan.events.ccc.de32 minvideo link971
C3TV -Interplanetary Colonization2016-12-30fahrplan.events.ccc.de33 minvideo link966
C3TV -Million Dollar Dissidents and the Rest of Us2016-12-29fahrplan.events.ccc.de53 minvideo link961
C3TV -Anthropology for kids - What is privacy?2016-12-27fahrplan.events.ccc.de25 minvideo link941
C3TV -Privatisierung der Rechtsdurchsetzung2016-12-30fahrplan.events.ccc.de36 minvideo link939
C3TV -A Story of Discrimination and Unfairness2016-12-27fahrplan.events.ccc.de34 minvideo link916
C3TV -Genetic Codes and what they tell us – and everyone else2016-12-30fahrplan.events.ccc.de32 minvideo link864
C3TV -Stopping law enforcement hacking2016-12-28fahrplan.events.ccc.de64 minvideo link856
C3TV -The DROWN Attack2016-12-27fahrplan.events.ccc.de55 minvideo link853
C3TV -On Smart Cities, Smart Energy, And Dumb Security2016-12-30fahrplan.events.ccc.de45 minvideo link834
C3TV -Netzpolitik in Österreich2016-12-28fahrplan.events.ccc.de61 minvideo link813
C3TV -Hacking Reality2016-12-28fahrplan.events.ccc.de60 minvideo link798
C3TV -Eavesdropping on the Dark Cosmos2016-12-30fahrplan.events.ccc.de33 minvideo link789
C3TV -Hebocon2016-12-30fahrplan.events.ccc.de23 minvideo link786
C3TV -Searchwing - Mit Drohnen leben retten2016-12-28fahrplan.events.ccc.de61 minvideo link771
C3TV -Beyond Virtual and Augmented Reality2016-12-30fahrplan.events.ccc.de33 minvideo link770
C3TV -The High Priests of the Digital Age2016-12-30fahrplan.events.ccc.de32 minvideo link768
C3TV -Building Custom Pinball Machines2016-12-29fahrplan.events.ccc.de63 minvideo link768
C3TV -How do we know our PRNGs work properly?2016-12-29fahrplan.events.ccc.de58 minvideo link738
C3TV -Wheel of Fortune2016-12-28fahrplan.events.ccc.de36 minvideo link727
C3TV -Decoding the LoRa PHY2016-12-29fahrplan.events.ccc.de64 minvideo link725
C3TV -Make the Internet Neutral Again2016-12-27fahrplan.events.ccc.de31 minvideo link719
C3TV -On the Security and Privacy of Modern Single Sign-On in the Web2016-12-28fahrplan.events.ccc.de64 minvideo link719
C3TV -The woman behind your WiFi2016-12-29fahrplan.events.ccc.de31 minvideo link716
C3TV -Predicting and Abusing WPA2/802.11 Group Keys2016-12-27fahrplan.events.ccc.de60 minvideo link708
C3TV -Tapping into the core2016-12-28fahrplan.events.ccc.de31 minvideo link691
C3TV -Lightning Talks Day 22016-12-28fahrplan.events.ccc.de120 minvideo link677
C3TV -Keys of Fury2016-12-27fahrplan.events.ccc.de25 minvideo link643
C3TV -Virtual Secure Boot2016-12-30fahrplan.events.ccc.de51 minvideo link636
C3TV -The Zcash anonymous cryptocurrency2016-12-30fahrplan.events.ccc.de31 minvideo link611
C3TV -Von Alpakas, Hasenbären und Einhörnern – Über Anerkennungskultur2016-12-30fahrplan.events.ccc.de32 minvideo link588
C3TV -The Nibbletronic2016-12-27fahrplan.events.ccc.de20 minvideo link563
C3TV -Netzpolitik in der Schweiz 20162016-12-28fahrplan.events.ccc.de62 minvideo link544
C3TV -No Love for the US Gov.2016-12-29fahrplan.events.ccc.de53 minvideo link544
C3TV -Lasers in the sky (with asteroids)2016-12-29fahrplan.events.ccc.de35 minvideo link536
C3TV -Understanding the Snooper’s Charter2016-12-30fahrplan.events.ccc.de36 minvideo link535
C3TV -Datenschutzgrundverordnung: Rechte für Menschen, Pflichten für Firmen & Chancen für uns2016-12-30fahrplan.events.ccc.de31 minvideo link514
C3TV -Space making/space shaping2016-12-28fahrplan.events.ccc.de33 minvideo link509
C3TV -Edible Soft Robotics2016-12-30fahrplan.events.ccc.de29 minvideo link503
C3TV -Lightning Talks Day 42016-12-30fahrplan.events.ccc.de109 minvideo link503
C3TV -Rebel Cities2016-12-30fahrplan.events.ccc.de33 minvideo link502
C3TV -Welcome to the Anthropocene?2016-12-28fahrplan.events.ccc.de28 minvideo link502
C3TV -Technologien für und wider Digitale Souveränität2016-12-29fahrplan.events.ccc.de60 minvideo link501
C3TV -PUFs, protection, privacy, PRNGs2016-12-30fahrplan.events.ccc.de31 minvideo link493
C3TV -Haft für Whistleblower?2016-12-28fahrplan.events.ccc.de34 minvideo link470
C3TV -Code BROWN in the Air2016-12-29fahrplan.events.ccc.de37 minvideo link464
C3TV -Saving the World with (Vegan) Science2016-12-30fahrplan.events.ccc.de31 minvideo link435
C3TV -What We Can Learn about Creativity from 3D Printing2016-12-30fahrplan.events.ccc.de28 minvideo link426
C3TV -From Server Farm to Data Table2016-12-30fahrplan.events.ccc.de32 minvideo link425
C3TV -SpinalHDL : An alternative hardware description language2016-12-29fahrplan.events.ccc.de45 minvideo link422
C3TV -Lightning Talks Day 32016-12-29fahrplan.events.ccc.de122 minvideo link405
C3TV -Syrian Archive2016-12-28fahrplan.events.ccc.de30 minvideo link350
C3TV -Memory Deduplication: The Curse that Keeps on Giving2016-12-29fahrplan.events.ccc.de59 minvideo link322
C3TV -Ethics in the data society2016-12-30fahrplan.events.ccc.de35 minvideo link321
C3TV -Making Technology Inclusive Through Papercraft and Sound2016-12-29fahrplan.events.ccc.de56 minvideo link316
C3TV -Community2016-12-30fahrplan.events.ccc.de62 minvideo link309
C3TV -Liberté, Égalité, Fraternité... and privacy ?!2016-12-29fahrplan.events.ccc.de64 minvideo link254
C3TV -Do as I Say not as I Do: Stealth Modification of Programmable Logic Controllers I/O by Pin Control Attack2016-12-29fahrplan.events.ccc.de60 minvideo link251
C3TV -The Economic Consequences of Internet Censorship2016-12-30fahrplan.events.ccc.de31 minvideo link237
C3TV -Formal Verification of Verilog HDL with Yosys-SMTBMC2016-12-28fahrplan.events.ccc.de52 minvideo link235
C3TV -Hacking collective as a laboratory2016-12-30fahrplan.events.ccc.de29 minvideo link186
" ], "text/plain": [ "" ] }, "execution_count": 319, "metadata": {}, "output_type": "execute_result" } ], "source": [ "HTML(df.sort_values(by='views', ascending=False).to_html(escape=False))" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "So there we have it: all talks sorted by views at the time of writing! Have fun watching!" ] } ], "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.5.2" } }, "nbformat": 4, "nbformat_minor": 0 }