Why are you learning Python if you haven't needed it before?

Many of the tools I use have Python embedded right in there and I need to do things that the tools don't do natively.

I can read Python and understand it, but not really write it from scratch without stumbling through and reading lots of docs, StackOverflow, and GeeksForGeeks.

I need to manipulate some data using Alteryx that comes from an API call. For reasons that are dumb, but insurmountable, Alteryx cannot call this API directly.

Alteryx has Python embedded and even includes an embedded Jupyter IDE. I have Python code that makes the API calls and pulls down the data.

The only way to get the data out of the Python blob is using a pandas datastream. Any field that was a list or dictionary in the original data, is just a string when it comes out in the same pickle format you'd get if you did a print from Python.

Alteryx doesn't understand pickle format. It barely understand JSON. But I need to convert pickle to JSON and I cannot find a reliable way to do that just using character substitution and regular expressions.

I can't get the data out of Python in JSON format unless you know how to force pandas to represent the data as JSON instead of native Python dict and list. Alteryx properly converts the other datatypes to Alteryx-native datatypes, just not those.

There are tools in Alteryx to unnest objects and flatten arrays but they have to be valid JSON.

When I try just replacing ' with ", None with null, True with true, and False with false, I get errors which I assume are from replacing an embedded or escaped '.

Alteryx error messages are terrible. The input is 18,000 lines, each one a dict to be parsed. I convert them to what I think is valid JSON and send them to the JSON parser which returns this error Missing comma or '}' after an object member. at character position: 170. Not which line it happened on. Not any context where I can search or find it. Just that.

Would anyone have a reliable way to convert the strings of pickle to valid JSON?

#Python #Alteryx #JSON #PCRE #regex #Pickle

my mom is coming to visit for #passover. I asked if she wanted anything from the grocery store--here's how the #conversation went:

her: diet coke & pickle juice
me: ... like pickles & you want to drink the brine?
her: no. they make just pickle juice.
me, after checking grocery online ordering: they have pickle shots & pickle bloody mary mix which doesn't seem like what you want. is there a substitute you want me to get?
her, no answer.
🙃

#silly #pickle #mom #parent #oy

Just so you all know

The cat has been promoted, from 'Massive pain in the arse' to 'Massive pain in *everyone's* arse'

There shall be a short ceremony at 2pm on Saturday. In lieu of gifts, please make donations to the RSPCB

#Pickle

The PJ party is live and we're in a #pickle - the only thing that can save me is draining #subs and having my #vibe set off while I make quick pickles!
Double #domme sessions with @RileySynn on #LoyalFans
Solo feed on #Chaturbate, #Stripchat, #JoystickTV and #Fansly ;)

#femdom #findom #draingame

No se si alguna vez os he enseñado a Pepi el samurai. Lo dibuje hace años basandome en una foto de una armadura.

#pepino #pickle #cucumber #art #mastoart #arte #paintoolsai

!!THIS WEEKEND'S AGENDA!!
Tonight: The #NSFW NewsFlash. We're talking marketing mayhem & SexSEO!
Saturday: #PICKLE PJ PARTY. My #findom friends & I are draining gherkins :P
Sunday: #Subscribers only/ticket show #mud #bath #WAM #Sploshing Stream!

#femdom #bbw #wetandmessy #sapiophile

Oops, almost missed Caturday!

Here's Marley having a little 🥒 Pickle Time 🥒 

Remember, kids -- always use catnip responsibly 

#Caturday #CatsOfMastodon #cats #kitty #FuzzyBaby #whiskers #peets #blep #pickle #catnip