Check if Dataframe is empty and print results

Question

I would like to go over an excel file with different stock symbols. How can I check after reading the stocks values (Open,Close,High,Low,Volume) in a dataframe with yahoo, if the dataframe is empty? In this excel list are more than 700 Symbols and some times yahoo have no data for some symbols. So I would like to exclude this symbols, when I go to the loop.

I am struggling with the following code: if df.empty = True: print (stock).

yf.pdr_override()
start = dt.datetime(2020,6,1)
now = dt.datetime.now()

stocklist = pd.read_csv('symbols/Input_ETF_alle_test.csv') 

# stocklist = stocklist.head()
for i in stocklist.index:
 stock = str(stocklist['Symbol'][i]) 
 print (stock)

 df = yf.download(stock,start,now)
 if df.empty = True:
     print (stock)

Equality checks are done with ==, not =. You could just use if df.empty:, though. — timgeb
– timgeb, Commented Jan 24, 2021 at 15:39

gtomer · Accepted Answer · 2021-01-24 15:40:56Z

3

You need to change the if to:

if df.empty == True:

or

if df.empty:

answered Jan 24, 2021 at 15:40

gtomer

6,6041 gold badge14 silver badges29 bronze badges

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

Comments

Knows_nothing · Accepted Answer · 2021-01-24 15:41:12Z

0

You can use regular expression. it will be good if you elaborate, what you want to exclude!!

answered Jan 24, 2021 at 15:41

Knows_nothing

1081 silver badge4 bronze badges

Collectives™ on Stack Overflow

Check if Dataframe is empty and print results

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related