Challenge #16: Parsing Out the New-line Character

[Emil_Kos]

Hi,

Sharing my solution.

Very quick and fun challenge. 

Spoiler

[DavidLane]

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.

[DMContente]

Here's my solution

[SideSweep7]

This problem seemed oddly familiar...

Spoiler

[edavilac]

My solution attached.

Spoiler

[powell]

Here's my solution

[jarrod]

Nice use case for regex_replace

Spoiler

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 

[vorod]

Learned how to use the datetime tool

[namrad]

Completed my second weekly challenge 🙂

[deviseetharaman]

Spoiler