There are nonprintable content and extra space in Vendor Name. b). The vendor names are all capitalized.
Question:
There are nonprintable content and extra space in Vendor Name.
b). The vendor names are all capitalized. Please change it to proper case
c). There are extra white space in the description. Please get rid of them.
d). Please split the description into two variables, “Description” and “Size”. “Size” shows the size of the product, for example “750mL”.
e). Some of the sales quantity are stored as string. Please replace it as numbers.
f). Please clean shipping mode variable and keep the full name of them, UPS Trade Direct, UPS Express Critical and UPS Freight. UPS TD =UPS Trade Direct UPS EC =UPS Express Critical UPS F= UPS Freight (Hint: please use Ctrl+F, select replace function to replace the variable. Please get rid of the extra space of the variables.)
g). There might be duplicated observations. Please get rid of the duplicated observations.
Expert Answer:
Based on the given information here is the cleaned and formatted data Brand InventoryID Vendor Name Description Size SalesQuantity Sales Price Sales Date Classification VendorNo Shipping Method HARDER... View the full answer
Introduction to Probability
ISBN: 978-0716771098
1st edition
Authors: Mark Daniel Ward, Ellen Gundlach
