In Python
Initially, you will prompt the user for the names of two files: one will contain Customer information, and the other will contain Product information, as described below. Sample files are attached (below) to this project so you can download and review them. Some test cases may use other files, which you will not be able to see, so it is important that your program ask the user for the file names, and be able to open and read any file.
The Customer Information file will be a csv file, with no header row, in which each line has the following fields, which are separated by commas.
- Customer_Number
- Customer_Name
- Customer_Balance
- Customer_Password
For example, the sample file named customers.csv has several lines, and the first two are:
24155,"Carey, Drew Allison",838.41,Bo7&J
24426,"Butler, Geoffrey Barbara",722.93,Ep5&
The Product Information file will be a csv file, with no header row, in which each line has the following fields, which are separated by commas:
- Item_Number
- Item_Description
- Item_Price
For example, the sample file named inventory.csv has several lines, and the first two are:
K733,Pens,86.2
LO917,Pencils,74.01