import os
import json
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "zuobiao.settings")
import django
django.setup()

from django.db.models import Avg, Count, Max, Q
from dashboard.models import Question, Anser, User
from dashboard.models import INCOME_CHOICES, EDU_CHOICES, ANSER_CHOICES, SEX_CHOICES

import pandas as pd
import datetime as dt
import plotly.plotly as py
from plotly.graph_objs import Bar, Scatter, Marker, Layout 

def get_display(choice_id, choice_set):
    return [v for k, v in choice_set if choice_id == k][0]

PK = 20
user_count = 170764
question = Question.objects.get(pk=PK)
ansers = question.anser_set
title = 'Question {}: {}'.format(PK, question.name)

data = ansers.values('choice').annotate(count=Count('choice')).order_by('choice')
x = [get_display(item['choice'], ANSER_CHOICES) for item in data]
y = [item['count'] for item in data]
py.iplot({
    'data': [Bar(x=x, y=y)],
    'layout': { 
            'title': title,
        },
    })

def get_user_data(field, choice_set):
    data = []
    for choice_id in [1, 2, 3, 4]:
        fieldname = 'user__{}'.format(field)
        queryset = ansers.filter(choice=choice_id).values(fieldname).annotate(count=Count(fieldname)).order_by('-count')
        x = [get_display(item[fieldname], choice_set) for item in queryset]
        y = [item['count'] / user_count * 100 for item in queryset]
        data.append({'x': x, 'y': y, 'type': 'bar', 'name': get_display(choice_id, ANSER_CHOICES)})   
    return data
data = get_user_data('sex', SEX_CHOICES)
py.iplot({
'data': data,
'layout': {
        'barmode': 'stack',
        'title': title
    }
})

def get_user_data_banlance(field, choice_set):
    data = []
    choices = [k for k, v in choice_set]
    for choice_id in [1, 2, 3, 4]:
        x = [k for k, v in choice_set]
        y = [0] * len(choice_set)
        fieldname = 'user__{}'.format(field)
        queryset = ansers.filter(choice=choice_id).values(fieldname).annotate(count=Count(fieldname)).order_by('-count')
        for item in queryset:
            for i, choice in enumerate(choices):
                if item[fieldname] == choice:
                    x[i] = get_display(item[fieldname], choice_set)
                    y[i] = item['count']
        data.append({'x': x, 'y': y, 'type': 'bar', 'name': get_display(choice_id, ANSER_CHOICES)})   
    sums = [sum(t) for t in zip(*[item['y'] for item in data])]
    for item in data:
        item['y'] = [y / (sums[i] or 1) * 100 for i, y in enumerate(item['y'])]
    return data
data = get_user_data_banlance('sex', SEX_CHOICES)
py.iplot({
'data': data,
'layout': {
        'barmode': 'stack',
        'title': title
    }
})

data = get_user_data('income', INCOME_CHOICES)
py.iplot({
'data': data,
'layout': {
        'barmode': 'stack',
        'title': title
    }
})

data = get_user_data_banlance('income', INCOME_CHOICES)
py.iplot({
'data': data,
'layout': {
        'barmode': 'stack',
        'title': title
    }
})

---------------------------------------------------------------------------
gaierror                                  Traceback (most recent call last)
/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in urlopen(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, **response_kw)
    543                                                   timeout=timeout_obj,
--> 544                                                   body=body, headers=headers)
    545 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in _make_request(self, conn, method, url, timeout, **httplib_request_kw)
    340         try:
--> 341             self._validate_conn(conn)
    342         except (SocketTimeout, BaseSSLError) as e:

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in _validate_conn(self, conn)
    761         if not getattr(conn, 'sock', None):  # AppEngine might not have  `.sock`
--> 762             conn.connect()
    763 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connection.py in connect(self)
    203         # Add certificate verification
--> 204         conn = self._new_conn()
    205 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connection.py in _new_conn(self)
    133             conn = connection.create_connection(
--> 134                 (self.host, self.port), self.timeout, **extra_kw)
    135 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/util/connection.py in create_connection(address, timeout, source_address, socket_options)
     63     err = None
---> 64     for res in socket.getaddrinfo(host, port, 0, socket.SOCK_STREAM):
     65         af, socktype, proto, canonname, sa = res

/usr/lib/python3.4/socket.py in getaddrinfo(host, port, family, type, proto, flags)
    529     addrlist = []
--> 530     for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
    531         af, socktype, proto, canonname, sa = res

