Continue running code when KeyError: "['Column'] not in index" occurs for null values?

Question

I get KeyError: "['marketCap'] not in index" when there is no data in the "marketCap" column for a particular symbol. How do I put "Null" when there's no data so the code can continue running and not error out?

import pandas as pd
from yahooquery import Ticker

symbols = ['MSFT','GOOG','AAPL'] #I have to put 75,000+ symbols here.
header = ["regularMarketPrice", "marketCap"]

for tick in symbols:
    faang = Ticker(tick)
    faang.price
    df = pd.DataFrame(faang.price).T
    df.to_csv('output.csv', mode='a', index=True, header=False, columns=header)

HTMLHelpMe · Accepted Answer · 2022-12-01 21:54:13Z

0

Got this working:

import pandas as pd
from yahooquery import Ticker

symbols = ['MSFT','GOOG','AAPL'] #I have to put 75,000+ symbols here.
header = ["regularMarketPrice", "marketCap"]

for tick in symbols:
    faang = Ticker(tick)
    faang.price
    df = pd.DataFrame(faang.price,{"regularMarketPrice":[1],"marketCap":[2]}).T  
#adding the {...} fixed a 'scalar value' error as well.
    try:
        df.to_csv('mktcaptest.csv', mode='a', index=True, header=False, columns=header)
    except KeyError:
        continue

answered Dec 1, 2022 at 21:54

HTMLHelpMe

3111 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Continue running code when KeyError: "['Column'] not in index" occurs for null values?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related