Project số 6 - Lớp: PY49A5L1

1. How many items are there in list 1? in list 2? in only list 1 (List the name of them)? in only list 2 (List the name of them)? in both of the two lists (List the name of them)? Create the new csv file only contains the unique items from the two lists? (Name that file as items.csv)
2. How many items are there in the items.csv? How many of them contain digits in name? How many of them are FIFA football game items (contain "FIFA" in the name)?
3. How many item categories are there in the dataset? Which item category contain highest number of items? lowest number of items? List all items according to each item category. Calculate the average number of items in each category.
4. Which item has the highest price in each year? Which item has the lowest price in each year? Calculate the average price of each item in each year?
5. Which item has the highest sales in each year? Which item has the lowest sales in each year? Calculate the average sales of each item in each year?