Extract Episodes into DataFrame
extract the episodes and their runtime into a dataframe
an episode has the following format
<item> <title>Charlie Munger</title> <itunes:season>13</itunes:season> <podcast:season>13</podcast:season> <itunes:title>Charlie Munger</itunes:title> <itunes:episodeType>full</itunes:episodeType> <guid isPermaLink="false">eb856085-2330-4cdb-8d6d-eb6ec9948791</guid> <link>https://www.acquired.fm/episodes/charlie-munger</link> <description> <![CDATA[<p>We sit down with the legendary Charlie Munger in the only dedicated longform podcast interview that he has done in his 99 years on Earth. We’ve gotten to have some special conversations on Acquired over the years, but this one truly takes the cake. Over dinner at his Los Angeles home, Charlie reflected with us on his own career and his nearly 50-year partnership at Berkshire Hathaway with Warren Buffett. He offered lessons and advice for investors today, and of course he shared his speech on the virtues of Costco once again (among other favorite investments). We’re so glad that we got the opportunity to record and share this with you all — break out your notebooks, tune in, and enjoy the singular wit and wisdom of Charlie Munger.</p><p>A transcript is available <a href="https://www.acquired.fm/episodes/charlie-munger#transcript">here</a>.</p><p><strong>Sponsor:</strong></p><ul><li>Special thanks to Tiny for being the exclusive sponsor of this episode. You can get <a href="https://bit.ly/acquiredtiny">in touch with them here</a> (just tell them Ben & David sent you), and <a href="https://bit.ly/acquiredbrknerds">order your very own bronze Charlie bust here</a>.</li></ul><p><br></p><p><strong>More Acquired!:</strong></p><ul> <li> <a href="https://www.acquired.fm/email">Get email updates</a> with hints on next episode and follow-ups from recent episodes</li> <li><a href="http://acquired.fm/slack">Join the Slack</a></li> <li><a href="https://pod.link/acquiredlp">Subscribe to ACQ2</a></li> <li> <a href="https://acquired.fm/lp">Become an LP</a> and support the show. Help us pick episodes, Zoom calls and more</li> <li> <a href="https://www.acquired.fm/store">ACQ Merch Store</a>!</li> </ul><p><em>Note: Acquired hosts and guests may hold assets discussed in this episode. This podcast is not investment advice, and is intended for informational and entertainment purposes only. You should do your own research and make your own independent decisions when considering any financial transactions.</em></p>]]> </description> <content:encoded> <![CDATA[<p>We sit down with the legendary Charlie Munger in the only dedicated longform podcast interview that he has done in his 99 years on Earth. We’ve gotten to have some special conversations on Acquired over the years, but this one truly takes the cake. Over dinner at his Los Angeles home, Charlie reflected with us on his own career and his nearly 50-year partnership at Berkshire Hathaway with Warren Buffett. He offered lessons and advice for investors today, and of course he shared his speech on the virtues of Costco once again (among other favorite investments). We’re so glad that we got the opportunity to record and share this with you all — break out your notebooks, tune in, and enjoy the singular wit and wisdom of Charlie Munger.</p><p>A transcript is available <a href="https://www.acquired.fm/episodes/charlie-munger#transcript">here</a>.</p><p><strong>Sponsor:</strong></p><ul><li>Special thanks to Tiny for being the exclusive sponsor of this episode. You can get <a href="https://bit.ly/acquiredtiny">in touch with them here</a> (just tell them Ben & David sent you), and <a href="https://bit.ly/acquiredbrknerds">order your very own bronze Charlie bust here</a>.</li></ul><p><br></p><p><strong>More Acquired!:</strong></p><ul> <li> <a href="https://www.acquired.fm/email">Get email updates</a> with hints on next episode and follow-ups from recent episodes</li> <li><a href="http://acquired.fm/slack">Join the Slack</a></li> <li><a href="https://pod.link/acquiredlp">Subscribe to ACQ2</a></li> <li> <a href="https://acquired.fm/lp">Become an LP</a> and support the show. Help us pick episodes, Zoom calls and more</li> <li> <a href="https://www.acquired.fm/store">ACQ Merch Store</a>!</li> </ul><p><em>Note: Acquired hosts and guests may hold assets discussed in this episode. This podcast is not investment advice, and is intended for informational and entertainment purposes only. You should do your own research and make your own independent decisions when considering any financial transactions.</em></p>]]> </content:encoded> <pubDate>Sun, 29 Oct 2023 18:49:26 -0700</pubDate> <author>Ben Gilbert and David Rosenthal</author> <enclosure url="https://chrt.fm/track/18338/pscrb.fm/rss/p/media.transistor.fm/c100f364/6ce4bb67.mp3" length="64090430" type="audio/mpeg"/> <itunes:author>Ben Gilbert and David Rosenthal</itunes:author> <itunes:image href="https://images.transistor.fm/file/transistor/images/episode/1571922/full_1698630566-artwork.jpg"/> <itunes:duration>4006</itunes:duration> <itunes:summary> <![CDATA[<p>We sit down with the legendary Charlie Munger in the only dedicated longform podcast interview that he has done in his 99 years on Earth. We’ve gotten to have some special conversations on Acquired over the years, but this one truly takes the cake. Over dinner at his Los Angeles home, Charlie reflected with us on his own career and his nearly 50-year partnership at Berkshire Hathaway with Warren Buffett. He offered lessons and advice for investors today, and of course he shared his speech on the virtues of Costco once again (among other favorite investments). We’re so glad that we got the opportunity to record and share this with you all — break out your notebooks, tune in, and enjoy the singular wit and wisdom of Charlie Munger.</p><p>A transcript is available <a href="https://www.acquired.fm/episodes/charlie-munger#transcript">here</a>.</p><p><strong>Sponsor:</strong></p><ul><li>Special thanks to Tiny for being the exclusive sponsor of this episode. You can get <a href="https://bit.ly/acquiredtiny">in touch with them here</a> (just tell them Ben & David sent you), and <a href="https://bit.ly/acquiredbrknerds">order your very own bronze Charlie bust here</a>.</li></ul><p><br></p><p><strong>More Acquired!:</strong></p><ul> <li> <a href="https://www.acquired.fm/email">Get email updates</a> with hints on next episode and follow-ups from recent episodes</li> <li><a href="http://acquired.fm/slack">Join the Slack</a></li> <li><a href="https://pod.link/acquiredlp">Subscribe to ACQ2</a></li> <li> <a href="https://acquired.fm/lp">Become an LP</a> and support the show. Help us pick episodes, Zoom calls and more</li> <li> <a href="https://www.acquired.fm/store">ACQ Merch Store</a>!</li> </ul><p><em>Note: Acquired hosts and guests may hold assets discussed in this episode. This podcast is not investment advice, and is intended for informational and entertainment purposes only. You should do your own research and make your own independent decisions when considering any financial transactions.</em></p>]]> </itunes:summary> <itunes:keywords>Business,MA,StartUps,acquisitions,investment,technology,vc,venturecapital</itunes:keywords> <itunes:explicit>No</itunes:explicit> <podcast:person role="Host" img="https://images.transistor.fm/file/transistor/images/person/0f8c5b63-0b29-4c43-bdb4-0440aebb13e8/1677101641-image.jpg">Ben Gilbert</podcast:person> <podcast:person role="Host" href="http://www.acquired.fm" img="https://images.transistor.fm/file/transistor/images/person/be73121e-f691-4f58-80d9-c5a79a0a78e4/1677101665-image.jpg">David Rosenthal</podcast:person> </item>The episode is in an item tag, and the runtime in itunes:duration tags
To extract the episodes and their runtimes from the provided XML file into a dataframe, I'll first read the file and then parse the XML to find the relevant information. Let's start by loading and examining the content of the XML file.
The XML file appears to be structured as expected, with the usual declarations and namespaces for an RSS feed. I will now parse the XML content to extract the episode titles and their runtimes, and then organize this information into a dataframe.
It seems there was an issue with handling the namespaces in the XML. I'll adjust the approach to correctly parse the namespaced elements for the episode titles and durations. Let's try again.
The extraction was successful. Here are the first few rows of the dataframe containing episode titles and their runtimes in seconds:
| Title | Runtime (seconds) |
|---|---|
| Charlie Munger | 4006 |
| NVIDIA CEO Jensen Huang | 5388 |
| Nvidia Part III: The Dawn of the AI Era (2022-...) | 10426 |
| Costco | 10869 |
| Nike | 14576 |
If you need more information or further analysis of this data, feel free to let me know!
also extract the pubDate
The dataframe has been updated to include the publication date of each episode. Here are the first few rows:
| Title | Runtime (seconds) | Publication Date |
|---|---|---|
| Charlie Munger | 4006 | Sun, 29 Oct 2023 18:49:26 -0700 |
| NVIDIA CEO Jensen Huang | 5388 | Sun, 15 Oct 2023 20:09:44 -0700 |
| Nvidia Part III: The Dawn of the AI Era (2022-...) | 10426 | Tue, 05 Sep 2023 23:47:30 -0700 |
| Costco | 10869 | Sun, 20 Aug 2023 21:46:51 -0700 |
| Nike | 14576 | Mon, 24 Jul 2023 21:15:18 -0700 |
If there's anything else you need, such as formatting the dates or additional data processing, please let me know!
plot the episodes and their runtime over time
Here is the plot showing the runtimes of the episodes over time. Each point on the graph represents an episode, with its publication date on the x-axis and its runtime in seconds on the y-axis.
The plot provides a visual representation of how the durations of the episodes have varied across different publication dates.
If you need any additional analysis or adjustments to the plot, please feel free to let me know!
plot a linear trend over time to show how episode lengths have on average increased
The updated plot now includes a linear trendline, illustrating how the average length of episodes has changed over time. This trendline gives a visual indication of whether the durations have generally increased, decreased, or remained relatively stable across the dataset's time span.
If there's more detailed analysis or another type of trend representation you're interested in, feel free to let me know!