Add lower quartile to wages (ASHE) data

[luke-strange]

I want to recreate the chart that shows ratio of lower quartile rents to lower quartile earnings per geography:

I need the LQ wages data to do this.

Also, wages are weekly, but rents are monthly. I can grossly assume monthly wage is 4*weekly, but if monthly data exists, then this would be good to use.

TODO:

• [x] add lower quartile weekly wages to data/ashe/ashe.csv.
• [x] Check if monthly wage data exists.

Nice to have:

• [ ] Time series data. (If we can't or don't yet have this, I can put the data on a map for now rather than line chart.)

[ChristianSpence]

ASHE data available at weekly, monthly, annual intervals. Will extract LQ monthly data. Do you need annual for house sale prices a well?

[luke-strange]

@ChristianSpence that would be useful yes. Thanks.

[ChristianSpence]

That's done and pushed.

(FYI, ASHE doesn't have monthly, so have calculated as annual / 12. Worth noting that weekly to monthly always has to gross up to a year before being divided down to months (so not week * 4, but week * 365/7 / 12

[ChristianSpence]

Re-opening as I'll sort the time series data out, too.