# !pip install conda
# !conda install numpy pandas matplotlib ipython-notebook
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
%matplotlib inline

#!pip install seaborn
import seaborn as sns
sns.set_palette("deep", desat=.6)
sns.set_context(rc={"figure.figsize": (11, 6)})
#sns.set(font='Liberation Sans')

import matplotlib as mpl
mpl.rcParams['font.sans-serif'].insert(0, 'Arial')
mpl.rcParams['font.sans-serif'].insert(0, 'Liberation Sans')
mpl.rcParams['font.family'] = 'sans-serif'

df = pd.read_csv('./data.csv')
status_labels = {-1: 'No Interest', 0: 'Limited Interest', 1:'Interest' }
df['status_label'] = df['status'].apply(status_labels.get)
df

df.count()

df['status'].describe()

df_crosstab = pd.crosstab(df['headquartered'], df['status_label'], colnames=['Interest in hiring remote developers'])
df_crosstab_margins = pd.crosstab(df['headquartered'], df['status_label'], margins=True, colnames=['Interest in hiring remote developers'])
df_crosstab_margins

crosstab_plot = df_crosstab.plot(kind='bar', stacked=True, title="PyCon 2014 Job Fair Survey")
plt.savefig(r'pycon_2014_job_fair_survey_crosstab_stacked_bar_chart.png', bbox_inches='tight')