golang 提取html数据,从网页中提取表格

这篇博客展示了如何利用R语言的dplyr和rvest库来抓取网页表格,并通过设置名称和结合表格数据。内容涉及居民税率对比,分别列出了2016-17年和2015-16年的税率信息,包括不同收入段的税率计算。如果需要将这些表格合并成单一数据框,可以使用bind_rows函数。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

I would suggest to keep them as list of dataframes and to distinguish the tables, name them with the caption available

library(dplyr)

library(rvest)

url

url %>%

read_html() %>%

html_table() %>%

setNames(., url %>%

read_html() %>%

html_nodes("caption") %>%

html_text())

#$`Resident tax rates for 2016-17`

# Taxable income Tax on this income

#1 0 – $18,200 Nil

#2 $18,201 – $37,000 19c for each $1 over $18,200

#3 $37,001 – $87,000 $3,572 plus 32.5c for each $1 over $37,000

#4 $87,001 – $180,000 $19,822 plus 37c for each $1 over $87,000

#5 $180,001 and over $54,232 plus 45c for each $1 over $180,000

#$`Resident tax rates for 2015-16`

# Taxable income Tax on this income

#1 0 – $18,200 Nil

#2 $18,201 – $37,000 19c for each $1 over $18,200

#3 $37,001 – $80,000 $3,572 plus 32.5c for each $1 over $37,000

#4 $80,001 – $180,000 $17,547 plus 37c for each $1 over $80,000

#5 $180,001 and over $54,547 plus 45c for each $1 over $180,000

#......

If you want it as one single dataframe, we can use bind_rows with .id parameter

url %>%

read_html() %>%

html_table() %>%

setNames(., url %>%

read_html() %>%

html_nodes("caption") %>%

html_text()) %>%

bind_rows(.id = "id")

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值