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. 

 

Vendor Name _HARDERSFIELD_11480 CANDIA VINEYARDS HARDERSFIELD_120 MCCORMICK DISTILLING CO _HARDERSFIELD_12069 DELICATO VINEYARDS INC _HARDERSFIELD_12111 LABELLE VYDS AND WINERY HARDERSFIELD 1226 WESTERN SPIRITS BEVERAGE CO HARDERSFIELD 12416 PALM BAY INTERNATIONAL INC HARDERSFIELD 12069 DELICATO VINEYARDS INC _HARDERSFIELD_1269 CASTLE BRANDS CORP. _HARDERSFIELD_1281 SAZERAC CO INC HARDERSFIELD_1282 SAZERAC NORTH AMERICA INC. _HARDERSFIELD_13081 OKOBRAND CORPORATION _HARDERSFIELD_1282 SAZERAC NORTH AMERICA INC. _HARDERSFIELD_1013 PERNOD RICARD USA nventoryld _HARDERSFIELD_1004 JIM BEAM BRANDS COMPANY _HARDERSFIELD_10058 SOUTHERN WINE & SPIRITS NE _HARDERSFIELD_10062 PERFECTA WINES _HARDERSFIELD_1009 LUXCO INC _HARDERSFIELD_1013 PERNOD RICARD USA _HARDERSFIELD_1019 WILLIAM GRANT & SONS INC _HARDERSFIELD_1020 BACARDI USA INC _HARDERSFIELD_10236 MARTIGNETTI COMPANIES _HARDERSFIELD_1024 MOET HENNESSY USA INC _HARDERSFIELD_10254 TREASURY WINE ESTATES _HARDERSFIELD_10266 MS WALKER INC _HARDERSFIELD_1029 HEAVEN HILL DISTILLERIES _HARDERSFIELD_10296 E & J GALLO WINERY _HARDERSFIELD_1039 PROXIMO SPIRITS INC. _HARDERSFIELD_10451 PINE STATE TRADING CO _HARDERSFIELD_10469 VINILANDIA USA _HARDERSFIELD_10472 CONSTELLATION BRANDS INC _HARDERSFIELD_1051 BROWN-FORMAN CORP _HARDERSFIELD_10596 WINE | GROUP INC _HARDERSFIELD_10626 ULTRA BEVERAGE COMPANY LLP _HARDERSFIELD_1065 DISARONNO INTERNATIONAL LLC HARDERSFIELD_1039 PROXIMO SPIRITS INC. HARDERSFIELD 10874 BANFI | PRODUCTS CORP Brand Raw Data Description 11480 Candia Vyds Noiret Vault RSV 750mL 120 Tarantula Azul Tequila Gift 750mL 12069 Gnarly Head Pnt Grigio 750mL 12111 LaBelle Winery Cranberry 750mL 1226 Lexington Bourbon 750mL 12416 Callia Alta Malbec 750mL 12069 Gnarly Head Pnt Grigio 750mL 1269 Jeffersons Bourbon 750mL 1281 Benchmark Old #8 Bourbon 1750ml 1282 Small Batch 1792 750mL 13081 Dom Ferret Pouilly Fuisse 750mL 1282 Small Batch 1792 750mL 1013 Kahlua Pumpkin Spice Liqueur 750mL 1004 Jim Beam w/2 Rocks Glasses 750mL 10058 F Coppola Dmd Ivry Cab Svgn 750mL 10062 Terroirs du Rhone 750mL 1009 Rebel Yell Variety Pack 750mL 1013 Kahlua Pumpkin Spice Liqueur 750mL 1019 Drambuie Glass Pack 750mL 1020 B & B Dom VAP 750mL 10236 Layer Cake Malbec Mendoza 750mL 1024 Hennessey VS +VSOP 50mL 750mL 10254 Beringer Classic Chard 750mL 10266 Klinker Brick Old Vine Znfdl 750mL 1029 Fulton's Harvest Apple Pie L 750mL 10296 Alamos Slcn Malbec Mendoza 750mL 1039 Three Olives Vodka w/Flask 750mL 10451 Line 39 Cab Svgn Lake Cnty 750mL 10469 Easton Svgn Bl Sierra Foothl 750mL 10472 Clos du Bois Pnt Nr Cal 750mL 1051 Woodford Reserve MC 1838 750mL 10596 Almaden Mt Rhine Calif B/B 5000ml 10626 MezzaCorona Pnt Nr 1500ml 1065 DiSaronno Cavalli Collection 150ml 1039 Three Olives Vodka w/Flask 750mL 10874 Cantine Maschio Prosecco Brt 750mL SalesQuantity SalesPrice SalesDate Classification SalesDate Classification VendorNc Column1 Shipping Metho UPS Express Critical UPS Express Critical UPS Trade Direct UPS Trade Direct 14.99 1/29/2016 13.99 1/15/2016 7.99 1/2/2016 15.99 1/2/2016 27.99 1/29/2016 7.99 1/2/2016 7.99 1/2/2016 25.99 1/2/2016 14.99 1/6/2016 29.99 1/19/2016 30.99 1/22/2016 29.99 1/19/2016 18.991 1/6/2016 16.49 1/1/2016 14.99 1/5/2016 8.99 1/1/2016 49.99 1/2/2016 18.99 1/6/2016 26.99 1/9/2016 24.99 1/29/2016 15.99 1/6/2016 27.99 1/13/2016 6.99 1/8/2016 16.99 1/9/2016 9.99 1/3/2016 15.99 1/7/2016 12.99 1/18/2016 9.99 1/2/2016 17.99 1/27/2016 12.99 1/9/2016 99.99 1/4/2016 14.99 1/1/2016 10.99 1/4/2016 12.99 1/20/2016 12.99 1/18/2016 10.99 1/7/2016 131 80 80 166 167 167 160 160 171 116 160 278 169 201 104 122 28 57 95 71 176 64 188 147 47 141 69 135 116 205 199 20 10 112 205 129 2 1 2 2 1 2 2 1 1 1 2 1 1 1 2 2 1 1 1 1 2 1 2 2 1 2 1 2 2 2 1 2 2 1 1 2 90046 5992 2242 90032 9625 6785 2242 1485 8004 660 4692 660 17035 12546 2000 10754 8352 17035 3664 480 4425 8112 9819 9552 3924 3252 7245 7153 90024 1392 1128 9815 9165 2555 7245 516 UPS Express Critical UPS Trade Direct UPS Trade Direct UPS Trade Direct UPS Trade Direct UPS Trade Direct UPS Trade Direct UPS Trade Direct UPS Express Critical UPS Trade Direct UPS Freight UPS Express Critical UPS Trade Direct UPS Express Critical UPS Trade Direct UPS Trade Direct UPS Trade Direct UPS Express Critical UPS Trade Direct UPS Trade Direct UPS Trade Direct UPS Trade Direct UPS Trade Direct UPS Express Critical UPS Trade Direct UPS Express Critical UPS Trade Direct UPS Express Critical UPS Express Critical UPS Express Critical UPS Trade Direct UPS Trade Direct