This is a copy of what is happening when trying to create a spreadsheet.
import pandas as pd
Customer Information
customer_info = {
“Field”: [“Name”, “Address”, “Phone”, “Email”, “Sales Order #”, “Ref #”, “Order Date”],
“Details”: [“Mrs. Alisha Burden”, “228 Liberty Ridge Dr, Elgin, SC 29045”, “803-543-3016”,
“carlton.alisha@yahoo.com”, “WO-00513”, “EST-204168”, “02-12-25”]
}
Work Order Data
work_order_data = [
[“Exterior”, “Soft Wash (2,155 sqft)”, “01:41”, “$94.82”, “”, “”, “”],
[“Dining Room/Foyer”, “Walls (672 sqft)”, “01:41”, “$228.48”, “”, “”, “”],
[“”, “Front Door”, “00:32”, “$32.00”, “”, “”, “”],
[“”, “Window Sills (2)”, “00:05”, “$9.60”, “”, “”, “”],
[“”, “Baseboard (59 ft)”, “00:35”, “$17.70”, “”, “”, “”],
[“Downstairs Hall”, “Walls (327 sqft)”, “00:49”, “$111.18”, “”, “”, “”],
[“”, “Interior Doors and Casings (7 sides)”, “01:24”, “$168.00”, “”, “”, “”],
[“”, “Baseboard (36 ft)”, “00:22”, “$10.80”, “”, “”, “”],
[“Downstairs Front Bedroom”, “Walls (407 sqft)”, “01:01”, “$138.38”, “”, “”, “”],
[“”, “Interior Doors and Casings (1 side)”, “00:12”, “$24.00”, “”, “”, “”],
[“”, “Window Sills (1)”, “00:02”, “$4.80”, “”, “”, “”],
[“”, “Baseboard (44 ft)”, “00:26”, “$13.20”, “”, “”, “”],
[“Hallway Bathroom”, “Walls (176 sqft)”, “00:26”, “$59.84”, “”, “”, “”],
[“”, “Interior Doors and Casings (1 side)”, “00:12”, “$24.00”, “”, “”, “”],
[“”, “Baseboard (19 ft)”, “00:11”, “$5.70”, “”, “”, “”],
[“Rear Bedroom”, “Walls (418 sqft)”, “01:03”, “$142.12”, “”, “”, “”],
[“”, “Interior Doors and Casings (1 side)”, “00:12”, “$24.00”, “”, “”, “”],
[“”, “Window Sills (1)”, “00:02”, “$4.80”, “”, “”, “”],
[“”, “Baseboard (46 ft)”, “00:28”, “$13.80”, “”, “”, “”],
[“Living Room/Kitchen”, “Walls (1,039 sqft)”, “02:36”, “$353.26”, “”, “”, “”],
[“”, “Interior Doors and Casings (2 sides)”, “00:24”, “$48.00”, “”, “”, “”],
[“”, “Cased Opening (2)”, “00:08”, “$19.99”, “”, “”, “”],
[“”, “Window Sills (5)”, “00:12”, “$24.00”, “”, “”, “”],
[“”, “Baseboard (87 ft)”, “00:52”, “$26.10”, “”, “”, “”],
[“Total”, “”, “102:34”, “$7,692.17”, “”, “”, “”]
]
Creating DataFrames
df_customer = pd.DataFrame(customer_info)
df_work_order = pd.DataFrame(work_order_data, columns=[“Area”, “Substrate”, “Estimated Time”, “Payout”, “Employee”, “Actual Hours”, “Hourly Rate Earned”])
File path for saving
file_path = “/mnt/data/Work_Order_00513.xlsx”
Writing to Excel file
with pd.ExcelWriter(file_path, engine=“xlsxwriter”) as writer:
df_customer.to_excel(writer, sheet_name=“Customer Info”, index=False)
df_work_order.to_excel(writer, sheet_name=“Work Order”, index=False)
file_path