this post was submitted on 27 Jan 2024
1199 points (96.9% liked)

Science Memes

11253 readers
2934 users here now

Welcome to c/science_memes @ Mander.xyz!

A place for majestic STEMLORD peacocking, as well as memes about the realities of working in a lab.

Rules

  1. Don't throw mud. Behave like an intellectual and remember the human.
  2. Keep it rooted (on topic).
  3. No spam.
  4. Infographics welcome, get schooled.

This is a science community. We use the Dawkins definition of meme.

Research Committee

Other Mander Communities

Science and Research

Biology and Life Sciences

Physical Sciences

Humanities and Social Sciences

Practical and Applied Sciences

Memes

Miscellaneous

founded 2 years ago
MODERATORS
[email protected]
[email protected]
[email protected]
1199
despite all my rage IT keeps me trapped like a rat in a cage. (mander.xyz)
submitted 10 months ago by [email protected] to c/[email protected]
191 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 30 points 10 months ago (3 children)

Unpopular opinion time: but give me a csv and a python script any day over excel.

I can’t count the hours I spend cleaning up and debugging xlsx files from customers that were completely unusable due to excels automatic data type feature.

[–] [email protected] 9 points 10 months ago

You can turn that off now.

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

What do Excel and Incels have in common?

They assume everything is a date.

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

How about an Excel with Python scripting? That would be awesome.

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

Not sure if you're joking, but that's a thing. You can just insert python scripts into a cell and have their return values be the cell value.

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

Python in Excel requires Internet access because calculations run on remote servers in the Microsoft Cloud. The calculations are not run by your local Excel application. 

From: https://support.microsoft.com/en-us/office/troubleshoot-python-in-excel-errors-7736520d-47ef-43a8-b640-d826afb63249

[–] [email protected] 1 points 10 months ago

... so?

[–] [email protected] 1 points 10 months ago

That sounds like pychart to me!