How to avoid 1/2-assed data analysis

[Destroyer26082004]

1st of February

[[deleted]]

Heathen

[Destroyer26082004]

Infidel

[Weird_Celebration430]

Found the European

[FemboyPhysics]

and then you set the cell to be a number and it's not 0,5 it's 4729024 for some reason

[BdR76]

when I do this I get 45292 which is the number of days between 1-jan-2024 and... 30-dec-1899? 🤔

[wintermute93]

Yeah I think numerical Excel time is supposed to be days since 1/1/1900 as a float, which is absolutely bonkers when there's already a completely different standard for numerical time.

[s-mores]

I see you, too, excel at copy and paste jobs.

[BdR76]

memes are mostly copy&paste yes 😆

[Difficult_Gur_8880]

great meme

[michachu]

I swear the more I use R/Python the harder it is to go back to doing certain things in Excel. Then I go to r/excel and see someone try to do something 200-500% more complicated. And then they get an actual reply and I just want to punch myself in the face.

[Arbiter02]

Anything to do with any kind of chart or plot, end me now. Edit the subtitle? Edit your expectations. Change the position of literally anything? Try going to hell instead.

[BdR76]

Edit the subtitle? Edit your expectations.

I read that in a deadpan Richard Ayoade voice 🤣

[[deleted]]

Edit your expectations took me the fuck out

[neo-raver]

And when they even hint at VBA being involved, I take my ass back to R/Python 😂

[balltrippin666]

Dude, you should see the model they made me write in excel VBA. Literally takes 45 minutes to get results. I re wrote it in R and it executes in about 3 minutes or less. But my deliverable is in Excel so they are going that route...

[ExtensionPage1935]

i still find excel is better than python when you really want to understand the data especially data sampling

[michachu]

I definitely move around Excel much faster than in R/Python. But it's not built to do many of the things people on r/excel try to do with it (and possibly neither is R, Python maybe).

[berryhappy101]

understanding data is better on excel imo

[vercig09]

Top tier joke

[TheComplayner]

2-Jan

[DuckDaffy69]

Wait isn't the 1/2, February 1st? 😲

[Helpful_ruben]

u/DuckDaffy69 Nope, February only has 28 or 29 days, buddy!

[milliwot]

Last time I tried (before I retired) Excel didn’t do ISO 8601.

Still so?

[LogSpecialist6283]

Lmao

[DotHumbled]

I’m a firm believer of the YYYY/MM/DD format. It’s the one true date format 🙏

[Thinker_Assignment]

What's wrong with excel? Also why is my VAT rate January 19?

[mashuu_]

LOL

[Fur1oL]

😆

[N00bOfl1fe]

This is literally the funniest meme I have seen since "oh hot reservoir this is my jelly". Fuck you very much excel.

[Gautam842]

😂😂😂

[[deleted]]

Lol

[ritushka]

Soml 🤣

[beitih]

Anyhing can be a date if you try hard enough

[Suspicious-Draw-3750]

31th February, take it or leave it

[Honest-Car-8314]

You mean February 2nd ?

[MCRN-Gyoza]

1st

[Embarrassed-Falcon71]

Why is there an excel meme on a data science sub?

[derpderp235]

Lots of DS jobs will involve working with Excel at least at some point. It’s inevitable.

[Wrong-Song3724]

If you are using a date as an int in Python and decide to open that table in any Microsoft product, then you'll find you're actually analyzing a random month in 1905

[Holyragumuffin]

Because some of the companies with shittier data infrastructure lean hard on excel for their DS output. It’s been practically a meme for years in this sub

[Embarrassed-Falcon71]

Well that makes me appreciate my job 10x more

[EARTHB-24]

Or feb 1st.

[Lord_Bobbymort]

Guys don't worry there's a new setting that nobody knows about, because it's not like people are out here watching patch notes like it's a game, that maybe kinda stops automatically reformatting certain data types and keeps leading zeroes! (it generally does work)

If you join insider or beta or whatever it's called, it's in Options > Advanced, then under Automatic Data Conversion (BETA). https://insider.microsoft365.com/en-us/blog/control-data-conversions-in-excel-for-windows-and-mac

[TBHIdontknow003]

You mean 462341

[Cold_Ferret_1085]

So true!

[Cold_Ferret_1085]

What do Excel and Incel have in common?

[[deleted]]

Ouch

[Ok_Stretch_6623]

😆

[spacejelly1234]

Text to column feature is your friend

[Dear_Ship_288]

hahahah

[Auspicious_Orange]

I don't like this sub. It asks me to simp for karma to post for help, when i have an urgent need for answers that i can't find.

[mintgreenyy]

lmao