A really swell thing that I have been doing is making my own encoding file in excel.
To avoid Major Major data cleaning after encoding (say, recoding
NCR and Metro Manila, as NCR), I simply use a drop-down menu via excel.
Suppose, I have two variables, Region and Province, making a drop-down menu for Region is easy.
However, for province, can the menu “change” depending on the answer on
Region. Say, if the Region is A, provinces in menu will be C, D, E.
and if Region is B, provinces will be X, Y, Z? Yes!
Click here for a video demo on drop down menus.
No comments:
Post a Comment