python - Panda Pivot Table troubles -> No module named style? -

i getting error: importerror: no module named style, coming import statement: from openpyxl.style import style

here code related pivot table:

excel = pd.excelfile(filename) df = excel.parse(sheetname=0) df1 = df[['product description', 'supervisor']]  print df1  table1 = pd.pivot_table(df1, rows = ['supervisor'],                            cols = ['product description'],                           values = ['product description'],                            aggfunc = [lambda x: len(x)], fill_value = 0) writer = pd.excelwriter(filename) table1.to_excel(writer, 'pivot table') writer.save()   workbook.save(filename) 

the thing can think of may cause header supervisor column has style applied (which applying bold style word 'supervisor'). removing lines apply style not solve problem however.

supervisorheader = worksheet.cell("cv1") s = style(font=font(bold=true)) supervisorheader.style = s 

here data frame looks like:

         product description supervisor 0        express 12:00 (doc)     gordon 1     express 10:30 (nondoc)    vinny p 2        express 12:00 (doc)    vinny 3     express 12:00 (nondoc)   building 4     express 12:00 (nondoc)   building 5     express 12:00 (nondoc)   building 6     express 12:00 (nondoc)     gordon 7   medical express (nondoc)     gordon 8     express 10:30 (nondoc)    vinny 9        express 12:00 (doc)       pete 10    express 12:00 (nondoc)    vinny p 11    express 10:30 (nondoc)   building 12    express 12:00 (nondoc)     gordon 13    express 12:00 (nondoc)    vinny 14    express 12:00 (nondoc)   building 15       express 10:30 (doc)     gordon  [16 rows x 2 columns] 

and error traceback:

file "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1625, in dispatch_request     return self.view_functions[rule.endpoint](**req.view_args)   file "/home/harrisonleggio/tdx.py", line 34, in upload     return process(f.filename)   file "/home/harrisonleggio/tdx.py", line 201, in process     table1.to_excel(writer, 'pivot table', engine = 'xlsxwriter')   file "/usr/lib/python2.7/dist-packages/pandas/core/frame.py", line 1204, in to_excel     startrow=startrow, startcol=startcol)   file "/usr/lib/python2.7/dist-packages/pandas/io/excel.py", line 530, in write_cells     style = self._convert_to_style(cell.style)   file "/usr/lib/python2.7/dist-packages/pandas/io/excel.py", line 577, in _convert_to_style     openpyxl.style import style importerror: no module named style