Simple data anonymization: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
Simple data anonymization | Simple data anonymization | ||
== case1: 王小明 --> 王O明 == | |||
ex: 王小明 --> 王O明 | ex: 王小明 --> 王O明 | ||
* Excel: {{kbd | key=<nowiki>=REPLACE(A2, 2, 1, O)</nowiki>}}<ref>[http://blog.xuite.net/yh96301/blog/80724141-Excel+2010%E5%A7%93%E5%90%8D%E7%9A%84%E7%AC%AC%E4%BA%8C%E5%80%8B%E5%AD%97%E5%8F%96%E4%BB%A3%E7%82%BAO Excel 2010姓名的第二個字取代為O @ 軟體使用教學 :: 隨意窩 Xuite日誌]</ref> | * Excel: | ||
** {{kbd | key=<nowiki>=REPLACE(A2, 2, LEN(A2)-2, O)</nowiki>}} also applied for 3 or 4 words ex: 王王小明 -> 王O明 | |||
** {{kbd | key=<nowiki>=REPLACE(A2, 2, 1, O)</nowiki>}}<ref>[http://blog.xuite.net/yh96301/blog/80724141-Excel+2010%E5%A7%93%E5%90%8D%E7%9A%84%E7%AC%AC%E4%BA%8C%E5%80%8B%E5%AD%97%E5%8F%96%E4%BB%A3%E7%82%BAO Excel 2010姓名的第二個字取代為O @ 軟體使用教學 :: 隨意窩 Xuite日誌]</ref> {{exclaim}} only applied for 3 words, NOT for 4 words | |||
* PHP: using regular_replace | * PHP: using regular_replace | ||
<pre> | <pre> | ||
| Line 18: | Line 21: | ||
</pre> | </pre> | ||
== case2: 王小明 --> 王OO == | |||
ex: 王小明 --> 王OO | ex: 王小明 --> 王OO | ||
* Excel: | |||
** {{kbd | key=<nowiki>=REPLACE(A2, 2, LEN(A2)-1, O)</nowiki>}} also applied for 3 or 4 words ex: 王王小明 -> 王OO | |||
** {{kbd | key=<nowiki>=REPLACE(A2, 2, 2, O)</nowiki>}} {{exclaim}} only applied for 3 words, NOT for 4 words | |||
* MySQL: {{kbd | key=<nowiki>SELECT CONCAT(LEFT("王小明", 1), 'OO')</nowiki>}} | * MySQL: {{kbd | key=<nowiki>SELECT CONCAT(LEFT("王小明", 1), 'OO')</nowiki>}} | ||
| Line 27: | Line 34: | ||
* [https://vtaiwan.tw/personal-data-protection/init/ 個資利用與去識別化 - vTaiwan.tw] | * [https://vtaiwan.tw/personal-data-protection/init/ 個資利用與去識別化 - vTaiwan.tw] | ||
[[Category:Data transformation]] [[Category:Data Science]] | [[Category:Data transformation]] [[Category:Data Science]] [[Category:Excel]] | ||
Revision as of 13:43, 3 December 2015
Simple data anonymization
case1: 王小明 --> 王O明
ex: 王小明 --> 王O明
- Excel:
- =REPLACE(A2, 2, LEN(A2)-2, O) also applied for 3 or 4 words ex: 王王小明 -> 王O明
- =REPLACE(A2, 2, 1, O)[1]
only applied for 3 words, NOT for 4 words
- PHP: using regular_replace
$string = '王小明'; $pattern = '/^(\X)(\X)(\X+)/u'; $replacement = '$1O$3'; echo preg_replace($pattern, $replacement, $string);
- MySQL: using SUBSTRING
SELECT CONCAT(SUBSTRING_INDEX('王小明', SUBSTRING('王小明', 2, 1), 1),
SUBSTRING('王小明', 2, 1),
SUBSTRING_INDEX('王小明', SUBSTRING('王小明', 2, 1), -1));
case2: 王小明 --> 王OO
ex: 王小明 --> 王OO
- Excel:
- =REPLACE(A2, 2, LEN(A2)-1, O) also applied for 3 or 4 words ex: 王王小明 -> 王OO
- =REPLACE(A2, 2, 2, O) only applied for 3 words, NOT for 4 words
- MySQL: SELECT CONCAT(LEFT("王小明", 1), 'OO')
reference
further reading