%reload_ext autotime
import pandas as pd
from bertopic import BERTopic
from bertopic.representation import KeyBERTInspired
import plotly.io as pio
import plotly.express as px # Plotting
pio.renderers.default = 'notebook'
pd.options.plotting.backend = "plotly"
pd.set_option("display.max_columns", None)
pd.set_option("display.max_colwidth", 100)

df = pd.read_excel("givealittle_health.xlsx")
df.index = pd.to_datetime(df["start"])
df["text"] = df.title.str.cat(df[["pitch", "description", "use_of_funds"]].astype(str), sep=" ")
df

	title	pitch	hero	uri	amountRaised	goal	timeLeft	action	actionUri	start	end	n_questions	location	n_donors	description	use_of_funds	whos_involved	moderated	n_updates	updates	Q&A	text
start
2025-10-25	Support Emma’s Family as They Cherish Every Moment	Supporting Emma and Her Family Through Stage 4 Cancer	https://static.givealittle.co.nz/assets/hero/86ee42e3-2455-4ca0-8ec6-b38101058d58-320:False	https://givealittle.co.nz/cause/supportforemma	9920.0	15000.0	89 days to go	Donate	https://givealittle.co.nz/donate/cause/supportforemma	25 Oct 2025	25 Jan 2026	0	Otago	129.0	Emma is a loving Mum to 8 year old Sophie and Wife to Mark. She is one of the calmest, kindest s...	All funds raised will go to Mark to support himself, Emma, and Sophie with lost wages, bills, tr...	Created by\r\nAbbey Cousens \n\n\n\n\r\n Paying to a verified bank account of\r\nMark Cous...	Page Moderated	1.0	Thank You\n26 October 2025\nHuge thank you from the bottom of my heart to everyone who has donat...	NaN	Support Emma’s Family as They Cherish Every Moment Supporting Emma and Her Family Through Stage ...
2025-10-24	Southland Farm Family Facing Breast Cancer	Help ease Tammy and Trent's financial pressure during this tough time.	https://static.givealittle.co.nz/assets/hero/cb439a2d-41cc-4cc2-b259-b380016d8e34-320:False	https://givealittle.co.nz/cause/southland-farm-family-facing-breast-cancer	3730.0	0.0	178 days to go	Donate	https://givealittle.co.nz/donate/cause/southland-farm-family-facing-breast-cancer	24 Oct 2025	24 Apr 2026	0	Southland	18.0	Tammy and Trent have always been the first to lend a hand to neighbor's, friends, and anyone in ...	Living expenses while unable to generate income due to treatment.	Created by\r\nAdele Cotton \n\n\n\n\r\n Paying to a verified bank account of\r\nTammy Wilson	Page Moderated	NaN	NaN	NaN	Southland Farm Family Facing Breast Cancer Help ease Tammy and Trent's financial pressure during...
2025-10-24	Please support Cody and his Mum Mel on their cancer journey	Please support Cody and his Mum Mel on their cancer journey	https://static.givealittle.co.nz/assets/hero/bc1c039e-949e-4b25-a72d-b37e018696b0-320:False	https://givealittle.co.nz/cause/please-support-cody-and-his-mum-mel	4453.0	0.0	488 days to go	Donate	https://givealittle.co.nz/donate/cause/please-support-cody-and-his-mum-mel	24 Oct 2025	28 Feb 2027	0	Riverton, Southland	52.0	In September 2025 15-year-old Cody Gnys suddenly became unwell, this was completely out of the b...	All funds raised will go directly towards supporting Mel and Cody - helping cover costs associat...	Created by\r\nJulie McEwan-Franks \n\n\n\n\r\n Paying to a verified bank account of\r\nMel...	Page Moderated	NaN	NaN	NaN	Please support Cody and his Mum Mel on their cancer journey Please support Cody and his Mum Mel ...
2025-10-24	“Together for Thomas — Backing a Father, Friend, and Local Legend Who’s Always There for Others”	This Givealittle page is a heartfelt tribute to Thomas — a devoted father, loving friend, and tr...	https://static.givealittle.co.nz/assets/hero/cfaec04f-ec47-4ece-84fc-b38000d61305-320:False	https://givealittle.co.nz/cause/together-for-thomas-backing-a-father-friend	845.0	10000.0	88 days to go	Donate	https://givealittle.co.nz/donate/cause/together-for-thomas-backing-a-father-friend	24 Oct 2025	24 Jan 2026	0	Whitianga, Waikato	10.0	Our Dad, Thomas, is the kindest soul and the best dad we could ever ask for. He’s always taught ...	We’re raising funds to help Dad live as fully and comfortably as possible so he can focus on wha...	Created by\r\n \r\n sharni champion\r\n \n\n\n\n\n\r\n Paying to a verifie...	Page Moderated	NaN	NaN	NaN	“Together for Thomas — Backing a Father, Friend, and Local Legend Who’s Always There for Others”...
2025-10-24	Broken but not out yet	Hate asking for help	https://static.givealittle.co.nz/assets/hero/8a7319bc-eb17-441c-9791-b373002ce3a5-320:False	https://givealittle.co.nz/cause/broken-but-not-out-yet	15.0	8000.0	343 days to go	Donate	https://givealittle.co.nz/donate/cause/broken-but-not-out-yet	24 Oct 2025	6 Oct 2026	0	New Plymouth, Taranaki	3.0	My story is an interesting one was fit working full time until June last year then sadly cant an...	Money will be spent on bills keeping afloat while I rehab in Auckland for 3 months with my partn...	Created by, and paying to a verified bank account of,\r\nMark Shirreffs	Page Moderated	NaN	NaN	NaN	Broken but not out yet Hate asking for help My story is an interesting one was fit working full ...
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
2016-05-02	Amber and Daniel were twins born on 24th and 25th December 2015. They were born at 23 weeks gest...	Raising money for the little McSweeney family who have spent the last 5 months in hospital!	https://static.givealittle.co.nz/assets/hero/a07c15e8-a593-48bb-a652-a5fa009e35b9-320:False	https://givealittle.co.nz/cause/hartleytwinsmicropremmies	4834.0	0.0	closed	Read more	https://givealittle.co.nz/cause/hartleytwinsmicropremmies	2 May 2016	6 Jun 2016	0	Canterbury	122.0	PLEASE READ THE UPDATE TO THIS POST UNDER UPDATE TAB. We need you all to know how much of an imp...	NaN	Created by, and paying to a verified bank account of,_x000D_\n _x000D_\n Elise Hartl...	Page Moderated	1.0	Attention all followers of our story\n31 May 2016\nHello, my name is Elise Hartley and I am the ...	NaN	Amber and Daniel were twins born on 24th and 25th December 2015. They were born at 23 weeks gest...
2016-05-01	Tania Whanau, known by most as Tarnz, is a strong, 40 year old woman who was diagnosed with brea...	Since February '16 Tarnz has undergone two operations; one removing 34 lymph nodes from her righ...	https://static.givealittle.co.nz/assets/hero/652566e9-6f90-4632-9b3f-a5f900e9af2c-320:False	https://givealittle.co.nz/cause/fightbreastcancerlikeabitch	1550.0	0.0	closed	Read more	https://givealittle.co.nz/cause/fightbreastcancerlikeabitch	1 May 2016	22 Jul 2016	0	Hawke's Bay	34.0	Tania Whanau, known by most as Tarnz, is a strong, 40 year old woman who was diagnosed with Grad...	NaN	Created by_x000D_\n _x000D_\n Nancy Easthope_x000D_\n \n\n\n\n\n_x000D_\n ...	Page Moderated	NaN	NaN	NaN	Tania Whanau, known by most as Tarnz, is a strong, 40 year old woman who was diagnosed with brea...
2016-05-01	Cardiology Fundraiser	Fundraising for patients & families affected by Heart Disease.	https://static.givealittle.co.nz/assets/hero/bfefeb94-f041-478f-80a0-a5f900c0dc47-320:False	https://givealittle.co.nz/cause/fund4aheart	915.0	0.0	closed	Read more	https://givealittle.co.nz/cause/fund4aheart	1 May 2016	15 Aug 2016	0	Waikato	9.0	We aim to provide clients with the most up-to-date education around their Heart Disease diagnosi...	NaN	Created by, and paying to a verified bank account of,_x000D_\n _x000D_\n Cardiology ...	Page Moderated	NaN	NaN	NaN	Cardiology Fundraiser Fundraising for patients & families affected by Heart Disease. We aim to p...
2016-04-30	Help for Julia, while she is caring for Ian Robertson	Please support me so I'll be able to continue caring for my dear friend Ian Roberston. He suffer...	https://static.givealittle.co.nz/assets/hero/531d73ca-22d8-423b-93be-a5f700a2c8ed-320:False	https://givealittle.co.nz/cause/help4julia	2645.0	0.0	closed	Read more	https://givealittle.co.nz/cause/help4julia	30 Apr 2016	30 May 2016	0	Canterbury	31.0	I'm caring for my dear Kiwi friend Ian Robertson, who suffers from terminal lung cancer. It's ge...	NaN	Created by, and paying to a verified bank account of,_x000D_\n _x000D_\n Julia Schlu...	Page Moderated	NaN	NaN	NaN	Help for Julia, while she is caring for Ian Robertson Please support me so I'll be able to conti...
2016-04-29	TRUS Biopsy Machine for Taranaki	The men of Taranaki need this TRUS Biopsy Machine to diagnose Prostate Cancer. Reduce waiting t...	https://static.givealittle.co.nz/assets/hero/c9169845-63b5-4c1e-bb50-a5fc00e5abd0-320:False	https://givealittle.co.nz/cause/prostatebiopsymachinenewplymouth	1910.0	20000.0	closed	Read more	https://givealittle.co.nz/cause/prostatebiopsymachinenewplymouth	29 Apr 2016	31 Aug 2016	0	Taranaki	15.0	Currently the TRUS (Trans Rectal Ultrasound) machine for diagnosing prostate cancer is only avai...	NaN	Created by, and paying to a verified bank account of,_x000D_\n _x000D_\n Rotary Club...	Page Moderated	NaN	NaN	NaN	TRUS Biopsy Machine for Taranaki The men of Taranaki need this TRUS Biopsy Machine to diagnose P...

