Challenge #89: Analyzing Social Data

[tristank]

I did some basic cleanup of the Global Goals dataset. I wanted to look at original tweets only and split the hashtags by row so I can do some hashtag visualization. Fun stuff!

Spoiler

[olga_strubbe]

Thank you, @ChristineB !  Still not able to upload the screenshot - I submitted a ticket to support.  Please see my app attached. 

I used a similar approach for building an app as Christine, you recommended in your solution.  Thank you! 

[rachel_lynch]

Spoiler

 

[Carolyn]

Solved. I went with an App so the user can select their hashtag and then see how many tweets the hashtag is in, and which other hashtags are with it

Spoiler

 

[ed_hayter]

Spoiler

Tried to keep it simple whilst also making the final table flexible for analysis. Opted for a wildcard input to simplify the flow. Split tweets with multiple hashtags into separate rows. We will just need to remember to use a count distinct for IDs when conducting particular analysis to avoid duplication error. I also parsed out the tweet content columns and date time to make them work more effectively. I filtered out cases where the tweet content was unrecognized characters (?????? ????).

[mithily]

Spoiler

not my fave type of data 

[gawa]

Simple analysis

Spoiler

[egalicha]

My Solution

[mithily]

Spoiler

used provided 89 solution to visualize

[BS_THE_ANALYST]

Didn't build a viz yet, just configuring questions for now:

Spoiler