{ "metadata": { "name": "", "signature": "sha256:1b2ad8538134c7664c7e0013b81594e0e7a1805585d09e88add1ad162e5e1935" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Pycon 2014 Job Fair Survey Analysis\n", "https://github.com/briandailey/pycon-2014-job-fair" ] }, { "cell_type": "code", "collapsed": false, "input": [ "# !pip install conda\n", "# !conda install numpy pandas matplotlib ipython-notebook\n", "import numpy as np\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "%matplotlib inline\n", "\n", "#!pip install seaborn\n", "import seaborn as sns\n", "sns.set_palette(\"deep\", desat=.6)\n", "sns.set_context(rc={\"figure.figsize\": (11, 6)})\n", "#sns.set(font='Liberation Sans')\n", "\n", "import matplotlib as mpl\n", "mpl.rcParams['font.sans-serif'].insert(0, 'Arial')\n", "mpl.rcParams['font.sans-serif'].insert(0, 'Liberation Sans')\n", "mpl.rcParams['font.family'] = 'sans-serif'" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 1 }, { "cell_type": "code", "collapsed": false, "input": [ "df = pd.read_csv('./data.csv')\n", "status_labels = {-1: 'No Interest', 0: 'Limited Interest', 1:'Interest' }\n", "df['status_label'] = df['status'].apply(status_labels.get)\n", "df" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | company | \n", "headquartered | \n", "status | \n", "status_label | \n", "
---|---|---|---|---|
0 | \n", "Amplify | \n", "Brooklyn, NY | \n", "1 | \n", "Interest | \n", "
1 | \n", "Bank of America | \n", "NYC/Toronto | \n", "0 | \n", "Limited Interest | \n", "
2 | \n", "Cars.com | \n", "San Franciso, CA; Boston, MA | \n", "1 | \n", "Interest | \n", "
3 | \n", "CashStar | \n", "Portland, ME | \n", "0 | \n", "Limited Interest | \n", "
4 | \n", "Continuum Analytics | \n", "Austin, TX | \n", "1 | \n", "Interest | \n", "
5 | \n", "Coursera | \n", "Mountain View, CA | \n", "-1 | \n", "No Interest | \n", "
6 | \n", "Cox Media | \n", "Atlanta, GA | \n", "1 | \n", "Interest | \n", "
7 | \n", "DataPad | \n", "San Francisco, CA | \n", "0 | \n", "Limited Interest | \n", "
8 | \n", "Demonware | \n", "Vancouver, Canada | \n", "0 | \n", "Limited Interest | \n", "
9 | \n", "Disney Animation Studio | \n", "Burbank, CA | \n", "-1 | \n", "No Interest | \n", "
10 | \n", "Divio | \n", "Zurich, Switzerland | \n", "1 | \n", "Interest | \n", "
11 | \n", "Dow Jones | \n", "New York, NY | \n", "1 | \n", "Interest | \n", "
12 | \n", "EMC | \n", "NaN | \n", "1 | \n", "Interest | \n", "
13 | \n", "ESRI | \n", "Redlands, CA | \n", "0 | \n", "Limited Interest | \n", "
14 | \n", "Enovance | \n", "Montreal, QC, CA; Paris, France | \n", "1 | \n", "Interest | \n", "
15 | \n", "Enthought | \n", "Austin, TX | \n", "0 | \n", "Limited Interest | \n", "
16 | \n", "EventBrite | \n", "San Francisco, CA | \n", "-1 | \n", "No Interest | \n", "
17 | \n", "Excella | \n", "Washington, DC | \n", "-1 | \n", "No Interest | \n", "
18 | \n", "Menlo Park, CA | \n", "1 | \n", "Interest | \n", "|
19 | \n", "FusionBox | \n", "Denver, CO | \n", "-1 | \n", "No Interest | \n", "
20 | \n", "Google (Nest) | \n", "Palo Alto, CA | \n", "-1 | \n", "No Interest | \n", "
21 | \n", "Guidebook | \n", "San Francisco, CA | \n", "0 | \n", "Limited Interest | \n", "
22 | \n", "HP | \n", "NaN | \n", "0 | \n", "Limited Interest | \n", "
23 | \n", "HearSaySocial | \n", "San Francisco, CA | \n", "-1 | \n", "No Interest | \n", "
24 | \n", "LaunchKey | \n", "NaN | \n", "NaN | \n", "None | \n", "
25 | \n", "LexMachina | \n", "Menlo Park, CA | \n", "1 | \n", "Interest | \n", "
26 | \n", "Lightspeed | \n", "Montreal, QC, Canada | \n", "-1 | \n", "No Interest | \n", "
27 | \n", "Mountain View, CA | \n", "0 | \n", "Limited Interest | \n", "|
28 | \n", "Mozilla | \n", "Mountain View, CA | \n", "1 | \n", "Interest | \n", "
29 | \n", "New Relic | \n", "Portland, OR | \n", "-1 | \n", "No Interest | \n", "
30 | \n", "PDTPartners | \n", "New York, NY | \n", "-1 | \n", "No Interest | \n", "
31 | \n", "Prism Skylabs | \n", "San Francisco, CA | \n", "-1 | \n", "No Interest | \n", "
32 | \n", "Rackspace | \n", "San Antonio, TX | \n", "1 | \n", "Interest | \n", "
33 | \n", "Red Hat | \n", "Raleigh, NC | \n", "1 | \n", "Interest | \n", "
34 | \n", "SauceLabs | \n", "San Francisco, CA | \n", "1 | \n", "Interest | \n", "
35 | \n", "Savoir-Faire Linux | \n", "Montreal, QC, CA | \n", "-1 | \n", "No Interest | \n", "
36 | \n", "Scraping Hub | \n", "NaN | \n", "1 | \n", "Interest | \n", "
37 | \n", "Simple Energy | \n", "Boulder, CO | \n", "-1 | \n", "No Interest | \n", "
38 | \n", "Sourceforge | \n", "San Francisco, CA | \n", "0 | \n", "Limited Interest | \n", "
39 | \n", "Stripe | \n", "San Francisco, CA | \n", "1 | \n", "Interest | \n", "
40 | \n", "TNDTechnologies | \n", "NaN | \n", "NaN | \n", "None | \n", "
41 | \n", "Thumbtack | \n", "San Francisco, CA | \n", "-1 | \n", "No Interest | \n", "
42 | \n", "Twilio | \n", "San Francisco, CA | \n", "-1 | \n", "No Interest | \n", "
43 | \n", "San Francisco, CA | \n", "0 | \n", "Limited Interest | \n", "|
44 | \n", "Vigilant Global | \n", "Montreal, QC, Canada | \n", "-1 | \n", "No Interest | \n", "
45 | \n", "Wargaming.net | \n", "Austin, TX | \n", "0 | \n", "Limited Interest | \n", "
46 | \n", "iWeb | \n", "Montreal, QC, Canada | \n", "-1 | \n", "No Interest | \n", "
47 rows \u00d7 4 columns
\n", "Interest in hiring remote developers | \n", "Interest | \n", "Limited Interest | \n", "No Interest | \n", "All | \n", "
---|---|---|---|---|
headquartered | \n", "\n", " | \n", " | \n", " | \n", " |
Atlanta, GA | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "
Austin, TX | \n", "1 | \n", "2 | \n", "0 | \n", "3 | \n", "
Boulder, CO | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "
Brooklyn, NY | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "
Burbank, CA | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "
Denver, CO | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "
Menlo Park, CA | \n", "2 | \n", "0 | \n", "0 | \n", "2 | \n", "
Montreal, QC, CA | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "
Montreal, QC, CA; Paris, France | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "
Montreal, QC, Canada | \n", "0 | \n", "0 | \n", "3 | \n", "3 | \n", "
Mountain View, CA | \n", "1 | \n", "1 | \n", "1 | \n", "3 | \n", "
NYC/Toronto | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "
New York, NY | \n", "1 | \n", "0 | \n", "1 | \n", "2 | \n", "
Palo Alto, CA | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "
Portland, ME | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "
Portland, OR | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "
Raleigh, NC | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "
Redlands, CA | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "
San Antonio, TX | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "
San Francisco, CA | \n", "2 | \n", "4 | \n", "5 | \n", "11 | \n", "
San Franciso, CA; Boston, MA | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "
Vancouver, Canada | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "
Washington, DC | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "
Zurich, Switzerland | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "
All | \n", "16 | \n", "12 | \n", "17 | \n", "47 | \n", "
25 rows \u00d7 4 columns
\n", "