Using summary tables
| Moderator:Jouni (see all) |
| This page is a stub. You may improve it into a full page. |
| Upload data
|
Question
How to combine several similar tables rowwise in a clever way such that
- information about missing columns can be given elsewhere?
Answer
Use this kind of summary tables. In addition, there is a need for an rcode that reads the table one row at a time, brings in the data from each table-to-be-combined, adds missing information, and combines the tables with rbind. At least one missing column must be added; that is the one that contains the identifier of the table-to-be-combined. In the example it is the person whose time sheet table is combined. If a table is missing a column that exists in other tables and the value is not defined in the summary table, "" is used as the value.
| Obs | Page | Column | Value | Description |
|---|---|---|---|---|
| 1 | Op_fi2334 | Person | Julia | Julia's time sheet |
| 2 | Op_fi2481 | Person | Aino | Aino's time sheet |
| 3 | Op_fi2702 | Person | Vilma | Vilma's time sheet |
| 4 | Op_fi2334 | Expertise | Summer worker | Julia has no special expertise |
| 5 | Op_fi2481 | Expertise | Summer worker | Aino has no special expertise |
| 6 | Op_fi2702 | Expertise | Substance expert (lower) | Vilma has expertise on Jatropa but on a lower level (below PhD) |
Rationale
See also
References
Related files
<mfanonymousfilelist></mfanonymousfilelist>