Traceback (most recent call last):

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\IPython\core\interactiveshell.py", line 3035, in run_code
exec(code_obj, self.user_global_ns, self.user_ns)

 "<ipython-input-18-6e9f5e8775c2>", line 1, in <module>
x.pivot_table(columns=x.groupby(['key1','key2']), values='values', index='index')

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\tools\pivot.py", line 111, in pivot_table
agged = grouped.agg(aggfunc)

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\groupby.py", line 685, in agg
return self.aggregate(func, *args, **kwargs)

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\groupby.py", line 2637, in aggregate
return getattr(self, arg)(*args, **kwargs)

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\groupby.py", line 706, in mean
return self._python_agg_general(f)

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\groupby.py", line 1121, in _python_agg_general
return self._python_apply_general(f)

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\groupby.py", line 675, in _python_apply_general
self.axis)

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\groupby.py", line 1270, in apply
splitter = self._get_splitter(data, axis=axis)

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\groupby.py", line 1256, in _get_splitter
comp_ids, _, ngroups = self.group_info

 "pandas\src\properties.pyx", line 34, in pandas.lib.cache_readonly.__get__ (pandas\lib.c:41917)

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\groupby.py", line 1365, in group_info
comp_ids, obs_group_ids = self._get_compressed_labels()

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\groupby.py", line 1373, in _get_compressed_labels
all_labels = [ping.labels for ping in self.groupings]

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\groupby.py", line 1373, in <listcomp>
all_labels = [ping.labels for ping in self.groupings]

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\groupby.py", line 2023, in labels
self._make_labels()

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\groupby.py", line 2034, in _make_labels
labels, uniques = algos.factorize(self.grouper, sort=self.sort)

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\algorithms.py", line 135, in factorize
labels = table.get_labels(vals, uniques, 0, na_sentinel)

 "pandas\hashtable.pyx", line 815, in pandas.hashtable.PyObjectHashTable.get_labels (pandas\hashtable.c:14073)

 "C:\Users\hanans\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\generic.py", line 663, in __hash__
' hashed'.format(self.__class__.__name__))TypeError: 'DataFrame' objects are mutable, thus they cannot be hashed
Traceback (most recent call last):


 "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1284, in _execute_context

cursor, statement, parameters, context


 "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute

cursor.execute(statement, parameters)


 "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 255, in execute

self.errorhandler(self, exc, value)


 "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler

raise errorvalue


 "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 252, in execute

res = self._query(query)


 "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 378, in _query

db.query(q)


 "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 280, in query

_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 3072 bytes')
