# Import data
data <- read.csv("Amazon_Men_Wrist_Watches.csv", stringsAsFactors = FALSE)

# Melihat struktur data
str(data)
## 'data.frame':    2400 obs. of  6 variables:
##  $ X                : int  0 1 2 3 4 5 6 7 8 9 ...
##  $ brand_name       : chr  "Casio" "Casio" "Titan" "Daniel Hechter" ...
##  $ watch_name       : chr  "Vintage A-158WA-1Q Digital Grey Dial Unisex Watch Silver Metal Strap (D011)" "Youth Series Digital Black Dial Unisex Watch - F-91W-1Q(D002)" "Karishma Analog Black Dial Men's Watch -NM1639SM02 / NL1639SM02" "Paris Bercy Collection Modern Multi Functional Watch for Men with Square Dial and Silicon Band-DHM1001" ...
##  $ rating           : num  4.4 4.5 4.3 4.3 4.5 4.3 4.1 4.4 4.3 4.1 ...
##  $ number_of_reviews: chr  "54K" "13.2K" "2.9K" "890" ...
##  $ price            : chr  "1,894" "1,191" "1,695" "2,593" ...
# Melihat ringkasan data
summary(data)
##        X           brand_name         watch_name            rating     
##  Min.   :   0.0   Length:2400        Length:2400        Min.   :1.000  
##  1st Qu.: 599.8   Class :character   Class :character   1st Qu.:3.900  
##  Median :1199.5   Mode  :character   Mode  :character   Median :4.200  
##  Mean   :1199.5                                         Mean   :4.141  
##  3rd Qu.:1799.2                                         3rd Qu.:4.400  
##  Max.   :2399.0                                         Max.   :5.000  
##                                                         NA's   :231    
##  number_of_reviews     price          
##  Length:2400        Length:2400       
##  Class :character   Class :character  
##  Mode  :character   Mode  :character  
##                                       
##                                       
##                                       
## 
colSums(is.na(data))
##                 X        brand_name        watch_name            rating 
##                 0                 0                 0               231 
## number_of_reviews             price 
##                 0                 0
sum(is.na(data))
## [1] 231
data_clean <- na.omit(data)
data$price[is.na(data$price)] <- mean(data$price, na.rm = TRUE)
## Warning in mean.default(data$price, na.rm = TRUE): argument is not numeric or
## logical: returning NA
data$rating[is.na(data$rating)] <- median(data$rating, na.rm = TRUE)
modus <- names(sort(table(data$brand), decreasing = TRUE))[1]
data$brand[is.na(data$brand)] <- modus
sum(is.na(data_clean))
## [1] 0
sum(duplicated(data))
## [1] 0
str(data$price)
##  chr [1:2400] "1,894" "1,191" "1,695" "2,593" "4,494" "706" "1,099" "4,796" ...
data$price <- gsub(",", "", data$price)
data$price <- gsub("₹", "", data$price)
data$price <- gsub("\\$", "", data$price)
data$price <- as.numeric(data$price)
str(data$price)
##  num [1:2400] 1894 1191 1695 2593 4494 ...
Q1 <- quantile(data$price, 0.25, na.rm = TRUE)
Q3 <- quantile(data$price, 0.75, na.rm = TRUE)
IQR_value <- IQR(data$price, na.rm = TRUE)

lower_bound <- Q1 - 1.5 * IQR_value
upper_bound <- Q3 + 1.5 * IQR_value
lower_bound
##       25% 
## -12286.12
upper_bound
##      75% 
## 23666.88
outlier <- data$price < lower_bound | data$price > upper_bound

