How old are you?? (poll)

u/DarkestEx April 08, 2017, 08:23:34 PM

Quote from: DJ Omnimaga on April 06, 2017, 04:31:45 PM
@Juju could definitively run a script across the entire db, ignoring those with no age or fake ages

I have written an automated CW profile crawler

It has statistics of anything: Gender, Age, ...

u/Yuki April 08, 2017, 08:50:32 PM

I have written super fancy SQL code. Kinda simpler that way.

u/DarkestEx April 08, 2017, 08:52:46 PM

Quote from: Juju on April 08, 2017, 08:50:32 PM
I have written super fancy SQL code. Kinda simpler that way.

If I would have had database access, this would've indeed been the easier way...

u/Yuki April 08, 2017, 08:53:40 PM

Yep. Just ask and I'll deliver, I guess.

Code Select

MariaDB [smf]> select count(*) as count, floor(TIMESTAMPDIFF(YEAR,birthdate,CURDATE())/5)*5 as age from smf_members where TIMESTAMPDIFF(YEAR,birthdate,CURDATE())>10 and TIMESTAMPDIFF(YEAR,birthdate,CURDATE())<100 group by floor(TIMESTAMPDIFF(YEAR,birthdate,CURDATE())/5)*5;
+-------+------+
| count | age  |
+-------+------+
|     4 |   10 |
|    27 |   15 |
|    19 |   20 |
|    14 |   25 |
|     9 |   30 |
|     2 |   40 |
+-------+------+
6 rows in set (0.01 sec)

u/Dream of Omnimaga April 08, 2017, 09:02:25 PM

Quote from: DarkestEx on April 08, 2017, 08:23:34 PM
Quote from: DJ Omnimaga on April 06, 2017, 04:31:45 PM
@Juju could definitively run a script across the entire db, ignoring those with no age or fake ages
I have written an automated CW profile crawler
It has statistics of anything: Gender, Age, ...

Yeah but didn't it only open 1 user at a time?

Anyway @Juju the best would be if you calculated the average of all ages rather than per groups, so that we got the media forum age.

We have to consider, however, that at least four of our 30-39 years old user did not include their age in his profile, same for three of our 40+ years old users, so technically, we have at least 13 30-39 years old users and 5 40+ years old users.

In other words, our median age could be approximately the following:

Code Select

+-------+------+
| count | age  |
+-------+------+
|     4 |   10 |
|    27 |   15 |
|    19 |   20 |
|    14 |   25 |
|     13 |   30 |
|     5 |   40 |
+-------+------+

21.5 years old.

Last Edit: April 08, 2017, 09:10:55 PM by DJ Omnimaga

u/DarkestEx April 08, 2017, 09:08:40 PM

Quote from: DJ Omnimaga on April 08, 2017, 09:02:25 PM
Quote from: DarkestEx on April 08, 2017, 08:23:34 PM
Quote from: DJ Omnimaga on April 06, 2017, 04:31:45 PM
@Juju could definitively run a script across the entire db, ignoring those with no age or fake ages
I have written an automated CW profile crawler
It has statistics of anything: Gender, Age, ...
Yeah but didn't it only open 1 user at a time?

Yes it did. But it repeated this process for many times.

u/Dream of Omnimaga April 08, 2017, 10:36:26 PM

Ah ok good. Also does it only include users who made at least 1 post?

u/DarkestEx April 08, 2017, 10:38:01 PM

Quote from: DJ Omnimaga on April 08, 2017, 10:36:26 PM
Ah ok good. Also does it only include users who made at least 1 post?

No, everyone.

A dump can be found here:
http://jsonviewer.stack.hu/#http://ninjabyte.eu/dl/cw_database_2017_04_08.json
Simply click on "Viewer" and explore the data!

u/Switchblade April 08, 2017, 10:40:18 PM

Unfortunately, I can't use the poll. I don't have twenty posts yet

u/Yuki April 08, 2017, 10:44:22 PM

Quote from: DJ Omnimaga on April 08, 2017, 09:02:25 PM
21.5 years old.

According to my data, I get 22.3.

u/Dream of Omnimaga April 09, 2017, 01:28:58 AM

Nice. Also thanks for the PM. With the extra data I provided, this puts our average age at 23.1266. Which is surprising considering CodeWalrus' randomness nature