Module 2 – Working with Data in Pandas (Dataframe Analysis) Source: 1. [Stock Markets Analytics Zoomcamp] Module2 “Working with Data in Pandas” (youtube.com) 2. https://docs.google.com/presentation/d/e/2PACX-1vT5XMStGsWf5tQkt-ulyk4MmWoSXTP4PqglHsrzGIlpd_cQ7nAzxNJVmUS7L67vAbYybZhxMNGZy-kY/pub?start=false&loop=false&delayms=3000 Module 2 Homework In this homework, we’re going to combine data from various sources to process it in Pandas and generate additional fields. If not stated otherwise, please use the Colab covered at the livestream to re-use the code snippets. Question 1: IPO Filings Web Scraping and Data Processing What’s the total sum ($m) of 2023 filings that happenned of Fridays? Re-use the [Code Snippet 1] example to get the data from web for this endpoint: https://stockanalysis.com/ipos/filings/ Convert the ‘Filing Date’ to datetime(), ‘Shares Offered’ to float64 (if ‘-‘ is encountered, populate with NaNs). Define a new field ‘Avg_price’ based on the “Price Ra