Question: python for data science find the HW2_DataA here: https://drive.google.com/drive/folders/1T_1c6PfJO4gp02w619H3xgMAUHGSnvTX Problem A [40 Marks]: Consider data given in HW2_DataA Microsoft Excel Comma Separated Values (.CSV) file.

python for data science

find the HW2_DataA here:

https://drive.google.com/drive/folders/1T_1c6PfJO4gp02w619H3xgMAUHGSnvTX

python for data science find the HW2_DataA here: https://drive.google.com/drive/folders/1T_1c6PfJO4gp02w619H3xgMAUHGSnvTX Problem A [40

Problem A [40 Marks]: Consider data given in "HW2_DataA" Microsoft Excel Comma Separated Values (.CSV) file. Using the given data, do the following tasks: A-1. [3 marks]: Read the data (Assume the 1st row in HW2_DataA contains the column headings). Then display: (i) 10 randomly selected rows (ii) 10 last rows for all columns. A-2. [5 marks]: Create a new dataframe (let's say: ndf) by selecting the first 20 rows from column-2 (Type_of_Payment) to column-6 (Late_delivery) and then sort the second column of the new dataframe in descending order and the third column of the new dataframe in ascending order. A-3. [2 marks]: Considering the new dataframe from part A-2, display the separate statistical summary for numerical and non-numerical columns. A-4. [5 marks]: From the original dataset "HW2_DataA", How many customers below the age of 40 ordered a smart watch using the first class shipping mode? A-5. [5 marks]: Add a new column (Order_Item_Discount_New) by converting "Order_Item_Discount" column values from float to nearest integer using the apply command and custom function. [Note: using lambda function is not allowed]

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 Databases Questions!

Problem A [40 Marks]: Consider data given in "HW2_DataA" Microsoft Excel Comma Separated Values (.CSV) file. Using the given data, do the following tasks: A-1. [3 marks]: Read the data (Assume the...

Consider data given in HW 2 _ Data _ A Microsoft Excel Comma Separated Values ( . csv ) file about laptop prices. Using the given data, do the tasks given below. A 1 . ( 3 points ) Read the data (...

Life without SQL (25 points). A comma separated values (csv) file is given on Canvas: employee-sample.csv . It contains a dataset with employee salary information, which includes Full Name, Current...

Problem A [ 5 0 Marks ] : Consider data given in " HW 2 _ Data _ A " Microsoft Excel Comma Separated Values ( . CSV ) file about laptop prices. Using the given data, do the following tasks: A - 1 . [...

Problem B [40 Marks]: Consider the data given in "HW2_DataB" Microsoft Excel (.csv) file and described in Table 1. Note: Solve all the following questions using Python. Use the Pandas \& Sklearn...

Part 1: Date Arithmetic Operations date_arithmetic()-> Tuple[datetime, datetime,int] Date arithmetic is far more difficult than you might imagine. For example, what is the date three days after Feb...

Please write down the code of Python Introduction: You've been given CSV (comma separated values) files that represent the contents of a bank, including the names and balances associated with each...

Create a design document complete with the objects and flow of data, as well as any decisions you made on the best use of classes, inheritance, polymorphism, and exception handling. After you have...

1 QUESTION 1 (15 marks) (18 minutes) KayFC Ltd acquired 70 000 of the 100 000 ordinary shares in Nandas Ltd on 1 May 2013 KayFC Lid seized the opportunity to expand, as both companies operate in the...

a) Estimate the value of by graphing the function f(x) = x / (√1 + 3x 1). (b) Make a table of values of for x close to 0 and guess the value of the limit. (c) Use the Limit Laws to prove that...

1 8 Which of the following is true regarding the efficient portfolio that targets 3 % STD ? 1 It allocates less than 5 0 % to stocks 2 It allocate more weight to KO than WMT than the portfolio that...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

How has Departmental Computing increased the need for HCM Professionals and Technical Staff to be skilled in Business Computing Software and Systems?

Describe the difference between Two- and Three-Tier Computing Systems.

Explain the differences between On Premises, SaaS, PaaS, IaaS, and Hybrid Computing environments.