Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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