Tip:
Highlight text to annotate it
X
This visualization shows where the most expensive houses in New York City are found
This information is found on realtor websites easily, but not in a spreadsheet ready to visualize
We extracted the data using import.io's new application. This video will show you how it works
On their website just sign up and click the button.
When the extractor loads you need to load the website where the data is.
We set the minimum price at a modest $5,000,000
For this demonstration we're interested in the most expensive houses in new york city.
Then turn on the extractor
First you need to add examples of data that would be on the same row in the spreadsheet
By highlighting then clicking 'add row selection'
Keep adding selections until the exractor extrapolates and highlights all of them
Check to see it hasn't missed any
Then we add the spreadsheet columns, click insert column
We add a name, zip code and price column
Click on the first column then start adding column selections
The system extrapolates the rest from a single selection
A quick check that it's correct and we continue with the other columns.
The table fills and it can now be copied to excel
To continue to the next page you need to turn the extractor off
So long as you remain in the same session the extractor remembers your previous selections, so it automatically fills the spreadsheet on the new page
We copy over the new spreadsheet, then repeat for the remaining pages.
Until we have a full spreadsheet ready to visualise.
Just drag and drop the spreadsheet and the visualization loads
You can quickly see that the most expensive places are in Southern Manhatten, with few further afield
The cluster map shows the largest number of houses around central park
You can then interrogate the data. The most expensive houses are found around the house
Or cheaper places further South
We hope that this video demonstrates that import.io can help our users find new data to visualize
With the data loaded you can think of how to present your data
Changing the base map can really improve the look of our visualization
Our new bright map is very visually striking
With street level mapping you can decide which zoom level you prefer.
We should probably zoom out a bit
Using the extractor we visualized the more expensive houses in New York
You can use Mapsdata the same way in business, maybe visualizing your store locations in a city
You can try the extractor at import.io, and visualize at mapsdata.co.uk