Skip to Content
เมนู
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
คำถามนี้ถูกตั้งค่าสถานะ
2 ตอบกลับ
10886 มุมมอง

in python file for example,

file=field.Binary();

data=pandas.DataFrame(numpy.arange(16).reshape(4,4));


Now I want to save 'data' into 'file' as a excel file; how shall code for this?

in addition, shall I save a fig(which is plot by matplotlib.plot) into 'file' as a picture?



อวตาร
ละทิ้ง
ผู้เขียน

in xml file, the "file" is set as: <field name="file" widget="image" readonly="1" />, and I know widget="image" is for picture, so what for "excel file"?

คำตอบที่ดีที่สุด

A Panda's DataFrame is not an excel spreadsheet on it's own. You have to first create the excel file, turn it into binary and then you can store it in your Binary field `file`.


However, if you want to edit an already existing excel spreadsheet on your computer you can simply do this:

import pandas as pd

# Create a Pandas dataframe from the data.
df = pd.DataFrame({'Data': [10, 20, 30, 20, 15, 30, 45]})

# Create a Pandas Excel writer using XlsxWriter as the engine.
writer = pd.ExcelWriter('pandas_simple.xlsx', engine='xlsxwriter')

# Convert the dataframe to an XlsxWriter Excel object.
df.to_excel(writer, sheet_name='Sheet1')

# Close the Pandas Excel writer and output the Excel file.
writer.save()

Source: http://xlsxwriter.readthedocs.io/working_with_pandas.html

There is much more information on the page that I am sure will be of use when solving your problem.

อวตาร
ละทิ้ง
Related Posts ตอบกลับ มุมมอง กิจกรรม
0
ม.ค. 22
2764
0
ก.ค. 19
2440
0
ต.ค. 15
3217
1
เม.ย. 24
4884
2
ก.พ. 23
9155