title: Unable to retrieve data from Macro Trends using selenium and read_html to create a data frame?
body: <p>I'm want to import data from macro trends into pandas data frame. From looking at the page source of the website it appears that data is in a jqxgrid.</p>
  
  <p>I have tried using pandas/beautiful soup with the read_html function and no table was found. I am currently trying to use selenium to extract the data. I was hoping that if I could move the horizontal scroll bar table jqxgrid would be loaded and able to be extracted. However, that did not work.</p>
  
  <pre><code>import pandas as pd
  import matplotlib.pyplot as plt
  import seaborn as sns
  from selenium import webdriver
  from selenium.webdriver.common.by import By
  from selenium.webdriver.support.ui import WebDriverWait
  from selenium.webdriver.support import expected_conditions as EC
  from selenium.webdriver import ActionChains
  import time
  
  driver = webdriver.Chrome()
  driver.maximize_window()
  driver.execute_script("window.location = 'http://www.macrotrends.net/stocks/charts/AMZN/amazon/income-statement?freq=Q';")
  driver.implicitly_wait(2)
  
  
  grid = driver.find_element_by_id('jqxgrid')
  time.sleep(1)
  driver.execute_script("window.scrollBy(0, 600);")
  scrollbar = driver.find_element_by_id('jqxScrollThumbhorizontalScrollBarjqxgrid')
  
  time.sleep(1)
  
  actions = ActionChains(driver)
  time.sleep(1)
  
  for i in range(1,6):
      actions.drag_and_drop_by_offset(scrollbar,i*70,0).perform()
      time.sleep(1)
  
  pd.read_html(grid.get_attribute('outerHTML'))
  
  </code></pre>
  
  <p>Error I get is:</p>
  
  <blockquote>
    <p>ValueError: No tables found</p>
  </blockquote>
  
  <p>I would expect table data from "<a href="http://www.macrotrends.net/stocks/charts/AMZN/amazon/income-statement?freq=Q" rel="nofollow noreferrer">http://www.macrotrends.net/stocks/charts/AMZN/amazon/income-statement?freq=Q</a>" to be imported into a data frame</p>