Modify Artificial Input Data Script so it adds temporal_id and can also combine multiple houses in one table

[carlosparadis]

Input Table

Simulation Data Tables (source: Riley)

Several tables of the format:

in_air_temperature_f	in_relative_humidity	site_energy_cooling

Where the file names are of the form:

<house_id>_<method_id>_pmv.csv.

Actual Data table (source: Eileen)

In addition, a single table of the form:

outdoor_temperature_f	rolling_temperature_f	in_air_temperature_f	in_in_air_speed_fpm

with any file name, e.g.

adaptive_method.csv

Is provided to be combined with all tables column-wise.

Output Table

temporal_id	in_air_temperature_f	in_in_air_speed_fpm	in_relative_humidity	site_energy_cooling	house_id	method_id

In addition to all input table columns (it will be a very large table column-wise).

The temporal_id is just the row numbers, and can be obtained by default when using the function write.csv. It has this name as a reminder of its reason for existence. In combining different tables into 1, care must be done so that every house still have repeated ids.

This issue description is not complete and is just a draft of the discussion. More thought must be done into it before starting to code.

[carlosparadis]

@kathrynparadis Some of what is described in this issue, such as making the big table, is actually the responsibility of the R Notebook on #10. The filler script should do what its name propose: Fill in data and take as input the large table instead.

We can revisit this later after we get to this point. There is only so much I can see upfront.