sum(outlier, na.rm = TRUE)
## [1] 159
data[outlier, ]
##          X               brand_name
## 119    118                    Casio
## 128    127                    Seiko
## 184    183                    Seiko
## NA      NA                     <NA>
## 307    306                    Titan
## 315    314                    Casio
## 336    335                    Casio
## 426    425                  Citizen
## 469    468                     EDGE
## 477    476                   Diesel
## 495    494                   OBLVLO
## 514    513                    Seiko
## 525    524                  BRETLEY
## 528    527          Armani Exchange
## 536    535          Armani Exchange
## 561    560                 AGELOCER
## 572    571                   Diesel
## 582    581           Emporio Armani
## 600    599                  Citizen
## NA.1    NA                     <NA>
## 627    626                    Seiko
## 638    637                    Titan
## 639    638                    Seiko
## 643    642                     BOSS
## 644    643          Armani Exchange
## 645    644                    Titan
## 653    652                    Seiko
## 658    657                     EDGE
## 681    680                   Fossil
## 696    695           Emporio Armani
## 713    712                D1 Milano
## 718    717                    FEICE
## 744    743          Armani Exchange
## 748    747                    Titan
## 775    774                   Fossil
## 798    797             KENNETH COLE
## 810    809                    Titan
## 811    810                    Seiko
## 842    841                    Seiko
## 844    843                   Fossil
## 851    850                    Titan
## 858    857                    FEICE
## 861    860                    Casio
## 902    901                   TISSOT
## NA.2    NA                     <NA>
## 930    929                  Citizen
## 935    934                    Titan
## NA.3    NA                     <NA>
## 952    951                   Diesel
## 960    959                    TIMEX
## 1030  1029                    Casio
## 1034  1033           Emporio Armani
## 1048  1047                   Diesel
## 1060  1059                   TISSOT
## 1078  1077           Tissot(ティソ)
## 1109  1108                Ingersoll
## 1122  1121                    Seiko
## 1128  1127           Emporio Armani
## 1130  1129               TSAR BOMBA
## 1133  1132                    Titan
## NA.4    NA                     <NA>
## 1192  1191                    Seiko
## 1205  1204                    Seiko
## 1207  1206           Tissot(ティソ)
## 1208  1207                    Casio
## 1219  1218                    Titan
## 1247  1246                  Tornado
## 1266  1265                     EDGE
## 1269  1268           Emporio Armani
## 1297  1296                     EDGE
## 1298  1297            Philipp Plein
## 1300  1299                   Diesel
## 1301  1300                    COACH
## 1308  1307                   Police
## NA.5    NA                     <NA>
## 1340  1339                    TIMEX
## 1344  1343             Michael Kors
## 1349  1348                    Seiko
## NA.6    NA                     <NA>
## 1394  1393          Armani Exchange
## NA.7    NA                     <NA>
## 1410  1409                    Seiko
## 1411  1410                    Titan
## NA.8    NA                     <NA>
## 1419  1418                    Casio
## 1420  1419                    Titan
## 1421  1420                    Casio
## NA.9    NA                     <NA>
## 1435  1434                   Diesel
## NA.10   NA                     <NA>
## 1459  1458           Emporio Armani
## 1468  1467                    Seiko
## 1469  1468          Armani Exchange
## 1476  1475    Swiss Military Hanowa
## NA.11   NA                     <NA>
## 1500  1499                    Seiko
## 1514  1513                    Casio
## 1515  1514                  SEAKOSS
## 1526  1525           Emporio Armani
## NA.12   NA                     <NA>
## NA.13   NA                     <NA>
## 1592  1591                    Seiko
## NA.14   NA                     <NA>
## 1611  1610                    Seiko
## 1618  1617    Swiss Military Hanowa
## 1627  1626    Swiss Military Hanowa
## 1632  1631                    Seiko
## 1641  1640                 Maserati
## 1654  1653                 Maserati
## 1680  1679           Emporio Armani
## 1706  1705                  Versace
## 1712  1711                   TISSOT
## 1716  1715                   Fossil
## 1727  1726                    Seiko
## NA.15   NA                     <NA>
## 1731  1730               Victorinox
## 1749  1748           Emporio Armani
## NA.16   NA                     <NA>
## 1767  1766          Seiko(セイコー)
## 1828  1827             KENNETH COLE
## 1838  1837                    Seiko
## 1841  1840                  Citizen
## 1851  1850                  Citizen
## 1855  1854             KENNETH COLE
## 1860  1859                   TISSOT
## 1867  1866                   Diesel
## 1873  1872                  Citizen
## NA.17   NA                     <NA>
## 1920  1919                 AGELOCER
## 1937  1936                  G-Shock
## 1952  1951                   Fossil
## 1962  1961                  Citizen
## 1964  1963    Swiss Military Hanowa
## 1974  1973                   TISSOT
## 1975  1974                   TISSOT
## NA.18   NA                     <NA>
## 1997  1996               Victorinox
## 2001  2000            Mathey-Tissot
## 2009  2008                  G-Shock
## 2011  2010                    FEICE
## 2035  2034             Michael Kors
## 2038  2037                   Diesel
## 2039  2038                  TIKORRA
## 2045  2044                   TISSOT
## 2050  2049          Seiko(セイコー)
## 2052  2051           Emporio Armani
## 2059  2058                    Seiko
## NA.19   NA                     <NA>
## 2071  2070               Victorinox
## 2072  2071    Swiss Military Hanowa
## 2077  2076             Michael Kors
## NA.20   NA                     <NA>
## 2101  2100                   TISSOT
## 2113  2112           Emporio Armani
## 2117  2116                  Citizen
## 2132  2131           Emporio Armani
## 2145  2144           Emporio Armani
## 2153  2152             Michael Kors
## 2158  2157             KENNETH COLE
## 2163  2162 Swiss Military by Chrono
## NA.21   NA                     <NA>
## 2182  2181            Guess Watches
## 2222  2221                    Seiko
## 2224  2223           Tissot(ティソ)
## 2225  2224                    TIMEX
## 2233  2232    Swiss Military Hanowa
## 2246  2245           Tissot(ティソ)
## NA.22   NA                     <NA>
## NA.23   NA                     <NA>
## 2257  2256                 Maserati
## NA.24   NA                     <NA>
## 2285  2284                 Maserati
## 2296  2295                  Citizen
## 2308  2307           Emporio Armani
## 2317  2316                 Maserati
## 2319  2318                    Seiko
## NA.25   NA                     <NA>
## 2337  2336    Swiss Military Hanowa
## 2341  2340                 Maserati
## 2354  2353    Swiss Military Hanowa
## 2363  2362                  Citizen
## 2372  2371                    Titan
## 2373  2372                  Citizen
## 2374  2373                    Casio
## 2396  2395                 Maserati
##                                                                                                                                                                                          watch_name
## 119                                                                                                                             Casio Edifice EFK-100D-3ADR Automatic Analog Green Dial Men (ED671)
## 128                                                                                                                         Seiko Analog Stainless Steel Blue Dial Silver Band Men's Watch-SSK003K1
## 184                                                                                                                    Seiko Stainless Steel Analog Green Dial Men Watch-Srpd63K1, Bandcolor-Silver
## NA                                                                                                                                                                                             <NA>
## 307                                                                Titan Ceramic Fusion Automatic Anthracite Dial Two Toned Rose Gold and Grey Stainless Steel Bracelet Watch for Men - NT90174KD03
## 315                                                                                                    G-Shock GG-B100-1A3DR Bluetooth Analog-Digital Black Dial Men Watch Green Resin Strap (G973)
## 336                                                                                       G-Shock GST-B100-1ADR Metal Ip Black Analog Dial Black Resin Strap Men's Watch Tough Solar Bluetooth G789
## 426                                                                                                                   Citizen Automatic Gents Watch Light Blue Dial - NJ0151-88M-Tsuyosa Collection
## 469                                                                                 EDGE Titan Fusion Quartz Analog Black Dial Two Toned Black & Rose Gold Ceramic Strap Watch for Men - NT1878KD03
## 477                                                                                                                            Stainless Steel Analog Gray Dial Men's Watch-Dz7484, Band Color:Gray
## 495                                                                          Luxury Brand Stars Wheel Mechanical Automatic Mens Watch Super Luminous Leather Waterproof Creative Sport Watches DK-J
## 514                                                                                                                                          Analog Green Dial Men's Stainless Steel Watch-SSK035K1
## 525   Watches Men's Tonneau Skeleton Watch, Analog Display, Black Silicone Band, Automatic Self-Winding Movement, Luminous Hands, Exhibition Caseback, Adult, Sport Style, Barrel Shape, Mechanical
## 528                                                                                                                                             Stainless Steel Analog Blue Dial Men's Watch-AX2457
## 536                                                                                                                           Stainless Steel Analog Black Dial Men's Watch-Ax2458, Band Color:Gray
## 561        Luxury Automatic Mechanical Watch Original Men Watch with 3D Moon Phase Watch Dial Tourbillon Skeleton Men's Wrist Watch for Business, Dating, Casual, 6401F2-1, Business Casual Meeting
## 572                                                                                                                    Mr. Daddy 2 Multicolor Quartz Stainless Steel Watch Dz7486, Chronograph, Men
## 582                                                                                                                                                                              Blue Watch AR11696
## 600                                                                                                      Citizen Automatic Blue Dial Mens Watch NJ0151-88L, Analogue, Stainless Steel, Silver Strap
## NA.1                                                                                                                                                                                           <NA>
## 627                                                                                                                       Analog Light Blue Dial Men's Watch-SUR371P1 Stainless Steel, Silver Strap
## 638                                                                                                                                                 Titan Edge Squircle Men's Analog Watch-1841QC03
## 639                                                                                                                          Analogue Men's Stainless Steel Watch (Black Dial Yellow Colored Strap)
## 643                                                                                                                                                           Analog Green Dial Men's Watch-1513923
## 644                                                                                                                               Men Analogue Black Band Black Quartz Stainless Steel Watch AX2463
## 645                                                                                                                Edge Ceramic White Dial Analog Ceramic Strap watch for Men-NS1696QC04/NT1696QC04
## 653                                                                                                                                       Silicone Analog Black Dial Men Watch-Srpd76K1, Black Band
## 658                                                                                    Titan Edge Ceramic Dress with Diamonds Quartz Analog Blue Dial Blue Ceramic Strap Watch for Men - NT1696QC09
## 681                                                                                                                                                         Analog Green Dial Men's Watch-BQ2754SET
## 696                                                                                                           Emporio Armani Analog Blue Dial Men's Watch-AR11362 Stainless Steel, Multicolor Strap
## 713                                                                                                                                      Ultra Thin Black Dial Quartz Analog Watch - for Men UTBJ42
## 718                                     Automatic Mechanical Watch Skeleton for MenWatch Titanium Steel 50M Waterproof Mens Wristwatch Luminous Analog Watches No Battery Silicone Strap,FM501 Blue
## 744                                                                                                                                                                           Gunmetal Watch AX4195
## 748                                                                                                                                            Titan Anthracite Dial Analog Watch for Men-90162QM01
## 775                                                                                                                                                     x Nick Jonas Machine Luxe Gold Watch LE1218
## 798                                                                                                                   Automatic Grey Dial Grey Stainless Steel Strap Watch for Men - KCWGY0064401MN
## 810                                                                    Titan Ceramic Fusion Automatic Black Dial Two Toned Silver Stainless Steel & Black Ceramic Strap Watch for Men - NT90175KD01
## 811                                                                                                                                         Seiko 5 Sports Automatic Black Dial Mens Watch SRPG27K1
## 842                                                                                                                       Seiko Analogue Blue Dial Silver Band Men's Stainless Steel Watch-SRPJ45K1
## 844                                                                                                                         Stainless Steel Analog Green Dial Men's Watch-Me3262, Band Color:Silver
## 851                                                                                                                   Edge Ceramic Analog Black Dial Men's Watch-NM1696NC01 / NL1696NC01/NP1696NC01
## 858        Watches for Men Automatic Skeleton Watch Waterproof Sapphire Crystal 5ATM Waterproof Wristwatch Anti Shock Luminous Display Business Wristwatch Silicone Strap, FM511, Multicolor, Strap
## 861                                                                                                  Edifice ECB-2000NP-1ADF Bluetooth Analog-Digital Black Dial Men Watch Blue Resin Strap (ED610)
## 902                                                                                                                           PRX Blue Dial Men's Watch-T1374101104100 (Dial Blue, Silver Bracelet)
## NA.2                                                                                                                                                                                           <NA>
## 930                                                                               CA4664-60W Chronograph Eco-Drive Men's Watch – Gold-Tone Stainless Steel Case & Band,Sapphire Crystal, Green Dial
## 935                                                                                                          Titan Edge Ceramic Green Dial Analog Ceramic Strap watch for Men-NS1696QC06/NT1696QC06
## NA.3                                                                                                                                                                                           <NA>
## 952                                                                                                                        Analog Stainless Steel Black Dial and Band (Big dial) Men's Watch-DZ7395
## 960                                                                                                    Jet Mechanical Automatic Watch for Men with Round Dial & Water Resistant Man's Wrist Watches
## 1030                                                                                                                              G-Shock MTG-B2000YST-1ADR Bluetooth Analog Black Dial Men (G1645)
## 1034                                                                                                                        Emporio Armani Leather Analog Silver Dial Men Watch-Ar60007, Black Band
## 1048                                                                                                                                                      Analog Multicolor Dial Men's Watch-DZ7492
## 1060                                                                                                                            Seastar Chronograph Quartz Blue Dial Men's Watch T120.417.11.041.03
## 1078                                                                                                                    PRX Black Dial Men's Watch T137.410.11.051.00 (Black dial, Silver Bracelet)
## 1109                                                                                                                                                       Analog Rose Gold Dial Men's Watch-I13101
## 1122                                                                                                                                         Stainless Steel Analog Black Dial Men's Watch-Ssc773P1
## 1128                                                                                                                                                                            Black Watch AR70015
## 1130      Men's Automatic Watch Tonneau Luxury Skeleton Watches for Men Mechanical 50M Waterproof Analogue Watches Mens Unique Cool Silver Square Big Face Dial Wristwatch with Silicone Strap Band
## 1133                                                                                    Titan Maritime Automatic Anthracite and Brown Bi-Colour Dial Brown Leather Strap Watch for Men - NT1793KL02
## NA.4                                                                                                                                                                                           <NA>
## 1192                                                                                                                              Seiko Nylon Analog Black Dial Men Watch-Srpd71K2, Bandcolor-Black
## 1205                                                                                                                 Stainless Steel Coutura Analog Black Dial Men Watch-Ssc764P1, Bandcolor-Silver
## 1207                                                                                                                                                         PR516 Chronograph Watch T1494172205101
## 1208                                                                      G-Shock GWG-B1000-3ADR Gray IP Analog-Digital Dial Military Green Resin Strap Men's Watch Mud Resistant Tough Solar G1472
## 1219                                                                                                                                       Analog Black Dial Men's Watch-1696KC01, Blaxk/NP1696KC01
## 1247        Xenith Automatic Men’s Watch – 39mm Skeleton Dial, Miyota 82S7 Japanese Automatic Watch, Black Stainless Steel Case, Deep-Green Silicone Strap, Butterfly Clasp, 10ATM Water Resistance
## 1266                                                                                                             EDGE Titan Bicolour Quartz Analog Green Dial and Green Ceramic Strap Watch for Men
## 1269                                                                                                                                                         Analog Silver Dial Men's Watch-AR60092
## 1297                                                               EDGE Titan Ceramic Dress with Diamonds Quartz Analog Black Dial Two Toned Black & Brown Ceramic Strap Watch for Men - NT1696KC02
## 1298                                                                                                                                                        $KELETON Men's Automatic Analogue Watch
## 1300                                                                                                                                        Mr. Daddy Slim Gold Quartz Stainless Steel Watch DZ7490
## 1301                                                                                                                                                         Analog Black Dial Men's Watch-14602681
## 1308                                                                                                                                           Black Dial Multifunction Leather Strap Watch for Men
## NA.5                                                                                                                                                                                           <NA>
## 1340                                                              Waterbury Heritage Analog Black Round Dial & Silver Stainless Steel Bracelet Band Water Resistant Men's Wrist Watch - TW2Y24000IK
## 1344                                                                                                                                         Analog White Dial Men's Stainless Steel Watch - MK8344
## 1349                                                                                                                 Seiko Stainless Steel Analogue Cream Dial Men Watch-Srpk31K1, Bandcolor-Silver
## NA.6                                                                                                                                                                                           <NA>
## 1394                                                                                                                     Stainless Steel Analog Black Dial Men's Watch-Ax2456, Band Color:Rose Gold
## NA.7                                                                                                                                                                                           <NA>
## 1410                                                                                                        Stainless Steel 5 Sports Field Deploy Automatic Analogue Watch for Men-Ssk023K1, Silver
## 1411                                                                                                           Titan Regalia Stellar Automatic Malachite Dial Leather Strap Watch for Men-10008TL01
## NA.8                                                                                                                                                                                           <NA>
## 1419                                               G-Shock GWG-2000-1A3DR Gray IP Multi-Coloured Analog-Digital Dial Military Green Resin Strap Men's Watch Mud Resistant Barometer Altimeter G1176
## 1420                                                                                       Titan Wine Ceramic Quartz Analog Maroon Dial Ceramic Strap Watch for Men | Analog Men's Watch - 1696QC19
## 1421                                                      G-Shock GM-B2100D-1ADR Stainless Steel Bezel Black Analog-Digital Dial Stainless Steel Solid Band Men's Watch Tough Solar Bluetooth G1270
## NA.9                                                                                                                                                                                           <NA>
## 1435                                                                                                                                                Mr. Daddy 2 Analog Gold Dial Men's Watch-DZ7479
## NA.10                                                                                                                                                                                          <NA>
## 1459                                                                                                                                                          Analog Black Dial Men's Watch-AR11680
## 1468                                                                                                                                                         Analog Green Dial Men's Watch-SUR377P1
## 1469                                                                                                                                                                             Black Watch AX4196
## 1476                                                                                                             SMWGL0005402 Master DILIGENTER - Swiss Made Round Silver Automatic - Watch for Men
## NA.11                                                                                                                                                                                          <NA>
## 1500                                                                                                                                                           5 Sports 38mm Automatic Skx SRPL77K1
## 1514                                                         G-Shock GM-B2100BD-1ADR Black IP Black Analog-Digital Dial Black IP Stainless Steel Solid Band Men's Watch Tough Solar Bluetooth G1271
## 1515                                                                                Watches for Men Automatic Mechanical Luxury Flywheel Watch 3D Double Globe Stainless Steel Case Men Wrist Watch
## 1526                                                                                                                                                                           Silver Watch AR11681
## NA.12                                                                                                                                                                                          <NA>
## NA.13                                                                                                                                                                                          <NA>
## 1592                                                                                                        Stainless Steel Chronograph Quartz Watch for Men- Ssb445P1, Blue Dial, Bandcolor-Silver
## NA.14                                                                                                                                                                                          <NA>
## 1611                                                                                                                            Analog Black Dial Men's Watch-SSC573P1 Stainless Steel, Black Strap
## 1618                                                                                                                   Avalanche Green Round Dial Swiss Made Automatic Watch for Men | SMWGL0006902
## 1627                                                                                                         Damask Legends Iron Black Round Dial Swiss Made Automatic Watch for Men | SMWGL0007030
## 1632                                                                                                                                         Analog White Dial Men's Stainless Steel Watch-SSK033K1
## 1641                                                                                                                                            Sfida Analog Dial Color Blue Men Watch- R8823140013
## 1654                                   Design Men's Luxury Watch, Stainless Steel Case, Quartz Movement, Rubber Strap, 30M Water Resistant Timepiece, Skeleton Dial, 2 Years Warranty - R8871642003
## 1680                                                                                                                                                          Analog Green Dial Men's Watch-AR60091
## 1706                                                                                                                                      Black Dial Chrono Quartz 46 mm Dial Men Watch - VE6CA0623
## 1712                                                                                                                                 PR 100 Chronograph Quartz Blue Dial Men's Watch T1504171104100
## 1716                                                                                                     Stainless Steel Modern Courier Analog Black Dial Unisex's Watch-Bq2400Set, Band Color:Gold
## 1727                                                                                                                                        Seiko Aluminium Analog Orange Dial Men's Watch-Ssk005K1
## NA.15                                                                                                                                                                                          <NA>
## 1731             Journey 1884, Swiss Made Men's Analog Watch, Black Dial, 43 Mm, Water Resistant Up To 200 M, Quartz Movement, Stainless Steel Case, Wrist Watch For Men | 242014, Band Color:Brown
## 1749                                                                                                                                                    Silver Quartz Stainless Steel Watch AR11676
## NA.16                                                                                                                                                                                          <NA>
## 1767                                                                                                                      Sports Automatic Gold Dial Men's Watch SSK044, SSK044K1 (Limited Edition)
## 1828                                                                                                                Automatic Brown Dial Brown Stainless Steel Strap Watch for Men - KCWGY0046501MN
## 1838                                                                                                                           Analog Black Dial Men's Watch-SSB345P1 Stainless Steel, Silver Strap
## 1841                                                                                                                     Stainless Steel Analog Blue Dial Men's Watch-Nk5010-51L, Band Color-Silver
## 1851                                                                                                                       Stainless Steel Analog White Dial Men Watch-Nh9136-88A, Multi-Color Band
## 1855                                                                                                   Kenneth Cole Automatic Analog Green Dial Green Silicon Strap Watch for Men - KCWGZ0076803MNW
## 1860                                                                                                                                                PRX Quartz Gold Dial Men's Watch T1374103302100
## 1867                                                                                                                   Stainless Steel Spiked Analog Silver Dial Men Watch-Dz4629, Multi-Color Band
## 1873                                                                                                                          Stainless Steel Analog Green Dial Silver Strap Men's Watch-Nk5010-51X
## NA.17                                                                                                                                                                                          <NA>
## 1920                                                                                    Mechanical Automatic Watches World Time Watch Men Business Mechanical Wrist Watch Leather Strap Blue Planet
## 1937                                                                                                                          Casio G-Shock GMC-B2100D-1ADR Bluetooth Analog Black Dial Men (G1631)
## 1952                                                                                                                                      Fenmore Multicolor Quartz Stainless Steel Watch BQ2900SET
## 1962                                                                                                                             Leather Analog White Dial Men's Watch-Ca4593-15A, Band Color-Brown
## 1964                                                                                                Master DILIGENTER Green Round Dial Comes with Swiss Made Automatic Watch for Men | SMWGL0005412
## 1974                                                                                                                                    Couturier Chronograph Black Dial Men's Watch T0356171105100
## 1975                                                                                                                                    PRS 516 Automatic Black Dial Men's Watch T100.430.11.051.00
## NA.18                                                                                                                                                                                          <NA>
## 1997             Journey 1884, Swiss Made Men's Analog Watch, Black Dial, 43 Mm, Water Resistant Up To 200 M, Quartz Movement, Stainless Steel Case, Wrist Watch For Men | 242014, Band Color:Brown
## 2001                                                                                                                                                       Automatic White Dial Men's Watch-H9030AI
## 2009                                                                                                                          Casio G-Shock GMC-B2100AD-2ADR Bluetooth Analog Blue Dial Men (G1630)
## 2011                        FM507 Men's Automatic Skeleton Black Analog-Digital Watch Mechanical Calendar Mens Black Wristwatch Square Sport Luminous Clock Watches 10ATM Waterproof Watches, Sport
## 2035                                                                                                                                                          Analog Grey Dial Men's Watch - MK8561
## 2038                                                                            Stainless Steel Men's Mr. Daddy 2.0 Dz7370 Red Silicone Japanese Quartz Fashion Analog Watch, Dial_ Black, Band_Red
## 2039                      Premium Stylish Men’s Watch | Elegant Analog Timepiece with Leather Strap | Perfect for Office, Party & Casual Wear | Scratch Resistant Dial | Trendy Gift Choice for Men
## 2045                                                                                                                         Seastar 1000 Chronograph Blue Gradient Dial Men's Watch T1204171104101
## 2050                                                                                                                                  GMT SSK031K1 Red Dial Limited Edition Automatic Watch for Men
## 2052                                                                                                                                          Stainless Steel Analog Black Dial Men's Watch-Ar11242
## 2059                                                Seiko Limited Edition India Exclusive Blue Dial Men's Analog Watch, Stainless Steel Band, with Extra Silicon Strap- Srpk81K1, Band Color:Silver
## NA.19                                                                                                                                                                                          <NA>
## 2071                                                                                                                                            Chrono Classic 41 mm Silver Dial Men Watch - 241509
## 2072                                                                                                               SMWGL0005530 Dark Night - Swiss Made Round Musou Black Automatic - Watch for Men
## 2077                                                                                                                                                                     Callum Black Watch MKO1242
## NA.20                                                                                                                                                                                          <NA>
## 2101                                                                                                                                     Seastar Automatic Powermatic 80 Men's Watch T1204071109101
## 2113                                                                                                                                                                            Green Watch AR70017
## 2117                                                                                                                              Stainless Steel Analog Gray Dial Men Watch-Nj0154-80H, Black Band
## 2132                                                                                                                                       Mens Chronograph Stainless Steel Watch (Black_Free Size)
## 2145                                                                                                                                                   Analog Gray Dial Men's Ceramic Watch-Ar70010
## 2153                                                                                                                                                                        Watches Lexington Watch
## 2158                                                                                                                         Automatic Grey Dial Brown Leather Strap Watch for Men - KCWGX0046203MN
## 2163                                                                                                       SWISS MILITARY HANOWA SMWGC0000302 - Swiss Made Round Silver Chronograph - Watch for Men
## NA.21                                                                                                                                                                                          <NA>
## 2182                                                                                                                                                     GC Analog Blue Dial Men's Watch-Z51001G7MF
## 2222                                                                                                                                    Metal Analog Grey Dial Men Watch-Ssc376P9, Bandcolor-Silver
## 2224                                                                                                                               T-Sport Chronograph Quartz Green Dial Men's Watch T1166172209100
## 2225                                                                                                                       Capstone Black Round Dial Mechanical Automatic Men's Watch - TW2Y39600UJ
## 2233                                                                                                          SMWGL0002001-SET - Swiss Made Round Black Automatic Watch for Men with Spare Bracelet
## 2246                                                                                                                                      Seastar Chronograph Green Dial Men's Watch T1204171109101
## NA.22                                                                                                                                                                                          <NA>
## NA.23                                                                                                                                                                                          <NA>
## 2257                       Sport Men's Luxury Watch, Stainless Steel Case, Automatic Movement, Stainless Steel Strap, 100M Water Resistant Timepiece, Skeleton Dial, 2 Years Warranty - R8823140011
## NA.24                                                                                                                                                                                          <NA>
## 2285                                                                                              Stainless Steel Lifestyle Day-Date Analog Dial Color Blue Men Watch - R8823100001, Rose Gold Band
## 2296                                                                                                                              Leather Analog Grey Dial Men's Watch-Nk5010-01H, Band Color-Black
## 2308                                                                                                                                                                             Blue Watch AR70016
## 2317                            Design Men's Luxury Watch, Stainless Steel Case, Quartz Movement, Stainless Steel Strap, 100M Water Resistant Timepiece, Black Dial, 2 Years Warranty - R8873642001
## 2319                                                                                                                                                                     5 Sports Yellow - SRPL87K1
## NA.25                                                                                                                                                                                          <NA>
## 2337                                                                                                                                  DILIGENTER Olive Round DIAL Analog Watch for Men SMWGL0002103
## 2341                          Lifestyle Men's Luxury Watch, Stainless Steel Case, Quartz Movement, Stainless Steel Strap, 100M Water Resistant Timepiece, Blue Dial, 2 Years Warranty - R8873600007
## 2354                                                                                                                       SMWGI0004303 - Swiss Made Square Dial Silver Chronograph - Watch for Men
## 2363                                                                                Eco-Drive Analog Mens Stainless Steel Watch Powered by Light -Beginning Blue - Eco Drive Chronograph-CA4500-83M
## 2372                                                                       Titan Stellar Quartz Green Shaped Dial Men's Watch | Stainless Steel Strap Material | Watches for Men Analog - 10053QM01
## 2373                                                                                             Eco-Drive Analog Mens Stainless Steel Watch Powered by Light - Octagon Shape Collection-BM7633-81X
## 2374                                                                                                                                           G-Shock GW-5000HS-1DR Digital Black Dial Men (G1670)
## 2396                              Sport Men's Luxury Watch, Stainless Steel Case, Quartz Movement, Stainless Steel Strap, 100M Water Resistant Timepiece, Blue Dial, 2 Years Warranty - R8873612054
##       rating number_of_reviews  price                    brand
## 119      4.3                19  25995                    Casio
## 128      4.5              1.1K  40500                    Seiko
## 184      4.6              4.9K  27000                    Seiko
## NA        NA              <NA>     NA                     <NA>
## 307      4.2                52  26725                    Titan
## 315      4.6               179  24796                    Casio
## 336      4.5               209  24994                    Casio
## 426      4.5              1.3K  31410                  Citizen
## 469      5.0                 6  24645                     EDGE
## 477      4.0                 8  27996                   Diesel
## 495      4.2                    74978                   OBLVLO
## 514      4.4               114  40500                    Seiko
## 525      4.2                    66916                  BRETLEY
## 528      4.1                21  23995          Armani Exchange
## 536      4.5                24  23995          Armani Exchange
## 561      5.0                 1  55434                 AGELOCER
## 572      4.2                 9  40994                   Diesel
## 582      5.0                 3  25995           Emporio Armani
## 600      4.6               117  35009                  Citizen
## NA.1      NA              <NA>     NA                     <NA>
## 627      4.5               107  24300                    Seiko
## 638      3.6                25  37395                    Titan
## 639      4.6                28  54000                    Seiko
## 643      4.3                29  25661                     BOSS
## 644      4.7                 8  23991          Armani Exchange
## 645      4.6                72  26276                    Titan
## 653      4.2               207  29700                    Seiko
## 658      4.2                19  25197                     EDGE
## 681      5.0                 4  26995                   Fossil
## 696      4.0               100  27994           Emporio Armani
## 713      4.2                    31499                D1 Milano
## 718      4.2                    36999                    FEICE
## 744      5.0                 2  24495          Armani Exchange
## 748      4.5                12  28495                    Titan
## 775      4.0                 2  23948                   Fossil
## 798      4.2                    24999             KENNETH COLE
## 810      4.2                32  27994                    Titan
## 811      4.4               298  27000                    Seiko
## 842      4.5               388  27000                    Seiko
## 844      4.4                24  24494                   Fossil
## 851      4.1               149  27815                    Titan
## 858      4.3                39  24999                    FEICE
## 861      4.2                15  23994                    Casio
## 902      4.2                    37000                   TISSOT
## NA.2      NA              <NA>     NA                     <NA>
## 930      4.4                12  52110                  Citizen
## 935      2.8                16  27595                    Titan
## NA.3      NA              <NA>     NA                     <NA>
## 952      4.0               389  27996                   Diesel
## 960      4.5                11  26995                    TIMEX
## 1030     4.7                 4  94995                    Casio
## 1034     4.0                44  32495           Emporio Armani
## 1048     4.4                 8  24796                   Diesel
## 1060     4.2                    49900                   TISSOT
## 1078     4.2                    33995           Tissot(ティソ)
## 1109     4.5                11  31620                Ingersoll
## 1122     4.3                78  37800                    Seiko
## 1128     4.2                    27995           Emporio Armani
## 1130     4.3               357  31975               TSAR BOMBA
## 1133     4.3                87  23995                    Titan
## NA.4      NA              <NA>     NA                     <NA>
## 1192     4.1               364  27000                    Seiko
## 1205     4.2                 7  46800                    Seiko
## 1207     4.2                    52000           Tissot(ティソ)
## 1208     5.0                 8  52195                    Casio
## 1219     4.0                14  28795                    Titan
## 1247     4.2                    28608                  Tornado
## 1266     4.4                43  28796                     EDGE
## 1269     5.0                 1  27994           Emporio Armani
## 1297     5.0                 5  34395                     EDGE
## 1298     4.6                11  72500            Philipp Plein
## 1300     4.5                 2  32494                   Diesel
## 1301     4.2                    26763                    COACH
## 1308     4.2                    29295                   Police
## NA.5      NA              <NA>     NA                     <NA>
## 1340     4.2                    24995                    TIMEX
## 1344     4.5              1.4K  24494             Michael Kors
## 1349     4.5               203  29700                    Seiko
## NA.6      NA              <NA>     NA                     <NA>
## 1394     4.3                 8  23995          Armani Exchange
## NA.7      NA              <NA>     NA                     <NA>
## 1410     4.4                57  40500                    Seiko
## 1411     3.3                 7  64994                    Titan
## NA.8      NA              <NA>     NA                     <NA>
## 1419     4.7                21  65994                    Casio
## 1420     5.0                 1  27996                    Titan
## 1421     4.2                17  38395                    Casio
## NA.9      NA              <NA>     NA                     <NA>
## 1435     4.3                38  34995                   Diesel
## NA.10     NA              <NA>     NA                     <NA>
## 1459     5.0                 1  27995           Emporio Armani
## 1468     4.4                81  26100                    Seiko
## 1469     4.2                    24495          Armani Exchange
## 1476     5.0                 2  53130    Swiss Military Hanowa
## NA.11     NA              <NA>     NA                     <NA>
## 1500     4.2                    27000                    Seiko
## 1514     3.7                10  49995                    Casio
## 1515     4.4                18  30313                  SEAKOSS
## 1526     4.0                 5  27995           Emporio Armani
## NA.12     NA              <NA>     NA                     <NA>
## NA.13     NA              <NA>     NA                     <NA>
## 1592     4.5                39  28800                    Seiko
## NA.14     NA              <NA>     NA                     <NA>
## 1611     4.0                20  54000                    Seiko
## 1618     4.2                    82575    Swiss Military Hanowa
## 1627     4.2                   185000    Swiss Military Hanowa
## 1632     4.2                25  40500                    Seiko
## 1641     4.2                    50288                 Maserati
## 1654     4.8                 9  25128                 Maserati
## 1680     1.0                 1  27995           Emporio Armani
## 1706     4.2                    99260                  Versace
## 1712     4.2                    33800                   TISSOT
## 1716     4.3               104  26995                   Fossil
## 1727     4.3               170  40500                    Seiko
## NA.15     NA              <NA>     NA                     <NA>
## 1731     5.0                 2  57600               Victorinox
## 1749     4.2                    27995           Emporio Armani
## NA.16     NA              <NA>     NA                     <NA>
## 1767     4.2                    40000          Seiko(セイコー)
## 1828     5.0                 2  25999             KENNETH COLE
## 1838     4.6               169  24300                    Seiko
## 1841     4.6               136  40410                  Citizen
## 1851     4.7                 2  34110                  Citizen
## 1855     4.2                    25999             KENNETH COLE
## 1860     4.2                    45000                   TISSOT
## 1867     4.9                33  24495                   Diesel
## 1873     4.6                27  40410                  Citizen
## NA.17     NA              <NA>     NA                     <NA>
## 1920     5.0                 3  86152                 AGELOCER
## 1937     5.0                 2  47995                  G-Shock
## 1952     4.2                    26995                   Fossil
## 1962     4.9                25  28710                  Citizen
## 1964     4.2                    89250    Swiss Military Hanowa
## 1974     4.2                    44700                   TISSOT
## 1975     4.2                    81000                   TISSOT
## NA.18     NA              <NA>     NA                     <NA>
## 1997     5.0                 2  57600               Victorinox
## 2001     5.0                 1  67000            Mathey-Tissot
## 2009     5.0                 6  53999                  G-Shock
## 2011     4.0                42  26999                    FEICE
## 2035     4.6               469  24495             Michael Kors
## 2038     4.4                 6  36995                   Diesel
## 2039     4.2                    49971                  TIKORRA
## 2045     5.0                 2  54000                   TISSOT
## 2050     4.2                    42000          Seiko(セイコー)
## 2052     4.4                25  27994           Emporio Armani
## 2059     4.0                39  28800                    Seiko
## NA.19     NA              <NA>     NA                     <NA>
## 2071     5.0                 5  32470               Victorinox
## 2072     5.0                 2  64308    Swiss Military Hanowa
## 2077     4.2                    36995             Michael Kors
## NA.20     NA              <NA>     NA                     <NA>
## 2101     5.0                 1  70900                   TISSOT
## 2113     4.2                    26995           Emporio Armani
## 2117     4.2                17  37709                  Citizen
## 2132     4.4                1K  26995           Emporio Armani
## 2145     4.2                 5  27997           Emporio Armani
## 2153     4.7               844  24495             Michael Kors
## 2158     4.2                    23995             KENNETH COLE
## 2163     5.0                 1  32274 Swiss Military by Chrono
## NA.21     NA              <NA>     NA                     <NA>
## 2182     5.0                 1  53995            Guess Watches
## 2222     3.5                15  46800                    Seiko
## 2224     4.2                    39700           Tissot(ティソ)
## 2225     4.2                    27995                    TIMEX
## 2233     4.2                    80850    Swiss Military Hanowa
## 2246     4.2                    55250           Tissot(ティソ)
## NA.22     NA              <NA>     NA                     <NA>
## NA.23     NA              <NA>     NA                     <NA>
## 2257     4.9                12  30925                 Maserati
## NA.24     NA              <NA>     NA                     <NA>
## 2285     4.7                 4  28930                 Maserati
## 2296     4.4                59  42210                  Citizen
## 2308     4.2                    26995           Emporio Armani
## 2317     4.2                29  24029                 Maserati
## 2319     5.0                 1  31500                    Seiko
## NA.25     NA              <NA>     NA                     <NA>
## 2337     4.2                 7  46796    Swiss Military Hanowa
## 2341     3.6                 3  24029                 Maserati
## 2354     5.0                 1  36750    Swiss Military Hanowa
## 2363     5.0                 1  31365                  Citizen
## 2372     5.0                 1  32995                    Titan
## 2373     3.5                 4  25564                  Citizen
## 2374     4.8                 6  24494                    Casio
## 2396     5.0                11  25128                 Maserati
boxplot(data$price, main="Boxplot Harga")

data$price[data$price < lower_bound] <- lower_bound
data$price[data$price > upper_bound] <- upper_bound
boxplot(data$price)