this post was submitted on 16 Mar 2025
911 points (98.7% liked)

Programmer Humor

21610 readers
2091 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 2 years ago
MODERATORS
Feyter@programming.dev
anzo@programming.dev
BurningTurtle@programming.dev
pylapp@programming.dev
911
muskrat's data eng expert's hard drive overheats while processing 60k rows (lemmy.dbzer0.com)
submitted 1 day ago by SchwertImStein@lemmy.dbzer0.com to c/programmer_humor@programming.dev
287 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[โ€“] driving_crooner@lemmy.eco.br 8 points 17 hours ago* (last edited 17 hours ago) (1 children)

It completely screws up numbers if the column is a number and the number is over 15 digits long.

I work in insurance in Brazil, by standards of our regulatory body, claims numbers must be a string of 20 numbers (zfill(20) if needed). You can't imagine the amount of times excel had fucked me up rounding down the claim numbers, this is one of the first things I teach to my interns and juniors when they're working with the claims databases.

[โ€“] blackbirdbiryani@lemmy.world 1 points 10 minutes ago

Could you import the column in as text to preserve it?