import datetime import pandas as pd import timeclass Book():def __init__(self,id,name,isbn,comment,content,summary,title,topic):self.id=idself.name=nameself.isbn=isbnself.comment=commentself.content=contentself.summary=summaryself.title=titleself.topic=topict1=datetime.datetime.now() print(t1) books_list=[]arr=range(1,1000001) for i in arr:books_list.append(Book(i,f'Name_{i}',f'ISBN_{i}',f'Comment_{i}',f'Content_{i}',f'Summary_{i}',f'Title_{i}',f'Topic_{i}'))book_data=[] for bk in books_list:dic={'Id':bk.id,'Name':bk.name,'Isbn':bk.isbn,'Comment':bk.comment,'Content':bk.content,'Summary':bk.summary,'Title':bk.title,'Topic':bk.topic}book_data.append(dic)t1=datetime.datetime.now() print(f'before book_data,now is {t1}') df=pd.DataFrame(book_data) excelFile=datetime.datetime.now().strftime('%Y%m%d%H%M%S%f') df.to_excel(f'{excelFile}.xlsx',index=False,sheet_name='book_sheet_1') print(f'pd.DataFrame(book_data),now:{datetime.datetime.now()},Time cost:{datetime.datetime.now()-t1},in {excelFile}')time.sleep(5)t1=datetime.datetime.now() df=pd.DataFrame([bk.__dict__ for bk in books_list]) excelFile=datetime.datetime.now().strftime('%Y%m%d%H%M%S%f') df.to_excel(f'{excelFile}.xlsx',index=False,sheet_name='book___dict___1') print(f'[bk.__dict__ for bk in books_list],now:{datetime.datetime.now()},Time cost:{datetime.datetime.now()-t1},in {excelFile}') print(f'dic len:{len(book_data)},type:{type(book_data)}')
