R-Podcast (Eric) :pci:

Hello! I'm a statistician & developer with a huge passion for the R language for statistical computing and Linux. I always enjoy learning with fun projects and following brilliant members of the community.

Public Key

npub19kxj2ezhwtg9jpj00nl06c3v797rdwu62rzt9vv9p0g23nf557pqua5a5e

NIP-05 Address

rpodcast_at_podcastindex.social@mostr.pub

Profile Code

nprofile1qqszmrf9v3th95zeqe8helhavgk0zlpkhwd9p39jkxzsh59ge5620qspz4mhxue69uhhyetvv9ujumt0wd68ytnsw43qz9thwden5te0v35hgar09ec82c30wfjkcctecjkpfq

Publishing to

relay.mostr.pub

ditto.pub/relay

Author Public Key

npub19kxj2ezhwtg9jpj00nl06c3v797rdwu62rzt9vv9p0g23nf557pqua5a5e

Show more details

Last Notes

2024-05-31 16:07:18

- reply

@npub1ln5…xyw6 Sounds like another candidate for inclusion in the PI dashboard, what do you think?
(I won't be able to accomplish that very well with the SQLite dumps though)

2024-05-24 22:03:27

- reply

@npub1dzn…4dfn My goodness, the end of an era! I still have the notification sound ingrained in my memory from my college days 💬

2024-05-24 14:41:29

- reply

@npub1ln5…xyw6 This looks fantastic! I'm living the API life these days and I'll add it to my toolbox.

2024-05-23 18:36:27

- reply

@npub103v…93fg Congratulations! I'm also very interested to see WebR take a bigger role in the places learnr was used. Do you miss anything from that package after converting to WebR?

2024-05-15 19:40:33

@npub1ln5…xyw6 If you'd like an audio primer on DuckDB here's a clip from my latest R Weekly Highlights episode https://podverse.fm/clip/U28gNlv6D0
There is massive potential here with my continued PI Dashboard efforts. I'm chomping at the bit to explore with you once I get that "access" 😉

2024-04-10 16:52:05

- reply

@npub1ln5…xyw6 I wonder if this could be utilized as another assertion/check in my database quality portion of the mega dashboard 🤔

2024-04-04 01:43:49

@npub1ln5…xyw6 I searched the API docs and came up empty, but how do I change my podcast's feed in the podcastindex now that I've switched to a different host? https://podcastindex.org/podcast/1062040
(The last thing I want to do is introduce a .... duplicate entry 😅 )

2024-04-03 16:14:29

@npub1tmc…zavv Where's the best place to send feature requests and/or suggestions? I have a few ideas after publishing my latest podcast episode on Podhome for the first time 🎉

2024-03-29 02:22:31

- reply

@npub12y5…6e36 Which phone are you using with GrapheneOS? Thinking of trying it out myself (currently using a Samsung Galaxy S22)

2024-03-23 15:05:58

- reply

@npub1df6…ns3a @npub1ln5…xyw6 Nothing like a slick database dashboard to satisfy one's appetite!
Perhaps this could be a topic for a future hot database talk segment, we just need a new jingle right? 😅

2024-03-23 03:44:29

- reply

@npub1jtm…rxtn Thank you! It was a unique opportunity to dive into the database for my own learning and to tackle a very complicated and annoying issue of duplicate record identification.

2024-03-23 02:55:53

- reply

@npub1ln5…xyw6 Awesome. This dashboard likely isn't the most mobile-friendly!
You'll want to check the methods tab where I describe the assumptions I made for which variables were the most important for determining duplicates. It was quite a bit of trial and error to get to this point!

2024-03-23 00:36:41

- reply

@npub1ln5…xyw6 correct, the algorithm splits these records up to groups that match based on a similarity score cutoff of 0.95

2024-03-22 22:43:54

Greetings @npub1ln5…xyw6 & @npub1df6…ns3a : After many late nights, the first version of the PodcastIndex Database Dashboard is live! https://rpodcast.github.io/pod-db-dash
🔎 Examine groups of potential duplicate podcast entries found via record linkage analysis
🤔 Highlight records that fail to pass quality assessment rules
📅 Updates every Sunday, just after the index SQLite database weekly refresh
Early days, but the power of open-source with #rstats and many amazing packages made this all possible. Feedback welcome!
https://cdn.masto.host/podcastindexsocial/media_attachments/files/112/141/745/025/179/816/original/2602317599cfac11.png
https://cdn.masto.host/podcastindexsocial/media_attachments/files/112/141/751/677/921/619/original/468ec4d83b15565f.png

2024-01-26 03:05:22

@npub1ln5…xyw6 How often is the podcast index sqlite database refreshed? I'm in the process of setting up an automated job for my duplicates and quality stat analyses. Very close to the finish line!

2023-12-28 16:13:54

- reply

@npub1ln5…xyw6 Sounds like I have my first screening criteria before applying the algorithms! I'll keep digging for other oddities

2023-12-28 15:59:38

- reply

@npub1ln5…xyw6 Correct, I'm looking at both the originalURL and url fields, nothing jumps out as being from a hosting provider

2023-12-28 15:53:46

@npub1ln5…xyw6 making progress on my database duplicate finder, but noticed many feeds (over 16k) have missing content hashes.
Even with HTTP status codes of 200, a manual check of a few feeds shows errors or nothing returning in their RSS. Does that indicate a dead podcast feed?

2023-12-14 00:49:51

- reply

@npub175e…fk4c @npub1zak…urh0 awesome episode! I couldn't find a link to the ipfs podcasting nix flake you mentioned in the boosts. I want to try that too!

2023-11-17 02:46:45

- reply

@npub1ln5…xyw6 I just learned about the ActivityPub Academy on the latest @npub1aqe…yqy2 podcast episode.Could this help as you explore this and other thorny activity pub issues?
https://activitypub.academy/

2023-11-15 21:06:32

- reply

@npub1dwu…hc2f @npub1ln5…xyw6
I wasn't thrilled when they took away their managed database services. I'll have to keep my DO account active just in case apparently.

2023-11-09 22:58:42

- reply

@npub1ln5…xyw6 We have a similar situation in data science / statistics. Back in grad school, a few students needed stat consulting help would come with data that didn't make any sense for their project, yet were totally convinced they did the right thing.
Just like with programming: Garbage in, garbage out!

2023-10-20 02:44:35

- reply

@npub17d6…v8qz ahh, you just happen to be using the Hugo theme from Yihui Xie, author of {blogdown} 😀
vscode with Hugo is a terrific combination. Later this year I'll publish a brand new site for my R-Weekly Highlights podcast that will automate my publishing pipeline at the same time. Heavily inspired by @npub175e…fk4c and the Jupiter Broadcasting crew https://jupiterbroadcasting.com

2023-10-20 02:36:45

- reply

@npub17d6…v8qz This site is terrific! And you're using {blogdown} (Hugo) with #rstats to make the site, right up my alley 🚀

2023-09-13 18:24:44

- reply

@npub175e…fk4c challenge accepted! As soon as I finish a major data science conference I'm jumping back into my custom R & python powered podcast 2.0 RSS and web site publisher :pci:

2023-08-03 13:23:55

- reply

@npub175e…fk4c @npub1ugm…f0zl @npub1ln5…xyw6 I'm really interested in seeing this too! I'm almost done with my automated podcast RSS feed generation using Python and R, and this would be a terrific addition to my automation setup 🚀

2023-06-22 02:03:15

- reply

@npub1ln5…xyw6 What is your tool stack for the dashboard? I'd be game to have a play at this with R and Shiny (perhaps with a little observable magic too) depending on what your goals are