hello! I am looking to merge two datasets to end with coherent district-level daily dataset from 2009-2013 with temperature, rainfall, and total rainfall variables.
- the first dataset "finalrainfall" has the following shape
Year Edate District_id State_name District_name dailymeanrainfall dailytotalrainfall
- the second dataset "finaltemp" has the following shape
Year Edate District_id State_name District_name Weightedavertemp
I initially tried using the merge command, but I got the error message given that there variables I used werent unique identifiers (merge 1:1 district_id year using "finalrainfall"
I have tried using also joinby - joinby district_id year using "finalrainfall" -
are the results given in this case by joinby equivalet to what merge would have provided?
Related Posts with merging panel data - merge or joinby?
How to call values of a matrix in forvalues loop?HI everyone, I would like to call values of a matrix in a foreach loop like this: Code: forvalu…
Line graph for multiple time pointsHi first time posting here, would appreciate any help as I am quite stuck on this. Have tried access…
Storing Beta values by running regression loops on panel dataHi, I have the daily data of ten years (from 2008 to 2018) with four variables: 1) Date 2) Firm Nam…
scatter matrix in python via Stata16Hi Statalisters, With the release of Stata16 and the fantastic integration of Python. I have decide…
Combine outreg2 with ivreg2Hello Stata users, Is there any specific step by step command to extract the first and second stage…
Subscribe to:
Post Comments (Atom)
0 Response to merging panel data - merge or joinby?
Post a Comment