Using summary tables
|Moderator:Jouni (see all)|
|This page is a stub. You may improve it into a full page.|
How to combine several similar tables rowwise in a clever way such that
- information about missing columns can be given elsewhere?
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.
|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)|