gaierror: [Errno -2] Name or service not known

During handling of the above exception, another exception occurred:

ProtocolError                             Traceback (most recent call last)
/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/adapters.py in send(self, request, stream, timeout, verify, cert, proxies)
    369                     retries=self.max_retries,
--> 370                     timeout=timeout
    371                 )

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in urlopen(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, **response_kw)
    596             retries = retries.increment(method, url, error=e, _pool=self,
--> 597                                         _stacktrace=sys.exc_info()[2])
    598             retries.sleep()

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/util/retry.py in increment(self, method, url, response, error, _pool, _stacktrace)
    244             if read is False:
--> 245                 raise six.reraise(type(error), error, _stacktrace)
    246             elif read is not None:

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/packages/six.py in reraise(tp, value, tb)
    308         if value.__traceback__ is not tb:
--> 309             raise value.with_traceback(tb)
    310         raise value

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in urlopen(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, **response_kw)
    543                                                   timeout=timeout_obj,
--> 544                                                   body=body, headers=headers)
    545 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in _make_request(self, conn, method, url, timeout, **httplib_request_kw)
    340         try:
--> 341             self._validate_conn(conn)
    342         except (SocketTimeout, BaseSSLError) as e:

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in _validate_conn(self, conn)
    761         if not getattr(conn, 'sock', None):  # AppEngine might not have  `.sock`
--> 762             conn.connect()
    763 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connection.py in connect(self)
    203         # Add certificate verification
--> 204         conn = self._new_conn()
    205 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connection.py in _new_conn(self)
    133             conn = connection.create_connection(
--> 134                 (self.host, self.port), self.timeout, **extra_kw)
    135 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/util/connection.py in create_connection(address, timeout, source_address, socket_options)
     63     err = None
---> 64     for res in socket.getaddrinfo(host, port, 0, socket.SOCK_STREAM):
     65         af, socktype, proto, canonname, sa = res

/usr/lib/python3.4/socket.py in getaddrinfo(host, port, family, type, proto, flags)
    529     addrlist = []
--> 530     for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
    531         af, socktype, proto, canonname, sa = res

ProtocolError: ('Connection aborted.', gaierror(-2, 'Name or service not known'))

During handling of the above exception, another exception occurred:

ConnectionError                           Traceback (most recent call last)
<ipython-input-8-ee9ef9da0a66> in <module>()
      4 'layout': {
      5         'barmode': 'stack',
----> 6         'title': title
      7     }
      8 })

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/plotly/plotly/plotly.py in iplot(figure_or_data, **plot_options)
    137     if 'auto_open' not in plot_options:
    138         plot_options['auto_open'] = False
--> 139     res = plot(figure_or_data, **plot_options)
    140     urlsplit = res.split('/')
    141     username, plot_id = urlsplit[-2][1:], urlsplit[-1]  # TODO: HACKY!

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/plotly/plotly/plotly.py in plot(figure_or_data, validate, **plot_options)
    189                 pass
    190     plot_options = _plot_option_logic(plot_options)