11754 rows × 22 columns

time: 18.6 s (started: 2025-10-29 12:02:53 +13:00)

df.amountRaised.resample("1YS").sum().plot.bar()

time: 399 ms (started: 2025-10-29 12:03:12 +13:00)

df.resample("ME").size().plot()

time: 111 ms (started: 2025-10-29 12:03:13 +13:00)

keywords = ["covid", "cancer", "leukemia", "heart", "stroke", "kidney", "bowel"]
for word in keywords:
  df[word] = df.text.str.lower().str.contains(rf"\b{word}\b")
df

	title	pitch	hero	uri	amountRaised	goal	timeLeft	action	actionUri	start	end	n_questions	location	n_donors	description	use_of_funds	whos_involved	moderated	n_updates	updates	Q&A	text	covid	cancer	leukemia	heart	stroke	kidney	bowel
start
2025-10-25	Support Emma’s Family as They Cherish Every Moment	Supporting Emma and Her Family Through Stage 4 Cancer	https://static.givealittle.co.nz/assets/hero/86ee42e3-2455-4ca0-8ec6-b38101058d58-320:False	https://givealittle.co.nz/cause/supportforemma	9920.0	15000.0	89 days to go	Donate	https://givealittle.co.nz/donate/cause/supportforemma	25 Oct 2025	25 Jan 2026	0	Otago	129.0	Emma is a loving Mum to 8 year old Sophie and Wife to Mark. She is one of the calmest, kindest s...	All funds raised will go to Mark to support himself, Emma, and Sophie with lost wages, bills, tr...	Created by\r\nAbbey Cousens \n\n\n\n\r\n Paying to a verified bank account of\r\nMark Cous...	Page Moderated	1.0	Thank You\n26 October 2025\nHuge thank you from the bottom of my heart to everyone who has donat...	NaN	Support Emma’s Family as They Cherish Every Moment Supporting Emma and Her Family Through Stage ...	False	True	False	False	False	False	False
2025-10-24	Southland Farm Family Facing Breast Cancer	Help ease Tammy and Trent's financial pressure during this tough time.	https://static.givealittle.co.nz/assets/hero/cb439a2d-41cc-4cc2-b259-b380016d8e34-320:False	https://givealittle.co.nz/cause/southland-farm-family-facing-breast-cancer	3730.0	0.0	178 days to go	Donate	https://givealittle.co.nz/donate/cause/southland-farm-family-facing-breast-cancer	24 Oct 2025	24 Apr 2026	0	Southland	18.0	Tammy and Trent have always been the first to lend a hand to neighbor's, friends, and anyone in ...	Living expenses while unable to generate income due to treatment.	Created by\r\nAdele Cotton \n\n\n\n\r\n Paying to a verified bank account of\r\nTammy Wilson	Page Moderated	NaN	NaN	NaN	Southland Farm Family Facing Breast Cancer Help ease Tammy and Trent's financial pressure during...	False	True	False	False	False	False	False
2025-10-24	Please support Cody and his Mum Mel on their cancer journey	Please support Cody and his Mum Mel on their cancer journey	https://static.givealittle.co.nz/assets/hero/bc1c039e-949e-4b25-a72d-b37e018696b0-320:False	https://givealittle.co.nz/cause/please-support-cody-and-his-mum-mel	4453.0	0.0	488 days to go	Donate	https://givealittle.co.nz/donate/cause/please-support-cody-and-his-mum-mel	24 Oct 2025	28 Feb 2027	0	Riverton, Southland	52.0	In September 2025 15-year-old Cody Gnys suddenly became unwell, this was completely out of the b...	All funds raised will go directly towards supporting Mel and Cody - helping cover costs associat...	Created by\r\nJulie McEwan-Franks \n\n\n\n\r\n Paying to a verified bank account of\r\nMel...	Page Moderated	NaN	NaN	NaN	Please support Cody and his Mum Mel on their cancer journey Please support Cody and his Mum Mel ...	False	True	False	False	False	False	False
2025-10-24	“Together for Thomas — Backing a Father, Friend, and Local Legend Who’s Always There for Others”	This Givealittle page is a heartfelt tribute to Thomas — a devoted father, loving friend, and tr...	https://static.givealittle.co.nz/assets/hero/cfaec04f-ec47-4ece-84fc-b38000d61305-320:False	https://givealittle.co.nz/cause/together-for-thomas-backing-a-father-friend	845.0	10000.0	88 days to go	Donate	https://givealittle.co.nz/donate/cause/together-for-thomas-backing-a-father-friend	24 Oct 2025	24 Jan 2026	0	Whitianga, Waikato	10.0	Our Dad, Thomas, is the kindest soul and the best dad we could ever ask for. He’s always taught ...	We’re raising funds to help Dad live as fully and comfortably as possible so he can focus on wha...	Created by\r\n \r\n sharni champion\r\n \n\n\n\n\n\r\n Paying to a verifie...	Page Moderated	NaN	NaN	NaN	“Together for Thomas — Backing a Father, Friend, and Local Legend Who’s Always There for Others”...	False	True	False	False	False	False	False
2025-10-24	Broken but not out yet	Hate asking for help	https://static.givealittle.co.nz/assets/hero/8a7319bc-eb17-441c-9791-b373002ce3a5-320:False	https://givealittle.co.nz/cause/broken-but-not-out-yet	15.0	8000.0	343 days to go	Donate	https://givealittle.co.nz/donate/cause/broken-but-not-out-yet	24 Oct 2025	6 Oct 2026	0	New Plymouth, Taranaki	3.0	My story is an interesting one was fit working full time until June last year then sadly cant an...	Money will be spent on bills keeping afloat while I rehab in Auckland for 3 months with my partn...	Created by, and paying to a verified bank account of,\r\nMark Shirreffs	Page Moderated	NaN	NaN	NaN	Broken but not out yet Hate asking for help My story is an interesting one was fit working full ...	False	False	False	False	False	False	False
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
2016-05-02	Amber and Daniel were twins born on 24th and 25th December 2015. They were born at 23 weeks gest...	Raising money for the little McSweeney family who have spent the last 5 months in hospital!	https://static.givealittle.co.nz/assets/hero/a07c15e8-a593-48bb-a652-a5fa009e35b9-320:False	https://givealittle.co.nz/cause/hartleytwinsmicropremmies	4834.0	0.0	closed	Read more	https://givealittle.co.nz/cause/hartleytwinsmicropremmies	2 May 2016	6 Jun 2016	0	Canterbury	122.0	PLEASE READ THE UPDATE TO THIS POST UNDER UPDATE TAB. We need you all to know how much of an imp...	NaN	Created by, and paying to a verified bank account of,_x000D_\n _x000D_\n Elise Hartl...	Page Moderated	1.0	Attention all followers of our story\n31 May 2016\nHello, my name is Elise Hartley and I am the ...	NaN	Amber and Daniel were twins born on 24th and 25th December 2015. They were born at 23 weeks gest...	False	False	False	False	False	False	False
2016-05-01	Tania Whanau, known by most as Tarnz, is a strong, 40 year old woman who was diagnosed with brea...	Since February '16 Tarnz has undergone two operations; one removing 34 lymph nodes from her righ...	https://static.givealittle.co.nz/assets/hero/652566e9-6f90-4632-9b3f-a5f900e9af2c-320:False	https://givealittle.co.nz/cause/fightbreastcancerlikeabitch	1550.0	0.0	closed	Read more	https://givealittle.co.nz/cause/fightbreastcancerlikeabitch	1 May 2016	22 Jul 2016	0	Hawke's Bay	34.0	Tania Whanau, known by most as Tarnz, is a strong, 40 year old woman who was diagnosed with Grad...	NaN	Created by_x000D_\n _x000D_\n Nancy Easthope_x000D_\n \n\n\n\n\n_x000D_\n ...	Page Moderated	NaN	NaN	NaN	Tania Whanau, known by most as Tarnz, is a strong, 40 year old woman who was diagnosed with brea...	False	True	False	False	False	False	False
2016-05-01	Cardiology Fundraiser	Fundraising for patients & families affected by Heart Disease.	https://static.givealittle.co.nz/assets/hero/bfefeb94-f041-478f-80a0-a5f900c0dc47-320:False	https://givealittle.co.nz/cause/fund4aheart	915.0	0.0	closed	Read more	https://givealittle.co.nz/cause/fund4aheart	1 May 2016	15 Aug 2016	0	Waikato	9.0	We aim to provide clients with the most up-to-date education around their Heart Disease diagnosi...	NaN	Created by, and paying to a verified bank account of,_x000D_\n _x000D_\n Cardiology ...	Page Moderated	NaN	NaN	NaN	Cardiology Fundraiser Fundraising for patients & families affected by Heart Disease. We aim to p...	False	False	False	True	False	False	False
2016-04-30	Help for Julia, while she is caring for Ian Robertson	Please support me so I'll be able to continue caring for my dear friend Ian Roberston. He suffer...	https://static.givealittle.co.nz/assets/hero/531d73ca-22d8-423b-93be-a5f700a2c8ed-320:False	https://givealittle.co.nz/cause/help4julia	2645.0	0.0	closed	Read more	https://givealittle.co.nz/cause/help4julia	30 Apr 2016	30 May 2016	0	Canterbury	31.0	I'm caring for my dear Kiwi friend Ian Robertson, who suffers from terminal lung cancer. It's ge...	NaN	Created by, and paying to a verified bank account of,_x000D_\n _x000D_\n Julia Schlu...	Page Moderated	NaN	NaN	NaN	Help for Julia, while she is caring for Ian Robertson Please support me so I'll be able to conti...	False	True	False	True	False	False	False
2016-04-29	TRUS Biopsy Machine for Taranaki	The men of Taranaki need this TRUS Biopsy Machine to diagnose Prostate Cancer. Reduce waiting t...	https://static.givealittle.co.nz/assets/hero/c9169845-63b5-4c1e-bb50-a5fc00e5abd0-320:False	https://givealittle.co.nz/cause/prostatebiopsymachinenewplymouth	1910.0	20000.0	closed	Read more	https://givealittle.co.nz/cause/prostatebiopsymachinenewplymouth	29 Apr 2016	31 Aug 2016	0	Taranaki	15.0	Currently the TRUS (Trans Rectal Ultrasound) machine for diagnosing prostate cancer is only avai...	NaN	Created by, and paying to a verified bank account of,_x000D_\n _x000D_\n Rotary Club...	Page Moderated	NaN	NaN	NaN	TRUS Biopsy Machine for Taranaki The men of Taranaki need this TRUS Biopsy Machine to diagnose P...	False	True	False	False	False	False	False

