#grouping data

[codewithnazam]

Data Manipulation: A Beginner's Guide to Pandas Dataframe Operations

Outline: What’s a Pandas Dataframe? (Think Spreadsheet on Steroids!) Say Goodbye to Messy Data: Pandas Tames the Beast Rows, Columns, and More: Navigating the Dataframe Landscape Mastering the Magic: Essential Dataframe Operations Selection Superpower: Picking the Data You Need Grab Specific Columns: Like Picking Out Your Favorite Colors Filter Rows with Precision: Finding Just the Right…

[bumblingbabooshka]

Tuvok is not as autistic coded in-narrative compared to what I've seen of Spock or T'Pol where they're othered heavily by those around them and have themes and arcs about struggling/striving to fit in BUT I do think he provides the vital autistic representation of not really angsting about your differences from other people because you're too busy and unaware and then even when you ARE made aware you mostly just think 'glad that's not me'. I think it's vital to have that sort of totally unbothered rep. I love that Tuvok is completely satisfied and proud of being Vulcan, doesn't long to experience emotion or struggle with a desire to express himself in a way his crewmates will understand, to be closer to them. I love that he has a long time and close friend that respects who he is and doesn't try to change him and that how close they are isn't framed as being in spite of his Vulcan nature. I love that being Vulcan isn't framed as a hindrance to him, like a roadblock to living a full and rich life. He has a wife and four kids and is a devoted husband and father. He's getting into gay horror scenarios. Tuvok was born on autism planet and he's thriving.

[infiniteglitterfall]

this is my most autistic half-birthday ever!

I gave myself the day to pursue a special interest and fulfill an offer I'd made last year.

The Jewish Virtual Library has a page listing all the rocket and mortar attacks on Israel since 2001 (which was when they first started). But it's incomplete. Last fall, I noticed it stopped in August, so I wrote to them offering to help update it. They thanked me and gave me some places I could look.

Today, I finally did it. I ended up cross-referencing with the lists on Wikipedia, digging through multiple Twitter accounts and outside news sources and NGOs, and sending them an email with my updates... plus an html file where I'd updated the code on the page so they could just check it and upload it instead of typing in all the data themselves.

I am such a huge nerd.

There's definitely more research to do. But I think I found a strong stopping place that let me actually send what I found and post about it. Which is always the hardest part. As my drafts folder could tell you.

I have more than two thousand drafts on here.

Anyway, I'm going to put my findings under a cut tag. Before you read on, I want you to try to guess.

Because one of the things I've been told most often by people who wanna Argue About Palestine Without Having To Learn Anything About Palestine (Or Israel Or History Or Imperialism Or Fact-Checking Or ?????) is that the reason for October 7, the reason for literally anything in fact, is that "Israel bombs Palestine constantly."

I want to put together a list of Israeli airstrikes next. I would love to reblog this with that information. But first, I want you to guess:

Note that this DOES NOT include terrorist car rammings, mass shootings, mass stabbings, bus bombings, suicide bombings, etc. It therefore excludes almost the entire Second Intifada.

After correcting the most recent four years and sending in my corrections, I made a list of the totals using the most complete collection I could find for each year. (Sometimes it was Jewish Virtual Library, sometimes it was Wikipedia, and sometimes they matched.)

2024: 12,629 (an average of 35 per day)

2023: 12,295 (34 per day)

2022: 1,180 (only 3 per day)

2021: 4,425 (12 per day)

2020: about 203

2019: 798+

2018: 348+, 0.95 per day

2017: Only 47!!! Why, it's almost like living in Canada!! 0.1 per day.

2016: Wow, only 20. See, if you go through the years backwards, it looks like progress is being made.  Very exciting. Until I get to the Second Intifada, probably. 0.05 per day.

2015: 58.

2014: oh right, that war. 4,778. (Wikipedia's 2015 list claims " In August 2014, Operation Protective Edge was ended after 4,594 rockets and mortars launched toward Israel. From the end of the operation came into force an unofficial cease-fire between Israel and Hamas." but there were three more after that, and 181 before it, listed on wikipedia alone. so like. 4,778 actually, for 13 a day.)

2013: 70 total. Wikipedia notes this was the lowest number since 2001.

2012: 2,442, or 6.7 per day.

2011: 680, for 1.9 a day.

2010: 365, for exactly one a day.

2009: 858, or 2.4 per day.

2008: 3,107! that's 8.5 a day.

2007: 2,807: 7.7 a day.

2006: 1,275, or 3.5 a day.

2005: 858. An average of 2.4 per day.

2004: 1,158.

2003: 637.

2002: 472.]

2001: "These attacks commenced in April 2001, although the first rocket to hit an Israeli city was on 5 March 2002, and the first Israeli fatality was 28 June 2004." I count 173 mortar attacks in 2001, however. Which makes the first fatality a critically-injured baby in 2001. And as soon as I make 250+ more edits and have the power to edit Wikipedia articles on "controversial" topics, I'll make it say so.

Grand Total: 51,685.

An average of SIX PER DAY.

FOR 24 YEARS.

I've been saying four.

But there were actually thousands that weren't listed on the Virtual Library site yet. It really cranked up that average.

Now consider this: between 10%-30% misfire and either crash into the sea, or hit Gaza.

