nput: a) ManufacturerList.csv -- contains items listed by row. Each row contains item ID, manufacturer name, item type, and optionally a damaged indicator b) PriceList.csv -- contains items listed by row. Each row contains item ID and the item price. c) ServiceDatesList.csv – contains items listed by row. Each row contains item ID and service date. Required Output: 1) Interactive Inventory Query Capability a. Query the user of an item by asking for manufacturer and item type with a single query. i. Print a message(“No such item in inventory”) if either the manufacturer or the item type are not in the inventory, more that one of either type is submitted or the combination is not in the inventory. Ignore any other words, so “nice Apple computer” is treated the same as “Apple computer”. ii. Print “Your item is:” with the item ID, manufacturer name, item type and price on one line. Do not provide items that are past their service date or damaged. If there is more than one item, provide the most expensive item. iii. Also print “You may, also, consider:” and print information about the same item type from another manufacturer that closes in price to the output item. Only print this if the same item from another manufacturer is in the inventory and is not damaged nor past its service date. iv. After output for one query, query the user again. Allow ‘q’ to quit.
You will design a
Input:
a) ManufacturerList.csv -- contains items listed by row. Each row contains item ID,
manufacturer name, item type, and optionally a damaged indicator
b) PriceList.csv -- contains items listed by row. Each row contains item ID and the item price.
c) ServiceDatesList.csv – contains items listed by row. Each row contains item ID and service
date.
Required Output:
1) Interactive Inventory Query Capability
a. Query the user of an item by asking for manufacturer and item type with a single query.
i. Print a message(“No such item in inventory”) if either the manufacturer or the
item type are not in the inventory, more that one of either type is submitted or
the combination is not in the inventory. Ignore any other words, so “nice Apple
computer” is treated the same as “Apple computer”.
ii. Print “Your item is:” with the item ID, manufacturer name, item type and price
on one line. Do not provide items that are past their service date or damaged. If
there is more than one item, provide the most expensive item.
iii. Also print “You may, also, consider:” and print information about the same item
type from another manufacturer that closes in price to the output item. Only
print this if the same item from another manufacturer is in the inventory and is
not damaged nor past its service date.
iv. After output for one query, query the user again. Allow ‘q’ to quit.
This is my code so far but it does not produce any output. Im trying to write the program without the use of PANDAS, LAMBDA, ITEMGETTER or
import csv
field_names = ['item_id', 'item_name', 'item_price', 'item_status', 'item_date']
class Inventory:
def __int__(self, item_id, item_name, item_type, item_price, item_status, item_date):
self.id = item_id
self.name = item_name
self.type = item_type
self.price = item_price
self.status = item_status
self.date = item_date
def main():
inventory_list = []
with open('ManufacturerList.csv', 'r') as manufacturer:
m_list = csv.reader(manufacturer)
for each in m_list:
item_id = each[0]
item_name = each[1]
item_type = each[2]
item_status = each[3]
inv_list = Inventory(item_id=item_id, item_name=item_name, item_type=item_type, item_status=item_status)
inventory_list.append(inv_list)
with open('PriceList.csv', 'r') as price:
p_list = csv.reader(price)
for row in p_list:
identifier = row[0]
cost = row[1]
for item1 in inventory_list:
if item1.id == identifier:
item1.price = cost
with open('ServiceDateList.csv', 'r') as service_date:
s_list = csv.reader(service_date)
for row in s_list:
obj = row[0]
serviced = row[1]
for item2 in inventory_list:
if item2.id == obj:
item2.serviced = serviced
def sort1(x):
return x.name
inventory_list.sort(key=sort1)
with open('FullInventory.csv', 'w')as file:
writer = csv.writer(file)
for each in inventory_list:
row = [each.id, each.name, each.type, each.price, each.date, each.status]
writer.writerow(row)
def sort2(x):
return x.id
inventory_list.sort(reverse=True, key=sort2)
with open('LaptopInventory.csv', 'w')as file:
writer = csv.writer(file)
for each in inventory_list:
row = [each.id, each.name, each.type, each.price, each.date, each.status]
writer.writerow(row)
def sort3(x):
return x.date
inventory_list.sort(key=sort3)
with open('PastServiceDateInventory.csv', 'w')as file:
writer = csv.writer(file)
for each in inventory_list:
if each.date != '#####':
row = [each.id, each.name, each.type, each.price, each.date, each.status]
writer.writerow(row)
def sort4(x):
return x.status
inventory_list.sort(key=sort4)
with open('DamagedInventory.csv', 'w')as file:
writer = csv.writer(file)
for each in inventory_list:
if each.status == 'damaged':
row = [each.id, each.name, each.type, each.price, each.date, each.status]
writer.writerow(row)
if __name__ == '__main__':
main()
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
