Pandas uses the xlwt
Python module internally for writing to Excel files.
movies.to_excel('output.xlsx')
You can choose to skip the index by passing along index-False.
movies.to_excel('output.xlsx', index=False)
We can do use these advanced output options by creating a ExcelWriter
object and use this object to write to the EXcel file.
writer = pd.ExcelWriter('output.xlsx', engine='xlsxwriter') movies.to_excel(writer, index=False, sheet_name='report') workbook = writer.bookworksheet = writer.sheets['report']
header_fmt = workbook.add_format({'bold': True}) worksheet.set_row(0, None, header_fmt)
writer.save()