2021年5月1日星期六

Why is only one row exported to excel?

When I try to export my pandas data frame to excel only one row exports.

The data base is created during a large loop which basically gives the output:

                                    Names  Average Selling Price  0  ★ Flip Knife | Gamma Doppler (Factory New)               2.418605                                      Names  Average Selling Price  0  ★ Flip Knife | Gamma Doppler (Factory New)                1.69697                                      Names  Average Selling Price  0  ★ Flip Knife | Gamma Doppler (Factory New)                    1.0  

but on a larger scale.

            itemois=pd.DataFrame({                  'Names':[namer],                  'Average Selling Price': [avgn]}). dropna()                        print(itemois)      except KeyError:      break      itemois.to_excel('database.xlsx')  

When I try exporting the database to excel it only adds the first row. Any Ideas?

https://stackoverflow.com/questions/67352630/why-is-only-one-row-exported-to-excel May 02, 2021 at 11:04AM

没有评论:

发表评论