Page 1 ITP 449 Applications of Machine Learning Homework Assignment #4, Week 6 30 points For each one of the questions below, write Python code in PyCharm, using a new Python file for each question. Name each file ITP449_HW04_QX_lastname_firstname.py where ‘X’ represents the question number. Provide short comments in your code describing your logic. Begin each file with the following comments: # Firstname Lastname # ITP 449 Spring 2020 # HW04 # Question X Use the Avocado Sales dataset provided in the assignment. Import the csv file into a pandas DataFrame. Convert the Date column to a datetime index. Add the following code to handle datetime plotting: pd.plotting.register_matplotlib_converters(). Place the csv file in the same folder as your Python file so that your code will not require changing directories using os.chdir. Provide answers to the analysis questions using comments in each of the Python files. For each question take a screenshot of the output plot. Place all the screenshots in a Word document. Zip all the Python files and the Word file for submission on Blackboard. Page 2 Question 1 Plot the average avocado prices by date for both conventional and organic avocados. Format the plot as shown below: What are the overall trends (for any type of avocado) in avocado prices over time? What are the overall trends in avocado prices for conventional vs. organic? What are some anomalies in avocado prices for conventional vs. organic? Page 3 Question 2 Plot the average avocado prices and the average total volume sold by date for conventional avocados. Format the plot as shown below: What are overall trends in volume of avocados sold over time? What is the relationship between avocado prices and volume sold?
