Thread Reader helps you read and share Twitter threads easily!
I'm @ThreadReaderApp a Twitter bot here to help you read threads more easily. To trigger me, you just have to reply to (or quote) any tweet of the thread you want to unroll and mention me with the "unroll" keyword and I'll send you a link back on Twitter 😀
— Thread Reader App (@threadreaderapp) November 25, 2017
X thread is series of posts by the same author connected with a line!
From any post in the thread, mention us with a keyword "unroll"
@threadreaderapp unroll
Follow @ThreadReaderApp to mention us easily!
Practice here first or read more on our help page!
Recent
How to read any new dataset in 15 minutes, before you write a single line of real analysis.
THREAD 👇👇👇👇👇
THREAD 👇👇👇👇👇
1. SHAPE AND GRAIN
Row count and column preview are not data validation.
They only tell you the table exists.
The real question is:
What does one row represent?
I once worked with a “customer” table that looked clean until the grain was checked.
It was not one row per customer.
It was one row per customer per device.
That small difference changed everything:
➝ Average order value was overstated
➝ Repeat purchase rate was distorted
➝ Churn logic became unreliable
➝ Customer count looked larger than reality
➝ Segmentation was built on duplicated behaviour
The table did not look broken.
That was the danger.
Check the grain before you trust the analysis:
SELECT customer_id, COUNT(*)
FROM table
GROUP BY customer_id
ORDER BY 2 DESC;
If this returns anything above 1 when you expect one row per customer, stop.
Do not build the dashboard.
Do not train the model.
Do not calculate churn.
Rebuild your assumptions first.
Because once the grain is wrong, every metric after it becomes confidently wrong.
Row count and column preview are not data validation.
They only tell you the table exists.
The real question is:
What does one row represent?
I once worked with a “customer” table that looked clean until the grain was checked.
It was not one row per customer.
It was one row per customer per device.
That small difference changed everything:
➝ Average order value was overstated
➝ Repeat purchase rate was distorted
➝ Churn logic became unreliable
➝ Customer count looked larger than reality
➝ Segmentation was built on duplicated behaviour
The table did not look broken.
That was the danger.
Check the grain before you trust the analysis:
SELECT customer_id, COUNT(*)
FROM table
GROUP BY customer_id
ORDER BY 2 DESC;
If this returns anything above 1 when you expect one row per customer, stop.
Do not build the dashboard.
Do not train the model.
Do not calculate churn.
Rebuild your assumptions first.
Because once the grain is wrong, every metric after it becomes confidently wrong.
2. NULLS ARE A QUESTION, NOT A METRIC
A 4% null rate sounds small.
But nulls are only harmless when they are random, expected, and understood.
I once found a 4% null rate in customer_id.
At first glance, it looked minor.
Then I segmented it.
Every missing customer_id came from one acquisition channel.
The tracking pixel had been broken for six weeks.
That “small” null rate meant:
➝ One channel was missing from attribution
➝ Campaign performance was understated
➝ Customer acquisition cost was unreliable
➝ Downstream churn modelling excluded a whole traffic source
➝ Leadership was comparing channels with incomplete evidence
That is why I do not accept null percentages at face value.
I segment them.
Check nulls by:
➝ Channel
➝ Date
➝ Region
➝ Product
➝ Device
➝ Campaign
➝ Customer type
➝ Source system
A null is not just missing data.
Sometimes it is a broken process, failed tracking, bad integration, or a business rule nobody documented.
A 4% null rate sounds small.
But nulls are only harmless when they are random, expected, and understood.
I once found a 4% null rate in customer_id.
At first glance, it looked minor.
Then I segmented it.
Every missing customer_id came from one acquisition channel.
The tracking pixel had been broken for six weeks.
That “small” null rate meant:
➝ One channel was missing from attribution
➝ Campaign performance was understated
➝ Customer acquisition cost was unreliable
➝ Downstream churn modelling excluded a whole traffic source
➝ Leadership was comparing channels with incomplete evidence
That is why I do not accept null percentages at face value.
I segment them.
Check nulls by:
➝ Channel
➝ Date
➝ Region
➝ Product
➝ Device
➝ Campaign
➝ Customer type
➝ Source system
A null is not just missing data.
Sometimes it is a broken process, failed tracking, bad integration, or a business rule nobody documented.
The media is using Congresswoman Kat Cammack's (@Kat_Cammack) heartbreaking pregnancy loss to attack pro-life laws.
They're hoping Americans don't understand the difference between treating a life-threatening ectopic pregnancy and intentionally ending the life of a healthy preborn child.
Let's talk about the facts.
They're hoping Americans don't understand the difference between treating a life-threatening ectopic pregnancy and intentionally ending the life of a healthy preborn child.
Let's talk about the facts.
An ectopic pregnancy occurs when a baby implants outside the uterus, most commonly in the fallopian tube.
Sadly, these pregnancies are not viable and will become life-threatening for the mother if left untreated.
Treating an ectopic pregnancy is not the same thing as an elective abortion. The baby is NEVER intentionally killed.
Planned Parenthood themselves have noted this distinction on their own website. Sadly, we all know they LOVE spreading misinformation and have changed the wording to equate ectopic pregnancy care to be the same thing as an intentional elective abortion.
Sadly, these pregnancies are not viable and will become life-threatening for the mother if left untreated.
Treating an ectopic pregnancy is not the same thing as an elective abortion. The baby is NEVER intentionally killed.
Planned Parenthood themselves have noted this distinction on their own website. Sadly, we all know they LOVE spreading misinformation and have changed the wording to equate ectopic pregnancy care to be the same thing as an intentional elective abortion.
Abortion is the intentional killing of a preborn child in the womb.
Treatment for an ectopic pregnancy is a medical intervention to address a life-threatening condition where the child cannot survive, regardless of what doctors do.
These are fundamentally different situations.
Treatment for an ectopic pregnancy is a medical intervention to address a life-threatening condition where the child cannot survive, regardless of what doctors do.
These are fundamentally different situations.
Thread 🧵 1/4
Yoni and I discussing last night's election results.
In this clip, we discuss politicians in general and why, without a backbone, you lose.
Yoni and I discussing last night's election results.
In this clip, we discuss politicians in general and why, without a backbone, you lose.
We need a new approach, and I’ve been doing a lot of thinking about some components of that new approach.
Jewish pride and Jewish strength.
Certainly, what we’ve been doing until now isn’t working.
Certainly, what we’ve been doing until now isn’t working.
@kali_thKitty We’re already living in an electoral matriarchy. Women cast the most votes and are the majority of voters.
Nevertheless, women elect men to do the work the women don’t want — such as the work that involves real responsibility and lots of labor — and then whine it’s a patriarchy.
Nevertheless, women elect men to do the work the women don’t want — such as the work that involves real responsibility and lots of labor — and then whine it’s a patriarchy.
@kali_thKitty “In every presidential election since 1980, the proportion of eligible female adults who voted has exceeded the proportion of eligible male adults who voted” (cawp.rutgers.edu/voters-voter-t… | infogram.com/proportion-tur… | infogram.com/number-turnout…).
@kali_thKitty “The gender gap in turnout rates and numbers tend to narrow in non-presidential election years, but women still consistently outnumber and outvote men” (cawp.rutgers.edu/voters-voter-t… | infogram.com/proportion-tur… | infogram.com/number-turnout…).
🚨 In a 2-1 vote, the Sixth Circuit ruled that the DOJ cannot force Michigan to turn over its unredacted statewide voter-registration database under the Civil Rights Act of 1960.
Judge Mathis, joined by Judge Cole, said the Civil Rights Act of 1960 only covers voting records that election officials "acquire" from others, such as voter-registration applications. Michigan's statewide voter database is created and maintained by the state itself.
Judge Nalbandian dissented, arguing the majority adopted an artificially narrow reading. He contends that Michigan's voter file is itself a voter-registration record, and that Congress intended broad federal access to election records.
I just saw a post from an MD about the increase in athletes dying of heart attacks, then I lost it. Search is broken, so I can’t find the post or the threads I made when heart attacks increased 30% in Americans ages 18-44 from 2020-2021.
2026: 66% increase. Godspeed, all.
2026: 66% increase. Godspeed, all.
Found it. Between 2020-2021, before anyone on the planet got vaccines, heart attacks had already increased almost 30% in Americans ages 25-44.
A 30% increase in one year. Today it’s 66%.
A 30% increase in one year. Today it’s 66%.
Hello? Is anyone paying attention?
1/ Ukraine is using quadcopter drones carried by uncrewed surface vessels (USVs) to hunt down and destroy Russian anti-drone teams in occupied Crimea, according to a Russian source. ⬇️
2/ Ukrainian drone carrier USVs have been observed in use in the Black Sea in recent months. The Russian warblogger 'Veterans' Notes' describes how they are being used to support Ukraine's middle-strike campaign, by suppressing air defences in the occupied regions:
3/ "Regarding mobile task forces (MOGs) on the peninsula, the enemy has begun actively hunting them. There have already been numerous cases of MOG crews coming under fire from Ukrainian drones and suffering losses. These attacks were carried out on the coast using FPV drones.
1/ The Russian government is a "great hypnotoad" that is trying to distract the population from the fact that things are bad and about to get worse, says Russian warblogger Anastasia Kashevarova. She complains that the government is attempting to "zombify people". ⬇️
2/ A common complaint among Russian warbloggers in recent months has been that the Russian government frequently but ineptly tries to play down the deteriorating situation with the Ukraine war, through so-called "anti-crisis" propaganda or simply not mentioning Ukrainian attacks.
3/ They point out that this is highly ineffective and erodes trust in the government, as anyone with an Internet connection can see – even on Russian pro-war Telegram channels – that things are not going well.
5 SIGNS YOUR SELF-CRITICISM MIGHT BE ACTUALLY ADHD:
1. The Internal Trial
You don't just "feel bad" about a mistake; you build a 20-page legal case for why you are a fundamentally "failed" person because of it.
WHY?
Because ADHD brains struggle with emotional regulation, you can't soften the feeling of failure. Your brain uses self-criticism as a way to "punish" yourself before anyone else can.
You don't just "feel bad" about a mistake; you build a 20-page legal case for why you are a fundamentally "failed" person because of it.
WHY?
Because ADHD brains struggle with emotional regulation, you can't soften the feeling of failure. Your brain uses self-criticism as a way to "punish" yourself before anyone else can.
2. The "Broken" Narrative
When you can't do a simple task like the dishes, your first thought is "I'm lazy failure," rather than "I'm tired."
WHY?
You have absorbed years of neurotypical expectations. Your ADHD brain interprets biological executive dysfunction as a moral failing, leading to a constant loop of self-blame.
When you can't do a simple task like the dishes, your first thought is "I'm lazy failure," rather than "I'm tired."
WHY?
You have absorbed years of neurotypical expectations. Your ADHD brain interprets biological executive dysfunction as a moral failing, leading to a constant loop of self-blame.
If you’ve only seen a few photos of me, you’d probably think I’m a brunette — but you’d be wrong.
Fair/pale freckled skin, green sunburst eyes, AUBURN hair =
One of the rarest bloodlines.
🔴Ireland/Scotland - The MC1R gene variant gives me auburn hair and fair skin BUT…🧵👇🏻
Fair/pale freckled skin, green sunburst eyes, AUBURN hair =
One of the rarest bloodlines.
🔴Ireland/Scotland - The MC1R gene variant gives me auburn hair and fair skin BUT…🧵👇🏻
My hair can look almost black in the winter.
This is because of my rare blend of Celtic genetics, the recessive red pheomelanin pigment, and ancient Pictish lineages which carry dense, dark eumelanin.
Because my DNA holds both, my hair can actually shift phenotypes. 🧵👇🏻
This is because of my rare blend of Celtic genetics, the recessive red pheomelanin pigment, and ancient Pictish lineages which carry dense, dark eumelanin.
Because my DNA holds both, my hair can actually shift phenotypes. 🧵👇🏻
@ZZZocrates @Remessesthe2
I met a girl online the other day, I told her she looked like a girl who’s never sold jeans before
She’s said you’re right. How did you know that? I told her I can just tell. I told her actually have some good jeans, and I’d be willing to give them to her for free.
She was so excited and said yes. She asked how I would deliver them to her. I said it’s a bit old fashioned. In person if that’s ok. She said that’s great and she couldn’t wait to get them.
