Elspeth Kirkman
Region: GB
Wednesday 21 May 2025 07:35:03 GMT
97869
11056
568
2638
Music
Download
Comments
Boomer :
That's exactly why data analysis is NOT DONE WITH EXCEL. Use software that is actually made for the usecase.
2025-05-21 10:30:16
756
Liz Guernsey Scientist 🇬🇬 :
Excel and dates is such a pervasive, infuriating issue
2025-05-21 07:47:09
2057
natedill :
Who's peer reviewing these?
2025-05-22 14:01:29
0
sillybum4567 :
this isn't an excel problem, it's a researcher problem
2025-05-21 08:59:07
161
hugging face :
one more reason to hate excel for me as a data analyst 😁
2025-05-21 07:46:27
167
Tori :
Some people look at a glass and think it’s 1/2 empty and some think it’s 1/2 full but excel thinks it’s January 2nd
2025-05-22 11:01:30
49
Christian Sonne :
found out recently that when reading a csv in pandas, the country code NA (Namibia) is converted into None, because it's interpreted as Not Available
2025-05-21 11:53:24
107
andybak :
Or, you know, Microsoft could make it easy and obvious how to disable the feature. There are no user errors - there is only bad UI design...
2025-05-21 07:53:46
894
Iván :
You have to understand that Excel is a new software from a very recent born software company (irony)
2025-05-21 15:54:15
0
DragonCake :
"If you are using Excel for everything, your IT have failed you" A DB with appropriate data types is the solution
2025-05-21 09:16:28
120
Robert Patrick :
Ok just so people know: excel corrects data even if you do all configuration right. Excel has mistakes in its configuration and import functions.
2025-05-21 13:17:56
72
_hoseph :
the actual analysis is done in software like R or Python, the errors come when exporting tables to excel. Still a prob but not impacting the actual research- source is me doing a giant transcriptomics project in my PhD lmao
2025-05-22 04:01:21
44
Rhys :
Australian mobile numbers start with 0. Excel tries to remove leading 0s
2025-05-21 12:57:50
247
Meldramiriel :
Format plain text..
2025-05-21 08:20:43
35
heyjaimefish :
Is excel doing a form of mainsplaining data to scientists?
2025-05-21 15:38:15
26
endelos :
And then you try to input a date and it gives you THE WRONG DATE
2025-05-21 14:28:44
194
🦇 Leon the Bat 🍂 :
No scientific analysis should be done in excel when it can be done with python
2025-05-21 12:32:41
17
M :
Data scientist here…why are we storing datasets in excel?
2025-05-22 04:09:20
20
user3791861761107 :
Software issue or user error?
2025-05-21 08:14:56
3
~The Christine~ :
Part of having AI doing everything for you and instead of you is that it overrules and automatically "corrects" what you said into what it thinks you should be saying based on what everyone else types. People NEVER learn the lesson that laziness doesn't pay off. It creates just as many extra mistakes and extra steps as it "saves". 🙄 I beg everyone to turn that AI assistance shit all the way off and prove you have a brain that can't be replaced by a chipset that works for free (or you will be).
2025-05-22 10:47:39
3
QMJ 🇦🇺 :
Sorry, user error. How are they not setting the number format preferences?
2025-05-21 11:05:54
6
punk_pig :
It’s possible to change the cell to text format though, no?
2025-05-21 07:54:48
4
🧏 :
who uses MS Excel for scientific data??! 🤥
2025-05-21 14:13:55
1
ceddog :
What a nightmare
2025-05-22 14:29:48
0
tonstein27 :
i don't think you can blame excel for this one, why are so many researchers using software they don't understand and not checking the output? it seems like a culture problem in genetics research to me
2025-05-21 08:43:14
79
To see more videos from user @karminker, please go to the Tikwm
homepage.
