HW Zip/Assignment Instructions.docx Assignment Instructions Please read and follow the instructions inside the attached notebook to complete the work. Following Attached Files are needed to complete...

The attached zip folder has instructions file on how to do this work and everything else you need to complete it. The attached .ipynb file/Jupyter notebookIt is what you need to work in. This work is pretty much the same type of work as Order : 78548. Please see if the same expert who work on o

rder 78548 is available to do this. It shouldn't take them more than 20-25 mins considering they already know how to do this kind of work.

HW Zip/Assignment Instructions.docx Assignment Instructions Please read and follow the instructions inside the attached notebook to complete the work. Following Attached Files are needed to complete this assignment: ·  Work03.ipynb (9.019 KB) ·  SalesTotalByRegion.csv (159 B) ·  Task2Fig.jpg (39.015 KB) ·  Task3Fig.jpg (47.507 KB) Please download the attached files to your local folder, and then use the attached Jupyter notebook as a template for your answers. Don't forget to download all these 4 attached files including the images. Hint#1 The expected output is added below each task’s code cells so you know what the expected answer is. Hin#2 The attached image files are also hints. The outputs should have title, labels, legends, etc. The attached image files just serve as a reference/guide. If you download the images, make sure to have them in the same folder as the Jupyter notebook. PS: In the last order, the completed. ipynb file kept coming as blank, please return me a word doc with code in code cells and screen shots along with the. ipynb file to save time. Just like the one you did for Order: 78548. Thanks! HW Zip/SalesTotalByRegion.csv Region,Tea,Espresso,Coffee,Herbal Tea West,35338,34200,28306,35391 Central,33451,29206,33808,33215 East,15745,23672,27740,20241 South,0,22008,16280,12558 HW Zip/Task2Fig.jpg HW Zip/Task3Fig.jpg HW Zip/Work03.ipynb { "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "##

Homework #3: Querying and plotting Multivariate data
\n", "\n", "## Total Points : 80 \n", "###

Due: Tuesday 03/30/2021 11:59 PM
\n", "### Objective : Assess your ability to use multivariate data plotting techniques\n", "\n", "#### Skills needed: In this homework assignment, you'll be using the concepts you've learned to\n", "1. Edit and run Jupyter notebooks\n", "2. Write Python code using `Pandas` and `Matplotlib` packages to :\n", " * import the Pandas and matplotlib packages\n", " * read dataset from file into Pandas dataframe\n", " * index and query the dataframe \n", " * Use color maps\n", " * Map data values to visual variables (colors, sizes, shapes, etc.)\n", " * sort dataframe according to a column values\n", " * Make visiuals using bar and Pie plots with multiple variables \n", " * Use subplots to create juxtaposed multiple displays" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "***\n", "Please type your name below" ] }, { "cell_type": "markdown", "metadata": { "collapsed": true }, "source": [ "##

Your Name:
" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "***" ] }, { "cell_type": "markdown", "metadata": { "collapsed": true }, "source": [ "## Requirements & Submission:\n", "1. Use this notebook as a template for your answers. Then rename it and submitted as ipynb (jupyter notebook) \n", "2. Submit on WTClass (“Resources >> Assignments >> Homework#3 \n", "3. The file name must be your ``first name``+ \"-\"+ ``Last name`` followed by \"-HW3.ipynb\".\n", "4. Each task's answer must be after the task description\n", "5. Answers and explainations must be properly formatted in the properiate Cell type\n", "8. You can add as many cells as you needed\n", "9. You should submit final ***clean version*** of your notebook, i.e. remove any experimenting cells\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Grading

[80 points]
\n", "1. This assignment contains 3 required tasks (80 total points) \n", " * Task 1: reading the data, has 10 points\n", " * Task 2: Making Multiple pie-charts using subplots, has 35 points\n", " * Task 3: Making multiple Bar plots using subplots, has 35 points\n", " \n", "1. You'll earn full points for each command that gives the desired output if it follow the rules\n", "2. Non-executable commands will get 0 points\n", "3. Partial credit will be given for executable non-complete tasks" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "###

Task 1-[10 points]:
Reading the dataset\n", "Import needed libraries and Read the attached csv file (`SalesTotalByRegion.csv`) into a dataframe named as `SalesData`. This dataset shows the total sales of 4 beverage categories (`'Tea', 'Espresso','Coffee','Herbal Tea'`) across 4 regions (`'West','Central','East','South'`)." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "###

Task 1 Answer:
" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "import .." ] }, { "cell_type": "code", "execution_count": 35, "metadata": {}, "outputs": [], "source": [ "SalesData = " ] }, { "cell_type": "code", "execution_count": 36, "metadata": {}, "outputs": [ { "data": { "text/html": [ "