Blog

The Benedict’s test will produce a __________ color in the presence of starch (complex carbohydrate).

Use the food labels shown to determine which test can be used to distinguish (tell the difference) between Apple Pie and Peanut Brittle?

You have a DataFrame called ecommerce with data on customer orders: OrderID (integer) CustomerID (integer) OrderDate (string in format ‘dd/mm/yyyy’) OrderAmount (float) ShipDate (string in format ‘dd/mm/yyyy’) ShipMode (categories: Regular/Express/Priority) Product (text) Category (text) Quantity (integer) Discount (float) Profit (float) Perform the following data manipulation step: Create a DataFrame including only transactions from year 2022.

The same dataframe is used for questions 2a through 1u.  So that you do not have to scroll up to see the dataframe, it has been presented with each question.  The dataframe is also shown below: You have a DataFrame called ecommerce with data on customer orders: OrderID (integer) CustomerID (integer) OrderDate (string in format ‘dd/mm/yyyy’) OrderAmount (float) ShipDate (string in format ‘dd/mm/yyyy’) ShipMode (categories: Regular/Express/Priority) Product (text) Category (text) Quantity (integer) Discount (float) Profit (float)

You have a DataFrame called ecommerce with data on customer orders: OrderID (integer) CustomerID (integer) OrderDate (string in format ‘dd/mm/yyyy’) OrderAmount (float) ShipDate (string in format ‘dd/mm/yyyy’) ShipMode (categories: Regular/Express/Priority) Product (text) Category (text) Quantity (integer) Discount (float) Profit (float) Perform the following data manipulation step: Add a ShippingDelay column calculating duration between OrderDate and ShipDate.

You have a DataFrame called ecommerce with data on customer orders: OrderID (integer) CustomerID (integer) OrderDate (string in format ‘dd/mm/yyyy’) OrderAmount (float) ShipDate (string in format ‘dd/mm/yyyy’) ShipMode (categories: Regular/Express/Priority) Product (text) Category (text) Quantity (integer) Discount (float) Profit (float) Perform the following data manipulation step: Convert the TaxAmount column to currency string format.

You have a DataFrame called ecommerce with data on customer orders: OrderID (integer) CustomerID (integer) OrderDate (string in format ‘dd/mm/yyyy’) OrderAmount (float) ShipDate (string in format ‘dd/mm/yyyy’) ShipMode (categories: Regular/Express/Priority) Product (text) Category (text) Quantity (integer) Discount (float) Profit (float) Perform the following data manipulation step: Resample the indexed data by month and calculate sum of TotalAmount.

You have a DataFrame called ecommerce with data on customer orders: OrderID (integer) CustomerID (integer) OrderDate (string in format ‘dd/mm/yyyy’) OrderAmount (float) ShipDate (string in format ‘dd/mm/yyyy’) ShipMode (categories: Regular/Express/Priority) Product (text) Category (text) Quantity (integer) Discount (float) Profit (float) Perform the following data manipulation step: Impute any missing values in the Quantity column with the mean.

You have a DataFrame called ecommerce with data on customer orders: OrderID (integer) CustomerID (integer) OrderDate (string in format ‘dd/mm/yyyy’) OrderAmount (float) ShipDate (string in format ‘dd/mm/yyyy’) ShipMode (categories: Regular/Express/Priority) Product (text) Category (text) Quantity (integer) Discount (float) Profit (float) Perform the following data manipulation step: Add a TotalAmount column calculating OrderAmount – Discount.

You have a DataFrame called ecommerce with data on customer orders: OrderID (integer) CustomerID (integer) OrderDate (string in format ‘dd/mm/yyyy’) OrderAmount (float) ShipDate (string in format ‘dd/mm/yyyy’) ShipMode (categories: Regular/Express/Priority) Product (text) Category (text) Quantity (integer) Discount (float) Profit (float) Perform the following data manipulation step: Create a new column DaysToShip that calculates the days between OrderDate and ShipDate.