Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI 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.
Nice use case for regex_replace
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