Question

Region

Country

Item Type

Sales Channel

Order Priority

Order Date

Order ID

Ship Date

Units Sold

Unit Price

Unit Cost

Total Revenue

Total Cost

Total Profit

Asia

Morocco

Clothes

Online

M

########

6.68E+08

########

4611

109.28

35.84

503890.1

165258.2

338631.8

Sub-Saharan Africa

Ghana

Office Supplies

Online

L

########

6.01E+08

########

896

651.21

524.96

583484.2

470364.2

113120

Sub-Saharan Africa

Slovakia

Beverages

Offline

L

########

1.75E+08

########

3973

47.45

31.79

188518.9

126301.7

62217.18

For this assignment you have been engaged by an e-commerce company to perform some analysis and manipulation of 500,000 records of orders from the company’s fulfillment partner. To complete the requirements of your engagement, you will create a Python program which will perform the following tasks.

The 500,000 records are provided in a comma separated value (.csv) file. Your program will read the file and create a list of records where each record is a list of fields. a. Your program must gracefully handle any file error such as the file not being present.

b. Your program will print out the following statistics about the dataset in the example format provided on the next page:

i. The record with the highest total profit including the amount, order ID, and index number in the list.

ii. The record with the lowest total profit including the amount, order ID, and index number in the list.

iii. A listing of the 10 highest total profit orders including the amount, order ID, and order date.

iv. A listing of the 10 lowest total profit orders including the amount, order ID, and order date.

c. After printing the statistics, your program will create a collection to allow for fast searching of the records by Order ID as a key and return the record if found.

i. Your program will prompt the user for an Order ID and if it is found, print the record in the example format provided on the next page.

ii. If the record is not found, an appropriate message should be printed.

iii. Your program must gracefully handle any errors and continue operation.

d. The company has a number of other systems, some of which work with objects. Your engagement contains a requirement to demonstrate the ability to create objects from the records, place them into a list, and serialize them for use as input to other programs. To do so, your program will do the following:

i. Create a class to hold the following attributes taken from each record: 1. Order ID 2. Ship Date 3. Total Profit

ii. The object will be read only and as such should provide only accessor methods. Your object must provide a __str__ method.

iii. Your program will create 100 instances for the first 100 records in the dataset.

iv. The 100 instances will be added to a list and then serialized to a file named “record_objects.dat”.

v. Your program should then deserialize the objects from file and display the 10th object in the example format provided on the next page.

Answer 1

Answer) According to the HomeworkLib policy we answer the first one. So I answer b.

For this data Analysis I use pandas in python. It is library in python which is used for data analysis. Here for the dataset the dataframe is used which is a multidimensional array list. Pandas has method which can sort,print like SQL in RDBMS. # is used for cooments

I put the code in try except block for the exception filenot found.

code starts here

import pandas as pd

try:
#dataframe created from the file.
df = pd.read_csv("C:\\python\\book1.csv")

print("i. The record with the highest total profit including the amount, order ID, and index number in the list.")

#Another dataframe created for perticular list
df1=df[['Order ID','Total Profit']]

#Another dataframe created for sorted data
df1_sorted = df1.sort_values( by ='Total Profit',ascending=False)

#head() is used to print the number of records from the top
print(df1_sorted.head(1))

print("ii. The record with the lowest total profit including the amount, order ID, and index number in the list.")

df1=df[['Order ID','Total Profit']]

df1_sorted = df1.sort_values( by ='Total Profit')

print(df1_sorted.head(1))

print("iii. A listing of the 10 highest total profit orders including the amount, order ID, and order date.")
df1=df[['Order ID','Total Profit','Order Date']]

df1_sorted = df1.sort_values( by ='Total Profit',ascending=False)

print(df1_sorted.head(10))

print("iv. A listing of the 10 lowest total profit orders including the amount, order ID, and order date.")

df1=df[['Order ID','Total Profit','Order Date']]

df1_sorted = df1.sort_values( by ='Total Profit')

print(df1_sorted.head(10))

except IOError:
print("File not found")

code end here

Output screenshot

c:\python>python ana.py i. The record with the highest total profit including the amount, order ID, and index number in the list. Order ID Total Profit 338631.8 0 668000000.0 ii. The record with the lowest total profit including the amount, order ID, and index number in the list. Order ID Total Profit 62217.18 2 175000000.0 iii. A listing of the 10 highest total profit orders including the amount, order ID, and order date. Total Profit Order Date 338631.80 113120.00 62217.18 Order ID 668000000.0 601000000.0 ####*** ##***** ###***** 0 1 2 175000000.0 iv. A listing of the 10 lowest total profit orders including the amount, order I D, and order date. Order ID Total Profit Order Date ##***# ###***** ###***** 62217.18 113120.00 338631.80 2 175000000.0 1 601000000.0 0 668000000.0