我想使用Excel檔案來存儲用python制作的資料。我的問題是我無法将圖紙添加到現有的excel檔案中。在這裡,我建議使用示例代碼來解決此問題
import pandas as pd
import numpy as np
path = r"C:\Users\fedel\Desktop\excelData\PhD_data.xlsx"
x1 = np.random.randn(100, 2)
df1 = pd.DataFrame(x1)
x2 = np.random.randn(100, 2)
df2 = pd.DataFrame(x2)
writer = pd.ExcelWriter(path, engine = 'xlsxwriter')
df1.to_excel(writer, sheet_name = 'x1')
df2.to_excel(writer, sheet_name = 'x2')
writer.save()
writer.close()
此代碼将兩個DataFrame儲存到兩個表中,分别命名為“ x1”和“ x2”。如果建立兩個新的DataFrame并嘗試使用相同的代碼添加兩個新的工作表“ x3”和“ x4”,則原始資料将丢失。
import pandas as pd
import numpy as np
path = r"C:\Users\fedel\Desktop\excelData\PhD_data.xlsx"
x3 = np.random.randn(100, 2)
df3 = pd.DataFrame(x3)
x4 = np.random.randn(100, 2)
df4 = pd.DataFrame(x4)
writer = pd.ExcelWriter(path, engine = 'xlsxwriter')
df3.to_excel(writer, sheet_name = 'x3')
df4.to_excel(writer, sheet_name = 'x4')
writer.save()
writer.close()
我想要一個具有四張紙的Excel檔案:“ x1”,“ x2”,“ x3”,“ x4”。我知道“ xlsxwriter”不是唯一的“引擎”,而是“ openpyxl”。我還看到已經有其他人對此問題進行了寫作,但是我仍然不知道如何做到這一點。
這是從此連結擷取的代碼
import pandas
from openpyxl import load_workbook
book = load_workbook('Masterfile.xlsx')
writer = pandas.ExcelWriter('Masterfile.xlsx', engine='openpyxl')
writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)
data_filtered.to_excel(writer, "Main", cols=['Diff1', 'Diff2'])
writer.save()
他們說這行得通,但是很難弄清楚它是怎麼回事。我不了解在此上下文中的“ ws.title”,“ ws”和“ dict”是什麼。
儲存“ x1”和“ x2”,然後關閉檔案,再次打開并添加“ x3”和“ x4”的最佳方法是什麼?