This is the code that I wrote. I don't understand why I get an error message.
import CSV
import openpyxl
import xlsxwriter
from pandas.io.excel import ExcelWriter
import pandas
def create_excell_from_csv():
arr = ['users', 'account']
dest_filename = r'transformed.xlsx'
wb = xlsxwriter.Workbook(dest_filename)
with ExcelWriter(dest_filename) as ew:
for arr1 in arr:
wb.add_worksheet('sh_' + arr1)
pandas.read_csv(arr1 + '.csv').to_excel(ew, index=FALSE, sheet_name='sh_sh_users' , encoding='utf-8' )
wb.add_worksheet('Sheet').hide()
create_excell_from_csv()