OK Cupid | EDA

FG
by Felix Gondwe3 views·Updated Oct 7, 2021

Chapters

Audio TranscriptAuto-generated

  1. Hi I'm Felix.
  2. I'm here to present age trend data on the okay
  3. QB deficit or given for the assignment.
  4. Um So uh through this process we're able to examine
  5. the data to a little bit of cleaning and certain
  6. modifications um for the trends for the h train that
  7. we're interested in exploring more and learning more about.
  8. Um So they did they were looked at again is
  9. the okay cubic data.
  10. We could help from um location data one with latitude
  11. and longitude that help us uh create a map and
  12. then addresses um to specifically find out where people are
  13. based of a much more detail.
  14. But Overall interested just finding out that the location using
  15. those two additional deficits.
  16. Um When he came to data cleaning uh We picked
  17. on variables we could do mean amputations on uh oh
  18. and all the variables.
  19. We could do a little bit, a little bit of
  20. binning. Um And for us that was the h data.
  21. Um As far as I've been is concerned and then
  22. for amputation and that was going to be uh income.
  23. We could have done same on other variables as well
  24. such as race.
  25. But that uh could gets very complicated pay fast.
  26. So he's sort of keeping to the basics and since
  27. we're interested to see the eggs trends uh What we
  28. mean by age trend is uh as far as the
  29. building is concerned is that we're able to group that
  30. did and to millennials gen Z's get X's, baby boomers
  31. and so on and so forth.
  32. Um In order for us to be able to draw
  33. certain insights from that.
  34. Um And yeah, all right, those uh data cleaning and
  35. now it's time to explore the data.
  36. Um We're looking at the six distribution.
  37. We find that there are more males uh than they
  38. are females in our dataset.
  39. And if uh the other line of sanction here was
  40. looking at the X trains across whether it's gen z,
  41. gen X and all that.
  42. Um we want to assume that this will remain true
  43. uh as we go through and we do do a
  44. little bit of examination later on to confirm that or
  45. to prove that assumption.
  46. So diving into the age insights after the beginning, we
  47. find out more millennials um are followed by gen X.
  48. And gen Zs million years age I think stops around
  49. 38 and then gen z h starts from 18 To
  50. about 23 ish and so on and so forth.
  51. And we found out seniors were sort of an outlier
  52. in this age category.
  53. Uh because very few of them they were able to
  54. find in the data set.
  55. And then the next step was trying to find a
  56. distribution uh of these different age groups across the U.
  57. S. And it seems like more of them are concentrated
  58. either on the east coast always cause whiskers having more
  59. of them and particularly in California as we can see
  60. from the image.
  61. Um And then the next thing was to find out
  62. what is the sex distribution across these different age groups.
  63. And as we uh made an assumption at the beginning
  64. that it was going to remain true across.
  65. And we can after further examinations, we found out that
  66. it is indeed true across um um these different groups.
  67. And then um furthermore, we're trying to find out um
  68. This is mostly to as we're going through our towards
  69. the end, we're trying to find what we conclude from
  70. from all this.
  71. And if there are any recommendations we could make for
  72. the platform using different signals in this case we pick
  73. offspring offspring signal to tell us more about parenting people
  74. interested in that or not.
  75. And when you look across the groups between between the
  76. two sexes, they were able to find um it seems
  77. like the millennial group is much more interested in that
  78. um than any other group.
  79. And we do also see some follow up interest from
  80. the uh, the gen x, which makes sense because uh
  81. um sorry, the gen z, so Elliot in life.
  82. Um So this is 18-28 as people approaching.
  83. Uh let's see 25, is that maybe thinking about these
  84. things? And then once you get into the millennial arena,
  85. we see this being true, people getting more interesting uh
  86. in having kids.
  87. And also there was a good representation of people that
  88. do not want that, but we wanted to see if
  89. uh if that signals anything and if there is some
  90. signal, what could be a possible recommendation or recommendation, we
  91. can work on to develop a particular feature on the
  92. Yeah from so our findings were um uh pretty clear
  93. that analyze them to stem from the extreme ends when
  94. it comes to age.
  95. Uh seems like the seniors are allies in this case
  96. and in this case.
  97. And then when you look at the income as well
  98. in the income variable, uh you find that these um
  99. extremely rich people mostly after uh think 250 K.
  100. Reported income.
  101. And then when we run some numbers with the what
  102. we're talking about before the parent signal whether people on
  103. that or not um with people that are interested in
  104. his, we found that the millennial group was much more
  105. interesting that followed by the gen z's.
  106. Um So in summary based on the trains are able
  107. to see uh we can we can conclude that they're
  108. more millennials on the Okay Cupid platform to start with
  109. and with that um there's several things we can do
  110. uh We feel larger group that was presented when we
  111. look at the parenting signals, we found out this group
  112. was particularly I had more interest than any other group
  113. uh sensitive many of them um and um based off
  114. that uh if we were to build a recommendation engine
  115. we would want to um if we're to do much
  116. as we want to match people who have this interest
  117. and when you look at the group, assuming that we
  118. wanted to recommend um um or someone else to to
  119. to be recommended to partner with someone else uh with
  120. regards to parenting.
  121. We want to make sure that uh we stay closer
  122. to the groups in this new case.
  123. When we saw that the gen z's um they're more
  124. in as far as being interested in, the printing is
  125. concerned you have more jonesy's uh interested in that um
  126. and Canadians being uh the leading group when it comes
  127. to that.
  128. So for example, if you to recommend um partners from
  129. each of these groups, we want to um also be
  130. aware of these signals, We don't want to pay someone
  131. else who they say um maybe that is not something
  132. else, the potential interest.
  133. Um There is more um I think there will be
  134. more success if we're to uh pear people along the
  135. lines of uh common interest.
  136. Thank you.