Programmer Humor

22080 readers

686 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

Keep content in english
No advertisements
Posts must be related to programming or programmer topics

founded 2 years ago

MODERATORS

Feyter@programming.dev

anzo@programming.dev

BurningTurtle@programming.dev

pylapp@programming.dev

967

muskrat's data eng expert's hard drive overheats while processing 60k rows (lemmy.dbzer0.com)

submitted 2 weeks ago by SchwertImStein@lemmy.dbzer0.com to c/programmer_humor@programming.dev

300 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] driving_crooner 8 points 2 weeks ago* (last edited 2 weeks 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 1 week ago (1 children)

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

[–] driving_crooner 1 points 1 week ago

Sure, but sometimes you need to do a pivot table and get transformed, or you while working you accidentally made it a number, or just because excel being excel it import the number as scientific notation, or any other case.