title: Download CSV file in Google Chrome into a Python dataframe
body: <p>Hoping someone can help me with this. I am very new to using Python and the Selenium module. I am trying to download a CSV file from the following URL (<a href="https://www.nlrb.gov/search/case" rel="nofollow noreferrer">https://www.nlrb.gov/search/case</a>) and then assign that CSV file into a dataframe. See below for what I have tried. It gets as far as downloading it into my local computer, but I can't find a quick way to then load that file as a dataframe object.</p>
  <pre><code>import pandas as pd
  from selenium import webdriver
  from selenium.webdriver.common.keys import Keys
  
  #executes and opens Google Chrome #bestbrowser
  driver = webdriver.Chrome(executable_path=&quot;C:/Users/jmartinez/Downloads/chromedriver_win32 (2)/chromedriver.exe&quot;)
  
  #waits for page to load
  driver.implicitly_wait(25)
  
  #page address
  driver.get(&quot;https://www.nlrb.gov/search/case&quot;) #page address
  
  #identifies and finds page element (the download button )
  btn = driver.find_element_by_xpath(&quot;/html/body/div[1]/div/main/div[3]/div/article/div/div[3]/div/div[2]/div[2]/p[1]/a&quot;)
  btn.click()
  </code></pre>
  <p>Thanks in advance.</p>