“webinar”/ “VOLUUM”/
Welcome to Our Community
Wanting to join the rest of our members? Feel free to sign up today.

Ask Me Anything What Does This Business Sell?

Discussion in 'Research and Intelligence' started by Graybeard, Jan 17, 2019.

  1. Graybeard

    Graybeard Well-Known Member affiliate

    5,166
    2,500
    113
    A: I have no real info :D
    • I came across this database for download -- what is it really about?
    • Did it come from one of those customer surveys that the cashier promotes with a prize give-a-way? IDK ...
    • Did some college kid upload his homework for his big data class 101 and invent this data for testing purposes :D <= could be!

    Regardless of the real source -- this is what you could do with this data
    this is the top 10% 40 of 400 (that is suspicious in itself -- even 100 number? LOL)

    My guess it that it is a fictional baby goods store or a toy store and
    >>2,Male,21,15,81 <<<he just got his first credit card and was helping his older sister out :p
    the data:

    echo 'CustomerID|Gender|Age|Annual Income (k$)|Spending Score (1-100)'
    && sed '1,40!d' mall_customers.csv
    _______________________________________________________________
    CustomerID|Gender|Age|Annual Income (k$)|Spending Score (1-100)
    ================================================
    12,Female,35,19,99
    20,Female,35,23,98
    146,Male,28,77,97
    186,Male,30,99,97
    128,Male,40,71,95
    168,Female,33,86,95
    8,Female,23,18,94
    142,Male,32,75,93
    164,Female,31,81,93
    34,Male,18,33,92
    42,Male,24,38,92
    174,Male,36,87,92
    124,Male,39,69,91
    194,Female,38,113,91
    150,Male,34,78,90
    180,Male,35,93,90
    156,Female,27,78,89
    136,Female,29,73,88
    152,Male,39,78,88
    184,Female,29,98,88
    30,Female,23,29,87
    144,Female,32,76,87
    176,Female,30,88,86
    182,Female,32,97,86
    190,Female,36,103,85
    162,Female,29,79,83
    200,Male,30,137,83
    26,Male,29,28,82
    2,Male,21,15,81
    36,Female,21,33,81
    16,Male,22,20,79
    196,Female,35,120,79
    158,Female,30,78,78
    4,Female,23,16,77
    14,Female,24,20,77
    126,Female,31,70,77
    6,Female,22,17,76
    154,Female,38,78,76
    40,Female,20,37,75
    130,Male,38,71,75
    ^above sorted by spending score

    sed '1,40!d' mall_customers.csv|sort -t',' -k3
    CustomerID|Gender|Age|Annual Income (k$)|Spending Score (1-100)
    34,Male,18,33,92
    40,Female,20,37,75
    2,Male,21,15,81
    36,Female,21,33,81
    6,Female,22,17,76
    16,Male,22,20,79
    4,Female,23,16,77
    8,Female,23,18,94
    30,Female,23,29,87
    14,Female,24,20,77
    42,Male,24,38,92
    156,Female,27,78,89
    146,Male,28,77,97
    26,Male,29,28,82
    136,Female,29,73,88
    162,Female,29,79,83
    184,Female,29,98,88
    200,Male,30,137,83
    158,Female,30,78,78
    176,Female,30,88,86
    186,Male,30,99,97
    126,Female,31,70,77
    164,Female,31,81,93
    142,Male,32,75,93
    144,Female,32,76,87
    182,Female,32,97,86
    168,Female,33,86,95
    150,Male,34,78,90
    196,Female,35,120,79
    12,Female,35,19,99
    20,Female,35,23,98
    180,Male,35,93,90
    190,Female,36,103,85
    174,Male,36,87,92
    194,Female,38,113,91
    130,Male,38,71,75
    154,Female,38,78,76
    124,Male,39,69,91
    152,Male,39,78,88
    128,Male,40,71,95
    ^same sample but sorted by age (k3[column 3])

    sed '1,40!d' mall_customers.csv|sort -nr -t',' -k4
    CustomerID|Gender|Age|Annual Income (k$)|Spending Score (1-100)
    200,Male,30,137,83
    196,Female,35,120,79
    194,Female,38,113,91
    190,Female,36,103,85
    186,Male,30,99,97
    184,Female,29,98,88
    182,Female,32,97,86
    180,Male,35,93,90
    176,Female,30,88,86
    174,Male,36,87,92
    168,Female,33,86,95
    164,Female,31,81,93
    162,Female,29,79,83
    150,Male,34,78,90
    156,Female,27,78,89
    152,Male,39,78,88
    158,Female,30,78,78
    154,Female,38,78,76
    146,Male,28,77,97
    144,Female,32,76,87
    142,Male,32,75,93
    136,Female,29,73,88
    128,Male,40,71,95
    130,Male,38,71,75
    126,Female,31,70,77
    124,Male,39,69,91
    42,Male,24,38,92
    40,Female,20,37,75
    34,Male,18,33,92
    36,Female,21,33,81
    30,Female,23,29,87
    26,Male,29,28,82
    20,Female,35,23,98
    16,Male,22,20,79
    14,Female,24,20,77
    12,Female,35,19,99
    8,Female,23,18,94
    6,Female,22,17,76
    4,Female,23,16,77
    2,Male,21,15,81

    ^same segment sorted by income -nr (DESC or -nr [numbers reversed])
     
  2. Voluum
MI