Skip to content

Instantly share code, notes, and snippets.

@ptyx507

ptyx507/Asamblea

Created October 13, 2020 01:13
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 ptyx507/3329c32b38b28cd87b831d4e067cc627 to your computer and use it in GitHub Desktop.
Save ptyx507/3329c32b38b28cd87b831d4e067cc627 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Asamblea
let
Source = Web.BrowserContents("https://asamblea.gob.pa/index.php/seguimiento-legislativo"),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE.views-table.views-view-table.cols-9.table.table-responsive > * > TR > :nth-child(1)"}, {"Column2", "TABLE.views-table.views-view-table.cols-9.table.table-responsive > * > TR > :nth-child(2)"}, {"Column3", "TABLE.views-table.views-view-table.cols-9.table.table-responsive > * > TR > :nth-child(3)"}, {"Column4", "TABLE.views-table.views-view-table.cols-9.table.table-responsive > * > TR > :nth-child(4)"}, {"Column5", "TABLE.views-table.views-view-table.cols-9.table.table-responsive > * > TR > :nth-child(5)"}, {"Column6", "TABLE.views-table.views-view-table.cols-9.table.table-responsive > * > TR > :nth-child(6)"}, {"Column7", "TABLE.views-table.views-view-table.cols-9.table.table-responsive > * > TR > :nth-child(7)"}, {"Column8", "TABLE.views-table.views-view-table.cols-9.table.table-responsive > * > TR > :nth-child(8)"}, {"Column9", "TABLE.views-table.views-view-table.cols-9.table.table-responsive > * > TR > :nth-child(9)"}}, [RowSelector="TABLE.views-table.views-view-table.cols-9.table.table-responsive > * > TR"]),
#"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Codigo de etapa", type text}, {"Fecha presentación", type date}, {"Anteproyecto", Int64.Type}, {"Proyecto", Int64.Type}, {"Título", type text}, {"Proponentes", type text}, {"Comisión", type text}, {"Etapas", type text}, {"Documento", type text}})
in
#"Changed Type"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment