Memes

45522 readers

1324 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]

306

I hate excel so much (lemmy.dbzer0.com)

submitted 2 months ago* (last edited 2 months ago) by [email protected] to c/[email protected]

52 comments fedilink hide all child comments

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

[–] [email protected] 10 points 2 months ago (3 children)

That works when you have access to a SQL database instead of a bunch of massive CSV files.

[–] [email protected] 14 points 2 months ago* (last edited 2 months ago) (1 children)

cracks knuckles

import pandas as pd

[–] [email protected] 5 points 2 months ago

Now you’re speaking my language!

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

Not saying there's any reason to switch, but I believe you can load CSV's into sqlite.

Datasette would be something that I would try for CSV's as well, that seems like an interesting piece of technology I haven't had reason to use yet.

Finally there's always Jupiter Notebook and any respectable DataFrame-solution.

Not to knock spreadsheet-solutions too much - I certainly see their value and use them frequently - but if I had to do something that warranted writing VBA, I'd probably reach for a tool I could combine with some form of VCS like Git at least.

[–] [email protected] 3 points 2 months ago

Importing CSV into SQL is trivial and gives you far more control than Excel can.