In the afternoon, I planned to make some improvement for my work on the Kadis. More datasets should be added into the current framework. The problem in the first place is that the data in the existing database (in fact, excel files) are composed of codes, not corresponding values. That means, some conversion work must be required. When I started to program to do the conversion, I had more questions. 

1. Is the code system in the different dataset the same?

2. Is any rule used to decide these codes?

3. In the integrated dataset, some values in the SITE column don't exist in the code system. Where are they from?

4. In the other dataset, there is no FUI values at all. What to do with such a situation?