--> 191     res = _send_to_plotly(figure, **plot_options)
    192     if res['error'] == '':
    193         if plot_options['auto_open']:

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/plotly/plotly/plotly.py in _send_to_plotly(figure, **plot_options)
   1253 
   1254     r = requests.post(url, data=payload,
-> 1255                       verify=get_config()['plotly_ssl_verification'])
   1256     r.raise_for_status()
   1257     r = json.loads(r.text)

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/api.py in post(url, data, json, **kwargs)
    106     """
    107 
--> 108     return request('post', url, data=data, json=json, **kwargs)
    109 
    110 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/api.py in request(method, url, **kwargs)
     48 
     49     session = sessions.Session()
---> 50     response = session.request(method=method, url=url, **kwargs)
     51     # By explicitly closing the session, we avoid leaving sockets open which
     52     # can trigger a ResourceWarning in some cases, and look like a memory leak

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/sessions.py in request(self, method, url, params, data, headers, cookies, files, auth, timeout, allow_redirects, proxies, hooks, stream, verify, cert, json)
    462         }
    463         send_kwargs.update(settings)
--> 464         resp = self.send(prep, **send_kwargs)
    465 
    466         return resp

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/sessions.py in send(self, request, **kwargs)
    574 
    575         # Send the request
--> 576         r = adapter.send(request, **kwargs)
    577 
    578         # Total elapsed time of the request (approximately)

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/adapters.py in send(self, request, stream, timeout, verify, cert, proxies)
    413 
    414         except (ProtocolError, socket.error) as err:
--> 415             raise ConnectionError(err, request=request)
    416 
    417         except MaxRetryError as e:

ConnectionError: ('Connection aborted.', gaierror(-2, 'Name or service not known'))

data = get_user_data('education', EDU_CHOICES)
py.iplot({
'data': data,
'layout': {
        'barmode': 'stack',
        'title': title
    }
})

---------------------------------------------------------------------------
gaierror                                  Traceback (most recent call last)
/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in urlopen(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, **response_kw)
    543                                                   timeout=timeout_obj,
--> 544                                                   body=body, headers=headers)
    545 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in _make_request(self, conn, method, url, timeout, **httplib_request_kw)
    340         try:
--> 341             self._validate_conn(conn)
    342         except (SocketTimeout, BaseSSLError) as e:

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in _validate_conn(self, conn)
    761         if not getattr(conn, 'sock', None):  # AppEngine might not have  `.sock`
--> 762             conn.connect()
    763 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connection.py in connect(self)
    203         # Add certificate verification
--> 204         conn = self._new_conn()
    205 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connection.py in _new_conn(self)
    133             conn = connection.create_connection(
--> 134                 (self.host, self.port), self.timeout, **extra_kw)
    135 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/util/connection.py in create_connection(address, timeout, source_address, socket_options)
     63     err = None
---> 64     for res in socket.getaddrinfo(host, port, 0, socket.SOCK_STREAM):
     65         af, socktype, proto, canonname, sa = res

/usr/lib/python3.4/socket.py in getaddrinfo(host, port, family, type, proto, flags)
    529     addrlist = []
--> 530     for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
    531         af, socktype, proto, canonname, sa = res

gaierror: [Errno -2] Name or service not known

During handling of the above exception, another exception occurred:

ProtocolError                             Traceback (most recent call last)
/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/adapters.py in send(self, request, stream, timeout, verify, cert, proxies)
    369                     retries=self.max_retries,
--> 370                     timeout=timeout
    371                 )

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in urlopen(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, **response_kw)
    596             retries = retries.increment(method, url, error=e, _pool=self,
--> 597                                         _stacktrace=sys.exc_info()[2])
    598             retries.sleep()

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/util/retry.py in increment(self, method, url, response, error, _pool, _stacktrace)
    244             if read is False:
--> 245                 raise six.reraise(type(error), error, _stacktrace)
    246             elif read is not None:

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/packages/six.py in reraise(tp, value, tb)
    308         if value.__traceback__ is not tb:
--> 309             raise value.with_traceback(tb)
    310         raise value

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in urlopen(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, **response_kw)
    543                                                   timeout=timeout_obj,
--> 544                                                   body=body, headers=headers)
    545 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in _make_request(self, conn, method, url, timeout, **httplib_request_kw)
    340         try:
--> 341             self._validate_conn(conn)
    342         except (SocketTimeout, BaseSSLError) as e:

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in _validate_conn(self, conn)
    761         if not getattr(conn, 'sock', None):  # AppEngine might not have  `.sock`
--> 762             conn.connect()
    763 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connection.py in connect(self)
    203         # Add certificate verification
--> 204         conn = self._new_conn()
    205 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connection.py in _new_conn(self)
    133             conn = connection.create_connection(
--> 134                 (self.host, self.port), self.timeout, **extra_kw)
    135 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/util/connection.py in create_connection(address, timeout, source_address, socket_options)
     63     err = None
---> 64     for res in socket.getaddrinfo(host, port, 0, socket.SOCK_STREAM):
     65         af, socktype, proto, canonname, sa = res

/usr/lib/python3.4/socket.py in getaddrinfo(host, port, family, type, proto, flags)
    529     addrlist = []
--> 530     for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
    531         af, socktype, proto, canonname, sa = res

ProtocolError: ('Connection aborted.', gaierror(-2, 'Name or service not known'))

During handling of the above exception, another exception occurred:

ConnectionError                           Traceback (most recent call last)
<ipython-input-9-a69b3f9af9ef> in <module>()
      4 'layout': {
      5         'barmode': 'stack',
----> 6         'title': title
      7     }
      8 })

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/plotly/plotly/plotly.py in iplot(figure_or_data, **plot_options)
    137     if 'auto_open' not in plot_options:
    138         plot_options['auto_open'] = False
--> 139     res = plot(figure_or_data, **plot_options)
    140     urlsplit = res.split('/')
    141     username, plot_id = urlsplit[-2][1:], urlsplit[-1]  # TODO: HACKY!

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/plotly/plotly/plotly.py in plot(figure_or_data, validate, **plot_options)
    189                 pass
    190     plot_options = _plot_option_logic(plot_options)
--> 191     res = _send_to_plotly(figure, **plot_options)
    192     if res['error'] == '':
    193         if plot_options['auto_open']:

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/plotly/plotly/plotly.py in _send_to_plotly(figure, **plot_options)
   1253 
   1254     r = requests.post(url, data=payload,
-> 1255                       verify=get_config()['plotly_ssl_verification'])
   1256     r.raise_for_status()
   1257     r = json.loads(r.text)

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/api.py in post(url, data, json, **kwargs)
    106     """
    107 
