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

Science Memes

11047 readers
3928 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]
1227
despite all my rage IT keeps me trapped like a rat in a cage. (mander.xyz)
submitted 9 months ago by [email protected] to c/[email protected]
211 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 30 points 9 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 9 months ago

You can turn that off now.

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

What do Excel and Incels have in common?

They assume everything is a date.

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

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

[–] [email protected] 2 points 9 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 9 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 9 months ago

... so?

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

That sounds like pychart to me!