Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #16: Parsing Out the New-line Character

Highlighted
12 - Quasar

Hi,

 

Sharing my solution.

 

Very quick and fun challenge. 

 

Spoiler
Challenge_16_Emil_Kos.PNG
Highlighted
8 - Asteroid

I have found the standard formula tool to be significantly faster than the data cleansing tool when you only need to do one task like remove a specific character, though clearly it is not quite as user friendly.

Not a big deal with this small dataset, but might be useful to bear in mind when dealing with GBs of data in a workflow.

Highlighted
Alteryx Partner

Here's my solution

Highlighted
7 - Meteor

This problem seemed oddly familiar...

 

Spoiler
SideSweep7_0-1589917159979.png

 

Highlighted
8 - Asteroid

My solution attached.

 

Spoiler
Challenge_16_edavilac.PNG
Highlighted
5 - Atom

Here's my solution

Highlighted
12 - Quasar
12 - Quasar

Nice use case for regex_replace

Spoiler
jarrod_0-1590172446655.png
from ayx import Alteryx
import pandas as pd

poem = Alteryx.read('#1')

poem['Field_1'] = poem['Field_1'].replace('\n',' ',regex=True) 
poem['Field_3'] = pd.to_datetime(poem['Field_3'])
poem = poem.rename(columns={'Field_1':'Poem','Field_2':'Poem_ID','Field_3':'Poem_Read_Date'})


Alteryx.write(poem,1)

#SnakingMyWayThruChallenges 

Highlighted
5 - Atom

Learned how to use the datetime tool

Highlighted
5 - Atom

Completed my second weekly challenge

Highlighted
11 - Bolide
Spoiler