Free Trial

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

alacoume
9 - Comet

My solution:

leonhekkert
8 - Asteroid

My solution for both this and the next challenge.

 

I´ve filtered out retweets and replies. After that I did a little analysis on the hashtags that had the most unique user id´s.

 

Spoiler
Challenge_89.png


challenge_89_.png
Flo_P
9 - Comet

Minor clean-up in the workflow then used PowerBI to analyze and visualize some of the information!

Spoiler
Flo_P_0-1678118166270.png

 

NhungLe
8 - Asteroid

NhungLe_0-1679175387897.png

 

 

 

 

 

 

CeliaC_Silje
8 - Asteroid

Just did the basic cleansing on the dataset

  • Date format
  • Parse the hashtag into rows
  • Filter out invalid hashtag/ empty records
Spoiler
CeliaC_Silje_0-1679649717610.png
HarryBrunning
7 - Meteor

Prepped and ready to go! 👍

Hammad_Rashid
11 - Bolide
Spoiler
89.PNG
Amy_smart
11 - Bolide

Here is my solution. I looked at the information for non-retweets in both word clouds and sentiment analysis counts, for each hashtag, in an interactive chart.

geoff_zath
Alteryx
Alteryx
Spoiler

geoff_zath_0-1683055169677.png

Looked at the top 10 hashtags and the top 10 retweeted hashtags.

chandler-gjino
Alteryx
Alteryx

attaching my solution