--> 108     return request('post', url, data=data, json=json, **kwargs)
    109 
    110 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/api.py in request(method, url, **kwargs)
     48 
     49     session = sessions.Session()
---> 50     response = session.request(method=method, url=url, **kwargs)
     51     # By explicitly closing the session, we avoid leaving sockets open which
     52     # can trigger a ResourceWarning in some cases, and look like a memory leak

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/sessions.py in request(self, method, url, params, data, headers, cookies, files, auth, timeout, allow_redirects, proxies, hooks, stream, verify, cert, json)
    462         }
    463         send_kwargs.update(settings)
--> 464         resp = self.send(prep, **send_kwargs)
    465 
    466         return resp

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/sessions.py in send(self, request, **kwargs)
    574 
    575         # Send the request
--> 576         r = adapter.send(request, **kwargs)
    577 
    578         # Total elapsed time of the request (approximately)

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/adapters.py in send(self, request, stream, timeout, verify, cert, proxies)
    413 
    414         except (ProtocolError, socket.error) as err:
--> 415             raise ConnectionError(err, request=request)
    416 
    417         except MaxRetryError as e:

ConnectionError: ('Connection aborted.', gaierror(-2, 'Name or service not known'))

data = get_user_data_banlance('education', EDU_CHOICES)
py.iplot({
'data': data,
'layout': {
        'barmode': 'stack',
        'title': title
    }
})

---------------------------------------------------------------------------
gaierror                                  Traceback (most recent call last)
/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in urlopen(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, **response_kw)
    543                                                   timeout=timeout_obj,
--> 544                                                   body=body, headers=headers)
    545 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in _make_request(self, conn, method, url, timeout, **httplib_request_kw)
    340         try:
--> 341             self._validate_conn(conn)
    342         except (SocketTimeout, BaseSSLError) as e:

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in _validate_conn(self, conn)
    761         if not getattr(conn, 'sock', None):  # AppEngine might not have  `.sock`
--> 762             conn.connect()
    763 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connection.py in connect(self)
    203         # Add certificate verification
--> 204         conn = self._new_conn()
    205 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connection.py in _new_conn(self)
    133             conn = connection.create_connection(
--> 134                 (self.host, self.port), self.timeout, **extra_kw)
    135 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/util/connection.py in create_connection(address, timeout, source_address, socket_options)
     63     err = None
---> 64     for res in socket.getaddrinfo(host, port, 0, socket.SOCK_STREAM):
     65         af, socktype, proto, canonname, sa = res

/usr/lib/python3.4/socket.py in getaddrinfo(host, port, family, type, proto, flags)
    529     addrlist = []
--> 530     for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
    531         af, socktype, proto, canonname, sa = res

gaierror: [Errno -2] Name or service not known

During handling of the above exception, another exception occurred:

ProtocolError                             Traceback (most recent call last)
/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/adapters.py in send(self, request, stream, timeout, verify, cert, proxies)
    369                     retries=self.max_retries,
--> 370                     timeout=timeout
    371                 )

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in urlopen(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, **response_kw)
    596             retries = retries.increment(method, url, error=e, _pool=self,
--> 597                                         _stacktrace=sys.exc_info()[2])
    598             retries.sleep()

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/util/retry.py in increment(self, method, url, response, error, _pool, _stacktrace)
    244             if read is False:
--> 245                 raise six.reraise(type(error), error, _stacktrace)
    246             elif read is not None:

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/packages/six.py in reraise(tp, value, tb)
    308         if value.__traceback__ is not tb:
--> 309             raise value.with_traceback(tb)
    310         raise value

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in urlopen(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, **response_kw)
    543                                                   timeout=timeout_obj,
