Skip to content

Instantly share code, notes, and snippets.

@petermreid

petermreid/AshleyPopulation

Created October 22, 2015 20:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save petermreid/a9ee7a1690f37f3b9563 to your computer and use it in GitHub Desktop.
Save petermreid/a9ee7a1690f37f3b9563 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
AshleyPopulation
let
Source = Web.Page(Web.Contents("http://www.geohive.com/earth/world1.aspx")),
Data1 = Source{1}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data1,{{"entity World", type text}, {"code 900", Int64.Type}, {"mid-2015 est. 7,349,472,099", Int64.Type}, {"population growth in 2015 est. 1.132%", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"population growth in 2015 est. 1.132%"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"mid-2015 est. 7,349,472,099", "population"}, {"code 900", "ISO numerical"}}),
#"Indexed Table" = Table.AddKey( #"Renamed Columns", {"ISO numerical"},true)
in
#"Indexed Table"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment