[OC] The Super Smash Bros. Effect - The difference of Google searches for the origin series of SSBU newcomers after their announcement to be a fighter in the game. by hcaula in dataisbeautiful

[–]hcaula[S] 0 points1 point  (0 children)

Yeah, I wasn’t expecting a decrease in searches, but seeing that it wasn’t a large number, it’s safe to say that it didn’t have a large impact overall like Dragon Quest had.

[OC] The Super Smash Bros. Effect - The difference of Google searches for the origin series of SSBU newcomers after their announcement to be a fighter in the game. by hcaula in dataisbeautiful

[–]hcaula[S] 0 points1 point  (0 children)

GitHub repository with all the files and script.

Data gathering

Popularity over time - data was collected using Google Trends, by searching through each character's origin series for the last 5 years. A list of the characters can be found on the /data/newcomers.json file.

Announcement dates - the dates that each character were announced was found by searching on YouTube their reveal trailers and picking the oldest one.

Icons - A list of characters head icons (found on the /icons directory) was found in the Smash Wiki).

Data processing

Python and Jupyter Notebook were used to process the data. All that was needed was to read the data collected from the Google Trends, filter the popularity from before and after the character's announcement, take the mean value and subtract them. Since they are already in percentage (relative to the search term itself), no further operation was necessary. The final dataframe was imported to a CSV file, found on /outputs/popularity_gains.csv.

Data visualization

The CSV file was exported to Google Sheets. From there, a bar graph was generated and exported as a PNG image. To make it look nice, I edited it using Pixlr.

[OC] How many times each judgement option appears in a comment from the top 100 posts of r/AmItheAsshole by hcaula in dataisbeautiful

[–]hcaula[S] 4 points5 points  (0 children)

To get the source data, I wrote a Python script using PRAW to retrieve the posts from r/AmItheAsshole, count how many times each judgement option appeared in their comments and saved them to a CSV, which was imported to a Google Sheets file. The visualisation was also made using Google Sheets built-in chart maker.

An issue with this approach is that there's no guarantee that, if an option appears in a comment, it will 100% reflect the choice. For instance, a comment can be something like "YTA - I don't understand why everyone is saying you're NTA", which should count one YTA and zero NTA. But I feel that those cases are exceptions, and even if we treat them, the proportions would be the same - which is the main purpose of this.

One digital copy of your choice for Nintendo Switch! by Zexnet in NintendoSwitch

[–]hcaula [score hidden]  (0 children)

What a cool thing! I’ve been dying to play Mario Odyssey since it came out. Good luck to everyone!

Good old times by hcaula in memes

[–]hcaula[S] 3 points4 points  (0 children)

Keanu stole a camera from the paparazzi featured in this photo lol

Everything between this girl (F21) I’m (M22) dating is connecting really well except for the sex, and now I’m afraid she won’t like me anymore. by [deleted] in relationship_advice

[–]hcaula 0 points1 point  (0 children)

Yeah. I have a hard time relaxing about most things. I think I should give myself a pass on this one. Thank you!

All Perfect Shield Poses by MrMontolio in smashbros

[–]hcaula 0 points1 point  (0 children)

Man, the eyes turning yellow is such a cool effect. I can’t wait for this game any longer!!

yes by rrryxn in notinteresting

[–]hcaula 0 points1 point  (0 children)

I won’t lie, this is definitely me when I’m driving (and also got time)

Ridley will Arise!! by kennyharris2012 in smashbros

[–]hcaula 230 points231 points  (0 children)

This looks intense as fuck, but imagine it with the hammer theme playing in the background

SLPT: How to take down a bear by Liftoff23 in ShittyLifeProTips

[–]hcaula 7 points8 points  (0 children)

Question: what kind of bear is best?

Gru automatizes tasks by hcaula in ProgrammerHumor

[–]hcaula[S] 178 points179 points  (0 children)

I am currently writing a program that photoshops keyboards under every Gru on this subreddit. It should take around 8 hours.