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.

Sign up for GitHub

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

Jump to bottom

導入台南市勞工局資料 #12

Open
virus-warnning opened this issue Sep 26, 2016 · 0 comments
Open

導入台南市勞工局資料 #12

virus-warnning opened this issue Sep 26, 2016 · 0 comments
Assignees
@virus-warnning
Labels
資料
Milestone
0.2.0

Comments

@virus-warnning
Copy link
Owner

virus-warnning commented Sep 26, 2016 •
edited

導入台南市勞工局資料的研究目標

  • 整理 103 年 7 月 ~ 105 年 9 月的資料
  • 研究資料格式問題
  • 用 Calc Basic 巨集進行資料正規化
  • 需要研究 Calc Basic 的搜尋/取代 API，進行大量取代操作

經驗紀錄

  • 稽查紀錄有出現多法規對應一公文，也有一法規對應一公文
  • 日期格式有很多種
  • 負責人姓名寫法很多，需要歸納
@virus-warnning virus-warnning added this to the 0.2.0 milestone Sep 26, 2016
@virus-warnning virus-warnning self-assigned this Sep 26, 2016
virus-warnning added a commit that referenced this issue Sep 28, 2016
@virus-warnning
refs #12 導入台南市勞工局資料
7bb595d 
* 合併所有資料
* 使用 Basic 語言處理儲存格 I/O
* 過濾不可見字元
* 正規化法規分隔符號
virus-warnning added a commit that referenced this issue Sep 30, 2016
@virus-warnning
refs #12 台南市勞工局資料轉檔完成
41d31d7
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@virus-warnning virus-warnning

Labels
資料
Projects
None yet
Milestone
0.2.0
Development

No branches or pull requests
1 participant
@virus-warnning