Inventory Test File

Note, many (not all) CSV file's first line defines the columns in the file.

Each item in the inventory is on a separate line and must contain

  1. unique ID
  2. type
  3. description
  4. current inventory count
  5. minimum required inventory count
  6. unit price

The inventory CSV file may contain blank lines.

It may also contain comments. (The first non-blank character of a comment is a '#'.)

Use this CSV file to test your code

id,name,description,count,minimum,price # household items 200100,can opener,hand operated can opener,20,40,5.99 200101,can opener,electric can opener,20,20,29.99 200102,dish soap,32 oz liquid soap bottle,35,45,12.99 #tools 300100,hammer,carpenter claw hammer,15,20 300101,screw driver,set of 6 screw drivers,23,15,19.99 300102, hammer,framing hammer,20,25,45,15.00 # school Supplies 400100,backpack,school backpack,1,25,32.99 400101,pencel case,plastic pencel with builtin,8,22,3.99 400102,apple,apple for teacher (1/2 doz),32,25,5.00 400103,book mark, book marks (pkg of 6),32,25,1.99 400104,eraser,erasers (pkg of 2),32,25,0.99 # books 500100,cookbook,To Serve Man,6,14,19.00 500101,biography,Friends, Lovers, and Big Terrible Things,200,100,23.99 500102,novel,Lessons in Chemistry,100,50,15.39 500103,biography,Taylor Swift: A little Golden Book Biography,2,100,15.39 # miscellaneous 100100,light saber,light saber offensive weapon,10,10,10000.00 100102,wrench,Left handed monkey wrench,10,10,200.00 100103,chamber pot,chamber pot(10 inch diameter),4,4,10.00 100104,cage,snipe cage,(holds 1 snipe),5,8,16.00