Scraping and accessing data on Redfin directly from JMP

[#1]

Hello All -

In one of the JMP seminars I came across the instructor demonstrating how to download housing price and related data from Red-fin website for analysis. The instructor used "internet open --> webpage" to access the data for analysis. Can someone share how we can do that? This is for academic purpose. Thanks!

JMP Pro 17.0.0 (622753)

[#2]

Hi @AbhijithS,

I will show you how to do it step-by-step on the website https://organicchemistrydata.org/solvents/ that shows a table of chemical solvents with different characteristics.

On JMP, click on "File", "Internet Open" and then "Web Page..." and insert the URL of the website you would like to use data from and click on OK :

Then, JMP will show you the tables it has found automatically on the website. You can select all or select only the ones you are interested in, and then click on OK :

JMP will then provide you a datatable with the informations directly extracted from the website table(s). There may be some correction/cleaning needed (for column formats/types, missing values, ...), but overall it is doing a good job :

You also have a script "Source" in your datatable that contains the informations about how and where the data has been collected. In this case, it contains this script, used to retrieve the data and create the datatable :

Open(
	"https://organicchemistrydata.org/solvents/",
	HTML Table( 1, Column Names( 1 ), Data Starts( 2 ) )
)

Hope this answer will help you in your task