pandas-datareader

pandas-datareader copied to clipboard

code:

    from pandas_datareader.nasdaq_trader import get_nasdaq_symbols                                  
    df = get_nasdaq_symbols()                                                                                                                                                                                                  
    df.to_csv('nasdaq_trader.csv')                                                                                                                                                                                             

in the output: nasdaq_trader.csv, there is a line:

Symbol,Nasdaq Traded,Security Name,Listing Exchange,Market Category,ETF,Round Lot Size,Test Issue,Financial Status,CQS Symbol,NASDAQ Symbol,NextShares
...
,True,Nano Labs Ltd - American Depositary Shares,Q,G,False,100.0,False,N,,,False

This stock's symbol is string: "NA".

https://finance.yahoo.com/quote/NA/

But the returned dataframe treat stock symbol "NA" as number, and the Symbol column for this stock is empty!