11754 rows × 29 columns

time: 2.92 s (started: 2025-10-29 12:03:13 +13:00)

df.resample("1M").cancer.sum().describe()

count    115.000000
mean      38.330435
std        9.113054
min        2.000000
25%       33.000000
50%       38.000000
75%       44.500000
max       58.000000
Name: cancer, dtype: float64

time: 37.2 ms (started: 2025-10-29 12:03:16 +13:00)

df.resample("1M")[keywords].sum().plot(height=800)

time: 90.3 ms (started: 2025-10-29 12:03:16 +13:00)

topic_model = BERTopic(representation_model=KeyBERTInspired(), min_topic_size=10, verbose=True)
topic_model.fit(df.text)
topic_model.get_topic_info()

2025-10-29 12:03:16,250 - BERTopic - Embedding - Transforming documents to embeddings.

Batches:   0%|          | 0/368 [00:00<?, ?it/s]

2025-10-29 12:03:36,004 - BERTopic - Embedding - Completed ✓
2025-10-29 12:03:36,005 - BERTopic - Dimensionality - Fitting the dimensionality reduction algorithm
2025-10-29 12:04:01,438 - BERTopic - Dimensionality - Completed ✓
2025-10-29 12:04:01,441 - BERTopic - Cluster - Start clustering the reduced embeddings
2025-10-29 12:04:02,589 - BERTopic - Cluster - Completed ✓
2025-10-29 12:04:02,597 - BERTopic - Representation - Fine-tuning topics using representation models.
2025-10-29 12:04:08,255 - BERTopic - Representation - Completed ✓

	Topic	Count	Name	Representation	Representative_Docs
