Forum Discussion

Prakash1050's avatar
Prakash1050
Helper III
2 years ago

String indices must be integers

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.

2 Replies

  •  

    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.

    • Prakash1050's avatar
      Prakash1050
      Helper III

      Thanks for your reply. 

      Here, I already convert into json. But, I don't know why the value of ticker_sentiment is still string.