A spreadsheet with titles and links for over 1900 YouTube EA videos

post by Peterslattery · 2021-07-26T02:05:00.418Z · EA · GW · 8 comments

Contents

  How I did it
  What you might use the sheet for
  How to add more videos
  Future plans
  Analysis of text data
  Credit
None
8 comments

I created a google sheet with titles and links for over 1900 EA videos (There are 2000+ listed but some are duplicates) . It took ~4 hours in total including this post.

How I did it

 

What you might use the sheet for

 

How to add more videos

Just add them to this sheet and I will move them over when I get time. Note that it is very easy to scrape a whole channel or playlist with the data miner plugin.


Future plans

I am happy to occasionally add videos and also to find and promote particularly good ones but it won’t be a priority for me. If anyone wants to make this their project then let me know and I can give you full ownership.

 

Analysis of text data

Alexander Saeri did an analysis of the text data for the video (see below of example output).  It might be worth a look if you are curious about the distribution of video topics within the list.

You can download it here (open in a browser)


Credit

My small task was greatly helped and partially inspired by Micheal Aird's post [EA · GW].

Recent forum posts/discussions also helped me to see the value in more video creation/curation and doing something to help with that (e.g., see what I discussed here [EA(p) · GW(p)]). 

8 comments

Comments sorted by top scores.

comment by Emma Liddell · 2021-07-29T00:29:07.629Z · EA(p) · GW(p)

I see  duplicates in this list. An example: "Considerations for fundraising in effective altruism | Stefan Torges | EAGxNetherlands 2018"

I recommend deduplicating using the video parameter value of the url rather than the entire parameter.

Further, it may be worth deduplicating by title, in the case of reuploads.

Regardless, thank you for putting this list together!

Replies from: Peterslattery
comment by Peterslattery · 2021-07-29T00:54:15.279Z · EA(p) · GW(p)

Thanks Emma! I had a second pass and removed ~ 200 more duplicate urls and titles. Let me know if you have more suggestions!

comment by ChanaMessinger · 2021-08-04T15:56:35.322Z · EA(p) · GW(p)

There's a new channel that could be added: (doesn't have much yet, but seems promising)

https://www.youtube.com/channel/UCNWBVvhjqMiWExTVvhDQEsQ

Replies from: ChanaMessinger, Peterslattery
comment by ChanaMessinger · 2021-08-06T14:38:00.323Z · EA(p) · GW(p)

Don't know if this fits the bill, but this channel talks about papers in AI and it's really fun and useful, especially  for examples of improvements in the field and examples of gaming specifications: https://www.youtube.com/user/keeroyz

Replies from: Peterslattery
comment by Peterslattery · 2021-08-20T05:21:07.937Z · EA(p) · GW(p)

Thanks Chana - I had a look but I think that the videos on this channel are a bit too technical and diverse for me to add to the spreadsheet. 

comment by Peterslattery · 2021-08-06T00:52:21.834Z · EA(p) · GW(p)

Thanks, have added

comment by D Skjellerup · 2021-07-29T10:20:51.973Z · EA(p) · GW(p)

Hi, some of the links later in the list aren't aligned with the matching title. For example, row 1787 has the youtube link to Deworm the World, 5 rows above. It appears to just be an offset introduced at some point. 

Also, the links all seem to have a double slash // in the url. This doesn't break anything though.

There is a link to the channel 'Ryan' in this list. They don't have any EA related videos.

 

Thanks for the collection, I'm sure it will uncover things that I wouldn't have come across otherwise.

Replies from: Peterslattery
comment by Peterslattery · 2021-07-30T00:40:03.231Z · EA(p) · GW(p)

Thanks! I checked that and noticed that I had made a mistake. To fix I reverted the sheet to a previous version.  Basically, if I deduplicate column A it removes title duplicates but this misaligns the titles and the urls. If I deduplicate columns A and B together the process finds no duplicates. This is probably because the duplicate titles have different urls.  

I think I will just keep those duplicates  for now as that seems better than the alternatives.

 

I removed the Ryan link. f you see anything in the new sheet please comment there or here.