开发者

How to Scrape Table Data (School Test Scores)?

开发者 https://www.devze.com 2023-03-27 10:27 出处:网络
What is an easy way to scrape tables from this website? (It\'s school test scores. It\'s public data). I need the 2011 data for each school. So, to start, I need, year: 2011, report type: report card,

What is an easy way to scrape tables from this website? (It's school test scores. It's public data). I need the 2011 data for each school. So, to start, I need, year: 2011, report type: report card, school group: DCPS Schools, School Level: Secondary Schools, School: (I then need the data for each school). My goal is to put the data in a mySQL database. If I can 开发者_如何学Cget the data into CSV format or Excel, it will be easy to import.

I tried the technique outlined here, but I'm not having any luck. In Google Docs, I tried: =ImportHtml("http://www.nclb.osse.dc.gov/dccas_reportcards.asp", "table", 1).

Any ideas?


Thank you for the message. You're right, my question was too broad.

I ended up using Google Docs' Spreadsheet and TableTools2, a Firefox add-on.

0

精彩评论

暂无评论...
验证码 换一张
取 消