SchwertImStein@lemmy.dbzer0.com to Programmer Humor@programming.devEnglish · 3 days agomuskrat's data eng expert's hard drive overheats while processing 60k rowslemmy.dbzer0.comimagemessage-square306fedilinkarrow-up1970arrow-down114
arrow-up1956arrow-down1imagemuskrat's data eng expert's hard drive overheats while processing 60k rowslemmy.dbzer0.comSchwertImStein@lemmy.dbzer0.com to Programmer Humor@programming.devEnglish · 3 days agomessage-square306fedilink
minus-squareblackbirdbiryani@lemmy.worldlinkfedilinkarrow-up1·2 days agoCould you import the column in as text to preserve it?
minus-squaredriving_crooner@lemmy.eco.brlinkfedilinkarrow-up1·2 days 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.