Hi, I am using ek.get_news_headlines to display a dataframe of 5 news articles for a particular company. i.e.
df = ek.get_news_headlines('GOOG.O AND Language:LEN', date_from='2021-01-01T09:00:00', date_to='2023-06-30T23:59:59', count = 5)
The above works fine at display the last 5 storyId's... but i'd like to use the ek.get_news_story request to loop through the rows in the above df and pull the article from each storyID into another dataframe? When I try the below snippet - which I found on another post - I just get a HTML dump from the first storyId only.
for idx, storyId in enumerate(headlines['storyId'].values): #for each row in our df dataframe
newsText = ek.get_news_story(storyId) #get the news story
time.sleep(5) # sleep for 5 seconds
I'd ideally like to see 1 new dataframe containing 5 rows (one row for each news article), one column with the news article's title, another column containing just the text from each article (no HTML tags!), and then another column of the URL.
Any help would be greatly appreciated.