Output from Python Tool

Question

Greetings!

I have reviewed other posts on this topic but did not find one that helped.  My python code extracts data from a file and places it into a DataFrame.  When the extraction completes, I use Alteryx.write to write the DataFrame out.

I want to save the output to a CSV file however the output from the Python tool is formatted with extra quotes and brackets (image below, some data is redacted with a yellow square) that make the CSV unusable in my instance.

Ideas on how to produce DataFrame output without extra characters?

Thanks!

Joe

BrandonB · Accepted Answer

If you want to do it with Alteryx tools you could follow it with two multi field formulas. One says Trim([_CurrentField_], "['") and the second says Trim([_CurrentField_], "']")