Is there any easy way to import a table on the web page into Exploratory?

Questions
#1

Hi,

I need a France state code and name mappings for my analysis. I found there’s a web page including the mapping table and that is exactly what I need. http://kb.bullseyelocations.com/support/solutions/articles/5000544638-france-state-codes . Is there any easy way to import this table into Exploratory? or should I create it manually?

Thanks in advance,
Riku

#2

Hi,
“Scrape Web Page” feature of Exploratory is exactly for this.
In your project,

  1. On the left hand side, click “+” icon next to “Data Frames”.
  2. Select “Import Remote Data”
  3. Click “Scrape Web Page”
  4. Copy the URL of the page to “URL” field.
  5. Click “Get Data” and you can see the scraped data now!
    Pasted image1114×660 73.9 KB
  6. Give it a name and put the name in the “Name” field
  7. Click save, and you can start using the scraped data for your analysis.
    Pasted image1034×557 77.2 KB
1 Like
#3

Thank you! It worked. This is great!

Riku