Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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 #227: /*comments*/

rmassambane
10 - Fireball

227

dsmdavid
11 - Bolide

 

Yet a slightly different number of records (16322 for me)

Spoiler
dsmdavid_0-1597065710386.png

 

No option to install the text mining tools for now

balajilolla
8 - Asteroid
Spoiler
Solution Attached
balajilolla_2-1597090232956.png

 

 

 

hanykowska
11 - Bolide

I get slightly different results (but very similar)

 

Assume it comes down to the way the data was cleaned and the set up of the sentiment analysis tool.

 

I have tried to create an interactive chart but couldn't change the colours to what I wanted by using split by type and not separate layers 😔

 

Spoiler
hanykowska_0-1597150465758.png

 

grazitti_sapna
17 - Castor

Here is my solution to Challenge  #227.

Thanks

Sapna Gupta
JennyMartin
9 - Comet
Spoiler
AWC227.PNG

Definitely not an optimal solution but it gets to a result that I would be happy to do text analysis on. Video solution here: https://www.youtube.com/watch?v=ddJHPlmZXOQ&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=31

pasccout
8 - Asteroid

Here is the first part... I don't have access to the extra tools

huynv96
9 - Comet

Submit my solution, thanks!

Spoiler
My regex string, lol =))) :
REGEX_Replace([body], "<div[^>]*>|<\/div>|<p>|<\/p>|<a[^>]*>|<\/a>|<noscript>|<\/noscript>|<img[^>]*>|<\/img>|<span[^>]*>|<\/span>|<ol>|<\/ol>|<li>|<\/li>|<BR \/>|\\n|\(Highlight to read\)|<strong>|<\/strong>|Spoiler|<strike>|<pre>|<\/strike>|<\/pre>|<font[^>]*>|<\/font>|<LI-EMOJI[^>]*>|<\/LI-EMOJI>", "")​
Inactive User
Not applicable

Unfortunately I don't have 2020.2.

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !