ATProto Browser

ATProto Browser

Experimental browser for the Atmosphere

Post

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

Record data

{
  "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"
  }
}