Challenge #89: Analyzing Social Data

[MikeLR]

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

Spoiler

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

[A2H]

Spoiler

[WernerE]

Thanks

[AkimasaKajitani]

My solution.

I made for simple.

Spoiler

[KOON]

here it is

[LukasJennings]

Spoiler

[Tokimatsu]

There are top hashtags using with your SDGs hashtag.

Spoiler

 

[tammybrown_tds]

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

[dombaikamilla]

Spoiler

[byagelski]

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.