search

California-Data-Collaborative / OWRS-Analysis

Analysis of water rates collected in the OWRS format.
3 stars 6 forks source link

Join with qualitative survey responses #10

Closed christophertull closed 6 years ago

christophertull commented 6 years ago

In addition to the OWRS files that give hard numbers to the utility rate structures, the 2017 Cal Nevada survey also asked more qualitative questions. Would be good to join these in, and it should be a pretty straightforward join on utility name.

One of the most interesting responses here is the "Percent of fixed costs". We can compare this to our OWRS-based analysis of the percent of fixed revenue to find those agencies who are the most susceptible to fluctuations in demand. Will share the data in Slack

patwater commented 6 years ago

I believe this has been accomplished and can be closed?

patwater commented 6 years ago

@christophertull would be good to iron out where all the linkages live and document those when we huddle today

christophertull commented 6 years ago

Victor did this here: https://github.com/California-Data-Collaborative/OWRS-Analysis/blob/master/owrs_analysis.Rmd#joining-data-from-the-qualitative-survey