SchwertImStein@lemmy.dbzer0.com to Programmer Humor@programming.devEnglish · 2 days agomuskrat's data eng expert's hard drive overheats while processing 60k rowslemmy.dbzer0.comimagemessage-square303fedilinkarrow-up1960arrow-down113
arrow-up1947arrow-down1imagemuskrat's data eng expert's hard drive overheats while processing 60k rowslemmy.dbzer0.comSchwertImStein@lemmy.dbzer0.com to Programmer Humor@programming.devEnglish · 2 days agomessage-square303fedilink
minus-squareblackbirdbiryani@lemmy.worldlinkfedilinkarrow-up1·15 hours agoCould you import the column in as text to preserve it?
minus-squaredriving_crooner@lemmy.eco.brlinkfedilinkarrow-up1·15 hours agoSure, 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.
Could you import the column in as text to preserve it?
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.