Memes

45902 readers

1435 users here now

Rules:

Be civil and nice.
Try not to excessively repost, as a rule of thumb, wait at least 2 months to do it if you have to.

founded 5 years ago

MODERATORS

[email protected]

311

Aced it (sh.itjust.works)

submitted 2 weeks ago by [email protected] to c/[email protected]

6 comments fedilink hide all child comments

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

[–] [email protected] 7 points 2 weeks ago (3 children)

I keep an empty sql DB just for importing and working with spreadsheets to minimize how much I have to fuck with excel.

[–] [email protected] 6 points 2 weeks ago

I do a lot of my wrangling in R for more ad hoc stuff.

[–] [email protected] 4 points 2 weeks ago (1 children)

Mind elaborating? I'm interested in anything keeping me away from excel

[–] [email protected] 7 points 2 weeks ago* (last edited 2 weeks ago)

You can also use BULK INSERT for csvs or just INSERT INTO and some text editing depending on the specifics.

This is more for one-off stuff like analyzing some 10,000 row spreadsheet you've been handed that you could probably do with formulas in excel, but it's easier to use sql, but not worth building a proper process for.

[–] [email protected] 3 points 1 week ago

Might want to give notebooks like Jupyter a try - they make for a pretty good time when it comes to working with data.