436
TELL ME (lemmy.world)

TELL ME

you are viewing a single comment's thread
view the rest of the comments
[-] deegeese@sopuli.xyz 3 points 9 months ago

But what about empty string, and what’s the difference between NULL and “NULL”? Is NaN a null number?

[-] fsxylo@sh.itjust.works 2 points 9 months ago

So there is the "it depends" answer, but generally:

NULL means a value doesn't exist in memory, usually because the variable was never given a value, or because the variable was given the null value.

"NULL" is a string with the word null written in all caps. It's not an empty string and it's not NULL. It's a value with the word "NULL".

"" is an empty string. It's not NULL because technically it's fully initialized value. It's a string that has a length of 0 characters.

NaN is not a number. A value could or could not exist, but if it's not a number then if you check for a number you could get NaN.

[-] Hamartiogonic@sopuli.xyz 1 points 9 months ago

It depends on the context. What was described as NA in that example by be NULL or NaN in another application. For example, excel power query would call it NULL, which I find baffling having used R.

It’s basically Wild West out there. There are no rules, there is only chaos.

[-] deegeese@sopuli.xyz 3 points 9 months ago

Excel probably thinks null is Jan-01-1900.

[-] Hamartiogonic@sopuli.xyz 2 points 9 months ago

And empty cells are zeroes. 🤯

this post was submitted on 13 Feb 2024
436 points (91.9% liked)

Lemmy Be Wholesome

6540 readers
334 users here now

Welcome to Lemmy Be Wholesome. This is the polar opposite of LemmeShitpost. Here you can post wholesome memes, palate cleanser and good vibes.

The home to heal your soul. No bleak-posting!

Rules:


1. Be Respectful


Refrain from using harmful language pertaining to a protected characteristic: e.g. race, gender, sexuality, disability or religion.

Refrain from being argumentative when responding or commenting to posts/replies. Personal attacks are not welcome here.

...


2. No Illegal Content


Content that violates the law. Any post/comment found to be in breach of common law will be removed and given to the authorities if required.

That means: -No promoting violence/threats against any individuals

-No CSA content or Revenge Porn

-No sharing private/personal information (Doxxing)

...


3. No Spam


Posting the same post, no matter the intent is against the rules.

-If you have posted content, please refrain from re-posting said content within this community.

-Do not spam posts with intent to harass, annoy, bully, advertise, scam or harm this community.

-No posting Scams/Advertisements/Phishing Links/IP Grabbers

-No Bots, Bots will be banned from the community.

...


4. No Porn/ExplicitContent


-Do not post explicit content. Lemmy.World is not the instance for NSFW content.

-Do not post Gore or Shock Content.

...


5. No Enciting Harassment,Brigading, Doxxing or Witch Hunts


-Do not Brigade other Communities

-No calls to action against other communities/users within Lemmy or outside of Lemmy.

-No Witch Hunts against users/communities.

-No content that harasses members within or outside of the community.

...


6. No NSFW Content


-Content shouldn't be NSFW

-Refrain from posting triggering content, if the content might be triggering try putting it behind NSFW tags.


7. Content should be Wholesome, we accept cute cats, kittens, puppies, dogs and anything, everything that restores your faith in humanity!


Content that isn't wholesome will be removed.

...


8. Reposting of Reddit content is permitted, try to credit the OC.


-Please consider crediting the OC when reposting content. A name of the user or a link to the original post is sufficient.

...


Also check out:

Partnered Communities:

1.Lemmy Review

2.Mildly Infuriating

3.Lemmy Shitpost

4.No Stupid Questions

5.You Should Know

6.Jokes

7.Credible Defense

...

Reach out to LillianVS for inclusion on the sidebar.

All communities included on the sidebar are to be made in compliance with the instance rules.

founded 1 year ago
MODERATORS