Question: 1 from docx import Documentimport math products = [ Parka , Boots, Snowshoes, Climbing Rope, Oxygen Tank, Ice Pick, Crampons ] for i

1 from docx import Documentimport math products =["Parka", "Boots", "Snowshoes", "Climbing Rope", "Oxygen Tank", "Ice Pick", "Crampons"] for i in range(numFiles): invoiceNum ="100"+ str(i).zfill(4) for j in range(random.randint(1,10)): if product in productList: else: subtot = round(random.random()*10**(random.randint (3,4)),2) total = round(subtot + tax, 2) aDoc = Document() pProd = aDoc.add_paragraph("PRODUCTS
") pProd.add_run(f"{key}:{productList[key]}
") aDoc.save(f"INV{invoiceNum}.docX") the file makedocs.py holds a script that when run will create a set of randomized invoices in the form of word documents. your task is to create a python script that processes all docx files created into a single spreadsheet that has a row for each invoice and columns for: invoice id, total number of products purchased, subtotal, tax, and total. the file a2_ex.xslx contains an example spreadsheet. 1. read documents (3%)2. extract data (9%)3. write spreadsheets (3%). please i want answer of this question in an easy way without using pandas with full file paths for my reference if you want you can upload images too
 1 from docx import Documentimport math products =["Parka", "Boots", "Snowshoes", "Climbing

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!