Razor Group_Python Task

The document outlines a case study task for identifying promising e-commerce acquisition targets in the Garden category on Amazon. It requires the use of Python for data sanitization and analysis, with a focus on developing selection criteria for the best sellers without manual data cleaning. Insights and results are to be presented in a Jupyter Notebook for assessment by the Acquisitions team at Razor.

Uploaded by

pranavimvs2009

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

5 views

Razor Group_Python Task

Uploaded by

pranavimvs2009

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

You are on page 1/ 4

Case Study - Python

2021

1
• THE
THE TASK

Identification of promising e-commerce acquisition

targets.
Your task is to sanitize and analyze the data to profile the sellers present and develop selection
TASK criteria to identify the best or most promising sellers in this dataset, that the Acquisitions team at
Razor should reach out to, and acquire.

Analyze the dataset provided on the next slide using Python and present your insights. Please
APPROACH do not do any manual data cleaning (only formula-based sanitization) , and do not use excel for
this exercise.

Please present your insights in the form of a Jupyter Notebook. We will assess you on your data
RESULTS parsing process, code quality as well as the insights and selection criteria you develop to
analyze the dataset and present the best sellers. We will ask you to present your results in a
joint call via screenshare.

2
• WHO
THE WE ARESET
DATA

Garden category data from Amazon.

This is a sample dataset of publicly available info on
e-commerce sellers in the Garden category in the Amazon
marketplace.

Download the data set

Click here to download the data set

3
• WHO
DATAWE ARE
SANITY

Preparing the data set four your analysis.

Before you develop your selection criteria, you will need sanitize the data , and
parse out useable data from the unstructured text. Here are some tips:

• The column sellerproductcount gives you the count of products in the form '1-16 of over 100,000 results' , and
you can parse out the product count 100,000.
• sellerratings - This columns gives you the % and count of positive ratings (e.g. 88% positive in the last 12 months
(118 ratings) ) if parsed correctly.
• sellerdetails - You can use this text to parse out phone numbers, and email IDs of merchants, where available, so
our team can reach out to them.
• businessaddress - This will give you the business locations of the sellers. You can parse them to identify if a seller
is registered in the US , Germany (DE), or China (CN). Note that Razor does not acquire Chinese sellers at this
point, so you can use this data to exclude sellers in China from your analysis.
• Hero Product 1 #ratings and Hero Product 2 #ratings - these 2 columns give you the number of ratings of the 2
'hero products' or bestselling products of this seller.