Join us on Discord!
You can help CodeWalrus stay online by donating here.

How old are you?? (poll)

Started by kotu, April 05, 2017, 03:35:39 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

So how old are you?

10 or younger
11-13
14-16
17-19
20-29
30-39
40 or older

DarkestEx

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, ...
  • Calculators owned: TI-84+, Casio 101-S, RPN-Calc, Hewlett-Packard 100LX, Hewlett-Packard 95LX
  • Consoles, mobile devices and vintage computers owned: Original Commodore 64C, C64 DTV, Nintendo GameBoy Color, Nintendo GameCube, Xbox 360, PlayStation 2

Yuki

I have written super fancy SQL code. Kinda simpler that way.
  • Calculators owned: TI-83+ (dead?), Casio Prizm (also dead???)
  • Consoles, mobile devices and vintage computers owned: A lot
Read Zarmina!
YUKI-CHAAAANNNN
In the beginning there was walrii. In the end there will be walrii. All hail our supreme leader :walrii: --Snektron

if you wanna throw money at me and/or CodeWalrus monthly it's here

DarkestEx

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... :P
  • Calculators owned: TI-84+, Casio 101-S, RPN-Calc, Hewlett-Packard 100LX, Hewlett-Packard 95LX
  • Consoles, mobile devices and vintage computers owned: Original Commodore 64C, C64 DTV, Nintendo GameBoy Color, Nintendo GameCube, Xbox 360, PlayStation 2

Yuki

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

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)
  • Calculators owned: TI-83+ (dead?), Casio Prizm (also dead???)
  • Consoles, mobile devices and vintage computers owned: A lot
Read Zarmina!
YUKI-CHAAAANNNN
In the beginning there was walrii. In the end there will be walrii. All hail our supreme leader :walrii: --Snektron

if you wanna throw money at me and/or CodeWalrus monthly it's here

Dream of Omnimaga

#19
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:

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


21.5 years old.
  • Calculators owned: TI-82 Advanced Edition Python TI-84+ TI-84+CSE TI-84+CE TI-84+CEP TI-86 TI-89T cfx-9940GT fx-7400G+ fx 1.0+ fx-9750G+ fx-9860G fx-CG10 HP 49g+ HP 39g+ HP 39gs (bricked) HP 39gII HP Prime G1 HP Prime G2 Sharp EL-9600C
  • Consoles, mobile devices and vintage computers owned: Huawei P30 Lite, Moto G 5G, Nintendo 64 (broken), Playstation, Wii U

DarkestEx

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.
  • Calculators owned: TI-84+, Casio 101-S, RPN-Calc, Hewlett-Packard 100LX, Hewlett-Packard 95LX
  • Consoles, mobile devices and vintage computers owned: Original Commodore 64C, C64 DTV, Nintendo GameBoy Color, Nintendo GameCube, Xbox 360, PlayStation 2

Dream of Omnimaga

Ah ok good. Also does it only include users who made at least 1 post?
  • Calculators owned: TI-82 Advanced Edition Python TI-84+ TI-84+CSE TI-84+CE TI-84+CEP TI-86 TI-89T cfx-9940GT fx-7400G+ fx 1.0+ fx-9750G+ fx-9860G fx-CG10 HP 49g+ HP 39g+ HP 39gs (bricked) HP 39gII HP Prime G1 HP Prime G2 Sharp EL-9600C
  • Consoles, mobile devices and vintage computers owned: Huawei P30 Lite, Moto G 5G, Nintendo 64 (broken), Playstation, Wii U

DarkestEx

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!
  • Calculators owned: TI-84+, Casio 101-S, RPN-Calc, Hewlett-Packard 100LX, Hewlett-Packard 95LX
  • Consoles, mobile devices and vintage computers owned: Original Commodore 64C, C64 DTV, Nintendo GameBoy Color, Nintendo GameCube, Xbox 360, PlayStation 2

Switchblade

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

Yuki

  • Calculators owned: TI-83+ (dead?), Casio Prizm (also dead???)
  • Consoles, mobile devices and vintage computers owned: A lot
Read Zarmina!
YUKI-CHAAAANNNN
In the beginning there was walrii. In the end there will be walrii. All hail our supreme leader :walrii: --Snektron

if you wanna throw money at me and/or CodeWalrus monthly it's here

Dream of Omnimaga

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 O.O
  • Calculators owned: TI-82 Advanced Edition Python TI-84+ TI-84+CSE TI-84+CE TI-84+CEP TI-86 TI-89T cfx-9940GT fx-7400G+ fx 1.0+ fx-9750G+ fx-9860G fx-CG10 HP 49g+ HP 39g+ HP 39gs (bricked) HP 39gII HP Prime G1 HP Prime G2 Sharp EL-9600C
  • Consoles, mobile devices and vintage computers owned: Huawei P30 Lite, Moto G 5G, Nintendo 64 (broken), Playstation, Wii U

Powered by EzPortal