The Nineteenth Byte

El'endia Starman

8:00 PM

I suppose I could do a nested regex function.

Syxer

@EᴀsᴛᴇʀʟʏIʀᴋ @ConorO'Brien Return RDFTD

Eᴀsᴛᴇʀʟʏ Iʀᴋ

hey

nice song

haven't seen you in a while

Syxer

Spoop

I'm still around

It just happens to be senior year + application time + dealing with music requests (no not RDFTDs - I'm writing sheet music for my school)

El'endia Starman

Hey, I think I got it.

The top 25 most common words in TNB:

the	296571
I	240237
a	223471
to	204031
is	138751
it	135055
of	129505
that	125386
you	110862
and	106137
in	102564
for	86042
be	63362
on	55934
not	55474
have	55267
but	52580
with	47238
are	43440
this	40917
just	40038
my	38508
was	38454
if	38357
as	37485

Syxer

@El'endiaStarman Code smiley face: :-]

Downgoat

8:07 PM

@El'endiaStarman :D u fixed redirect bug \o/

El'endia Starman

@Syxer Hahaha, yeah. :P

Geobits

@El'endiaStarman That's pretty similar to the top 25 in English, but differently ordered. Apparently we talk somewhat normally o_O

flawr

@El'endiaStarman I get a different result.

3

the	296571
I	240237
a	223471
to	204031
is	138751
it	135055
of	129505
that	125386
and	106137
in	102564
for	86042
be	63362
on	55934
never	55474
gonna	55267
give	52580
you 	47238
up	43440
this	40917
just	40038
my	38508
was	38454
if	38357
as	37485

TimmyD

@Geobits I don't think El's list considers lexemes

Downgoat

@Geobits ;_; y u think we're not normal

Syxer

8:09 PM

@flawr disapproves

Geobits

@Downgoat Have you met Marky?

Downgoat

Yes

El'endia Starman

@flawr Here I was wondering what was different, and then I noticed... >_<

Geobits

@TimmyD True, but most are prepositions, pronouns, or articles, which don't have as many alternate forms.

Eᴀsᴛᴇʀʟʏ Iʀᴋ

@Syxer ooh nice

@flawr .......

El'endia Starman

8:12 PM

@TimmyD Haha, probably not. I used a pretty unsophisticated regex to pick out words as best as I could.

Downgoat

^^

Eᴀsᴛᴇʀʟʏ Iʀᴋ

@El'endiaStarman it also doesn't include carets

i need to see the comparison

El'endia Starman

@EᴀsᴛᴇʀʟʏIʀᴋ Carets are not words.

Eᴀsᴛᴇʀʟʏ Iʀᴋ

true

Geobits

Well neither is : but it shows up if you extend the list past 25 :P

Syxer

8:13 PM

@El'endiaStarman Any way you can pack in an wordlist to check not contains? We should be able to remove simple verbs and articles

Geobits

@AlexA is the most common explicit ping there. (I hope that didn't ping him...)

Dennis

It did.

El'endia Starman

@EᴀsᴛᴇʀʟʏIʀᴋ They wouldn't come near the top 25 anyway because they're really quite rare in relation to all the other words or pseudo-words in messages.

Syxer

lol

Eᴀsᴛᴇʀʟʏ Iʀᴋ

@El'endiaStarman true

muddyfish

8:14 PM

:P x 24051 times

Geobits

Bah. Couldn't remember if pings in code worked or not :/

El'endia Starman

@Syxer I don't mind if you do that. I'd suggest running the query on a smaller subset (like the month of August) first until you're sure it works as intended.

Syxer

@El'endiaStarman I was asking because I don't know SQL at all.

Dennis

@Geobits If in doubt, U+200B.

Downgoat

@El'endiaStarman question: what percent of "y u"s were said by me?

Geobits

8:15 PM

@Dennis It's ok. He's apparently ignoring me anyway :(

Conor O'Brien

@Dennis that's both comforting and terrifying >_>

Geobits

@Syxer While you're at it, make it case-insensitive, too ;)

Syxer

1 min ago, by Syxer

@El'endiaStarman I was asking because I don't know SQL at all.

muddyfish

@-AlexA - 15534 times

El'endia Starman

@Downgoat Pretty high.

Downgoat

8:18 PM

@El'endiaStarman ;_; still lower than I expected

Geobits

@muddyfish Hmm 15k pings, and he's said 55k things. I think I'm at roughly the same ratio.

DanTheMan

I'm trying to figure out which users have the most stars but I don't know SQL well enough.

Syxer

@DanTheMan There's a challenge for this

Conor O'Brien

^

El'endia Starman

@DanTheMan Already had this one: ppcg.starmaninnovations.com/tnbde/#HAGmVhkRQW

Geobits

8:19 PM

There's a query saved for that, but I don't have the link.

>_>

DanTheMan

@Geobits Figure out the people with the highest ratio of messages to pings

Geobits

@DanTheMan That's left as an exercise for the reader.

But pings/messages would be better imo.

Syxer

@El'endiaStarman how am I in the top 20

DanTheMan

@El'endiaStarman I have only 12 stars. :(

Downgoat

@DanTheMan post funee gaot meem to fix

Geobits

8:22 PM

There are funny goat memes?

Downgoat

@Geobits haha very funny

Geobits

I thought so. Surprised you did, but okay.

El'endia Starman

Pings/messages would be a fairly complex query. You'd have to join tables on messages that have @ + username, and then aggregate the ones for usernames that belong to the same user. Well, that's if we're looking for an aggregate of that. If we're just looking at one user, that wouldn't be too hard.

DanTheMan

I was looking at the most starred messages and I found this.

El'endia Starman

@DanTheMan You literally could've just linked the message in here. :P

But yes, that was a funny message.

DanTheMan

8:25 PM

No, why is there a </div>?

Geobits

</div>s are the secret to getting stars.

El'endia Starman

@DanTheMan I don't 100% know why. They do show up as artifacts pretty often though.

Nathan Merrill

@El'endiaStarman perhaps because its a multi-line message?

El'endia Starman

@NathanMerrill That's probably it.

Eᴀsᴛᴇʀʟʏ Iʀᴋ

@Geobits lel nice try

El'endia Starman

8:28 PM

@EᴀsᴛᴇʀʟʏIʀᴋ I'm tempted to star his message to spite you. Hmmmmmm....... :P

Eᴀsᴛᴇʀʟʏ Iʀᴋ

........

Geobits

Huh. Yeah I guess I can see why that would look like star-begging, but it wasn't my intent. Should've been, but wasn't :/

El'endia Starman

Those stars that just showed up weren't mine, I swear.

DanTheMan

@NathanMerrill I'm not so sure

El'endia Starman

Just did a query to get the most common words in starred messages, and there isn't really that much difference from the most common words overall. :P

@DanTheMan Oneboxes typically have an extra trailing </div> because of how they were parsed.

Martin Ender

8:31 PM

@MitchSchwartz it seems the (tiny) Hexagony golfing scene just got some serious competition :)

DanTheMan

@El'endiaStarman How common is </div> in messages?

Martin Ender

13 for the addition challenge is insane

DanTheMan

@MartinEnder I need 20 CCs of context, stat!

DJMcMayhem

@MartinEnder link?

Martin Ender

anarchy golf

golf.shinh.org/p.rb?A+plus+B+problem

Syxer

8:32 PM

should			19290
really			16245
challenge		15595
that's			15459
because			14470
question		13995
language		13804
answer			13577
though			12891
people			12886
something		12491
doesn't			12029
actually		11545
number			10851
quartata		10755
Doorknob		10627
Geobits			10454
Dennis			9986
MartinB			9983
El'endiaStarman		9464
probably		9415
program			9110
Downgoat		9028
That's			8885
didn't			8702

Downgoat

3

guys im rich

it says its not a spam

mınxomaτ

> Lucas SWAT

Syxer

@Downgoat wow there's no capital b in facebook

Downgoat

@mınxomaτ i have a feeling when the spammers were collaborating to make this they thought instead of FB it was FBI so they added the "SWAT"

Syxer

gg scammer you fail

mınxomaτ

8:35 PM

@Downgoat Bet you can't see his defense strategy coming.

Downgoat

4/10 clearly no photoshop

El'endia Starman

Most common words in starred messages that are longer than 10 characters.

Syxer

@El'endiaStarman I'm on the list twice :D

mınxomaτ

@Downgoat Oh wow, she won 600k "United State"

DJMcMayhem

@MartinEnder the shortest vim answer is 13 bytes... I can do it in 10.

Martin Ender

8:37 PM

@DJMcMayhem add it then :)

DJMcMayhem

I think I will.

El'endia Starman

@Syxer I'm honestly not sure whether to be proud or not that my name is third on the list. People pinging me are more likely to get stars for whatever reason...

Syxer

@El'endiaStarman O.o

El'endia Starman

Ugh, the star-joker is at it again. :P

DanTheMan

@El'endiaStarman Guilty as charged :P

El'endia Starman

8:40 PM

@El'endiaStarman Maybe if I ping myself, I'll get more stars!

Geobits

You'll go blind if you keep doing that.

DJMcMayhem

Actually, I can do it in 9!

Martin Ender

Meanwhile, I'm increasingly convinced that Mitch Schwartz uses some sort of blood magic for golfing.

Nathan Merrill

lol

its always great when we get a new user that stomps our regulars

Downgoat

@Ｅl'endiaStarman programming stackexchange interesting interpreter, pls giv stars

>_> pls work

Martin Ender

8:45 PM

@NathanMerrill Mitch has been around for a while (on anarchy golf more than on PPCG though)

El'endia Starman

Of the words longer than 4 letters most likely to appear in starred messages, "stars" is #21.

DJMcMayhem

Lol, that does not surprise me

Poke

don't about think people would should

muddyfish

stars stars stars stars stars stars?

Poke

now to watch the stars pour in

pls

muddyfish

8:54 PM

first don't think about people. would there really language something challenge? could answer question. other questions which stars AlexA should right because that's you're can't

DanTheMan

don't about think people would should there because really language challenge question answer something could questions other which right stars you're that's can't first

Geobits

Well then

Downgoat

> 1 don't

clearly this is in "dont star this"

DJMcMayhem

You guys are all trying too hard

TimmyD

I think some people were replaced with Markov bots

Geobits

8:56 PM

I didn't do it this time.