A surprising number of Gazan casualties in every "conflict" have been from Hamas & Co's own missiles.

And they know this. And not only do they not care, but they keep using everything from mosques to humanitarian zones as rocket launch sites.

And why shouldn't they? You have to really dig to find information on how many Gazans die that way. Almost everyone just attributes the deaths to Israel. Hamas is never going to get any actual flak for accidentally killing its own civilians. It barely gets any flak for intentionally killing Israeli civilians, for pete's sake.

[the-real-list-of-ominous-threats]

I’m going to make your p-value 40

[mostly-natm]

The student becomes the teacher.

[project-sekai-facts]

Here's 25-ji, Nightcord de.'s artworks from the 3rd anniversary site!

[genderful-ghoul]

Can we please start having open conversations about how we are going to preserve fanworks, access to fanworks, and fan spaces in the US under the harsh Project 2025-lead government?

Edit: I know there has been no policy change, but it’s clear this is a warning to everyone that a storm is coming. We still need to prepare.

[bookwyrminspiration]

sisyphus moanin about that boulder when he doesn't even have to write a research essay with three strangers

[iamthepulta]

There is a woodpecker hammering at the side of the house and it's a bold take for 10:30 am, bird.

[kodokberjamur]

If anyone asks me how life is going, I'll just show them this video and not elaborate further... Yes I keep posting I'm sorry

Warning: local toad crashes out in the tags

[asexualbookbird]

25 in 2025

Sigh. I've been bullied. I guess. I did a big swing and a miss on last years list, but I have a Plan this time. A Theme. A Goal. This will be mostly comprised of my Illumicrate books so I can decide if it is in fact worth it to keep my subscription going until the Alecto edition gets announced. If I don't actually enjoy the majority of the books in these boxes then what's the point, yknow?

So here's this years color key:

Green - Carry over from last year (not carrying over every missed book, which probably means I should just get rid of them huh)

Purple - Illumicrate books

Blue - I own these in physical form, but they're not from Illumicrate

Labyrinth's Heart by MA Carrick

The Faithless by CL Clark

The Art of Prophecy by Wesley Chu

The Jasmine Throne by Tasha Suri

City of Bones by Martha Wells

Witch King by Martha Wells

After the Forest by Kell Woods

Voyage of the Damned by Frances White

Of Jade and Dragons by Amber Chen

The Phoenix Keeper by SA Maclean

A Dark and Drowning Tide by Allison Saft

Until We Shatter by Kate Dylan

Mistress of Lies by KM Enright

Hammajang Luck by Makana Yamamoto

A Sorceress Comes to Call by T Kingfisher

The Bone Shard War by Andrea Stewart

The Last Hour Between Worlds by Melissa Caruso

The Spare Man by Mary Robinette Kowal

He Who Drowned the World by Shelley Parker Chan

All Those Explosions Were Someone Else's Fault by James Alan Gardner

The Tainted Cup by Robert Jackson Bennett

The Spellshop by Sarah Beth Durst

Can't Spell Treason Without Tea by Rebecca Thorne

In the Ravenous Dark by AM Strickland

A Conjuring of Light by VE Schwab

PHEW. Okay. A fw things to note. A Dark and Drowning Tide is an Illumicrate book, but I didn't pay for it. A friend gave it to me after I skipped that month because she wasn't interested. I always look up book spoilers and skip if I'm not interested and if I'm uninterested in any of the stuff I'll skip even if the book seems neat. That month the box was full of fandoms I didn't care about, so my friends said "here, take my copy" and I said "yay! Free book!"

Cutting in during the month of April to say Until We Shatter was also probably given to me by a friend because it's NOT in my order history and I don't have the stuff in that box but it IS on my shelf?? Wild. Where'd it come from.

The Last Hour Between Worlds I think was also an Illumicrate book? They do fanart for it so I assume it was at some point. I did not get it. This is not the IC edition. I was not thrilled about The Tethered Mage so I was going to get this out of the library. Then my mom bought it for me for the holidays. So yay! Free book!

I think I would also like to keep track of books I purchase this year. I'd like to cut down on buying books that I won't love. So I'd like to utilise my library more. Win win, I think! And that seems easier than a full out ban since yeah sometimes I do enjoy little treats! Books purchased for other people do not count, obviously.

There are also some books I'd like to reread this year, mainly The Bone Maker because I've been saying that since I read it the first time. And honestly, I've been chasing the same vibes and haven't been able to match it (Godkiller got close!).

As usual, I reserve the right to pretend this post doesn't exist, but I think I've set myself up for success here :)

I don't know who hasn't done this by now @logarithmicpanda ? Have you?? Consider yourself tagged >:3c

oh right I was bullied tagged by @bigcats-birds-and-books

[blessedbrick]

Data and Worf are both left-handed. But Riker uses his phaser with his left hand. If I remember right, Geordi is also some type of ambidextrous

[wearethekat]

it's concerning that I've seen multiple people commenting Lews Therin is attractive. please, thinking Lews Therin is hot is the leading cause of becoming a forsaken...

[flying-cat]

no need to ban tiktok if meta is buying it. i'll just delete it myself lmfao

[fisheito]

let him speak

[pleasecatchforusthefoxes]

if you fill out my super quick form you can have a token of gratitude =)