Using summary tables: Difference between revisions
Jump to navigation
Jump to search
(first draft based on own thinking) |
m (→Answer) |
||
| Line 11: | Line 11: | ||
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. | 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. | ||
<t2b index ="Page, | <t2b index ="Page,Index,Observation" locations="Location,Description" unit="-"> | ||
Op_fi2334|Person|Julia|Julia's time sheet | Op_fi2334|Person|Julia|Julia's time sheet | ||
Op_fi2481|Person|Aino|Aino's time sheet | Op_fi2481|Person|Aino|Aino's time sheet | ||
Latest revision as of 10:14, 2 January 2012
| 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 | Index | Location | 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>