{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "Let's analyse the CSV file provided by the people who wrote the [33 year summary](https://fahrplan.events.ccc.de/congress/2016/Fahrplan/events/8266.html).\n", "\n", "The raw data is here:\n", "https://gitlab.com/maxigas/cccongresstalks/blob/master/cccongresstalks.csv" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": true }, "outputs": [], "source": [ "url = \"https://gitlab.com/maxigas/cccongresstalks/raw/master/cccongresstalks.csv\"" ] }, { "cell_type": "code", "execution_count": 16, "metadata": { "collapsed": false }, "outputs": [], "source": [ "df = pd.read_csv(url, sep='|', engine='c', error_bad_lines=False)" ] }, { "cell_type": "code", "execution_count": 35, "metadata": { "collapsed": false }, "outputs": [], "source": [ "df = df.replace(to_replace=pd.np.nan, value=\"\")" ] }, { "cell_type": "code", "execution_count": 36, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | year | \n", "congress | \n", "title | \n", "abstract | \n", "link | \n", "tags | \n", "
---|---|---|---|---|---|---|
0 | \n", "1984 | \n", "1C3 | \n", "Kommunikation über den Computer. Grundwissen | \n", "Workshop | \n", "\n", " | t | \n", "
1 | \n", "1984 | \n", "1C3 | \n", "Datex und ähnliche Netzwerke | \n", "Workshop | \n", "\n", " | t | \n", "
2 | \n", "1984 | \n", "1C3 | \n", "Professionelle Mailboxen: Konzepte und Beispiele | \n", "Workshop | \n", "\n", " | t | \n", "
3 | \n", "1984 | \n", "1C3 | \n", "Bedienerfreundlichkeit und Datenschutz in Mail... | \n", "Diskussion | \n", "\n", " | t | \n", "
4 | \n", "1984 | \n", "1C3 | \n", "Psychische Störungen durch Computermißbrauch | \n", "Workshop | \n", "\n", " | s | \n", "
5 | \n", "1984 | \n", "1C3 | \n", "Offene Netze. 15 Jahre Erfahrung aus den USA | \n", "Workshop | \n", "\n", " | s/t | \n", "
6 | \n", "1984 | \n", "1C3 | \n", "Rund um Bildschrimtext | \n", "Workshop | \n", "\n", " | t | \n", "
7 | \n", "1984 | \n", "1C3 | \n", "Einführung ins Telefonsystem | \n", "Workshop | \n", "\n", " | t | \n", "
8 | \n", "1984 | \n", "1C3 | \n", "Datenfunk | \n", "Workshop | \n", "\n", " | t | \n", "
9 | \n", "1984 | \n", "1C3 | \n", "Jura für Hacker | \n", "Workshop | \n", "\n", " | s | \n", "
10 | \n", "1984 | \n", "1C3 | \n", "Modems. Von Datenklo bis Autodial und -answer | \n", "Workshop | \n", "\n", " | t | \n", "
11 | \n", "1985 | \n", "2C3 | \n", "[Die Entwicklung von Mailbox als Medium und di... | \n", "\n", " | https://web.archive.org/web/20061208062857/htt... | \n", "\n", " |
12 | \n", "1985 | \n", "2C3 | \n", "[Freunde aus anderen Ländern (bisher: AU, CH, ... | \n", "\n", " | https://web.archive.org/web/20061208062857/htt... | \n", "\n", " |
13 | \n", "1985 | \n", "2C3 | \n", "[Der CCC erörtert die preisgünstigste Datenver... | \n", "\n", " | https://web.archive.org/web/20061208062857/htt... | \n", "\n", " |
14 | \n", "1986 | \n", "3C3 | \n", "Sichere Kopplung an das Postnetz. Was läuft be... | \n", "\n", " | http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
15 | \n", "1986 | \n", "3C3 | \n", "Parlakom – das Parlament am Netz. Computer im ... | \n", "\n", " | http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
16 | \n", "1986 | \n", "3C3 | \n", "Computer Artists Cologne stellen sich vor | \n", "\n", " | http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
17 | \n", "1986 | \n", "3C3 | \n", "Datenfernübertragung für Anfänger | \n", "\n", " | http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
18 | \n", "1986 | \n", "3C3 | \n", "PC-Virenforum | \n", "- Was sind Computerviren; - Wie arebietne Vire... | \n", "http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
19 | \n", "1986 | \n", "3C3 | \n", "Video über den letzten Kongress | \n", "\n", " | http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
20 | \n", "1986 | \n", "3C3 | \n", "Kompromittierende Abstrahlung: Abhören von Mon... | \n", "\n", " | http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
21 | \n", "1986 | \n", "3C3 | \n", "Frühschoppen | \n", "Fünf Hacker aus sechs Ländern | \n", "http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
22 | \n", "1986 | \n", "3C3 | \n", "Renümee des Sysoptages vom letzten Congress. K... | \n", "\n", " | http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
23 | \n", "1986 | \n", "3C3 | \n", "Informationen zum Netzverbund FIDO-NET | \n", "\n", " | http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
24 | \n", "1986 | \n", "3C3 | \n", "Auswirkungen des 2. WiKg. | \n", "Workshop auch über “Hacker-Jäger” | \n", "http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
25 | \n", "1986 | \n", "3C3 | \n", "Desktop Publishing – die Zeitschrift vom Schre... | \n", "\n", " | http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
26 | \n", "1986 | \n", "3C3 | \n", "Regionale Vernetzung von Mailboxen, Serversystem | \n", "\n", " | http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
27 | \n", "1986 | \n", "3C3 | \n", "Btx als preiswerter Datenserver. Vorschlag zum... | \n", "\n", " | http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
28 | \n", "1986 | \n", "3C3 | \n", "Mailboxen – neue Konzepte | \n", "\n", " | http://www.offiziere.ch/trust-us/ds/17/001.htm | \n", "\n", " |
29 | \n", "1989 | \n", "6C3 | \n", "[Wie koennen Heimcomputer und Datenfernuebertr... | \n", "\n", " | http://www.offiziere.ch/trust-us/ds/32/012_fem... | \n", "\n", " |
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2420 | \n", "2016 | \n", "33C3 | \n", "Methodisch inkorrekt!: How thousands of compan... | \n", "Wer hat diese Jungs wieder reingelassen?! Nico... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2421 | \n", "2016 | \n", "33C3 | \n", "Corporate surveillance, digital tracking, big ... | \n", "Today virtually everything we do is monitored ... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2422 | \n", "2016 | \n", "33C3 | \n", "Memory Deduplication: The Curse that Keeps on ... | \n", "We are 4 security researchers who have collect... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2423 | \n", "2016 | \n", "33C3 | \n", "Liberté, Égalité, Fraternité... and privacy ?! | \n", "France is under a state of emergency since Nov... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2424 | \n", "2016 | \n", "33C3 | \n", "Do as I Say not as I Do: Stealth Modification ... | \n", "Input/Output is the mechanisms through which e... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2425 | \n", "2016 | \n", "33C3 | \n", "Talking Behind Your Back: Dissecting a Modern ... | \n", "In the last two years, the marketing industry ... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2426 | \n", "2016 | \n", "33C3 | \n", "Decoding the LoRa PHY: Wie Wertschätzung in (T... | \n", "LoRa is an emerging Low Power Wide Area Networ... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2427 | \n", "2016 | \n", "33C3 | \n", "Von Alpakas, Hasenbären und Einhörnern – Über ... | \n", "Wie würdigen verschiedene Tech-Communities das... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2428 | \n", "2016 | \n", "33C3 | \n", "From Server Farm to Data Table: Hackers' know... | \n", "Early digital computers were the size of room... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2429 | \n", "2016 | \n", "33C3 | \n", "Hacking collective as a laboratory | \n", "Talk presents findings from sociological inves... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2430 | \n", "2016 | \n", "33C3 | \n", "The 12 Networking Truths: Power and politics i... | \n", "In *The 12 Networking Truths* Swedish artist J... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2431 | \n", "2016 | \n", "33C3 | \n", "Ethics in the data society: Why Censorship is ... | \n", "This talk presents the idea that ethics as log... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2432 | \n", "2016 | \n", "33C3 | \n", "The Economic Consequences of Internet Censorship | \n", "Internet censorship today is widespread, both ... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2433 | \n", "2016 | \n", "33C3 | \n", "The High Priests of the Digital Age | \n", "The High Priests of the Digital Age Are Workin... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2434 | \n", "2016 | \n", "33C3 | \n", "Genetic Codes and what they tell us – and ever... | \n", "The genome – the final frontier – or just a co... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2435 | \n", "2016 | \n", "33C3 | \n", "Datenschutzgrundverordnung: Rechte für Mensche... | \n", "Ziel des Vortrages ist es, einen Überblick übe... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2436 | \n", "2016 | \n", "33C3 | \n", "The Ultimate Game Boy Talk | \n", "The 8-bit Game Boy was sold between 1989 and 2... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2437 | \n", "2016 | \n", "33C3 | \n", "Security Nightmares 0x11 | \n", "Was hat sich im letzten Jahr im Bereich IT-Sic... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2438 | \n", "2016 | \n", "33C3 | \n", "33C3 Closing Ceremony: Mind-sets, state-of-the... | \n", "\n", " | https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2439 | \n", "2016 | \n", "33C3 | \n", "Mass Surveillance through Computational Lingui... | \n", "Even though the Snowden revelations for the fi... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2440 | \n", "2016 | \n", "33C3 | \n", "Beyond Virtual and Augmented Reality: 50 most ... | \n", "With recent development in capture technology,... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2441 | \n", "2016 | \n", "33C3 | \n", "Retail Surveillance / Retail Countersurveillan... | \n", "From geo-magnetic tracking for smartphones to ... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2442 | \n", "2016 | \n", "33C3 | \n", "Rebel Cities: Was der Anti-Terror-Kampf von de... | \n", "Cities are emerging as a space for local actio... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2443 | \n", "2016 | \n", "33C3 | \n", "Privatisierung der Rechtsdurchsetzung: About m... | \n", "2016 drehte der Anti-Terror-Kampf in der EU au... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2444 | \n", "2016 | \n", "33C3 | \n", "Surveilling the surveillers: Post-trump open b... | \n", "In the last years, technology-savvy artists an... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2445 | \n", "2016 | \n", "33C3 | \n", "Prediction Fail: Lightning Talks | \n", "Live action role play as method of fast social... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2446 | \n", "2016 | \n", "33C3 | \n", "Lightning Talks Day 4: The usual extremely fac... | \n", "Lightning Talks are short lectures (almost) an... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2447 | \n", "2016 | \n", "33C3 | \n", "33C3 Infrastructure Review: Deciding between t... | \n", "NOC, POC, VOC and QOC show interesting facts a... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2448 | \n", "2016 | \n", "33C3 | \n", "The Transhumanist Paradox: Theresa May’s effor... | \n", "How does a pluralist society – a society built... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2449 | \n", "2016 | \n", "33C3 | \n", "Understanding the Snooper’s Charter: Secure Bo... | \n", "The ‚Investigative Powers Bill‘ is about to be... | \n", "https://events.ccc.de/congress/2016/Fahrplan/s... | \n", "\n", " |
2450 rows × 6 columns
\n", "