I have to merge 15 tables of around 2000-3000 rows each, and only the first column contains matching values(in my case, object names). All other columns contain some properties of objects from first column. However, tables are of different size in rows, and I would like to know if there is a method to merge them, so rows with no corresponding columns to contain 'NA' value? Like, merging:
| Name | Property_1 |
|---|---|
| a. | 12. |
| b. | 25. |
With
| Name | Property_2 |
|---|---|
| a. | XY. |
to receive:
| Name | Property_1 | Property_2 |
|---|---|---|
| a. | 12. | XY. |
| b. | 25. | 'NA'. |
