python Visual to create and save excel

[Anonymous]

import xlsxwriter

HI I have written this code that generate no error but I can't find the generate excel.

Can someone help?

#creating an empty dataframe that collect calculated VaR

VaR_per_book = pd.DataFrame(columns=('BOOK', 'VaR'))

workbook = xlsxwriter.Workbook('BOOKVAR.xlsx')

worksheet = workbook.add_worksheet()

worksheet = workbook.add_worksheet()

worksheet.write('A1', 'Hello world')

workbook.close()

[Anonymous]

Hi @Anonymous ,

I got an error: Name 'pd' is not defined.

Best Regards,

Jay

[Anonymous]

#creating an empty dataframe that collect calculated VaR

VaR_per_book = pd.DataFrame(columns=('BOOK', 'VaR'))

workbook = xlsxwriter.Workbook('BOOKVAR.xlsx')

worksheet = workbook.add_worksheet()

worksheet = workbook.add_worksheet()

sorry I forgot the first line?

import pandas as pd

worksheet.write('A1', 'Hello world')

workbook.close()

[Anonymous]

sorry typing issue the correct code is a below:

import pandas as pd

#creating an empty dataframe that collect calculated VaR

VaR_per_book = pd.DataFrame(columns=('BOOK', 'VaR'))

workbook = xlsxwriter.Workbook('BOOKVAR.xlsx')

worksheet = workbook.add_worksheet()

worksheet = workbook.add_worksheet()

worksheet.write('A1', 'Hello world')

workbook.close()