Exploring Manhattan with Excel Power Map • ©[blogs.office.com]

New York is an iconic city with a rich history of innovation. I have a lot of family in New York and grew up visiting the city. Now that I’m living in Seattle, thousands of miles away, I don’t get to visit very often. However, I thought it might be fun to see if I could explore New York from the comfort of my desk using Excel. Through a little Internet searching, I discovered New York City’s “PLUTO” dataset. Created by the Department of City Planning, the PLUTO dataset includes information on every building in the city—more than 500,000 in total. I downloaded the dataset as CSV files and using Power Query for Excel, imported the data directly into Excel. I focused on the data file containing the borough of Manhattan as I’m most familiar with it. The dataset has a separate row for each building complex in the city and about 80 columns of information for each one.

via Exploring Manhattan with Excel Power Map – Office Blogs.

Advertisements

Tags: , ,

About plerudulier

Primarily interested in interacting and engaging with people about issues related to profession but also charity, environment, ... you get the idea.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Les Bulles de Bourgogne

« La Lecture est une amitié » Proust

Les trouvailles de Georgette

Trésors du domaine public et des licences libres : une sélection de la bibliothèque Georges Brassens, Paris 14e

Urbanisme - Aménagement - Fiscalité

Consultant et Formation en Urbanisme

Le Blog de Nicolas Beretti

Avec de l'entrepreneur et de l'auteur à l'intérieur

iROCBlog

L'information Revisitée et Ouverte aux Citoyens

Thierry Borne

RIEN N'EST IMPOSSIBLE

Le Monde selon Jane

Très politiquement et surtout très incorrect...

ecosphere

Medias et économie numérique par les chiffres, les idées et les rencontres

Cybercriminalité

Observatoire de veille sur la cybercriminalité

800.000 feignasses!

800.000 enseignants : 6 mois par an? 20h par semaine? Non!

Electrek

Charge Forward

Me & My SharePoint [FrontEnd]

© Christian Stahl - All about SharePoint & o365 front end

La Petite Espagne de la plaine saint denis

L'immigration espagnole à Saint-Denis / La emigración española a Francia

Valeurs de la culture

Carnet de recherches de Dominique Sagot-Duvauroux

Papilles en Balade

Dans ma cuisine, dans mes balades, en Bourgogne et ailleurs... Suivez mes papilles !

J'ai pris parti

A gauche toute!

dominik schachtsiek

My website more focussed on expertise - less opinionated as www.opinionated-alchemist.com

%d bloggers like this: