SandbagTiara2816@lemmy.dbzer0.com to Memes@lemmy.ml · edit-211 months agoI hate excel so muchlemmy.dbzer0.comimagemessage-square15fedilinkarrow-up114arrow-down12
arrow-up112arrow-down1imageI hate excel so muchlemmy.dbzer0.comSandbagTiara2816@lemmy.dbzer0.com to Memes@lemmy.ml · edit-211 months agomessage-square15fedilink
minus-squareraspberriesareyummy@lemmy.worldlinkfedilinkarrow-up0·11 months ago But, if you’re a power user doing a lot of complex data analytics, Excel is still the king. Only if you refuse to learn SQL and do everything in a fraction of the time with way more functionality.
minus-squarejubilationtcornpone@sh.itjust.workslinkfedilinkEnglisharrow-up0·11 months agoThat works when you have access to a SQL database instead of a bunch of massive CSV files.
minus-squareArtVandelay@lemmy.worldlinkfedilinkEnglisharrow-up1·edit-211 months agocracks knuckles import pandas as pd
minus-squareraspberriesareyummy@lemmy.worldlinkfedilinkarrow-up1·11 months agoImporting CSV into SQL is trivial and gives you far more control than Excel can.
Only if you refuse to learn SQL and do everything in a fraction of the time with way more functionality.
That works when you have access to a SQL database instead of a bunch of massive CSV files.
cracks knuckles
import pandas as pdImporting CSV into SQL is trivial and gives you far more control than Excel can.