Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Need data cleansing: assets/mapping.csv #1

Open
wythe51 opened this issue Nov 29, 2017 · 2 comments
Open

Need data cleansing: assets/mapping.csv #1

wythe51 opened this issue Nov 29, 2017 · 2 comments

Comments

@wythe51
Copy link
Contributor

wythe51 commented Nov 29, 2017

  1. PowerMeters ID 需補齊
    請參考 assets/meters.csv 的 BuildingID,
    assets/mapping.csv 的 PowerMeters 欄位補成跟 BuildingID 一致。
    Ex: 1A_2 to 01A_P1_02

  2. 鹿鳴雅舍事件
    鹿鳴雅舍、地質系、浩瀚樓等,ID內有減號,
    請改成底線。
    並在 assets/meters.csv 的 BuildingID 做一樣的處理。
    Ex: 1A_2 to 01A_P1_02

  3. 依照資料庫架構輸出成 JSON
    如果可以,直接寫入資料庫。

@tigercosmos
Copy link
Contributor

資料庫寫入應該給另外一支程式來做
這隻負責抓資料
抓完呼叫處理DB的寫入

@Andy-Cheng
Copy link
Contributor

fixed

@Andy-Cheng Andy-Cheng self-assigned this Dec 11, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants