Microsoft Excel Training: Scraping NBA player data from Basketball-Reference with Power Query (1)
Автор: Excel Wealth Academy
Загружено: 2022-02-22
Просмотров: 10612
Описание:
This video shows you how to scrape NBA Player Data directly from Basketball-Reference.com website using MS Excel Power Query.
The URL for Basketball-Reference Daily Leaders is: https://www.basketball-reference.com/...
The code to use for Power Query is:
let
QryParam = Table.FirstValue(Excel.CurrentWorkbook(){[Name="BBallRefURL"]}[Content]),
Source = Web.Page(Web.Contents(QryParam)),
Data0 = Source{0}[Data]
in
Data0
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: