Experimental browser for the Atmosphere
TIL to inspect/clean my data prior to merging in pandas. Output had 0 rows. Def something with the join. Inspected the output of each df prior to the merge and saw the column I was joining on had extra spaces. Trim function worked. db2 to SQLServer data joined. 80 sec vs 2 hours in power BI
Feb 14, 2025, 7:27 PM
{ "uri": "at://did:plc:vcyg7nsbwcxv2jxnq4recwqh/app.bsky.feed.post/3li5wpm57ec2f", "cid": "bafyreignmecxidgehryeexpvjhn23hslguxt57fhsj3zzg6quypf34o5lm", "value": { "text": "TIL to inspect/clean my data prior to merging in pandas. Output had 0 rows. Def something with the join. Inspected the output of each df prior to the merge and saw the column I was joining on had extra spaces. Trim function worked. db2 to SQLServer data joined. 80 sec vs 2 hours in power BI", "$type": "app.bsky.feed.post", "langs": [ "en" ], "createdAt": "2025-02-14T19:27:42.749Z" } }