Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi All,
String indices must be integers
This is my code :
This code output :
What i need is....,
I need to fetch the ticker values from the output in the ticker_sentiment json format values that is in the below.
[{ticker=MSFT, ticker_sentiment_label=Somewhat-Bullish, ticker_sentiment_score=0.163239, relevance_score=0.04028}, {ticker=NVDA, ticker_sentiment_label=Somewhat-Bullish, ticker_sentiment_score=0.235239, relevance_score=0.48854}, {ticker=VMW, ticker_sentiment_label=Neutral, ticker_sentiment_score=0.056248, relevance_score=0.04028}, {ticker=AVGO, ticker_sentiment_label=Somewhat-Bullish, ticker_sentiment_score=0.274491, relevance_score=0.520477}]
I need output is MSFT. So,
I Witten this code : print(news_json_1["json_object"]["ticker_sentiment"][0])
this code output is : [
so, I written this code : print(news_json_1["json_object"]["ticker_sentiment"]["ticker"])
this code got error : TypeError Traceback (most recent call last)
print(news_json_1["json_object"]["time_published"])
print(news_json_1["json_object"]["url"])
---> print(news_json_1["json_object"]["ticker_sentiment"][0]["ticker"])
TypeError: string indices must be integers
How to fetch the first ticker?
Please help me.
Thanks in advance.
I need to fetch the ticker value from the output.
The value of ticker_sentiment is a string, not an array. You will need to parse that string again as JSON before you can access the first item in the array.
Thanks for your reply.
Here, I already convert into json. But, I don't know why the value of ticker_sentiment is still string.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.