--> 544                                                   body=body, headers=headers)
    545 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in _make_request(self, conn, method, url, timeout, **httplib_request_kw)
    340         try:
--> 341             self._validate_conn(conn)
    342         except (SocketTimeout, BaseSSLError) as e:

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connectionpool.py in _validate_conn(self, conn)
    761         if not getattr(conn, 'sock', None):  # AppEngine might not have  `.sock`
--> 762             conn.connect()
    763 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connection.py in connect(self)
    203         # Add certificate verification
--> 204         conn = self._new_conn()
    205 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/connection.py in _new_conn(self)
    133             conn = connection.create_connection(
--> 134                 (self.host, self.port), self.timeout, **extra_kw)
    135 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/packages/urllib3/util/connection.py in create_connection(address, timeout, source_address, socket_options)
     63     err = None
---> 64     for res in socket.getaddrinfo(host, port, 0, socket.SOCK_STREAM):
     65         af, socktype, proto, canonname, sa = res

/usr/lib/python3.4/socket.py in getaddrinfo(host, port, family, type, proto, flags)
    529     addrlist = []
--> 530     for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
    531         af, socktype, proto, canonname, sa = res

ProtocolError: ('Connection aborted.', gaierror(-2, 'Name or service not known'))

During handling of the above exception, another exception occurred:

ConnectionError                           Traceback (most recent call last)
<ipython-input-10-41109a72a7aa> in <module>()
      4 'layout': {
      5         'barmode': 'stack',
----> 6         'title': title
      7     }
      8 })

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/plotly/plotly/plotly.py in iplot(figure_or_data, **plot_options)
    137     if 'auto_open' not in plot_options:
    138         plot_options['auto_open'] = False
--> 139     res = plot(figure_or_data, **plot_options)
    140     urlsplit = res.split('/')
    141     username, plot_id = urlsplit[-2][1:], urlsplit[-1]  # TODO: HACKY!

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/plotly/plotly/plotly.py in plot(figure_or_data, validate, **plot_options)
    189                 pass
    190     plot_options = _plot_option_logic(plot_options)
