Uploading the code
The Taiwan exposure preparation code (using which the steps below are done by @kensheu2002 ), needs to be uploaded to be used as a part of the Taiwan exposure data preprocessor.
The steps taken in the code are as follows:
- Converting all 70 XML Taiwan exposure files(from 1950 to 2020) into CSV format.
- Merging all the 70 CSV files into one.
- Merging the duplicate building information(the rows which have same address) into the one, by keeping the building information which has the latest year of construction(this step deletes information of the former buildings(non-exisiting buildings at present)) in a specific point.
- Translating Chinese characters in the CSV file to English.
- Converting Taiwanese year into Gregorian year.