Pivot a table using Python/Pandas

pivot.py

#!/usr/bin/env python

import os
import numpy
import pandas

xlsx = './workbook.xlsx'
df = pandas.read_excel(open(xlsx,'rb'), sheetname=1)

df2 = pandas.pivot_table(df,
                         values='Sales',
                         index=['Department', 'Category', 'Item'],
                         columns=['Store'],
                         aggfunc=numpy.sum)

parts = os.path.splitext(xlsx)
oxlsx = parts[0] + '_pivoted' + parts[1]
writer = pandas.ExcelWriter(oxlsx)
df2.to_excel(writer, sheet_name='Sheet1', merge_cells=False)
writer.save()