Solutions
Pricing
Log in
Teams
Get started
Log in
Get started
OK Cupid | EDA
FG
by
Felix Gondwe
·
3 views
·
Updated Oct 7, 2021
Share
Embed
Create your own
Chapters
00:00
Chapter 1
00:07
Chapter 2
00:23
Chapter 3
00:52
Chapter 4
00:53
Chapter 5
01:51
Chapter 6
01:53
Chapter 7
01:55
Chapter 8
01:56
Chapter 9
02:00
Chapter 10
02:35
Chapter 11
02:37
Chapter 12
03:08
Chapter 13
03:10
Chapter 14
03:27
Chapter 15
03:29
Chapter 16
03:51
Chapter 17
03:53
Chapter 18
05:33
Chapter 19
05:34
Chapter 20
05:36
Chapter 21
05:37
Chapter 22
05:39
Chapter 23
06:26
Chapter 24
06:28
Chapter 25
06:29
Chapter 26
06:30
Chapter 27
Audio Transcript
Auto-generated
00:01 - 00:01
Hi I'm Felix.
00:02 - 00:05
I'm here to present age trend data on the okay
00:05 - 00:07
QB deficit or given for the assignment.
00:09 - 00:13
Um So uh through this process we're able to examine
00:13 - 00:15
the data to a little bit of cleaning and certain
00:16 - 00:20
modifications um for the trends for the h train that
00:21 - 00:23
we're interested in exploring more and learning more about.
00:24 - 00:27
Um So they did they were looked at again is
00:27 - 00:27
the okay cubic data.
00:28 - 00:32
We could help from um location data one with latitude
00:33 - 00:36
and longitude that help us uh create a map and
00:36 - 00:42
then addresses um to specifically find out where people are
00:43 - 00:44
based of a much more detail.
00:45 - 00:49
But Overall interested just finding out that the location using
00:50 - 00:52
those two additional deficits.
00:53 - 00:57
Um When he came to data cleaning uh We picked
00:57 - 01:02
on variables we could do mean amputations on uh oh
01:02 - 01:03
and all the variables.
01:03 - 01:06
We could do a little bit, a little bit of
01:06 - 01:11
binning. Um And for us that was the h data.
01:12 - 01:15
Um As far as I've been is concerned and then
01:15 - 01:18
for amputation and that was going to be uh income.
01:19 - 01:22
We could have done same on other variables as well
01:22 - 01:23
such as race.
01:23 - 01:28
But that uh could gets very complicated pay fast.
01:29 - 01:33
So he's sort of keeping to the basics and since
01:34 - 01:37
we're interested to see the eggs trends uh What we
01:37 - 01:40
mean by age trend is uh as far as the
01:40 - 01:42
building is concerned is that we're able to group that
01:43 - 01:46
did and to millennials gen Z's get X's, baby boomers
01:47 - 01:48
and so on and so forth.
01:48 - 01:51
Um In order for us to be able to draw
01:51 - 01:52
certain insights from that.
01:53 - 01:58
Um And yeah, all right, those uh data cleaning and
01:58 - 02:00
now it's time to explore the data.
02:01 - 02:04
Um We're looking at the six distribution.
02:05 - 02:08
We find that there are more males uh than they
02:08 - 02:10
are females in our dataset.
02:11 - 02:15
And if uh the other line of sanction here was
02:16 - 02:19
looking at the X trains across whether it's gen z,
02:20 - 02:21
gen X and all that.
02:22 - 02:26
Um we want to assume that this will remain true
02:26 - 02:29
uh as we go through and we do do a
02:29 - 02:34
little bit of examination later on to confirm that or
02:34 - 02:35
to prove that assumption.
02:38 - 02:42
So diving into the age insights after the beginning, we
02:42 - 02:46
find out more millennials um are followed by gen X.
02:46 - 02:49
And gen Zs million years age I think stops around
02:49 - 02:55
38 and then gen z h starts from 18 To
02:55 - 02:59
about 23 ish and so on and so forth.
03:00 - 03:03
And we found out seniors were sort of an outlier
03:03 - 03:04
in this age category.
03:05 - 03:08
Uh because very few of them they were able to
03:08 - 03:09
find in the data set.
03:10 - 03:12
And then the next step was trying to find a
03:12 - 03:16
distribution uh of these different age groups across the U.
03:16 - 03:19
S. And it seems like more of them are concentrated
03:19 - 03:23
either on the east coast always cause whiskers having more
03:23 - 03:27
of them and particularly in California as we can see
03:27 - 03:27
from the image.
03:29 - 03:33
Um And then the next thing was to find out
03:33 - 03:36
what is the sex distribution across these different age groups.
03:36 - 03:39
And as we uh made an assumption at the beginning
03:40 - 03:42
that it was going to remain true across.
03:43 - 03:46
And we can after further examinations, we found out that
03:46 - 03:51
it is indeed true across um um these different groups.
03:54 - 03:59
And then um furthermore, we're trying to find out um
04:00 - 04:04
This is mostly to as we're going through our towards
04:05 - 04:07
the end, we're trying to find what we conclude from
04:08 - 04:08
from all this.
04:08 - 04:11
And if there are any recommendations we could make for
04:11 - 04:15
the platform using different signals in this case we pick
04:15 - 04:20
offspring offspring signal to tell us more about parenting people
04:20 - 04:21
interested in that or not.
04:22 - 04:26
And when you look across the groups between between the
04:26 - 04:31
two sexes, they were able to find um it seems
04:31 - 04:35
like the millennial group is much more interested in that
04:36 - 04:39
um than any other group.
04:40 - 04:43
And we do also see some follow up interest from
04:43 - 04:47
the uh, the gen x, which makes sense because uh
04:47 - 04:52
um sorry, the gen z, so Elliot in life.
04:53 - 04:57
Um So this is 18-28 as people approaching.
04:58 - 05:02
Uh let's see 25, is that maybe thinking about these
05:02 - 05:05
things? And then once you get into the millennial arena,
05:06 - 05:10
we see this being true, people getting more interesting uh
05:12 - 05:12
in having kids.
05:13 - 05:16
And also there was a good representation of people that
05:16 - 05:19
do not want that, but we wanted to see if
05:19 - 05:24
uh if that signals anything and if there is some
05:24 - 05:29
signal, what could be a possible recommendation or recommendation, we
05:29 - 05:32
can work on to develop a particular feature on the
05:33 - 05:44
Yeah from so our findings were um uh pretty clear
05:44 - 05:47
that analyze them to stem from the extreme ends when
05:47 - 05:47
it comes to age.
05:48 - 05:52
Uh seems like the seniors are allies in this case
05:52 - 05:53
and in this case.
05:53 - 05:55
And then when you look at the income as well
05:55 - 05:58
in the income variable, uh you find that these um
05:59 - 06:04
extremely rich people mostly after uh think 250 K.
06:04 - 06:05
Reported income.
06:06 - 06:10
And then when we run some numbers with the what
06:10 - 06:14
we're talking about before the parent signal whether people on
06:14 - 06:18
that or not um with people that are interested in
06:18 - 06:20
his, we found that the millennial group was much more
06:21 - 06:24
interesting that followed by the gen z's.
06:25 - 06:34
Um So in summary based on the trains are able
06:35 - 06:39
to see uh we can we can conclude that they're
06:40 - 06:43
more millennials on the Okay Cupid platform to start with
06:44 - 06:48
and with that um there's several things we can do
06:49 - 06:53
uh We feel larger group that was presented when we
06:53 - 06:56
look at the parenting signals, we found out this group
06:56 - 06:59
was particularly I had more interest than any other group
06:59 - 07:04
uh sensitive many of them um and um based off
07:04 - 07:07
that uh if we were to build a recommendation engine
07:08 - 07:11
we would want to um if we're to do much
07:11 - 07:14
as we want to match people who have this interest
07:14 - 07:17
and when you look at the group, assuming that we
07:17 - 07:22
wanted to recommend um um or someone else to to
07:22 - 07:25
to be recommended to partner with someone else uh with
07:26 - 07:26
regards to parenting.
07:27 - 07:30
We want to make sure that uh we stay closer
07:31 - 07:32
to the groups in this new case.
07:32 - 07:36
When we saw that the gen z's um they're more
07:38 - 07:40
in as far as being interested in, the printing is
07:40 - 07:45
concerned you have more jonesy's uh interested in that um
07:46 - 07:49
and Canadians being uh the leading group when it comes
07:49 - 07:49
to that.
07:49 - 07:53
So for example, if you to recommend um partners from
07:54 - 07:57
each of these groups, we want to um also be
07:57 - 07:59
aware of these signals, We don't want to pay someone
08:00 - 08:03
else who they say um maybe that is not something
08:04 - 08:05
else, the potential interest.
08:06 - 08:09
Um There is more um I think there will be
08:09 - 08:13
more success if we're to uh pear people along the
08:13 - 08:16
lines of uh common interest.
08:19 - 08:19
Thank you.
See full transcript