#data source: github

[buffydataviz]

BTVS speaking time (racing bar chart)

Finally get to post something I created! Eventually I will make a Tableau dashboard to dig into this data, but for now here is a very rough racing bar chart, showing the top 11 BTVS characters by speaking time, per episode. This is built on the work done by J. Freedland in GitHub, which I linked to previously. Details below the cut.

BTVS_speaking_time

A Flourish data visualisation by Buffy Data Viz

When I googled how to create a racing bar chart for free, I found something called Flourish. It was very easy to create, so I decided to go ahead and make a rough version of this. (No coding required if you want to create your own. This post sadly not sponsored.) The colors on this aren't great, to keep it legible I limited it to the top 11 characters, it lacks captions, and it lacks images (faces) for the top characters. I can actually fix all that in Flourish but don't have the time at the moment. BUT you get the point.

Notes:

This is cumulative speaking time per episode for each character, in seconds. (The original J. Freedland data did the work of compiling this for each character for each episode.)

Angel and Angelus are treated separately in the original J. Freedland data, but I chose to combine them into one character labeled "Angel." This is consistent with how Spike's speaking time is treated, with only one entry. (I also deleted the original Flourish bars for Angel and Angelus, you can only see the combined bar here.)

For whatever reason the original J. Freedland data combines E01 and E02 for S06 into one entry.

I have not spot checked the J. Freedland data with a stopwatch, but from reviewing it at a high level it seems accurate.

ADDED 09/01: Joyce has speaking time in S7, but this is the First using her body. So note that this data source credits First's speaking time to the character the First is using. (You can also think of it as this data using the actors and not the characters.)

Happy to share the source data (currently in excel) upon request, however it is really just the raw csv from J. Freedland's GitHub in excel, and then basic math making it cumulative to put into Flourish.

If you have any requests for this type of chart for BTVS let me know! It would be relatively easy to re-create this for specific characters and / or focus on specific seasons.

[buffydataviz]

BTVS Speaking Time: Buffy Boos edition (racing bar chart)

Buffy is a hero. Buffy saved the world ALOT. Buffy cannot be reduced to the people she dated / flirted with.

And Yet... It is fun to compare. I created the Buffy Boos edition of the previous chart, and made some other improvements. ("Love interest" sounds like a 1980s term, and trying to be gender neutral I chose "boos.") So you have 17 of Buffy's boos in a racing bar chart, showing their speaking time, per episode. Unlike the previous version (with all characters) this has images for the top characters, and INTERACTIVE CATEGORIES. (Again, credit to J. Freedland who did the GitHub data work.) Details below the cut.

BTVS_Buffy_Boos_speaking_time

A Flourish data visualisation by Buffy Data Viz

The best part is the INTERACTIVE CATEGORIES!! They are color-coded in the chart and you can add or remove them at will. You can also flip the chart from Most to Least. (Do you reject that Faith was a boo? Remove her. Don't want to see minor baddies like Dracula? Remove them. Bored with the people she only flirted with? Remove them.)

Made using Flourish, it was free. This still lacks captions, which I hope to add in later. Will update if I do. End goal is a Tableau dashboard to dig into the full data, but this is fun for now.

This is a cumulative speaking time per episode for each of Buffy's boos in seconds. (The original J. Freedland data did the work of compiling this for each character for each episode. Note that on a high-level review it seems accurate. And the original data combines E01 and E02 for S06 into one entry.)

I have combined Angel's and Angelus's speaking time. This is consistent with how Spike's speaking time is treated. (I also did this in the previous chart.)

Online it looks like The First used Spike as a disguise a few times, so Spike's time could be inflated by that. You would have to check the Forever Dreaming transcripts for those moments to be sure. No other boos were used by The First as disguises.

I used the term "boos" very broadly. A racing bar chart of just Angel vs. Spike would be boring. As expected, adding Riley in does not make it less boring! I would not really count all of these people as boos, but Buffy had some sort of interesting interaction with each of them. Note this includes any speaking time they had, including to people besides Buffy, and also even when Buffy isn't around.

I DID intentionally leave out Xander in this, even though Buffy does flirt with him (magic, making Angel jealous). I considered adding him but his speaking time will dwarf all the others, so I did not.

Happy to share the source data (currently in excel) upon request, however it is really just the raw csv from J. Freedland's GitHub in excel, and then basic math making it cumulative to put into Flourish.

If you have any requests for this type of chart for BTVS let me know!