Simple data anonymization - Revision history

Unknown user: Text replacement - "== references ==" to "== References =="

2022-07-10T09:13:06Z

Text replacement - "== references ==" to "== References =="

← Older revision		Revision as of 17:13, 10 July 2022
Line 122:		Line 122:
	** {{kbd \| key=<nowiki>=LEFT(A2, 5)&REPT("X", 5)&RIGHT(A2, 1)</nowiki>}}		** {{kbd \| key=<nowiki>=LEFT(A2, 5)&REPT("X", 5)&RIGHT(A2, 1)</nowiki>}}

	== ~~references~~ ==		== References ==
	<references />		<references />

Planetoid at 03:44, 22 July 2017

2017-07-22T03:44:44Z

@@ Line 2: / Line 2: @@
 == 姓名的個資去識別化 ==
-=== case1: 王小明 --> 王O明; 孤獨求敗 --> 孤O敗 ===
+=== case1: 王小明 --> 王O明; 孤獨求敗 --> 孤OO敗 ===
 Reserve the first and last characters of name, and replace other characters with the symbol 'OO'.
@@ Line 52: / Line 39: @@
      END;
 </pre>
 === case3: 王小明 --> 王OO; 孤獨求敗 --> 孤OO ===

Planetoid at 03:31, 22 July 2017

2017-07-22T03:31:59Z

@@ Line 1: / Line 1: @@
 使用 Excel 或 MySQL 資料庫查詢方式，簡易地將個人資料去識別化 (將姓名馬賽克) 。
-== case1: 王小明 --> 王OO; 孤獨求敗 --> 孤OO ==
+== 姓名的個資去識別化 ==
 Reserve the first character of name, and replace other characters with the symbol 'OO'.
@@ Line 25: / Line 77: @@
 </pre>
-== case2: 王小明 --> 王OO; 孤獨求敗 --> 孤OO敗 ==
+=== case4: 王小明 --> 王OO; 孤獨求敗 --> 孤OO敗 ===
 Replace the second and third characters with the symbol 'OO', and reserve other characters.
@@ Line 59: / Line 111: @@
 </pre>
-ex:
-* 楊過 --> 楊O
+== 手機號碼的個資去識別化 ==
-* 王小明 --> 王O明
+=== case1: 0912345678 --> 09123XXXXX8 ===
 methods:
-* Excel:
+* Excel
-** {{kbd | key=<nowiki>=IF(LEN(A1)=2, LEFT(A1, 1)&"O", LEFT(A1, 1)&REPT("O", LEN(A1)-2)&RIGHT(A1, 1))</nowiki>}}
+** {{kbd | key=<nowiki>=LEFT(A2, 5)&REPT("X", 5)&RIGHT(A2, 1)</nowiki>}}
 == references ==
