Laptop Sales at a London Computer Chain: Interactive Visualization. The next exercises are designed for using an interactive visualization tool. The file LaptopSales.txt is a comma-separated file with nearly 300,000 rows. ENBIS (the European Network for Business and Industrial Statistics) provided these data as part of a contest organized in the fall of 2009. Scenario: Imagine that you are a new analyst for a company called Acell (a company selling laptops). You have been provided with data about products and sales. You need to help the company with their business goal of planning a product strategy and pricing policies that will maximize Acells projected revenues in 2009. Using an interactive visualization tool, answer the following questions. Using Python.
- Price Questions:
- At what price are the laptops actually selling?
AutoSave Off Laptop Sales(1) (1) Search olivia mosier OM File Home Insert Page Layout Formulas Data Review View Add-ins Help Power Pivot Share Comments AT TTY TA W 47 Z Sort & Find & Filter Select Ideas Calibri 11 ~ A ab Wrap Text General Paste Conditional Format as Cell Insert Delete Format BIU CA EEE 2 Merge & Center $ % 48.00 Formatting Table Styles Clipboard Font Alignment Number Styles Cells 0 POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again y Editing Ideas Save As... X A1 Date - J Q R S T B D E F G H K L M N o P 1 Date Iconfigura Customer Store Post Retail Pric Screen Siz Battery Lif RAM (GB) Processor Integratec HD Size (Bundled A customer customer store X store Y 2 1/1/2008 0:01 163 EC4V 5BH SE1 2BN 455 15 5 1 2 Yes 80 Yes 532041 180995 534057 179682 3 1/1/2008 0:02 320 SW4 OJL SW12 9HD 545 15 6 1 2 No 300 No 529240 175537 528739 173080 4 1/1/2008 0:04 23 EC3V 1LR E2 ORY 515 15 4 1 2 Yes 300 Yes 533095 181047 535652 182961 5 1/1/2008 0:04 169 SW1P 3AU SE1 2BN 395 15 5 1 2 No 40 Yes 529902 179641 534057 179682 6 1/1/2008 0:06 365 EC4V 4EG SW1V 4QC 585 15 6 2 2 No 120 Yes 531684 180948 528924 178440 7 1/1/2008 0:12 309 W1B 5PX SW1V 400 555 15 6 1 2 Yes 120 Yes 529207 180969 528924 178440 8 1/1/2008 0:14 75 SE25 4LX SE8 3JD 465 15 4 2 2 No 80 Yes 534575 168236 537175 177885 9 1/1/2008 0:17 346 N7 6AR E2 ORY 450 15 6 2 1.5 No 40 No 530461 186176 535652 182961 10 1/1/2008 0:24 70 W3 7JT SW18 INN 455 15 4 2 2 Yes 120 No 520898 180071 525155 175180 11 1/1/2008 0:56 351 SW8 1RB SW1V 4QC 620 15 6 2 1.5 No 300 Yes 530298 177435 528924 178440 12 1/1/2008 1:00 209 SE26 5HB CR7 8LE 465 15 5 2 2 Yes 40 Yes 535838 171458 532714 168302 13 1/1/2008 1:03 359 W1T 1DG NW5 2QH 665 15 6 2 2 Yes 300 Yes 529584 181554 529248 185213 14 1/1/2008 1:05 300 TW9 3AH W4 3PH 440 15 6 1 1.5 No 80 No 518891 177662 519585 177640 15 1/1/2008 1:07 363 N1 9DU SW1V 4QC 565 15 6 2 2 No 80 Yes 530451 183067 528924 178440 16 1/1/2008 1:15 22 N1 SLU E2 ORY 405 15 4 1 2 Yes 120 No 531957 183906 535652 182961 17 1/1/2008 1:18 53 E14 OBB SE8 3JD 480 15 4 2 1.5 Yes 120 Yes 538189 180731 537175 177885 18 1/1/2008 1:29 310 WC1X OAE SW1P 3AU 505 15 6 1 2 Yes 120 No 531065 182190 529902 179641 19 1/1/2008 1:30 314 N1 9BL SE1 2BN 425 15 6 1 2 No 40 No 530520 183119 534057 179682 20 1/1/2008 1:32 320 WC2E 8RF SE1 2BN 545 15 6 1 2 No 300 No 530351 180907 534057 179682 21 1/1/2008 1:32 299 SE1 3XB SW1P 3AU 490 15 6 1 1.5 No 80 Yes 533256 179711 529902 179641 AutoSave Off Laptop Sales(1) (1) Search olivia mosier OM File Home Insert Page Layout Formulas Data Review View Add-ins Help Power Pivot Share Comments AT TTY TA W 47 Z Sort & Find & Filter Select Ideas Calibri 11 ~ A ab Wrap Text General Paste Conditional Format as Cell Insert Delete Format BIU CA EEE 2 Merge & Center $ % 48.00 Formatting Table Styles Clipboard Font Alignment Number Styles Cells 0 POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again y Editing Ideas Save As... X A1 Date - J Q R S T B D E F G H K L M N o P 1 Date Iconfigura Customer Store Post Retail Pric Screen Siz Battery Lif RAM (GB) Processor Integratec HD Size (Bundled A customer customer store X store Y 2 1/1/2008 0:01 163 EC4V 5BH SE1 2BN 455 15 5 1 2 Yes 80 Yes 532041 180995 534057 179682 3 1/1/2008 0:02 320 SW4 OJL SW12 9HD 545 15 6 1 2 No 300 No 529240 175537 528739 173080 4 1/1/2008 0:04 23 EC3V 1LR E2 ORY 515 15 4 1 2 Yes 300 Yes 533095 181047 535652 182961 5 1/1/2008 0:04 169 SW1P 3AU SE1 2BN 395 15 5 1 2 No 40 Yes 529902 179641 534057 179682 6 1/1/2008 0:06 365 EC4V 4EG SW1V 4QC 585 15 6 2 2 No 120 Yes 531684 180948 528924 178440 7 1/1/2008 0:12 309 W1B 5PX SW1V 400 555 15 6 1 2 Yes 120 Yes 529207 180969 528924 178440 8 1/1/2008 0:14 75 SE25 4LX SE8 3JD 465 15 4 2 2 No 80 Yes 534575 168236 537175 177885 9 1/1/2008 0:17 346 N7 6AR E2 ORY 450 15 6 2 1.5 No 40 No 530461 186176 535652 182961 10 1/1/2008 0:24 70 W3 7JT SW18 INN 455 15 4 2 2 Yes 120 No 520898 180071 525155 175180 11 1/1/2008 0:56 351 SW8 1RB SW1V 4QC 620 15 6 2 1.5 No 300 Yes 530298 177435 528924 178440 12 1/1/2008 1:00 209 SE26 5HB CR7 8LE 465 15 5 2 2 Yes 40 Yes 535838 171458 532714 168302 13 1/1/2008 1:03 359 W1T 1DG NW5 2QH 665 15 6 2 2 Yes 300 Yes 529584 181554 529248 185213 14 1/1/2008 1:05 300 TW9 3AH W4 3PH 440 15 6 1 1.5 No 80 No 518891 177662 519585 177640 15 1/1/2008 1:07 363 N1 9DU SW1V 4QC 565 15 6 2 2 No 80 Yes 530451 183067 528924 178440 16 1/1/2008 1:15 22 N1 SLU E2 ORY 405 15 4 1 2 Yes 120 No 531957 183906 535652 182961 17 1/1/2008 1:18 53 E14 OBB SE8 3JD 480 15 4 2 1.5 Yes 120 Yes 538189 180731 537175 177885 18 1/1/2008 1:29 310 WC1X OAE SW1P 3AU 505 15 6 1 2 Yes 120 No 531065 182190 529902 179641 19 1/1/2008 1:30 314 N1 9BL SE1 2BN 425 15 6 1 2 No 40 No 530520 183119 534057 179682 20 1/1/2008 1:32 320 WC2E 8RF SE1 2BN 545 15 6 1 2 No 300 No 530351 180907 534057 179682 21 1/1/2008 1:32 299 SE1 3XB SW1P 3AU 490 15 6 1 1.5 No 80 Yes 533256 179711 529902 179641
