Extract car prices

You can use Python or other script language to download the data and pre-process it. Or, you can use the following example to get started.

Suppose you have already made effort to cut-and-paste the web page that contains ONLY cars of a particular model and a particular year, for example, Honda CRV and year 2012, and save that to a text file, say "tmpHondaCRV2012.txt" (see attachment at the end of this).

Use a Linux utility (open a terminal on your mac) as follows

> grep '\$' tmpHondaCRV2012.txt > hondaCRV2012.txt

Then file "hondaCRV2012.txt" will only contain car prices of year 2012, the first few lines MAY look like

$29,488

$29,325

$29,220

$28,999

$28,999

$28,990

$28,990

$28,752

$28,520

$28,112

$28,033

$28,000

...............

Then you can calculate average using R or Excel etc (you may need to get rid of the '$' sign, but I think you can figure out how to do it).