@@ Line 105: / Line 125: @@
 further reading
 * [https://vtaiwan.tw/personal-data-protection/init/ 個資利用與去識別化 - vTaiwan.tw]
 related terms

Planetoid at 11:25, 12 March 2017

2017-03-12T11:25:44Z

← Older revision		Revision as of 19:25, 12 March 2017
Line 1:		Line 1:
			使用 Excel 或 MySQL 資料庫查詢方式，簡易地將個人資料去識別化 (將姓名馬賽克) 。
	~~Simple data anonymization~~ 使用 Excel 或 MySQL ~~資料庫查詢方式，簡易地個人資料去識別化~~ (將姓名馬賽克)

	== case1: 王小明 --> 王OO; 孤獨求敗 --> 孤OO ==		== case1: 王小明 --> 王OO; 孤獨求敗 --> 孤OO ==

Planetoid at 04:17, 29 September 2016

2016-09-29T04:17:18Z

← Older revision		Revision as of 12:17, 29 September 2016
Line 1:		Line 1:

	Simple data anonymization 使用 Excel 或 MySQL ~~資料庫查詢方式，做簡易個資去識別化~~ (將姓名馬賽克)		Simple data anonymization 使用 Excel 或 MySQL 資料庫查詢方式，簡易地個人資料去識別化 (將姓名馬賽克)

	== case1: 王小明 --> 王OO; 孤獨求敗 --> 孤OO ==		== case1: 王小明 --> 王OO; 孤獨求敗 --> 孤OO ==

Planetoid at 08:05, 29 July 2016

2016-07-29T08:05:00Z

← Older revision		Revision as of 16:05, 29 July 2016
Line 101:		Line 101:


	~~reference~~		== references ==
	<references />		<references />

	further reading		further reading
	* [https://vtaiwan.tw/personal-data-protection/init/ 個資利用與去識別化 - vTaiwan.tw]		* [https://vtaiwan.tw/personal-data-protection/init/ 個資利用與去識別化 - vTaiwan.tw]

			related terms
			* [https://en.wikipedia.org/wiki/Data_masking Data masking] ([http://www.ithome.com.tw/tech/87443 資料遮罩])

	[[Category:Data transformation]] [[Category:Data Science]] [[Category:Excel]]		[[Category:Data transformation]] [[Category:Data Science]] [[Category:Excel]]

Planetoid at 03:05, 29 July 2016

2016-07-29T03:05:42Z

← Older revision		Revision as of 11:05, 29 July 2016
Line 3:		Line 3:

	== case1: 王小明 --> 王OO; 孤獨求敗 --> 孤OO ==		== case1: 王小明 --> 王OO; 孤獨求敗 --> 孤OO ==
			Reserve the first character of name, and replace other characters with the symbol 'OO'.

	ex:		ex:
	* 楊過 -> 楊OO		* 楊過 -> 楊OO
Line 12:		Line 14:
	methods		methods
	* Excel:		* Excel:
	** {{kbd \| key=<nowiki>=REPLACE(A2, 2, LEN(A2)-1, "OO")</nowiki>}} also applied for 3 or 4 ~~words~~		** {{kbd \| key=<nowiki>=REPLACE(A2, 2, LEN(A2)-1, "OO")</nowiki>}} also applied for 3 or 4 characters
	** {{kbd \| key=<nowiki>=REPLACE(A2, 2, 2, "O")</nowiki>}} {{exclaim}} only applied for 3 ~~words~~, NOT for 4 ~~words~~		** {{kbd \| key=<nowiki>=REPLACE(A2, 2, 2, "O")</nowiki>}} {{exclaim}} only applied for 3 characters, NOT for 4 characters
	* MySQL:		* MySQL:
	<pre>		<pre>
Line 25:		Line 27:

	== case2: 王小明 --> 王OO; 孤獨求敗 --> 孤OO敗 ==		== case2: 王小明 --> 王OO; 孤獨求敗 --> 孤OO敗 ==
			Replace the second and third characters with the symbol 'OO', and reserve other characters.

	* 楊過 --> 楊OO		* 楊過 --> 楊OO
	* 王小明 --> 王OO		* 王小明 --> 王OO
Line 57:		Line 61:

	== case3: 王小明 --> 王O明; 孤獨求敗 --> 孤OO敗 ==		== case3: 王小明 --> 王O明; 孤獨求敗 --> 孤OO敗 ==
			Reserve the first and last characters of name, and replace other characters with the symbol 'OO'.

	ex:		ex:
	* 楊過 --> 楊O		* 楊過 --> 楊O
Line 66:		Line 72:
	* Excel:		* Excel:
	** {{kbd \| key=<nowiki>=IF(LEN(A1)=2, LEFT(A1, 1)&"O", LEFT(A1, 1)&REPT("O", LEN(A1)-2)&RIGHT(A1, 1))</nowiki>}}		** {{kbd \| key=<nowiki>=IF(LEN(A1)=2, LEFT(A1, 1)&"O", LEFT(A1, 1)&REPT("O", LEN(A1)-2)&RIGHT(A1, 1))</nowiki>}}
	** {{kbd \| key=<nowiki>=REPLACE(A1, 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~~		** {{kbd \| key=<nowiki>=REPLACE(A1, 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 characters, NOT for 4 characters
	* PHP: using regular_replace		* PHP: using regular_replace
	<pre>		<pre>

Planetoid: /* case2: 王小明 --> 王OO; 孤獨求敗 --> 孤OO敗 */

2016-07-29T02:54:54Z

case2: 王小明 --> 王OO; 孤獨求敗 --> 孤OO敗

← Older revision		Revision as of 10:54, 29 July 2016
Line 53:		Line 53:
	-- SET @name := "Guo da-xia";		-- SET @name := "Guo da-xia";

	SELECT ~~CASE~~		SELECT CONCAT(LEFT(@name, 1), 'OO', RIGHT(@name, CHAR_LENGTH(@name)-3));
	~~WHEN CHAR_LENGTH(@name) =2 THEN CONCAT(LEFT(@name, 1), 'OO')~~
	~~ELSE~~ CONCAT(LEFT(@name, 1), 'OO', RIGHT(@name, CHAR_LENGTH(@name)-3))
	~~END~~;
	</pre>		</pre>

Planetoid at 02:48, 29 July 2016

2016-07-29T02:48:22Z

← Older revision		Revision as of 10:48, 29 July 2016
Line 1:		Line 1:

	Simple data anonymization 使用 Excel 或 MySQL 資料庫查詢方式，做簡易個資去識別化		Simple data anonymization 使用 Excel 或 MySQL 資料庫查詢方式，做簡易個資去識別化 (將姓名馬賽克)

	== case1: 王小明 --> 王OO; 孤獨求敗 --> 孤OO ==		== case1: 王小明 --> 王OO; 孤獨求敗 --> 孤OO ==

Planetoid: /* case2: 王小明 --> 王OO; 孤獨求敗 --> 孤OO敗 */

2016-07-29T02:43:21Z

case2: 王小明 --> 王OO; 孤獨求敗 --> 孤OO敗

← Older revision		Revision as of 10:43, 29 July 2016
Line 31:		Line 31:

	methods:		methods:
	* Excel:		* Excel
	** {{kbd \| key=<nowiki>=REPLACE(A1, 2, 2, "OO")</nowiki>}}		** {{kbd \| key=<nowiki>=REPLACE(A1, 2, 2, "OO")</nowiki>}}

Line 44:		Line 44:
	$replacement = '$1OO$3';		$replacement = '$1OO$3';
	echo preg_replace($pattern, $replacement, $string);		echo preg_replace($pattern, $replacement, $string);
			</pre>

			* MySQL
			<pre>
			-- SET @name := "楊過";
			SET @name := "王小明";
			-- SET @name := "孤獨求敗";
			-- SET @name := "Guo da-xia";

			SELECT CASE
			WHEN CHAR_LENGTH(@name) =2 THEN CONCAT(LEFT(@name, 1), 'OO')
			ELSE CONCAT(LEFT(@name, 1), 'OO', RIGHT(@name, CHAR_LENGTH(@name)-3))
			END;
	</pre>		</pre>