0	-1	6208	-1_cancer_diagnosed_support_family	[cancer, diagnosed, support, family, care, treatment, money, life, living, funds]	[Help Christine get the answers and help she needs Christine has tried several options to get th...
1	0	364	0_patients_wellness_charity_donated	[patients, wellness, charity, donated, charities, support, health, depression, foundation, couns...	[Kintsugi -Mental Health Fundraiser Let’s stand together, support each other and create a more l...
2	1	266	1_recovery_medical_expenses_suffered	[recovery, medical, expenses, suffered, rehabilitation, hospital, support, family, funds, financ...	[A long road to recovery - Scott & Nakita After the birth of their child, weighing just less 5pd...
3	2	226	2_surgery_fund_able_funds	[surgery, fund, able, funds, will, get, costs, mastectomy, cost, getting]	[Felix's Top Surgery Raising money for my gender affirming surgery Hi, my name is Felix and I'm ...
4	3	214	3_support_medical_care_funds	[support, medical, care, funds, expenses, hospital, costs, her, journey, she]	[Waikato Nurse, Wife and Mother battles Metastatic Cancer 17 years of marriage, studying to beco...
...	...	...	...	...	...
100	99	11	99_transplant_hospitalisation_providing_support	[transplant, hospitalisation, providing, support, poor, money, health, services, raise, families]	[YiXian - Asthma Ambassador: "Nothing Else Matters when you can't breathe" Education is a powerf...
101	100	10	100_hospice_treatment_treatments_therapy	[hospice, treatment, treatments, therapy, cancer, medicines, remedies, mother, chemo, fund]	[Help Sharon make memories. Help Sharon fight this awful disease and make the most of the time s...
102	101	10	101_medical_recovery_donating_hospital	[medical, recovery, donating, hospital, family, sibling, families, sara, mother, appointments]	[Meg and Ryan's Injury Relief Fund Help Meg and Ryan through injury-related loss of income. Meg ...
103	102	10	102_support_expenses_medicalcare_carebut	[support, expenses, medicalcare, carebut, lives, family, relocation, work, hope, costmedical]	[Support Steve Akroyd's recovery Hospital scans revealed cancerous lesions on Steve Akroyd’s br...
104	103	10	103_treatments_treatment_chemotherapy_cancer	[treatments, treatment, chemotherapy, cancer, oncologist, support, funded, her, life, burden]	[Help Trish Beat Cancer Fundraising to get Trish to the Sanoviv Medical Institution in Mexico fo...

105 rows × 5 columns

time: 53.4 s (started: 2025-10-29 12:03:16 +13:00)

topic_model.visualize_topics()

time: 6.35 s (started: 2025-10-29 12:04:09 +13:00)

topics_over_time = topic_model.topics_over_time(df.text, df.index, nr_bins=10)
topics_over_time

10it [00:32,  3.25s/it]

	Topic	Words	Frequency	Timestamp
0	-1	diagnosed, treatment, hospital, cancer, family	528	2016-04-25 12:48:57.600
1	0	depression, suicide, health, charity, illness	39	2016-04-25 12:48:57.600
2	1	injury, injuries, recovery, reece, accident	31	2016-04-25 12:48:57.600
3	2	transgender, depression, trans, surgery, dysphoria	2	2016-04-25 12:48:57.600
4	3	whanau, kapa, damian, family, support	11	2016-04-25 12:48:57.600
...	...	...	...	...
922	98	immunotherapy, sue, treatment, carcinoma, cancer	1	2024-11-12 09:36:00.000
923	99	breathwork, lung, breathing, breathe, respiratory	3	2024-11-12 09:36:00.000
924	100	chemotherapy, cancer, immunotherapy, treatment, fundraising	1	2024-11-12 09:36:00.000
925	101	meg, ryan, ryans, fund, funds	1	2024-11-12 09:36:00.000
926	102	cholangiocarcinoma, steve, tumors, father, family	1	2024-11-12 09:36:00.000

927 rows × 4 columns

time: 32.7 s (started: 2025-10-29 12:04:16 +13:00)

topic_model.visualize_topics_over_time(topics_over_time, top_n_topics=20, height=600)

time: 68.8 ms (started: 2025-10-29 12:04:48 +13:00)

df = df[(df.timeLeft == "closed") & (df.goal > 0)]
df["Target_completion"] = df.amountRaised / df.goal * 100
display(df["Target_completion"].describe())
df.sort_values("Target_completion")

count     4763.000000
mean        63.765547
std        744.018495
min          0.000000
25%          5.919833
50%         23.077189
75%         62.176858
max      44000.000000
Name: Target_completion, dtype: float64

	title	pitch	hero	uri	amountRaised	goal	timeLeft	action	actionUri	start	end	n_questions	location	n_donors	description	use_of_funds	whos_involved	moderated	n_updates	updates	Q&A	text	covid	cancer	leukemia	heart	stroke	kidney	bowel	Target_completion
start
2024-06-01	Me and you against the world	Help keep my bro alive ❤️	https://static.givealittle.co.nz/assets/hero/11e8353e-d3b1-4e38-983f-b18200aeb589-320:False	https://givealittle.co.nz/cause/me-and-you-against-the-world	0.0	5000.0	closed	Read more	https://givealittle.co.nz/cause/me-and-you-against-the-world	1 Jun 2024	24 Jun 2024	0	Bay of Plenty	NaN	Hi my name is Jess, my younger brother Corey (28 years old) was diagnosed with a 9cm pituitary g...	Medical expenses - to get an appointment with RestoreMe Clinic and subsequently CBD oil (prescri...	Created by_x000D_\nJessica Kelly \n\n\n\n_x000D_\n Paying to a verified bank account of_x0...	Page Moderated	NaN	NaN	NaN	Me and you against the world Help keep my bro alive ❤️ Hi my name is Jess, my younger brother Co...	False	False	False	True	False	False	False	0.00000
2024-10-13	Flights needed NZ-London to help 83 year old mum through a mastectomy	Raising funds to send a caring daughter to London to look after her 83 year old mum following a ...	https://static.givealittle.co.nz/assets/hero/03a34b2c-1401-4460-8ca3-b20800b6f41e-320:False	https://givealittle.co.nz/cause/flights-needed-nz-london-to-help-83-year-old-mum	0.0	3340.0	closed	Read more	https://givealittle.co.nz/cause/flights-needed-nz-london-to-help-83-year-old-mum	13 Oct 2024	16 Oct 2024	0	NaN	NaN	My mother has breast cancer and at 83 is having a mastectomy on 24th October. She lives alone an...	Just the flights	Created by, and paying to a verified bank account of,_x000D_\n _x000D_\n Sian Jones	Page Moderated	NaN	NaN	NaN	Flights needed NZ-London to help 83 year old mum through a mastectomy Raising funds to send a ca...	False	True	False	False	False	False	False	0.00000
2017-03-18	Filling removal to reverse multiple sclerosis	Silver filling removal to cure m.s. caused by mercury poisoning	https://static.givealittle.co.nz/assets/hero/97b5a6a5-6fb9-432b-9bb0-a73a0110af59-320:False	https://givealittle.co.nz/cause/silveramalgalmscauseautoimmunedisorders	4.0	250000.0	closed	Read more	https://givealittle.co.nz/cause/silveramalgalmscauseautoimmunedisorders	18 Mar 2017	20 Jun 2017	0	Northland	3.0	Old filling removal is dangerous and requires a dentist that really knows how to remove them saf...	Silver filling removal, 2 teeth now need to be ripped as as root canal will harbour bacteria and...	Created by, and paying to a verified bank account of,_x000D_\n _x000D_\n Sandy Howell	Page Moderated	1.0	28th april\n3 May 2017\nHad two teeth removed as they required root canals which are a death sen...	NaN	Filling removal to reverse multiple sclerosis Silver filling removal to cure m.s. caused by merc...	False	False	False	True	False	False	False	0.00160
2023-05-19	Charlies life threatening lung complication.	This page is set up to help support my family during this time of extreme hardship we are experi...	https://static.givealittle.co.nz/assets/hero/bf6e7924-c106-4b1e-b4bf-b0070056a009-320:False	https://givealittle.co.nz/cause/charlies-life-threatening-lung-complication	7.0	100000.0	closed	Read more	https://givealittle.co.nz/cause/charlies-life-threatening-lung-complication	19 May 2023	10 Oct 2023	0	Auckland	3.0	Please help our family as our lives have changed due to our sons right lung not functioning prop...	A vehicle, accomadation in a warm home. 2 sons under 3 + new born twins, funds will support us u...	Created by, and paying to a verified bank account of,_x000D_\nRobert Shane Williams	Page Moderated	NaN	NaN	NaN	Charlies life threatening lung complication. This page is set up to help support my family durin...	False	False	False	False	False	False	False	0.00700
2019-03-05	Help My Father	My Father is diagnosed with Adult CHD. His position is really critical, please help me so that i...	https://static.givealittle.co.nz/assets/hero/761d7080-ddd4-42e0-9dea-aa07014cb211-320:False	https://givealittle.co.nz/cause/help-my-father	35.0	400000.0	closed	Read more	https://givealittle.co.nz/cause/help-my-father	5 Mar 2019	30 Apr 2019	0	Auckland	3.0	Hello everyone,\nMy name is Manisha i am a single mother from India currently living in New Zeal...	For my father treatment	Created by, and paying to a verified bank account of,_x000D_\nmanisha mittal on behalf of M...	Page Moderated	NaN	NaN	NaN	Help My Father My Father is diagnosed with Adult CHD. His position is really critical, please he...	False	False	False	True	False	False	False	0.00875
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
2017-01-20	Cancer (Langhan's Cell Histiocytosis)	Raising money for treatment and recovery of being paralyzed and going through chemotherapy and h...	https://static.givealittle.co.nz/assets/hero/7ca74a99-5881-48a7-a7e4-a6fe0052b1bb-320:False	https://givealittle.co.nz/cause/shaunmurphy	1160.0	10.0	closed	Read more	https://givealittle.co.nz/cause/shaunmurphy	20 Jan 2017	8 Jul 2017	0	Auckland	27.0	Hi, I'm Shaun Murphy and I'm 25 years old.\nIf you don't already know my story, 2 years ago I st...	Rehabilitation treatment and any other costs for chemotherapy and physio	Created by, and paying to a verified bank account of,_x000D_\n _x000D_\n Shaun murphy	Page Moderated	NaN	NaN	NaN	Cancer (Langhan's Cell Histiocytosis) Raising money for treatment and recovery of being paralyze...	False	True	False	False	False	False	False	11600.00000
2017-03-19	We need to raise funds for Cibele's surgery	Please help raise funds to pay for a tumour removal surgery. Any donation will help. Thank you.	https://static.givealittle.co.nz/assets/hero/f2446f46-19a2-418b-b6fb-a73b014c6d84-320:False	https://givealittle.co.nz/cause/help4cibele	2482.0	20.0	closed	Read more	https://givealittle.co.nz/cause/help4cibele	19 Mar 2017	1 May 2017	0	Auckland	36.0	Cibele has a tumour in her stomach and desperately needs $20.000 to pay for a surgery to remove ...	To pay for a surgery to remove a tumour in her stomach.	Created by_x000D_\n _x000D_\n Carmosina Braga Trancoso_x000D_\n \n\n\n\n\n\n\n_...	Page Moderated	NaN	NaN	NaN	We need to raise funds for Cibele's surgery Please help raise funds to pay for a tumour removal ...	False	False	False	False	False	False	False	12410.00000
2017-03-22	To raise money to fight for Justice for Baby Jai curtis Blake preventable Still BIrth	Angela and Scott are seeking support with legal fees into the Still Birth of then unborn child t...	https://static.givealittle.co.nz/assets/hero/14ca9772-ba50-4f2d-91b6-a73e01280edc-320:False	https://givealittle.co.nz/cause/supportbabyjai	277.0	2.0	closed	Read more	https://givealittle.co.nz/cause/supportbabyjai	22 Mar 2017	30 Apr 2017	0	Canterbury	16.0	Angela lost her baby in utero at 37 weeks full term after a complicated pregnancy and lots of he...	funds are to fight the justice system for other women preventing this happening to other expecta...	Created by_x000D_\n _x000D_\n April Ritchie_x000D_\n \n\n\n\n\n\n\n_x000D_\n ...	Page Moderated	NaN	NaN	NaN	To raise money to fight for Justice for Baby Jai curtis Blake preventable Still BIrth Angela and...	False	False	False	False	False	False	False	13850.00000
2017-07-18	helping barry after a serious hit n run accident	our friend was in a serious hit and run and will be in hospital and after care for some time and...	https://static.givealittle.co.nz/assets/hero/2bfd0a24-b2ab-412f-b8f8-a7b400cce458-320:False	https://givealittle.co.nz/cause/barrystollery	1450.0	10.0	closed	Read more	https://givealittle.co.nz/cause/barrystollery	18 Jul 2017	30 Sep 2017	0	Bay of Plenty	18.0	One of our local motorcyclists was severly injured in a hit and run this week in tauranga he is ...	help barry to get on his feet and back to some kind of normality ideally he will need to save fo...	Created by_x000D_\n _x000D_\n Briar Morreel_x000D_\n \n\n\n\n\n\n\n_x000D_\n ...	Page Moderated	NaN	NaN	NaN	helping barry after a serious hit n run accident our friend was in a serious hit and run and wil...	False	False	False	False	False	False	False	14500.00000
2022-02-24	Help the Mason family	William's upcoming surgery/recovery	https://static.givealittle.co.nz/assets/hero/10960d59-c892-40b4-8121-ae4a0142f5fa-320:False	https://givealittle.co.nz/cause/help-the-mason-family	2200.0	5.0	closed	Read more	https://givealittle.co.nz/cause/help-the-mason-family	24 Feb 2022	25 Jun 2022	0	Upper Hutt, Wellington	38.0	Hi my name is William and I'm 38 years old and I had a massive Heart attack on the 2nd of Februa...	Everything. Travel to appointments in lower hutt and Wellington hospital ,Food, rent, petrol, ki...	Created by, and paying to a verified bank account of,_x000D_\n _x000D_\n William Mason	Page Moderated	4.0	Thanx all\n12 March 2022\nThanx all your support so far , I can't thank you enough. Have got 2 m...	NaN	Help the Mason family William's upcoming surgery/recovery Hi my name is William and I'm 38 years...	False	False	False	True	False	False	False	44000.00000

4763 rows × 30 columns

time: 38.1 ms (started: 2025-10-29 12:04:48 +13:00)

df["Target_completion"].resample("1YS").median().plot.bar()

time: 40.9 ms (started: 2025-10-29 12:04:49 +13:00)

# Take the last part of the location string (most coarse location)
df.location = df.location.str.split(", ").str[-1].replace({
  "Manawatu-Wanganui": "Manawatu / Whanganui",
  "Bay Of Plenty": "Bay of Plenty",
})
top_10 = df.location.value_counts().head(10)
top_10

location
Auckland                1420
Canterbury               560
Wellington               471
Waikato                  391
Bay of Plenty            284
Nationwide               252
Manawatu / Whanganui     204
Otago                    171
International            163
Northland                157
Name: count, dtype: int64

time: 9.99 ms (started: 2025-10-29 12:04:49 +13:00)

with pd.option_context("display.max_rows", None):
  display(df.location.value_counts())

location
Auckland                          1420
Canterbury                         560
Wellington                         471
Waikato                            391
Bay of Plenty                      284
Nationwide                         252
Manawatu / Whanganui               204
Otago                              171
International                      163
Northland                          157
Hawke's Bay                        128
Taranaki                           100
Southland                           68
Nelson / Tasman                     67
Marlborough                         40
Gisborne                            36
Christchurch                        30
Nelson                              27
West Coast                          23
Hamilton                            13
Lower Hutt                          12
Tasman                              11
Tauranga                            10
Dunedin                              7
Papamoa                              7
Kapiti Coast District                6
Lower Hutt City                      5
Porirua                              4
Palmerston North                     4
Masterton District                   4
Rotorua                              3
Hastings District                    3
Whanganui                            3
Unspecified                          3
Invercargill                         3
Whangaparaoa                         3
Far North District                   3
New Plymouth                         2
New Plymouth District                2
Whangarei                            2
Whakatane District                   2
Waikato District                     2
Hastings                             2
Upper Hutt                           2
Blenheim                             2
Tauranga City                        2
Upper Hutt City                      2
Wellington City                      2
Kingston                             1
Central Hawke's Bay District         1
Westland District                    1
Manawatū-Whanganui                   1
Tasman District                      1
Waipa District                       1
Porirua City                         1
Piha                                 1
Thames-Coromandel District           1
Timaru District                      1
Dunedin City                         1
Cambridge                            1
Manawatu District                    1
Stratford District                   1
Nelson City                          1
Matamata-Piako District              1
Buller District                      1
Waikanae                             1
Paraparaumu                          1
Horowhenua District                  1
Otorohanga District                  1
Napier City                          1
Western Bay of Plenty District       1
Name: count, dtype: int64

time: 4.87 ms (started: 2025-10-29 12:04:49 +13:00)

df.sort_values("n_donors", ascending=False).head(10)

	title	pitch	hero	uri	amountRaised	goal	timeLeft	action	actionUri	start	end	n_questions	location	n_donors	description	use_of_funds	whos_involved	moderated	n_updates	updates	Q&A	text	covid	cancer	leukemia	heart	stroke	kidney	bowel	Target_completion
start
2018-08-10	Hope for Hollie	Helping Hollie and her family fight this fight that no child or family should ever have to go th...	https://static.givealittle.co.nz/assets/hero/7822e73b-d195-41a1-b48f-ab0101246377-320:False	https://givealittle.co.nz/cause/helping-hollie-fund	652196.69	850000.0	closed	Read more	https://givealittle.co.nz/cause/helping-hollie-fund	10 Aug 2018	12 May 2022	5	Auckland	8269.0	Beautiful 8-year-old Hollie Beattie is currently in the middle of the fight of her life.\nIn Jul...	As a striving young Auckland family, Jo and John are both working full time but we know that ove...	Created by_x000D_\nSalome Schlebusch \n\n\n\n\n\n_x000D_\n Paying to a verified bank accou...	Page Moderated	19.0	Remembering Hollie\n6 May 2022\nIt is with much sadness that we update you all that on Tuesday M...	on 16 Aug 2022\nSusan asks\nKia ora,\nI am a researcher at the University of Otago (https://www....	Hope for Hollie Helping Hollie and her family fight this fight that no child or family should ev...	True	True	False	True	False	False	False	76.729022
2022-07-07	Mum and Dad both diagnosed with Stage 4 (terminal) lung cancer (non-smokers)	Help provide treatment for Mum and Dad (non-smokers) diagnosed with Stage 4 lung cancer so their...	https://static.givealittle.co.nz/assets/hero/13922d5d-8666-4cff-b904-aecb00c0ff08-320:False	https://givealittle.co.nz/cause/brook-smith-family	335980.91	315000.0	closed	Read more	https://givealittle.co.nz/cause/brook-smith-family	7 Jul 2022	31 Jan 2023	8	Auckland	5440.0	Please help us provide the best cancer treatment available to both Graham and Mery so their two ...	Any money collected will first go towards Mery's treatment (Pembrolizumab), then towards Graham'...	Created by_x000D_\n _x000D_\n Candor3_x000D_\n (Business)_x000D_\n \n\...	Page Moderated	5.0	Graham's presentation to a Parliamentary Cocktail function\n6 December 2022\nGraham was invited ...	on 27 Mar 2023\nJeanne asks\nAfter reading Graham's story on Stuff News today, can people still ...	Mum and Dad both diagnosed with Stage 4 (terminal) lung cancer (non-smokers) Help provide treatm...	False	True	False	False	False	False	False	106.660606
2018-07-14	Ka'iulani's Cancer Treatment in Barcelona, Spain	Fundraising for Ka'iulani's cancer treatment in Spain starting August 2018.	https://static.givealittle.co.nz/assets/hero/4238f3ae-20a2-409b-855c-a91d00ac5207-320:False	https://givealittle.co.nz/cause/kaiulanis-cancer-treatment-in-barcelona-spain	241236.00	65000.0	closed	Read more	https://givealittle.co.nz/cause/kaiulanis-cancer-treatment-in-barcelona-spain	14 Jul 2018	14 Jan 2019	1	Nationwide	4823.0	Ka'iulani has shown some positive signs to reducing the spread of the neuroblastoma cancer disea...	Funds raised will be used for medical treatment, flights & accommodation	Created by, and paying to a verified bank account of,_x000D_\nManihera Forbes on behalf of ...	Page Moderated	NaN	NaN	on 31 Aug 2018\nBranana asks\nDoes this givealittle page close on Jan 14th 2019, even though you...	Ka'iulani's Cancer Treatment in Barcelona, Spain Fundraising for Ka'iulani's cancer treatment in...	False	True	False	False	False	False	False	371.132308
2021-12-07	Brittany, NZ Health has let her down. After starting facial reconstruction they tell her there i...	Fundraising for Brittany to get her surgery	https://static.givealittle.co.nz/assets/hero/43590cbe-57c4-4454-842b-adf700a29656-320:False	https://givealittle.co.nz/cause/help-brittany-get-surgery	282988.84	400000.0	closed	Read more	https://givealittle.co.nz/cause/help-brittany-get-surgery	7 Dec 2021	23 Nov 2022	5	Canterbury	4271.0	Brittany has a new page here: https://givealittle.co.nz/cause/brittany-lets-get-this-done\nAfter...	Surgery - Fat grafting and a skull base prosthetic jaw. And any other costs associated with surg...	Created by_x000D_\n _x000D_\n Anna Meyer_x000D_\n \n\n\n\n\n_x000D_\n Payi...	Page Moderated	11.0	Family Very Grateful\n23 November 2022\nSo, as we come to the close of the Givealittle page, Bri...	on 9 Nov 2023\nNovalea asks\nHi there, I have just read the article (today) in Stuff re Brittany...	Brittany, NZ Health has let her down. After starting facial reconstruction they tell her there i...	False	True	False	False	False	False	False	70.747210
2025-02-05	Sophie’s Singapore Lifeline	Please help Sophie and her family by donating towards the cost of groundbreaking CAR-T cancer tr...	https://static.givealittle.co.nz/assets/hero/40a1eba1-31eb-4f32-92a0-b27b01477ad3-320:False	https://givealittle.co.nz/cause/sophies-singapore-lifeline	198871.65	500000.0	closed	Read more	https://givealittle.co.nz/cause/sophies-singapore-lifeline	5 Feb 2025	5 Aug 2025	0	Canterbury	2698.0	Our wonderful friend Sophie has been fighting Peripheral T-Cell Non-Hodgkins Lymphoma (PTCL), a ...	All funds raised will be used to fund Sophie's CAR-T cell therapy at the National University Hos...	Created by\r\nCaitlin Hewitt \n\n\n\n\r\n Paying to a verified bank account of\r\nSophie M...	Page Moderated	14.0	Mission Singapore Complete\n3 September 2025\nWe have an exciting update to give you! After a 4 ...	NaN	Sophie’s Singapore Lifeline Please help Sophie and her family by donating towards the cost of gr...	False	True	False	False	False	False	False	39.774330
2018-09-01	Save Kurt	Kurt has one last treatment option. _x000D_\nSet to be the race to save his life...	https://static.givealittle.co.nz/assets/hero/594bb8a7-d4d7-4084-b566-a94e010b506e-320:False	https://givealittle.co.nz/cause/saving-kurt	206515.34	1500000.0	closed	Read more	https://givealittle.co.nz/cause/saving-kurt	1 Sep 2018	30 Sep 2018	1	Auckland	2612.0	WE NEED YOUR HELP IN THE RUSH TO SAVE KURTS LIFE!\nKurt is a 41 year old husband and father to b...	Funds will be used for CAR-T Therapy for international patients will cost up to US$800,000. If f...	Created by_x000D_\nEmma Mildon \n\n\n\n_x000D_\n Paying to a verified bank account of_x000...	Page Moderated	2.0	Kurt accepted into a potentially life-saving cancer treatment trial after travelling to the Unit...	on 4 Sep 2018\nRom asks\nHi there,\nHave you looked into phoenix tears, could be another option ...	Save Kurt Kurt has one last treatment option. _x000D_\nSet to be the race to save his life... WE...	False	True	False	True	False	False	False	13.767689
2016-07-13	Give The Gift Of Life To Maddie	Maddie has a kidney disease that means she requires another kidney transplant.	https://static.givealittle.co.nz/assets/hero/a6f0f5bd-5afc-4865-a585-a64200b7b466-320:False	https://givealittle.co.nz/cause/givethegiftoflifetomaddie	149420.77	350000.0	closed	Read more	https://givealittle.co.nz/cause/givethegiftoflifetomaddie	13 Jul 2016	28 Feb 2018	4	Canterbury	2540.0	***Update 23/2****************\nOn the 17th of January we received a call in the night that NZ h...	NaN	Created by Sarah and Madeline Collins, paying to a verified bank account of_x000D_\n _x000D...	Page Moderated	4.0	Miracles Do Happen\n22 February 2018\nOn the 17th of January we received a call in the night tha...	on 26 Aug 2017\nSandy asks\nWhat blood type is she? Why can't she have a kidney from nz? What ar...	Give The Gift Of Life To Maddie Maddie has a kidney disease that means she requires another kidn...	False	False	False	False	False	True	False	42.691649
2023-04-25	The MacPhersons fight cancer - help support them on the journey	Helping the MacPhersons with medical and support services costs during Hamish's cancer journey.	https://static.givealittle.co.nz/assets/hero/318518b2-b8d1-448e-b65b-afef015c7a90-320:False	https://givealittle.co.nz/cause/support-the-macphersons	169191.56	210000.0	closed	Read more	https://givealittle.co.nz/cause/support-the-macphersons	25 Apr 2023	25 Apr 2024	0	Otago	2462.0	Update 9 Sept 2023:\nIt is with huge grief that I share the news with you that our beloved Hamis...	Medication (Dabrafenib and Trametinib), medical support services, mortgage, bills	Created by_x000D_\nHeidi Martin-Johnson \n\n\n\n_x000D_\n Paying to a verified bank accoun...	Page Moderated	8.0	With Grief and Love\n9 September 2023\nIt is with huge grief that I share the news with you that...	NaN	The MacPhersons fight cancer - help support them on the journey Helping the MacPhersons with med...	False	True	False	False	False	False	False	80.567410
2021-05-22	Help bring my brother Matty home	We need help bringing my critically ill brother home to NZ, cover hospital bills from overseas a...	https://static.givealittle.co.nz/assets/hero/65a30032-0067-4c5d-8554-ad9e00cf48c5-320:False	https://givealittle.co.nz/cause/help-bring-my-brother-matty-home	118398.61	126000.0	closed	Read more	https://givealittle.co.nz/cause/help-bring-my-brother-matty-home	22 May 2021	20 Nov 2021	7	Auckland	2346.0	UPDATE: Matty is now home and completed his stay in MIQ at north shore hospital. He has a long r...	Flights / expenses to come home.Update on June 20th 2021: Your donations are also helping to cov...	Created by, and paying to a verified bank account of,_x000D_\nSara Tomlinson on behalf of M...	Page Moderated	24.0	Looking more like Matty\n27 October 2021\nHi team. Just wanted to send through this pic of Matty...	on 20 Jul 2021\nGarth asks\nDear Sara,\nMy name is Garth Sutherland and I am from The Insides Co...	Help bring my brother Matty home We need help bringing my critically ill brother home to NZ, cov...	False	False	False	False	False	False	True	93.967151
2023-09-18	Help Simon fight his Cancer for his Kids	Please help Simon keep fighting to see his kids grow older, and for them to bank lots of memorie...	https://static.givealittle.co.nz/assets/hero/72cb9dca-7417-42e8-b21b-b085009a97d7-320:False	https://givealittle.co.nz/cause/helpsimonfight	176291.25	300000.0	closed	Read more	https://givealittle.co.nz/cause/helpsimonfight	18 Sep 2023	21 Jun 2024	0	Auckland	2303.0	Hi, we are the Clark Whanau, Simon, Libby and our four kids Ethan (15), Jacob and Liam (5) and E...	We set up this page specifically to pay for two drugs - pomalidomide and daratumumab and as at A...	Created by, and paying to a verified bank account of,_x000D_\nSimon and Libby Clark	Page Moderated	28.0	Devastated\n17 June 2024\nI'm devastated to let you know that my darling Simon passed away earli...	NaN	Help Simon fight his Cancer for his Kids Please help Simon keep fighting to see his kids grow ol...	False	True	False	False	False	False	False	58.763750

time: 54.7 ms (started: 2025-10-29 12:04:49 +13:00)

df[df.location.isin(top_10.index)].groupby("location")["Target_completion"].mean().sort_values(ascending=False).plot.bar(title="Mean target completion % by location")

time: 85.8 ms (started: 2025-10-29 12:04:49 +13:00)

df[df.location.isin(top_10.index)].groupby("location")["Target_completion"].median().sort_values(ascending=False).plot.bar(title="Median target completion % by location")

time: 54.9 ms (started: 2025-10-29 12:04:49 +13:00)

fig = px.box(df[df.location.isin(top_10.index)], x="location", y="Target_completion", title="Target completion % by location")
fig.update_yaxes(range=[0, 200])
fig.show()

time: 46.9 ms (started: 2025-10-29 12:04:49 +13:00)

px.scatter(df, x="n_donors", y="Target_completion", trendline="ols")

time: 1.26 s (started: 2025-10-29 12:04:49 +13:00)

px.scatter(df[(df.n_donors <= 200) & (df["Target_completion"] <= 110)], x="n_donors", y="Target_completion", trendline="ols")

time: 45 ms (started: 2025-10-29 12:04:51 +13:00)

df["duration"] = (pd.to_datetime(df.end) - pd.to_datetime(df.start, format="mixed")).dt.days
px.scatter(df, x="duration", y="Target_completion", trendline="ols")

time: 178 ms (started: 2025-10-29 12:04:51 +13:00)

px.scatter(df[(df.duration <= 100) & (df["Target_completion"] < 200)], x="duration", y="Target_completion", trendline="ols")

time: 43.4 ms (started: 2025-10-29 12:04:51 +13:00)

import statsmodels.formula.api as smf

nona = df.dropna(subset=["location", "n_donors", "duration"])
nona["Cancer"] = nona.text.str.contains("Cancer", case=False).astype(int)
nona["Surgery"] = nona.text.str.contains("Surgery", case=False).astype(int)
nona["Auckland"] = nona.location.str.contains("Auckland").astype(int)
nona["Wellington"] = nona.location.str.contains("Wellington").astype(int)
smf.ols(formula="Target_completion ~ Cancer + Surgery + Auckland + Wellington + n_donors + duration", data=nona).fit().summary()

OLS Regression Results

Dep. Variable:	Target_completion	R-squared:	0.002
Model:	OLS	Adj. R-squared:	0.001
Method:	Least Squares	F-statistic:	1.550
Date:	Wed, 29 Oct 2025	Prob (F-statistic):	0.158
Time:	12:04:51	Log-Likelihood:	-38073.
No. Observations:	4740	AIC:	7.616e+04
Df Residuals:	4733	BIC:	7.621e+04
Df Model:	6
Covariance Type:	nonrobust

	coef	std err	t	P>|t|	[0.025	0.975]
Intercept	64.5278	19.918	3.240	0.001	25.479	103.577
Cancer	-7.7772	23.555	-0.330	0.741	-53.957	38.402
Surgery	10.6898	23.133	0.462	0.644	-34.662	56.042
Auckland	2.3869	24.244	0.098	0.922	-45.143	49.917
Wellington	94.3293	37.082	2.544	0.011	21.631	167.028
n_donors	0.0384	0.046	0.844	0.399	-0.051	0.128
duration	-0.1129	0.078	-1.444	0.149	-0.266	0.040

Omnibus:	14731.485	Durbin-Watson:	2.003
Prob(Omnibus):	0.000	Jarque-Bera (JB):	1347153101.177
Skew:	47.621	Prob(JB):	0.00
Kurtosis:	2612.973	Cond. No.	953.

Notes:
[1] Standard Errors assume that the covariance matrix of the errors is correctly specified.

time: 197 ms (started: 2025-10-29 12:04:51 +13:00)