--> 191     res = _send_to_plotly(figure, **plot_options)
    192     if res['error'] == '':
    193         if plot_options['auto_open']:

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/plotly/plotly/plotly.py in _send_to_plotly(figure, **plot_options)
   1253 
   1254     r = requests.post(url, data=payload,
-> 1255                       verify=get_config()['plotly_ssl_verification'])
   1256     r.raise_for_status()
   1257     r = json.loads(r.text)

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/api.py in post(url, data, json, **kwargs)
    106     """
    107 
--> 108     return request('post', url, data=data, json=json, **kwargs)
    109 
    110 

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/api.py in request(method, url, **kwargs)
     48 
     49     session = sessions.Session()
---> 50     response = session.request(method=method, url=url, **kwargs)
     51     # By explicitly closing the session, we avoid leaving sockets open which
     52     # can trigger a ResourceWarning in some cases, and look like a memory leak

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/sessions.py in request(self, method, url, params, data, headers, cookies, files, auth, timeout, allow_redirects, proxies, hooks, stream, verify, cert, json)
    462         }
    463         send_kwargs.update(settings)
--> 464         resp = self.send(prep, **send_kwargs)
    465 
    466         return resp

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/sessions.py in send(self, request, **kwargs)
    574 
    575         # Send the request
--> 576         r = adapter.send(request, **kwargs)
    577 
    578         # Total elapsed time of the request (approximately)

/home/phyng/dev/zuobiao/zuobiaoenv/lib/python3.4/site-packages/requests/adapters.py in send(self, request, stream, timeout, verify, cert, proxies)
    413 
    414         except (ProtocolError, socket.error) as err:
--> 415             raise ConnectionError(err, request=request)
    416 
    417         except MaxRetryError as e:

ConnectionError: ('Connection aborted.', gaierror(-2, 'Name or service not known'))

data = []
for choice_id in [1, 2, 3, 4]:
    field = 'birthday'
    fieldname = 'user__{}'.format(field)
    queryset = ansers.filter(choice=choice_id).values(fieldname).annotate(count=Count(fieldname)).order_by('-count')[:20]
    x = [item[fieldname] for item in queryset]
    y = [item['count'] for item in queryset]
    data.append({'x': x, 'y': y, 'type': 'bar', 'name': get_display(choice_id, ANSER_CHOICES)})   
    
py.iplot({
'data': data,
'layout': {
        'barmode': 'stack',
        'title': title
    }
})

data = []
years = range(1930, 2000)
for choice_id in [1, 2, 3, 4]:
    field = 'birthday'
    x, y = list(range(1930, 2000)), [0] * 70 
    fieldname = 'user__{}'.format(field)
    queryset = ansers.filter(choice=choice_id).values(fieldname).annotate(count=Count(fieldname)).order_by('-count')
    for item in queryset:
        for i, year in enumerate(years):
            if item[fieldname] == year:
                x[i] = item[fieldname]
                y[i] = item['count']
    data.append({'x': x, 'y': y, 'type': 'bar', 'name': get_display(choice_id, ANSER_CHOICES)})   

sums = [sum(t) for t in zip(*[item['y'] for item in data])]
for item in data:
    item['y'] = [y / (sums[i] or 1) * 100 for i, y in enumerate(item['y'])]

py.iplot({
'data': data,
'layout': {
        'barmode': 'stack',
        'title': title,
    }
})

%%html
<style>a {text-decoration: none!important}</style>

Index

1. 如果人民没有受过民主教育，他们是不应该拥有普选权的。
2. 人权高于主权。
3. 发生重大社会安全事件时，即使认为信息公开会导致骚乱的风险，政府仍应该开放信息传播。
4. 西方的多党制不适合中国国情。
5. 在中国照搬西方式的言论自由会导致社会失序。
6. 由高校自主考试招生比全国统一考试招生更好。
7. 应该容许宗教人士在非宗教场所公开传教。
8. 无论中小学生或大学生，都应参加由国家统一安排的军训。
9. 国家的统一和领土完整是社会的最高利益。
10. 哪怕经历了违反程序规定的审讯和取证过程，确实有罪的罪犯也应被处刑。
11. 国家有义务进行对外援助。
12. 国家领导人及开国领袖的形象可以作为文艺作品的丑化对象。
13. 当法律未能充分制止罪恶行为时，人民群众有权自发对罪恶行为进行制裁。
14. 应当允许媒体代表某一特定阶层或利益集团发言。
15. 如果国家综合实力许可，那么中国有权为了维护自己的利益而采取任何行动。
16. 条件允许的话应该武力统一台湾。
17. 律师即使明知被辩护人的犯罪事实也应当尽力为其进行辩护。
18. 应该允许中国公民同时具有外国国籍。
19. 以美国为首的西方国家不可能真正容许中国崛起成为一流强国。
20. 国家应当采取措施培养和支持体育健儿在各种国际比赛场合为国争光。
21. 最低工资应由国家规定。
22. 中国改革开放以来的经济发展的成果都被一小群人占有了，大多数人没得到什么好处。
23. 在重大工程项目的决策中，个人利益应该为社会利益让路。
24. 浪费粮食也是个人的自由。
25. 如果猪肉价格过高，政府应当干预。
26. 应当对国外同类产品征收高额关税来保护国内民族工业。
27. 教育应当尽可能公立。
28. 国有企业的利益属于国家利益。
29. 试图控制房地产价格的行为会破坏经济发展。
30. 改善低收入者生活的首要手段是国家给予财政补贴和扶持。
31. 有钱人理应获得更好的医疗服务。
32. 高收入者应该公开自己的经济来源。
33. 靠运作资金赚钱的人对社会的贡献比不上靠劳动赚钱的人。
34. 与其让国有企业亏损破产，不如转卖给资本家。
35. 那些关系到国家安全、以及其他重要国计民生的领域，必须全部由国有企业掌控。
36. 资本积累的过程总是伴随着对普通劳动人民利益的伤害。
37. 私人应当可以拥有和买卖土地。
38. 政府应当采用较高的粮食收购价格以增加农民收入。
39. 在华外国资本应享受和民族资本同样的待遇。
40. 市场竞争中自然形成的垄断地位是无害的。
41. 两个成年人之间自愿的性行为是其自由，无论其婚姻关系为何。
42. 不应公开谈论自己长辈的缺点。
43. 现代中国社会需要儒家思想。
44. 判断艺术作品的价值的根本标准是看是不是受到人民大众喜爱。
45. 即使有人口压力，国家和社会也无权干涉个人要不要孩子，要几个孩子。
46. 周易八卦能够有效的解释很多事情。
47. 中国传统医学对人体健康的观念比现代主流医学更高明。
48. 汉字无需人为推行简化。
49. 应当将中国传统文化的经典作品作为儿童基础教育读物。
50. 如果是出于自愿，我会认可我的孩子和同性结成伴侣关系。