FSD PROJECT
Perbandingan Peluang Terjualnya Produk Sepatu dari berbagai Local Brand
Kenapa Kita Memilih Topik Ini?
Maraknya brand local sepatu asal indonesia yang akhir=akhir ini muncul membuat kita tertarik untuk menganalisa data tentang peluang terjual nya sepatu ini di masyarakat. Dengan melakukan scrapping data dari salah satu ecomerce terbesar yang ada di indonesia kami berharap data yang kami olah relevan sehingga mampu menggambarkan penjualan produk-produk sepatu local indonesia ini. Data ini juga dapat digunakan penjual untuk melihat di cluster mana produk yang mereka jual. Sehingga dapat menyusun strategi marketing produk sepatu tersebut untuk menaikan profit penjualan mereka.
import pandas as pd
data = pd.read_csv("Data-Sepatu-BrandLocal.csv")
data
Product Nameobject
Compass Retrograde Slip On Cream - 380.6%
Compass Linen Low Sand - 380.6%
177 others98.9%
Priceint64
20000 - 738000
20
Compass Retrograde Low Double Black - 36
538000
21
Compass Gazelle Low Cream - 44
348000
22
Compass Retrograde Hi Decon Cream - 40
568000
23
Compass Gazelle Hi White Blue - 44
388000
24
Compass Retrograde Hi Decon Black White - 39
568000
25
Compass Retrograde Hi Decon Double Black - 37
568000
26
Compass Linen Low Dusk - 41
538000
27
Compass Paracenamoy Low - 40
738000
28
Compass Retrograde Slip-On Black - 27s9i5LU0B - 36
458000
29
Compass Retrograde Slip-On Black - 41W92kIK3O - 37
458000
data_filtered = data[['Product Name','Sold', 'Views']]
data_filtered[:8]
Product Nameobject
Soldint64
0
Compass Retrograde Slip On Cream - 38
1539
1
Compass Linen Low Sand - 38
1226
2
Compass Gazelle Hi White Red - 40
2350
3
Compass Retrograde Low Black White - 35
5053
4
Compass Gazelle Low White Red - 39
3908
5
Compass Linen Hi Ash - 39
370
6
Compass Retrograde Slip On Green/Blue - 38
1053
7
Compass Retrograde Low Baby Blue - 35
1362
Di sini dapat terlihat persebaran yang didapatkan dari ploting menggunakan data 'Views' dan 'Sold'
data_filtered.plot.scatter(x='Views', y='Sold')
data_array = data_filtered.values # dari pandas dataframe ke numpy array
from sklearn.cluster import KMeans
kmeans = KMeans(n_clusters=3, random_state=2) # random seed
X = data_array[:, 1:] # semua baris, dari kolom 1 sampai akhir
kmeans.fit(X)
centroid = kmeans.cluster_centers_
label = kmeans.labels_
label
data_filtered.plot.scatter(x='Views', y='Sold', c=label, colormap='Set1')
import matplotlib.pyplot as plt
#ini adalah produk dengan kemungkinan jual rendah (merah)
for i in range(len(data_array)):
if label[i]==0:
print(data_array[i][0])
Compass Linen Low Sand - 38
Compass Linen Hi Ash - 39
Compass Linen Hi Ocean - 39
Compass Retrograde Hi Decon Cream - 40
Compass Gazelle Hi White Blue - 44
Compass Linen Low Dusk - 41
Compass Retrograde Slip-On Black - 27s9i5LU0B - 36
Compass Retrograde Slip-On Black - 41W92kIK3O - 37
Compass Retrograde Low Black White - f5M483x9sL - 43
Compass Gazelle Hi Black White - W1P60aX8f9 - 43
Compass Retrograde Low Black White - 1mCP4723Wy - 36
Compass Retrograde Low Black White - Y8y0K1i97e - 40
Compass Retrograde Low Black White - p7n26QRi49 - 35
Compass Gazelle Hi Black White - x10rQ94XR2 - 39
Compass Gazelle Low Matcha Blue - c094E5m3Bw - 39
Compass Gazelle Hi Black White - 68jM1XBE43 - 38
Compass Gazelle Low Matcha Blue - V41TOGc286 - 35
Compass Gazelle Hi Black White - 9187OpSB3f - 43
Compass Gazelle Hi Black White - 3dUDrj7219 - 38
Compass Gazelle Low Matcha Blue - 34w5OhU1Q8 - 34
Compass Gazelle Low Matcha Blue - dy47T61FM2 - 34
Compass Gazelle Hi Black White - Bf7W024Td3 - 42
Compass Retrograde Low Black White - 6Ow8Rv0T42 - 35
Compass Xpresi Low Anastasia - s79hE4K6e2 - 44
Compass Gazelle Low Black White - E6P5HD72t0 - 40
Compass Gazelle Low Black White - 5lj2F96yI7 - 40
Compass Gazelle Low Black White - 69O5lw8Xr0 - 43
Compass Retrograde Low Blue/Gum - 089GC16YPT - 35
Compass Gazelle Low Black White - 4zB315x6wf - 40
Compass Gazelle Hi Matcha Blue - W0l9H81N6j - 34
Compass Retrograde Low Black White - R0b9h5Z81c - 35
Compass Gazelle Low Black White - 60y87RuWC4 - 42
Compass Gazelle Low Black White - O92p6J7N8s - 43
Compass Gazelle Low Black White - 4g2PL581FQ - 40
Compass Gazelle Low Black White - jl32g7o6V5 - 37
Compass Gazelle Low Black White - 684ZiO0M2J - 40
Compass Gazelle Low Black White - 430W71TauM - 40
Compass Gazelle Low Black White - 02UVv375Zd - 43
Compass Gazelle Low Black White - 91E024BYAz - 41
Compass Gazelle Low Black White - 73r46Hd5ln - 40
Compass Gazelle Low Black White - W68rCG190g - 40
Compass Gazelle Hi Black White - N73Ca10b8T - 38
Compass Xpresi Hi Syafrudin - M702mTO54q - 42
Compass Retrograde Hi Cream - C7F234mR9E - 35
Compass Retrograde Low Cream - o31V60ag4i - 43
Compass Retrograde Low Cream - J4H9y1ld76 - 41
Compass Gazelle Low Black White - 9756URHh4l - 43
Compass Retrograde Low Cream - 5CAN203Gr1 - 39
Compass Retrograde Low Cream - 37n49B0TPA - 37
Compass Gazelle Low Black White - 17K9i5JW2u - 38
Compass Retrograde Low White/Blue - 328vmu5j40r - 37
Compass Retrograde Low Cream - Y3BN7fK581 - 35
Compass Gazelle Low Black White - 4JaL326E9M - 40
Compass Retrograde Low Cream - oG0532btB8 - 42
Compass Retrograde Low Cream - NM9F40G15E - 38
Compass Xpresi Low Yoshua - PMx4S68h15 - 36
Compass Retrograde Low White/Blue - fRa1736xz8 - 38
Compass Xpresi Low Yoshua - 5qY78D4H9U - 36
Aerostreet 36-45 Osaka Putih - Sepatu Sneakers Sport 21HH20 - 41
Aerostreet 36-40 Rin Putih Fushia - Sepatu Sneakers Sport 21II01 - 37
Aerostreet 36-40 Osaka Mint Silver - Sepatu Sneakers Sport 21HH19 - 38
Aerostreet 36-45 Osaka Abu Navy - Sepatu Sneakers Sport 21HH20 - 37
Aerostreet 36-45 Comfy Kuning - Sepatu Slip On Slop Pria Wanita 21GG24 - 41
Aerostreet 36-45 Comfy Maroon - Sepatu Slip On Slop Pria Wanita 21GG24 - 38
Aerostreet 35-38 Enzo Navy - Sepatu Sneakers Casual Sport Pria Wanita - 35
Aerostreet 39-42 Gowes Abu Merah -Sepatu Sport Pria Wanita Aero - 39
Aerostreet 39-42 Gowes-V Navy Neon -Sepatu Sport Pria Wanita Aero - 39
Aerostreet 36-40 Rin Abu Toska - Sepatu Sneakers Sport 21II01 - 38
Aerostreet 39-42 Gowes-V Navy Merah -Sepatu Sport Pria Wanita Aero - 39
Aerostreet 36-45 Brave Low Putih - Sepatu Sneakers Casual 21AA30 - 37
Aerostreet 36-45 Hoops Putih Gum - Sepatu Sneakers Casual Aero 21JJ10 - 40
Aerostreet 36-40 Rose Putih Natural Pink - Sepatu Sneaker Sport 21JJ27 - 38
Aerostreet 36-40 Jennie Putih - Sepatu Sneakers Sport 2II16 - 38
Aerostreet 36-45 Hoops Low Gum White - Sepatu Sneakers Casual - 38
Aerostreet 37-44 Jhosse Low Navy - Sepatu Sneakers Casual Pria - 38
Aerostreet 36-45 Hoops Low Putih Hijau Tua - Sepatu Sneakers Casual - 37
Aerostreet 36-45 Hoops Low Merah Hitam - Sepatu Sneakers Casual - 37
Aerostreet 36-45 Hoops Putih Merah Hitam - Sepatu Sneaker Sport 21FF24 - 38
Aerostreet 36-40 Rose Putih Natural Hitam- Sepatu Sneaker Sport 21JJ27 - 38
Aerostreet 36-45 Massive Low Maroon - Sepatu Sneakers Casual 21AA30 - 37
Aerostreet 36-40 Rose Putih Natural Hijau- Sepatu Sneaker Sport 21JJ27 - 38
Aerostreet 36-45 Hoops Low Putih Biru Tua- Sepatu Sneakers Casual - 38
Patrobas Cloud Olive Sneakers - 36
Patrobas Equip High All Black Sepatu Casual - 38
Patrobas Equip White Gum Sneakers - 38
Patrobas Ivan All Black Sepatu Casual - 36
Patrobas Equip High Charcoal Sepatu Casual - 37
Patrobas Cloud Off White Sneakers - 37
Patrobas Equip Black White Sepatu Casual - 39
Patrobas Hugo High All Black Sepatu Casual - Hitam, 38
Patrobas Cloud Slip On Black White Sneakers - 36
Patrobas Isaac Charcoal Sepatu Casual - 37
Patrobas Hugo Low Grey Sepatu Casual - Abu-abu Muda, 39
Patrobas Cloud Slip On All Black Sneakers - 37
Patrobas Hugo Low All Black Sepatu Casual - Hitam, 37
Patrobas Isaac Navy Sepatu Casual - 37
Patrobas Cloud White Blue Sneakers - 36
Patrobas Cloud Black Gum Sneakers - 36
Patrobas NEW Ivan Triple White Sneakers - 38
Patrobas Ivan High All Black Sepatu Casual - 40
Patrobas Cloud Slip On Off White Sneakers - 38
Patrobas Cloud Slip On Olive Sneakers - 37
Patrobas Ivan High Charcoal Sepatu Casual - 39
Patrobas New Ivan High Triple White - 36
Patrobas Equip Maroon Sepatu Casual - 43
Patrobas Hawk Low Grey Sepatu Casual - Abu-abu Muda, 38
Patrobas NEW Ivan Black White Sneakers - 40
Patrobas Equip Charcoal Sepatu Casual - 38
Patrobas Equip Navy Sepatu Casual - 37
Patrobas Cloud Slip On Beige Sneakers - 37
Patrobas Cloud High Black White Sneakers - 36
Patrobas Equip High Black White Sepatu Casual - 39
Patrobas NEW Ivan All Black Sneakers - 39
Patrobas Equip All Black Sepatu Casual - 36
Patrobas New Ivan High Black White Sneakers - 37
Patrobas Hugo High Black Sepatu Casual - Hitam, 38
Patrobas Equip High Maroon Sepatu Casual - 39
Patrobas Equip High Navy Sepatu Casual - 39
Patrobas Ivan High Navy Sepatu Casual - 38
Patrobas Ivan Charcoal Sepatu Casual - 39
Patrobas Hugo High Grey Sepatu Casual - Abu-abu Muda, 37
Patrobas Cloud High Navy Sneakers - 38
Patrobas Hugo High Navy Sepatu Casual - Navy, 37
Patrobas Ivan High Maroon Sepatu Casual - 36
Patrobas Ivan Forest Sepatu Casual - 36
Patrobas Hugo Low Black Sepatu Casual - Hitam, 37
Patrobas Ivan High Forest Sepatu Casual - 38
Patrobas NEW Ivan Navy Sneakers - 36
Patrobas Ivan High Triple White Sneakers - 36
Patrobas Equip High White Gum Sneakers - 36
Patrobas Too Lavish - Triassic Low - 42
Patrobas Cloud High Off White Sneakers - 36
Patrobas Cloud High Olive Sneakers - 36
Patrobas Cloud White Red - 36
Patrobas Onic Yellow - 37
Patrobas Wasa - 38
Patrobas Cloud Olive Burn Survivor - 42
Patrobas Duke Black Sepatu Casual - Hitam, 38
Patrobas Carmel Khaki Sepatu Casual - , 37
#ini adalah produk dengan kemungkinan jual sedang (orange)
for i in range(len(data_array)):
if label[i]==1:
print(data_array[i][0])
Compass Retrograde Low Black White - 35
Compass Retrograde Low Baby Blue - 35
Compass Gazelle Low Black White - 45
Compass Retrograde Low Cream - 35
Compass Retrograde Low White Blue - 38
Aerostreet 36-45 Massive Low Hitam - Sepatu Sneakers Casual 21AA30 - 38
Aerostreet 36-45 Massive Low Hitam Hitam-Sepatu Sneakers Casual 21AA30 - 38
#ini adalah dproduk dengan kemungkinan jual tinggi (abu abu)
for i in range(len(data_array)):
if label[i]==2:
print(data_array[i][0])
Compass Retrograde Slip On Cream - 38
Compass Gazelle Hi White Red - 40
Compass Gazelle Low White Red - 39
Compass Retrograde Slip On Green/Blue - 38
Compass Retrograde Slip On Blue/Green - 37
Compass Gazelle Hi Black White - 44
Compass Retrograde Slip On Green - 36
Compass Retrograde Slip On Blue - 35
Compass Gazelle Low White Blue - 37
Compass Retrograde Slip On Black - 44
Compass Gazelle Hi Cream - 38
Compass Retrograde Hi Decon Baby Blue - 38
Compass Retrograde Low Double Black - 36
Compass Gazelle Low Cream - 44
Compass Retrograde Hi Decon Black White - 39
Compass Retrograde Hi Decon Double Black - 37
Compass Paracenamoy Low - 40
Aerostreet 40-43 Riku Navy Oranye - Sepatu Sneakers Sport 21HH31 - 41
Aerostreet 36-45 Massive Low Putih -Sepatu Sneaker Casual Sport 21AA30 - 38
Aerostreet 36-45 Aerofomz - Insole Sepatu Sneakers Pria Wanita Aero - 36
Aerostreet 36-45 Massive Hitam Hitam Gum -Sepatu Sneaker Casual 21HH23 - 37
Aerostreet 36-45 Osaka Abu Merah - Sepatu Sneakers Sport 21HH20 - 37
Aerostreet 37-44 Jhosse Low Hitam - Sepatu Sneakers Casual Pria - 38
Aerostreet 36-45 Massive Putih Gum - Sepatu Sneakers Casual 21HH23 - 37
Aerostreet 37-44 Jhosse Low Putih - Sepatu Sneakers Casual Pria Wanita - 38
Aerostreet 36-45 Comfy Putih - Sepatu Slip On Slop Pria Wanita 21GG24 - 43
Aerostreet 36-45 Massive Low Navy - Sepatu Sneakers Casual 21AA30 - 37
Aerostreet 36-45 Massive Hitam Gum - Sepatu Sneakers Casual 21HH23 - 37
Aerostreet 36-45 Hoops Hitam Gum - Sepatu Sneakers Casual Aero 21JJ10 - 37
Aerostreet 36-45 Hoops Army Gum - Sepatu Sneakers Casual Aero 21JJ10 - 37
Aerostreet 36-45 Tokyo Putih Army - Sepatu Sneakers Casual 21II210 - 37
Patrobas Ivan Black White Sepatu Casual - 38
Patrobas Ivan High Black White Sepatu Casual - 39