Hello,
I am trying to merge multiple csv files into one but I am not sure where to start or which package to use. My data shows yearly growth measurements per tree pre year and set up with years as rows and individual tree IDs as columns. Also, each excel file does not go back the same number of years.
Here is a sample of my data:
| Year | P1_132 | P1_133 | P1_134 | P1_135 | P1_136 |
|---|---|---|---|---|---|
| 1950 | NA | NA | NA | NA | NA |
| 1951 | NA | NA | NA | NA | NA |
| 1952 | NA | NA | NA | NA | NA |
| 1953 | NA | NA | NA | NA | NA |
| 1954 | NA | NA | NA | NA | NA |
| 1955 | NA | NA | NA | NA | NA |
| 1956 | NA | NA | NA | NA | NA |
| 1957 | NA | NA | NA | NA | NA |
| 1958 | NA | NA | NA | NA | NA |
| 1959 | NA | NA | NA | NA | NA |
| 1960 | NA | NA | NA | NA | NA |
| 1961 | NA | NA | NA | 20.18858125 | NA |
| 1962 | NA | NA | 27.39534453 | 12.7295575 | NA |
| 1963 | NA | NA | 154.0152981 | 349.2215505 | NA |
| 1964 | NA | NA | 137.1622463 | 464.3694413 | 78.0692843 |
| 1965 | NA | NA | 244.0170016 | 424.9999917 | 323.3647319 |
| 1966 | NA | NA | 99.66211663 | 241.0149459 | 360.264101 |
| 1967 | NA | NA | 100.228995 | 356.321751 | 1180.648796 |
| 1968 | NA | NA | 97.90509611 | 46.25681023 | 908.5082291 |
| 1969 | NA | NA | 89.01405903 | 305.2563845 | 1939.031302 |
| 1970 | NA | NA | 106.6008361 | 341.7962926 | 2069.506316 |
| 1971 | NA | NA | 166.5640161 | 349.0156034 | 1669.814602 |
| 1972 | NA | NA | 67.46622688 | 492.6286672 | 1903.616979 |
| 1973 | NA | NA | 68.23273151 | 724.2217569 | 2853.476861 |
| 1974 | NA | NA | 90.15722177 | 92.5274686 | 1506.098798 |
| 1975 | NA | NA | 47.87847523 | 39.70412654 | 4242.715975 |
| 1976 | NA | NA | 20.63932126 | 64.56596195 | 937.5931096 |
| 1977 | NA | NA | 69.39515849 | 169.2409735 | 3595.471865 |
| 1978 | NA | NA | 35.06546131 | 126.1101799 | 1245.406286 |
| 1979 | NA | NA | 94.69658753 | 381.02618 | 4060.969599 |
| 1980 | NA | NA | 152.1366885 | 291.1619746 | 2385.113168 |
| 1981 | NA | NA | 65.99849364 | 432.4572185 | 2022.25993 |
| 1982 | NA | NA | 18.59714466 | 56.73357248 | 672.0563868 |
| 1983 | NA | NA | 125.5544321 | 98.52966986 | 2979.878569 |
| 1984 | NA | NA | 204.3797501 | 160.6463802 | 2034.977785 |
| 1985 | NA | NA | 754.8401713 | 2378.510241 | 1998.372616 |
| 1986 | NA | NA | 137.70304 | 1325.074851 | 892.3572196 |
| 1987 | NA | NA | 57.99159185 | 506.823341 | 325.5534449 |
| 1988 | NA | 1.877192717 | 395.8205148 | 858.9299512 | 3022.900267 |
| 1989 | 25.71494432 | 4.036491029 | 22.67190657 | 2561.032819 | 662.6735554 |
| 1990 | 64.40709475 | 3.641583408 | 444.1798202 | 350.8020952 | 6982.344274 |
| 1991 | 46.43560769 | 3.776395432 | 799.7455406 | 3107.614497 | 7338.434618 |
| 1992 | 94.33788048 | 14.36135413 | 642.3602561 | 3187.84406 | 5080.222849 |
| 1993 | 109.6183107 | 19.84587747 | 408.2431795 | 3755.807972 | 10256.68718 |
| 1994 | 199.0265045 | 122.871223 | 76.78605366 | 4893.024636 | 8227.597397 |
| 1995 | 169.8649849 | 279.0434726 | 1053.180622 | 4396.628194 | 5291.681327 |
| 1996 | 315.7217899 | 619.4887547 | 1729.144421 | 3381.897779 | 3949.414949 |
| 1997 | 485.1919048 | 590.6487614 | 959.537084 | 4420.050464 | 3055.921522 |
| 1998 | 676.7579593 | 921.6196315 | 1519.522346 | 3374.18569 | 1007.897395 |
| 1999 | 573.0913928 | 354.1096205 | 548.3898006 | 1136.833871 | 173.4685142 |
| 2000 | 1173.858885 | 183.1125879 | 924.3375866 | 210.1001065 | 1039.618266 |
| 2001 | 832.5802826 | 312.5136143 | 954.9442012 | 454.454245 | 2706.574022 |
| 2002 | 249.6415614 | 517.5462722 | 975.226603 | 2638.720242 | 2881.529729 |
| 2003 | 960.4508728 | 745.4603903 | 2660.412107 | 1059.291576 | 10463.30389 |
| 2004 | 628.491067 | 2115.619282 | 2796.110217 | 6888.534143 | 11147.37418 |
| 2005 | 343.7447492 | 2799.437952 | 355.250226 | 4898.403033 | 2409.813497 |
| 2006 | 158.6952407 | 739.6195381 | 2234.643773 | 952.0563361 | 4788.950966 |
| 2007 | 151.7253378 | 1293.376068 | 3197.742716 | 4947.791738 | 8263.247637 |
| 2008 | 346.5450518 | 1612.850943 | 4216.915318 | 5989.546218 | 13436.89911 |
| 2009 | 166.9237033 | 1158.439455 | 2527.696396 | 10762.0156 | 8774.735992 |
| 2010 | 226.0174852 | 1888.104725 | 315.3886742 | 1528.640561 | 1773.110825 |
| 2011 | 324.7120259 | 289.1262508 | 327.9027782 | 305.9149094 | 685.9600455 |
| 2012 | 532.8433183 | 123.5107727 | 97.13176166 | 125.0193027 | 145.7334284 |
| 2013 | 948.5439947 | 272.8739909 | 585.759375 | 162.6603579 | 1521.746917 |
| 2014 | 175.5853099 | 584.3151221 | 1139.589082 | 1180.709643 | 950.9880721 |
| 2015 | 343.2351106 | 1383.763515 | 3065.109651 | 1986.677324 | 7263.623932 |
| 2016 | 279.2040205 | 2829.522572 | 885.7632554 | 3480.648161 | 14114.68311 |
| 2017 | 358.1403027 | 946.6179754 | 202.8212186 | 6023.015917 | 12291.5131 |
| 2018 | 295.9096782 | 1125.269228 | 1199.408415 | 4971.743316 | 3768.51184 |
| 2019 | 179.3617713 | 362.7378382 | 183.5397753 | 837.1782705 | 3180.815315 |
| 2020 | 429.6867453 | 3387.803542 | 1883.815618 | 5390.095207 | 9635.875341 |