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
Bola de fogo

227

dsmdavid
Bólide

 

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

Saqueador
dsmdavid_0-1597065710386.png

 

No option to install the text mining tools for now

balajilolla
Asteroide
Saqueador
Solution Attached
balajilolla_2-1597090232956.png

 

 

 

hanykowska
Bólide

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 😔

 

Saqueador
hanykowska_0-1597150465758.png

 

Here is my solution to Challenge  #227.

Thanks

Sapna Gupta
JennyMartin
Cometa
Saqueador
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
Asteroide

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

huynv96
Cometa

Submit my solution, thanks!

Saqueador
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
Não aplicável

Unfortunately I don't have 2020.2.

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !