Remember: The rstrip () or strip () methods can be used to get rid of unwanted newlines on the Inputlines from the Input fles, and "
" can be appended to a line, when writing to a file, If you want to begin on anew line.Hint: The bead price list can be read Into a two-dimenslonal list to make looking up the price of the beadseasler while processing the order, and also to facilitate the updates of the quantitles. Once the order Isprocessed, the two-dimensional list can be used to write Infomation to the new updated bead list file. Write a Python program to solve the following problem:PURM, 180, 0.59PNKG, 153,0.39Bob the Porcupine wishes to buy some decorative beads for his quills. He heads to the bead shop where theowner, Arnold the Aardvark, Is struggling to write a Python program to compute the cost of a customer's beadorder from some files that have the pertinent Information. Arnold has a comma-separated file contalning theist of beads he has (actually It's a list of codes which represent each Individual type of bead), along with thequantity-on-hand of each type of bead and the corresponding unit price (the price for a single bead of eachtype). Amold also has the customer's bead order In another file and he's wondering how to qulckly print upan Itemized recelpt for the customer and show them the total price. He needs to be able to repeat thisprocess by runnling the program again with different Input files.CLRP, 206, 0.10CLRM, 279,0.15and the glven Input file bead_order.txt as follows:GRNE, 30GRNG, 50PURM, 180PNKG, 150BLUP, 25REDG, 100CLRM, 60Given two Input filles, with user-entered filenames (e.g. bead_pricelist.txt and bead_order.txt).where• each line of the bead pricelist file Includes the bead code (e.g. "BLUPL" for a blue plastic bead), the quantity-on-hand (e.g., 50) and the unit price of the bead (e.g. 0.15), and• each line of the bead order file Includes the bead code for each type of bead ordered and the quantity ofthat type of bead ordered by the customerBLUG, 200The sample Input/output should look like:Enter bead price list filename: bead_pricelist.txtEnter bead order filename: bead_order.txtQuant Ordered30Bead CodeTotal FriceHelp Amold write a Python program to compute and print the customer's recelpt, Including the bead code, thequantity ordered and the total price of that many of those types of beads. In addition, your program shouldalso compute and print the total price of all beads ordered for that customer's order. Remember to useformatting and descriptive labels as shown in the sample output.$27.00$32.50$106.20$58.50$12.25$29.00$9.00GRNEGRNG50PURM180PNKG150BLUP25REDG100Besides printing the required output, your program must also write the bead code, the new quantity-on-hand(the number of beads remalning after the order has been filled), and the unit price of the bead, to a newoutput file called result_bead_list.txt. For each type of bead, If the quantity on hand Is less than 5,then the message "ORDER MORE" should be added to the end of the line In the file. NOTE: You may assumethat the customer's order will never result in a negative number of beads remalning, I.e., the order can alwaysbe completely filled).CLRM60BLUG200$70.00Total Frice: $344.45And the contents of the output file, zesult_bead_list.txt should be:BLUF, 133, 0.49REDG, 3,0.29 ORDER MOREInclude exception handling In your program so that an error Is produced and your program exits cleanly If anyfiles are not avallable to be opened.YELG, 220,0.99YELM, 109,0.89GRNP, 287,0.90Call your program file bead_purchase.py and test your program with the glven files,bead_pricelist.ext and bead_order.txt, as shown below, and your own test data as well.GRNG, 474,0.65BLUG, 5,0.35REDM, 325,0.25PURM, 0,0.59 ORDER MORENote: The Input files should be placed In the same directory as the .py file for testing (or the pathname to theInput files would need to be specified).PNKG, 3,0.39 ORDER MORECLRE, 206, 0.10CLRM, 219,0.15For example, with the glven Input file bead_pricelist.txt as follows:ELUF, 158,0.49REDG, 103,0.29YELG, 220,0.99If the program trles to open a file that does not exist (e.g., bead_price.txt), then the following Inputprompt, Input and output should be generated:YELM, 109, 0.89GRNE, 317,0.90Enter bead price list filename: bead_price.-txtEnter bead order filename: bead_order.txtGRNG, 524, 0. 65Error: File not fouund.ELUG, 205, 0.35REDM, 325, 0.25

Question

Remember: The rstrip () or strip () methods can be used to get rid of unwanted newlines on the Inputlines from the Input fles, and &#34;
&#34; can be appended to a line, when writing to a file, If you want to begin on anew line.Hint: The bead price list can be read Into a two-dimenslonal list to make looking up the price of the beadseasler while processing the order, and also to facilitate the updates of the quantitles. Once the order Isprocessed, the two-dimensional list can be used to write Infomation to the new updated bead list file. Write a Python program to solve the following problem:PURM, 180, 0.59PNKG, 153,0.39Bob the Porcupine wishes to buy some decorative beads for his quills. He heads to the bead shop where theowner, Arnold the Aardvark, Is struggling to write a Python program to compute the cost of a customer's beadorder from some files that have the pertinent Information. Arnold has a comma-separated file contalning theist of beads he has (actually It's a list of codes which represent each Individual type of bead), along with thequantity-on-hand of each type of bead and the corresponding unit price (the price for a single bead of eachtype). Amold also has the customer's bead order In another file and he's wondering how to qulckly print upan Itemized recelpt for the customer and show them the total price. He needs to be able to repeat thisprocess by runnling the program again with different Input files.CLRP, 206, 0.10CLRM, 279,0.15and the glven Input file bead_order.txt as follows:GRNE, 30GRNG, 50PURM, 180PNKG, 150BLUP, 25REDG, 100CLRM, 60Given two Input filles, with user-entered filenames (e.g. bead_pricelist.txt and bead_order.txt).where• each line of the bead pricelist file Includes the bead code (e.g. &#34;BLUPL&#34; for a blue plastic bead), the quantity-on-hand (e.g., 50) and the unit price of the bead (e.g. 0.15), and• each line of the bead order file Includes the bead code for each type of bead ordered and the quantity ofthat type of bead ordered by the customerBLUG, 200The sample Input/output should look like:Enter bead price list filename: bead_pricelist.txtEnter bead order filename: bead_order.txtQuant Ordered30Bead CodeTotal FriceHelp Amold write a Python program to compute and print the customer's recelpt, Including the bead code, thequantity ordered and the total price of that many of those types of beads. In addition, your program shouldalso compute and print the total price of all beads ordered for that customer's order. Remember to useformatting and descriptive labels as shown in the sample output.$27.00$32.50$106.20$58.50$12.25$29.00$9.00GRNEGRNG50PURM180PNKG150BLUP25REDG100Besides printing the required output, your program must also write the bead code, the new quantity-on-hand(the number of beads remalning after the order has been filled), and the unit price of the bead, to a newoutput file called result_bead_list.txt. For each type of bead, If the quantity on hand Is less than 5,then the message &#34;ORDER MORE&#34; should be added to the end of the line In the file. NOTE: You may assumethat the customer's order will never result in a negative number of beads remalning, I.e., the order can alwaysbe completely filled).CLRM60BLUG200$70.00Total Frice: $344.45And the contents of the output file, zesult_bead_list.txt should be:BLUF, 133, 0.49REDG, 3,0.29 ORDER MOREInclude exception handling In your program so that an error Is produced and your program exits cleanly If anyfiles are not avallable to be opened.YELG, 220,0.99YELM, 109,0.89GRNP, 287,0.90Call your program file bead_purchase.py and test your program with the glven files,bead_pricelist.ext and bead_order.txt, as shown below, and your own test data as well.GRNG, 474,0.65BLUG, 5,0.35REDM, 325,0.25PURM, 0,0.59 ORDER MORENote: The Input files should be placed In the same directory as the .py file for testing (or the pathname to theInput files would need to be specified).PNKG, 3,0.39 ORDER MORECLRE, 206, 0.10CLRM, 219,0.15For example, with the glven Input file bead_pricelist.txt as follows:ELUF, 158,0.49REDG, 103,0.29YELG, 220,0.99If the program trles to open a file that does not exist (e.g., bead_price.txt), then the following Inputprompt, Input and output should be generated:YELM, 109, 0.89GRNE, 317,0.90Enter bead price list filename: bead_price.-txtEnter bead order filename: bead_order.txtGRNG, 524, 0. 65Error: File not fouund.ELUG, 205, 0.35REDM, 325, 0.25

Accepted Answer

code is written in next steps: