Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start 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 #296: Breaking News - Headlines and Keywords

ChrisMelck
Astéroïde

Forecast bit required help

Kamran1991
Bolide

My solution::::

tanyafischer
Astéroïde

solved :)

MilindG
Quasar
Révélation
MilindG_0-1658256998673.png

 

ARussell34
Astéroïde

Mondays have the most Sports articles of which 35 contained Football either in the headline and/or the keywords.

leonhekkert
Astéroïde

My solution (without the bonus)

 

Révélation
Challenge_296.png
RWvanLeeuwen
Bolide
Révélation
296.png
simi22
Astéroïde
Révélation
simi22_1-1661263890114.png

 

simi22_0-1661263848018.png

Solved

lkim524
Astéroïde

The wording of the challenge is a little ambiguous as it states:

 

"Your second task is to identify how many times the word "Football" or "football" is in the headline or keywords on the day of the week that has the highest number of sport articles published."

 

which makes it sound like you are counting and summing the specific number of instances that "Football" or "football" appear in either the headline or keywords.

 

The output, though, is just based on whether or not "Football" or "football" appears anywhere in the keywords or headline and flagging it to be counted.  For example, say the "football" keyword shows up 3x in the keyword field.  The total sum count in terms of the model output, though, would just count this article as 1.

 

 

 

 

karlhansen
Comète
Révélation
solution_296.jpg

For the bonus I calculated an average monthly comment, then divided 20 million less 2020's comments and advanced from 12/31/2020.  I was within a month.