0

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 get 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?

Brian Tompsett - 汤莱恩
  • 5,195
  • 62
  • 50
  • 120
Laxmidi
  • 2,580
  • 11
  • 45
  • 78
  • 1
    Are you automating it? Doing it by hand? What language do you want to use or are familiar with? There are hundreds if not thousands of ways of doing this… This question is too broad and vague. – ghoppe Aug 09 '11 at 19:05
  • 1
    see also: http://stackoverflow.com/questions/1403087/how-can-i-convert-an-html-table-to-csv – ghoppe Aug 09 '11 at 19:07

1 Answers1

0

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.

Laxmidi
  • 2,580
  • 11
  • 45
  • 78