title: A list of ticker to get setor and name
body: <pre><code>   import pandas as pd
  import datetime as dt
  from pandas_datareader import data as web
  import yfinance as yf
  yf.pdr_override()
  </code></pre>
  <p>filename=r'C:\Users\User\Desktop\from_python\data_from_python.xlsx'</p>
  <pre><code>yeah = pd.read_excel(filename, sheet_name='entry')
  stock = []
  
  stock = list(yeah['name'])
  stock = [ s.replace('\xa0', '') for s in stock if not pd.isna(s) ]
  
  
  adj_close=pd.DataFrame([])
  high_price=pd.DataFrame([])
  low_price=pd.DataFrame([])
  volume=pd.DataFrame([])
  
  print(stock)
  
  
  ['^GSPC', 'NQ=F', 'AAU', 'ALB', 'AOS', 'APPS', 'AQB', 'ASPN', 'ATHM', 'AZRE', 'BCYC', 'BGNE', 'CAT', 'CC', 'CLAR', 'CLCT', 'CMBM', 'CMT', 'CRDF', 'CYD', 'DE', 'DKNG', 'EARN', 'EMN', 'FBIO', 'FBRX', 'FCX', 'FLXS', 'FMC', 'FMCI', 'GME', 'GRVY', 'HAIN', 'HBM', 'HIBB', 'IEX', 'IOR', 'KFS', 'MAXR', 'MPX', 'MRTX', 'NSTG', 'NVCR', 'NVO', 'OESX', 'PENN', 'PLL', 'PRTK', 'RDY', 'REGI', 'REKR', 'SBE', 'SQM', 'TCON', 'TCS', 'TGB', 'TPTX', 'TRIL', 'UEC', 'VCEL', 'VOXX', 'WIT', 'WKHS', 'XNCR']
  
  for symbol in stock:
      adj_close[symbol] = web.get_data_yahoo([symbol],start,end)['Adj Close']
  </code></pre>
  <p>I have a list of tickers, I have got the adj close price, how can get these tickers NAME and SECTORS?</p>
  <p>for single ticker I found in web, it can be done like as below</p>
  <pre><code>sbux = yf.Ticker(&quot;SBUX&quot;)
  tlry = yf.Ticker(&quot;TLRY&quot;)
  
  print(sbux.info['sector'])
  print(tlry.info['sector'])
  </code></pre>
  <p>How can I make it as a <code>dataframe</code> that I can put the data into excel as I am doing for <code>adj</code> price.</p>
  <p>Thanks a lot!</p>