This is a part of one dataset from Georgia.
Date | TMax at Georgia, 1990-01-01 to 2019-12-31 |
1/1/1990 | 32 |
1/2/1990 | 42 |
1/3/1990 | 50 |
... | |
... | |
... | |
12/29/2019 | 56 |
12/30/2019 | 35 |
12/31/2019 | 35 |
In the first row, there are the name of variables. I want to create a column for a state variable and combine all datasets for 50 states.
Date | TMax | State |
1/1/1990 | 32 | Georgia |
1/2/1990 | 42 | Georgia |
... | ||
12/31/2019 | 35 | Georgia |
1/1/1990 | 32 | Idaho |
1/2/1990 | 26 | Idaho |
... | ||
12/31/2019 | 30 | Idaho |
.... |
All dataset files are located in the same folder.
Please help me solve this problem.
Thank you!
0 Response to Create a column from a different column and combine multiple datasets
Post a Comment