Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #89: Analyzing Social Data

MikeLR
8 - Asteroid

I quickly fell down a rabbit hole of looking at the users who posted the most

Spoiler
MikeLR_0-1603450092528.png

 

so I clambered out and then promptly fell down another rabbit hole of using Regex to clean up the tweet data for a word cloud:

Spoiler
MikeLR_1-1603450490806.png

 

A2H
11 - Bolide
Spoiler
Capture d’écran, le 2020-10-24 à 11.52.02.png
WernerE
8 - Asteroid

Thanks

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

I made for simple.

Spoiler
AkimasaKajitani_0-1606542098282.png

 

KOON
8 - Asteroid

here it is

LukasJennings
8 - Asteroid
Spoiler
Weekly Challenge #89 Solved .jpg

 

Tokimatsu
12 - Quasar

There are top hashtags using with your SDGs hashtag.

Spoiler
2021-01-17_14h31_42.png

tammybrown_tds
8 - Asteroid

I am not a creative person, so I looked at others' posts.  I liked where @NicoleJohnson was going with hers, and it will be a great foundation for a Tableau visualization for the next challenge.  So I did a workflow very similar to hers.   After all, imitation is the sincerest form of flattery, right?

 

Spoiler
tammybrown_tds_0-1612569347881.png

 

dombaikamilla
8 - Asteroid
Spoiler
89.PNG
byagelski
8 - Asteroid

i did some basic data clean-up by parsing out the hashtags to a new row, creating date/time field in Alteryx format, and modifying hashtag and location fields to uppercase.