Question: Use the dataset LaptopSales.csv and write a code to do the following: 1 . Read the data into a data frame named LaptopSales.df 2 .

Use the dataset LaptopSales.csv and write a code to do the following:

1 .

Read the data into a data frame named LaptopSales.df

2 .

Use a for

-

loop to print the number of missing values in each of the columns of the

dataset

. 3 .

Build a data frame of average, standard deviation, and number of missing values of

Screen Size, Battery, Ram, and Processor Speed.

4 .

Build a correlation matrix of Price, processor speed, and ram only for laptops with

Bundled Applications. Round to

1

decimal.

5 .

Bin the data of Retail Price column into $

150,

200,

250, . . .,

900

and add a column

named Binned Retail Price to the dataset.

6 .

Find the top

5

postcodes with highest volume of sale. Produce a table of average retail

price sliced by top

-

selling

5

Store Postcodes and if Bundled Application is Yes or No

. 7 .

Create a pivot table of total sales by top selling

5

store Postcodes

(

on columns

),

and

Integrated Wireless being Yes or No

(

on rows

) . 8 .

Produce a bar plot for the data of the previous part. Use stacked bars and custom axis and

paste of your choosing.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Case Study Managing a Merger at Lightning Networks After receiving regulatory approval from the European Union, Lightning Networks, a major wireless carrier, and SatTV, the largest satellite TV...

In this assignment, you will need to work on Microsoft Malware Prediction problem. Here is the link to download data from Kaggle. Please make sure to download train.csv file...

Write SAS code for the following task: 1) Read in the excel file "Data.xlsx" to create a temporary SAS dataset 2) Based on the DOB column, create a new column called Age 3) Based on AdmissionDate and...

(Please do this in C language using data files and arrays) Problem Statement : Given a text file RandomData.txt, that contains random integer numbers. You are required to write a program that does...

In c + + please: Project 5 Online Groceries PART 1 Background You are building a system to allow customers to order groceries. You have two files with data: customers.txt items.txt The first file...

Use the following Daily Gold Price on World dataset with different currencies (available at Kaggle.com). It contains historical gold prices (end of year) from 1979 to 2022. Create a Jupyter notebook...

Given the attached file, write a Python code to do the following : 1 . read the data into a data frame 2 . use regular expressions to delete the special characters from the text ( message column ) ....

Given this dataset of 3 0 animals and thier weight , top speed , life span , habitat , diet and social behavior. write a python code that does the following: 1 - Read animal from the Table. Use Panda...

Use the following gold prices dataset (available at Kaggle.com). It contains historical gold prices (end of year) from 1979 to 2018. Create a Jupyter notebook file that includes Python code to do the...

Write a stack class implemented with a linked list, with the foll o wing functionality: 1. Constructor 2. Destructor 3. Push 4. Pop 5. Stack_top (wont need in this particular main program, but...

A 400 V, 15 kW, 4-pole, 50Hz, Y-connected induction motor has full load slip of 4%. The output torque of the machine at full load is (A) 1.66 Nm (B) 95.50 Nm (C) 99.47 Nm (D) 624.73 Nm

Billy was employed as the managing director of Edward Estate Bhd, a company that deals with property development. Under his contract of employment, he is prohibited from soliciting the companys...

The success of a not - for - profit organization is measured primarily by the amount of profits generated by the organization s activities. True False

The annual demand for an item is 1,700 units. The order cost is $7. Unit cost is $8 and the unit holding cost per year is 18% of the item's value. The order quantity is 125 units. What are the total...