python: add more new row

https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_excel.html

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

def appendDataToExcel(excelName, sheetName, data):     """     EXCEL向后行插入数据     :param excelName: EXCEL文件     :param sheetName: 工作表名     :param data: 数据集合     :return:     """     columns = []     for k, v in data.items():         columns.append(k)     df = pd.DataFrame(data, index= None)     #print(df)     df_source = None     if os.path.exists(excelName):        dfdata = pd.read_excel(excelName, sheet_name=sheetName)        df_source = pd.DataFrame(dfdata)     if df_source is not None:        df_dest = pd.concat([df_source, df], ignore_index=True)# df_source.append(df)     else:        df_dest = df     #print(df_dest)     df_dest.to_excel(excelName, sheet_name=sheetName, index = False, columns=columns)

　　

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

def append_data_to_excel(excel_name, sheet_name, data):     """     EXCEL向后行插入数据 预先有一定格式的表头的工作表     :param excel_name: EXCEL文件     :param sheet_name: 工作表名     :param data: 数据集合     :return:     """     #如果不是规范的工作表，是会报错     df_source = None     if os.path.exists(excel_name):         df_source = pd.DataFrame(pd.read_excel(excel_name, sheet_name=sheet_name))         print(df_source)       with pd.ExcelWriter(excel_name) as writer:         columns = []         for k, v in data.items():             columns.append(k)         df = pd.DataFrame(data, index= None)         print(df)         if df_source is not None:             df_dest = pd.concat([df_source, df], ignore_index=True)#df_source.append(df)         else:             df_dest = df.copy()         print("***********")         print(df_dest)         df_dest.to_excel(writer, sheet_name=sheet_name, index = False, columns=columns)  #

　　

调用：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

#df1 = pd.read_excel('test.xlsx', sheet_name='person') #df2 = pd.DataFrame(df1) #print(df2) data = {'Name': ['Geovin Du', 'Jack', 'Steve', 'Ricky'], 'Age': [28, 34, 29, 42],         'City': ['wuhan', 'chongqin', 'beijing', 'shanghai']} columns = [] for k, v in data.items():     columns.append(k) print(columns) df3 = pd.DataFrame(data); #df2.append(df3) print(df3)   df2 = df3.copy()   with pd.ExcelWriter('output.xlsx') as writer:     df3.to_excel(writer, sheet_name='Sheet1')     df2.to_excel(writer, sheet_name='Sheet2')   #pd.concat() #df2=pd.concat([df2, df3], ignore_index=True) #print(df2) #df2.to_excel('test.xlsx', sheet_name='person', index=False)  # index false为不写入索引 appendDataToExcel('test.xlsx', 'person', data) data = {'Name': ['Geovin', '涂聚文', '涂聚文', '涂年生'], 'Age': [12, 14, 19, 12],'City': ['深圳', '重庆', '北京','西安']} appendDataToExcel('test.xlsx', 'person', data) appendDataToExcel('test.xlsx', 'person', data)

　　

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

#df1 = pd.read_excel('test.xlsx', sheet_name='person') #df2 = pd.DataFrame(df1) #print(df2) data = {'Name': ['Geovin Du', 'Jack', 'Steve', 'Ricky'], 'Age': [28, 34, 29, 42],         'City': ['wuhan', 'chongqin', 'beijing', 'shanghai']} columns = [] for k, v in data.items():     columns.append(k) print(columns) df3 = pd.DataFrame(data); #df2.append(df3) print(df3)   df2 = df3.copy()   with pd.ExcelWriter('output.xlsx') as writer:     df3.to_excel(writer, sheet_name='Sheet1')     df2.to_excel(writer, sheet_name='Sheet2')   append_data_to_excel('test.xlsx', 'person', data) #pd.concat() #df2=pd.concat([df2, df3], ignore_index=True) #print(df2) #df2.to_excel('test.xlsx', sheet_name='person', index=False)  # index false为不写入索引 #appendDataToExcel('test.xlsx', 'person', data) data = {'Name': ['Geovin', '涂聚文', '涂聚文', '涂年生'], 'Age': [12, 14, 19, 12],'City': ['深圳', '重庆', '北京','西安']} #appendDataToExcel('test.xlsx', 'person', data) #appendDataToExcel('test.xlsx', 'person', data) append_data_to_excel('test.xlsx', 'person', data)

　　

?

1 2 3 4 5 6 7 8 9 10

df1 = pd.read_excel('test.xlsx', sheet_name='person')     df2 = pd.DataFrame(df1)     #df2.loc(len(df2))       data = {'Name': 'GeovinDu', 'Age': 22,             'City': '深圳'}     print(len(df2))     df2.loc[len(df2)]=data  #添加一条     print(df2)     print("*********************添加一条**************************")