\u98df\u5149\u96c6\u5e02\u6bcf\u5929\u65e9\u4e0a 8 \u70b9，\u8d22\u52a1\u90e8\u95e8\u9700\u8981\u5b8c\u6210\u524d\u4e00\u5929\u7684\u65e5\u5bf9\u8d26\u2014\u2014\u5c06\u5fae\u4fe1\u652f\u4ed8\u3001\u652f\u4ed8\u5b9d\u3001\u94f6\u8054\u4e09\u5bb6\u6e20\u9053\u8fd4\u56de\u7684\u5bf9\u8d26\u6587\u4ef6（CSV\/JSON \u6df7\u5408，UTF-8 \u7f16\u7801\u4f46\u5076\u5c14\u6df7\u5165 GBK \u5b57\u7b26，\u90e8\u5206\u6587\u4ef6\u5e26 BOM \u5934）\u4e0e\u5185\u90e8\u8ba2\u5355\u7cfb\u7edf\u8fdb\u884c\u6bd4\u5bf9，\u627e\u51fa\u91d1\u989d\u4e0d\u4e00\u81f4\u3001\u5b57\u6bb5\u7f3a\u5931\u3001\u591a\u51fa\u6216\u7f3a\u5c11\u7684\u8ba2\u5355\u8bb0\u5f55\u3002<\/p>\n
\u8fc7\u53bb\u4e09\u4e2a\u6708\u6765，\u8fd9\u5957\u6d41\u7a0b\u9760\u7684\u662f"\u738b\u59d0 + Excel"\u2014\u2014\u738b\u59d0\u624b\u52a8\u4e0b\u8f7d\u4e09\u4e2a\u6587\u4ef6，\u7528 Excel \u7684 VLOOKUP \u8dd1\u6bd4\u5bf9，\u53d1\u73b0\u6709\u95ee\u9898\u7684\u884c\u6807\u9ec4\u8272，\u7136\u540e\u622a\u56fe\u53d1\u5230\u7fa4\u3002\u968f\u7740\u65e5\u5747\u8ba2\u5355\u4ece 500 \u6da8\u5230 8000 \u5355，Excel \u5df2\u7ecf\u8dd1\u4e0d\u52a8\u4e86\u2014\u2014\u6253\u5f00\u6587\u4ef6\u8981\u7b49 20 \u79d2，VLOOKUP \u8de8\u8868\u67e5\u8be2\u76f4\u63a5\u6b7b\u673a，\u66f4\u81f4\u547d\u7684\u662f 3 \u6708 7 \u65e5\u738b\u59d0\u8bf7\u4e86\u75c5\u5047，\u5bf9\u8d26\u4efb\u52a1\u6ca1\u4eba\u63a5\u624b，\u5bfc\u81f4\u4e00\u7b14 1400 \u5143\u7684\u5dee\u5f02\u5230\u6708\u5e95\u5ba1\u8ba1\u624d\u88ab\u53d1\u73b0\u3002<\/p>\n
\u6280\u672f\u56e2\u961f\u51b3\u5b9a\u628a\u8fd9\u4e2a\u6d41\u7a0b\u81ea\u52a8\u5316\u3002\u9700\u6c42\u770b\u4f3c\u7b80\u5355\u2014\u2014\u8bfb\u6587\u4ef6\u3001\u6bd4\u5bf9\u5b57\u6bb5\u3001\u8f93\u51fa\u5dee\u5f02\u62a5\u544a\u3002\u4f46\u771f\u6b63\u52a8\u624b\u505a\u624d\u53d1\u73b0\u5751\u591a\u5230\u7206\u70b8：<\/p>\n
\u5b57\u7b26\u4e32\u3001\u6b63\u5219\u4e0e\u6587\u4ef6 I\/O\u2014\u2014\u8fd9\u4e09\u9879\u662f\u540e\u7aef\u5f00\u53d1\u6700\u65e5\u5e38\u4e5f\u6700\u5bb9\u6613\u8e29\u5751\u7684\u6280\u80fd\u3002<\/p>\n
\u5b57\u7b26\u4e32\u548c\u6587\u4ef6\u5904\u7406\u4e0d\u5f53，\u4f1a\u5bfc\u81f4：<\/p>\n
\u573a\u666f：\u738b\u59d0\u8bf7\u5047\u5f53\u5929，CTO \u8981\u6c42"\u4eca\u5929\u5fc5\u987b\u4e0a\u7ebf\u81ea\u52a8\u5bf9\u8d26"\u3002\u5c0f\u80d6\u81ea\u544a\u594b\u52c7，\u7528\u534a\u5929\u5199\u4e86\u7b2c\u4e00\u7248\u811a\u672c，\u7ed3\u679c\u8dd1 3 \u4e2a\u6587\u4ef6\u62a5 4 \u4e2a\u9519\u3002\u5927\u5e08\u628a\u4e24\u4eba\u53eb\u5230\u4f1a\u8bae\u5ba4\u3002<\/p>\n
\u5c0f\u80d6（\u82e6\u607c）：\u201c\u5927\u5e08，\u6211\u5c31\u60f3\u8bfb\u4e2a CSV，\u7528 open('duizhang.csv') \u6253\u5f00，Python \u5c31\u62a5\u7f16\u7801\u9519\u8bef\u3002\u6211\u8bd5\u4e86 UTF-8 \u4e0d\u884c，\u52a0\u4e86 encoding='gbk' \u53c8\u62a5\u53e6\u4e00\u4e2a\u9519\u2014\u2014\u6211\u5230\u5e95\u600e\u4e48\u77e5\u9053\u6587\u4ef6\u7528\u4ec0\u4e48\u7f16\u7801？\u201d<\/p>\n
\u5c0f\u767d：\u201c\u8fd9\u662f\u4e00\u4e2a\u5f88\u5b9e\u9645\u7684\u95ee\u9898\u3002Python \u6ca1\u6709\u5185\u7f6e\u7684\u7f16\u7801\u68c0\u6d4b\u529f\u80fd，\u4f46\u6709\u4e2a chardet \u5e93\u53ef\u4ee5\u505a\u3002\u4f46\u6211\u60f3\u95ee\u4e2a\u66f4\u6839\u672c\u7684\u95ee\u9898\u2014\u2014\u4e3a\u4ec0\u4e48\u6211\u4eec\u5141\u8bb8\u6bcf\u4e2a\u652f\u4ed8\u6e20\u9053\u8fd4\u56de\u4e0d\u540c\u7f16\u7801\u7684\u6587\u4ef6？\u670d\u52a1\u7aef\u7684 API \u5951\u7ea6\u4e0d\u5e94\u8be5\u7edf\u4e00\u6210 UTF-8 \u5417？\u201d<\/p>\n
\u5927\u5e08：\u201c\u5c0f\u767d\u8bf4\u5230\u4e86\u67b6\u6784\u5c42\u9762\u2014\u2014\u4ece\u6e90\u5934\u7edf\u4e00\u7f16\u7801\u662f\u6700\u4f18\u89e3\u3002\u4f46\u73b0\u5b9e\u662f：\u4f60\u8fd9\u5468\u5c31\u8981\u4e0a\u7ebf，\u94f6\u8054\u90a3\u8fb9\u6539\u63a5\u53e3\u6392\u671f\u5230\u4e24\u4e2a\u6708\u540e\u3002\u6240\u4ee5\u6211\u4eec\u9700\u8981\u5bb9\u5fcd\u6df7\u4e71，\u4f46\u4fdd\u6301\u81ea\u5df1\u7684\u8fb9\u754c\u3002\u201d<\/p>\n
"\u7f16\u7801\u95ee\u9898\u4e0a，\u6709\u4e09\u4e2a\u9632\u5b88\u7b56\u7565：<\/p>\n
\u6700\u597d\u7684\u65b9\u6848：API \u51fa\u53e3\u7edf\u4e00 UTF-8，\u6587\u4ef6\u5165\u53e3\u5bb9\u9519\u5904\u7406\u3002"<\/p>\n
\u6280\u672f\u6620\u5c04：\u7f16\u7801\u95ee\u9898 = \u4f60\u5728\u56fd\u5916\u6536\u5230\u4e00\u5c01\u624b\u5199\u4fe1\u2014\u2014\u770b\u7740\u662f\u4e2d\u6587（GBK），\u4f46\u90ae\u9012\u5458（Python）\u6309\u82f1\u6587（UTF-8）\u89e3\u8bfb\u5c31\u6210\u4e71\u7801\u3002\u4f60\u5f97\u5148\u8ba4\u51fa\u8fd9\u662f\u4e2d\u6587，\u518d\u7528\u4e2d\u6587\u8bcd\u5178\u8bfb\u3002<\/p>\n
\u5c0f\u80d6：\u201c\u7f16\u7801\u6211\u641e\u5b9a\u4e86\u3002\u4f46\u8bfb\u5199\u5927\u6587\u4ef6\u65f6，\u6211\u5199\u4e86 data = f.read() \u7136\u540e\u670d\u52a1\u5668\u5185\u5b58\u5c31\u7206\u4e86\u2014\u20142GB \u7684\u5bf9\u8d26\u6587\u4ef6\u554a！\u201d<\/p>\n
\u5c0f\u767d：\u201c\u8fd9\u4e2a\u6211\u77e5\u9053\u2014\u2014\u7528 for line in f: \u9010\u884c\u8bfb，Python \u7684\u6587\u4ef6\u5bf9\u8c61\u672c\u8eab\u5c31\u662f\u8fed\u4ee3\u5668\u3002\u4f46\u6211\u9047\u5230\u8fc7\u4e00\u4e2a\u60c5\u51b5：\u6587\u4ef6\u91cc\u6709\u5b57\u6bb5\u672c\u8eab\u5305\u542b\u6362\u884c\u7b26（CSV \u4e2d\u88ab\u53cc\u5f15\u53f7\u5305\u88f9\u7684\u591a\u884c\u5b57\u6bb5），\u9010\u884c\u8bfb\u5c31\u65ad\u4e86\u3002\u8fd9\u4e2a\u600e\u4e48\u5904\u7406？\u201d<\/p>\n
\u5927\u5e08：\u201c\u597d\u95ee\u9898\u3002\u9010\u884c\u8bfb\u53d6 for line in f \u9002\u7528\u4e8e\u6bcf\u884c\u5bf9\u5e94\u4e00\u6761\u903b\u8f91\u8bb0\u5f55\u7684\u573a\u666f\u3002\u5bf9\u4e8e CSV \u4e2d\u6709\u8f6c\u4e49\u6362\u884c\u7684\u573a\u666f，\u7528 csv.reader \u800c\u4e0d\u662f\u624b\u5199\u89e3\u6790\u2014\u2014csv \u6a21\u5757\u5df2\u7ecf\u5904\u7406\u597d\u4e86\u5f15\u53f7\u5185\u7684\u6362\u884c\u3002\u201d<\/p>\n
"\u5927\u6587\u4ef6\u5904\u7406\u7684\u4e09\u677f\u65a7：<\/p>\n
\u201c\u4f46\u6709\u4e00\u4e2a\u91cd\u8981\u7684\u5751\u2014\u2014Windows \u548c Linux \u7684\u6362\u884c\u7b26\u4e0d\u540c\u3002Python 3 \u7684 open() \u9ed8\u8ba4\u542f\u7528\u901a\u7528\u6362\u884c\u6a21\u5f0f（universal newlines），\u8bfb\u5165\u65f6 \\\\r\\\\n\u3001\\\\r\u3001\\\\n \u90fd\u7edf\u4e00\u8f6c\u6362\u4e3a \\\\n\u3002\u8fd9\u5728\u4f60\u505a\u591a\u5e73\u53f0\u6587\u4ef6\u5904\u7406\u65f6\u662f\u6551\u547d\u7684\u7279\u6027，\u4f46\u8981\u6ce8\u610f：\u7528 open(path, newline='') \u53ef\u4ee5\u7981\u7528\u8fd9\u4e2a\u884c\u4e3a\u2014\u2014\u6bd4\u5982\u4f60\u9700\u8981\u4fdd\u7559\u539f\u59cb\u6362\u884c\u7b26\u5199\u5165\u65f6\u3002\u201d<\/p>\n
\u6280\u672f\u6620\u5c04：\u9010\u884c\u8bfb\u53d6 = \u5403\u6d41\u6c34\u9762\u2014\u2014\u6765\u4e00\u7897\u5403\u4e00\u7897，\u4e0d\u9700\u8981\u4e00\u5f20\u80fd\u653e 100 \u7897\u9762\u7684\u684c\u5b50\u3002csv.reader = \u5bff\u53f8\u4f20\u9001\u5e26\u2014\u2014\u4e0d\u4ec5\u9010\u76d8\u62ff，\u8fd8\u628a\u6bcf\u4e2a\u5bff\u53f8\u7684\u914d\u6599（\u5b57\u6bb5）\u5206\u597d\u4e86\u3002<\/p>\n
\u5c0f\u80d6：\u201c\u6b63\u5219\u5462？\u6211\u8981\u4ece\u4e00\u5806\u652f\u4ed8\u56de\u6267\u91cc\u63d0\u53d6\u8ba2\u5355\u53f7，\u6709\u7684\u53eb ORDER_ID=ABC-123，\u6709\u7684\u53eb orderId=ABC-123，\u6709\u7684\u662f "\u8ba2\u5355\u53f7":"ABC-123"\u3002\u2014\u2014\u8fd9\u600e\u4e48\u5199\u4e00\u4e2a\u6b63\u5219\u5168\u90e8\u5339\u914d？\u201d<\/p>\n
\u5c0f\u767d：\u201c\u6b63\u5219\u662f\u4e2a\u597d\u5de5\u5177，\u4f46\u4e5f\u662f\u53cc\u5203\u5251\u3002\u6211\u89c1\u8fc7\u4e00\u4e2a\u6b63\u5219\u6709 200 \u4e2a\u5b57\u7b26，\u5199\u7684\u4eba\u81ea\u5df1\u4e00\u5468\u540e\u90fd\u770b\u4e0d\u61c2\u3002\u600e\u4e48\u5224\u65ad\u4e00\u4e2a\u6b63\u5219\u662f\u2019\u591f\u7528\u2019\u8fd8\u662f\u2019\u8fc7\u5ea6\u2019\u4e86？\u8fd8\u6709 re.match\u3001re.search\u3001re.fullmatch \u7684\u533a\u522b，\u5f88\u591a\u4eba\u641e\u4e0d\u6e05\u3002\u201d<\/p>\n
\u5927\u5e08：\u201c\u6b63\u5219\u7684\u6838\u5fc3\u601d\u60f3\u662f\u63cf\u8ff0\u6a21\u5f0f\u800c\u975e\u5217\u4e3e\u60c5\u51b5\u3002\u4ee5\u8ba2\u5355\u53f7\u63d0\u53d6\u4e3a\u4f8b\u2014\u2014\u8ba2\u5355\u53f7\u7684\u672c\u8d28\u662f\u2019\u4ee5 ABC- \u5f00\u5934，\u540e\u8ddf\u4e09\u4f4d\u6570\u5b57\u2019\u3002\u4e0d\u7ba1\u4f60\u524d\u9762\u7684\u6807\u7b7e\u53eb ORDER_ID \u8fd8\u662f orderId \u8fd8\u662f \u8ba2\u5355\u53f7，\u8ba2\u5355\u53f7\u7684\u56fa\u6709\u6a21\u5f0f\u662f ABC-\\\\d{3}\u3002\u201d<\/p>\n
import<\/span> re<\/p>\n ORDER_ID_PATTERN =<\/span> re.<\/span>compile<\/span>(<\/span>r"ABC-\\\\d{3}"<\/span>)<\/span><\/p>\n # \u4e09\u79cd\u90fd\u80fd\u5339\u914d\u7684\u6587\u672c<\/span> for<\/span> text in<\/span> texts:<\/span> "\u5173\u4e8e\u4e09\u4e2a\u51fd\u6570\u7684\u533a\u522b：<\/p>\n \u9009\u62e9\u76f4\u89c9：\u5982\u679c\u4f60\u5728\u8bf4\u2019\u8fd9\u4e2a\u5b57\u7b26\u4e32\u662f\u4e0d\u662f\u4e00\u4e2a\u5408\u6cd5\u7684\u624b\u673a\u53f7\u2019\u2192 \u7528 fullmatch\u3002\u5982\u679c\u4f60\u5728\u8bf4\u2019\u8fd9\u4e2a\u5b57\u7b26\u4e32\u91cc\u6709\u6ca1\u6709\u624b\u673a\u53f7\u2019\u2192 \u7528 search\u3002\u5982\u679c\u4f60\u5728\u8bf4\u2019\u8fd9\u4e2a\u5b57\u7b26\u4e32\u5f00\u5934\u7684\u90e8\u5206\u662f\u4e0d\u662f\u5408\u6cd5\u624b\u673a\u53f7\u2019\u2192 \u7528 match\u3002"<\/p>\n \u201c\u81f3\u4e8e\u6b63\u5219\u662f\u5426\u8fc7\u5ea6\u2014\u2014\u4e00\u4e2a\u7b80\u5355\u7684\u5224\u65ad\u6807\u51c6：\u5982\u679c\u4e00\u4e2a\u6b63\u5219\u91cc\u51fa\u73b0\u4e86 3 \u4e2a\u4ee5\u4e0a\u7684\u5d4c\u5957\u5206\u7ec4 ((…))，\u6216\u8005\u9700\u8981\u6ce8\u91ca\u624d\u80fd\u8bfb\u61c2\u7684 (?<=…) \u96f6\u5bbd\u65ad\u8a00，\u8003\u8651\u62c6\u6210\u591a\u6b65\u5904\u7406\u3002\u5148\u63d0\u53d6\u7c97\u7c92\u5ea6\u7684\u6587\u672c\u5757，\u518d\u7528\u7b80\u5355\u7684\u5b57\u7b26\u4e32\u65b9\u6cd5\u505a\u7ec6\u7c92\u5ea6\u89e3\u6790\u3002\u201d<\/p>\n \u6280\u672f\u6620\u5c04：\u6b63\u5219 = \u901a\u7f09\u4ee4\u2014\u2014\u4f60\u4e0d\u63cf\u8ff0\u5177\u4f53\u957f\u4ec0\u4e48\u6837（\u9ad8\u77ee\u80d6\u7626），\u800c\u662f\u63cf\u8ff0\u6a21\u5f0f（\u5de6\u8138\u6709\u75a4\u3001\u6234\u773c\u955c）\u3002search = \u5168\u57ce\u641c\u6355，fullmatch = \u5728\u95e8\u53e3\u5835\u7740\u67e5\u9a8c\u8eab\u4efd\u8bc1\u3002<\/p>\n mkdir<\/span> foodmarket-ch08 &&<\/span> cd<\/span> foodmarket-ch08 src\/file_reader.py：<\/p>\n """\u7f16\u7801\u81ea\u9002\u5e94\u6587\u4ef6\u8bfb\u53d6\u5668"""<\/span><\/p>\n import<\/span> csv ENCODINGS_TO_TRY =<\/span> [<\/span>"utf-8-sig"<\/span>,<\/span> "utf-8"<\/span>,<\/span> "gbk"<\/span>,<\/span> "gb2312"<\/span>,<\/span> "latin-1"<\/span>]<\/span><\/p>\n def<\/span> detect_encoding<\/span>(<\/span>file_path:<\/span> Path,<\/span> sample_size:<\/span> int<\/span> =<\/span> 10240<\/span>)<\/span> –<\/span>><\/span> str<\/span>:<\/span> # \u7b80\u5355\u542f\u53d1\u5f0f：\u5982\u679c\u524d 3 \u5b57\u8282\u662f BOM，\u9009 utf-8-sig<\/span> # \u6309\u987a\u5e8f\u5c1d\u8bd5<\/span> # \u515c\u5e95：latin-1 \u6c38\u8fdc\u4e0d\u4f1a\u5931\u8d25（0x00-0xFF \u90fd\u6709\u5bf9\u5e94\u5b57\u7b26）<\/span> def<\/span> safe_read_lines<\/span>(<\/span>file_path:<\/span> str<\/span> |<\/span> Path)<\/span> –<\/span>><\/span> Iterator[<\/span>str<\/span>]<\/span>:<\/span> encoding =<\/span> detect_encoding(<\/span>path)<\/span> with<\/span> open<\/span>(<\/span>path,<\/span> encoding=<\/span>encoding,<\/span> errors=<\/span>"replace"<\/span>)<\/span> as<\/span> f:<\/span> def<\/span> read_csv_records<\/span>(<\/span>file_path:<\/span> str<\/span> |<\/span> Path)<\/span> –<\/span>><\/span> list<\/span>[<\/span>dict<\/span>[<\/span>str<\/span>,<\/span> str<\/span>]<\/span>]<\/span>:<\/span> rows =<\/span> [<\/span>]<\/span>
\ntexts =<\/span> [<\/span>
\n 'ORDER_ID=ABC-123'<\/span>,<\/span>
\n '"orderId":"ABC-456"'<\/span>,<\/span>
\n '\u8ba2\u5355\u53f7:ABC-789'<\/span>,<\/span>
\n]<\/span><\/p>\n
\n match<\/span> =<\/span> ORDER_ID_PATTERN.<\/span>search(<\/span>text)<\/span> # search \u67e5\u627e\u4efb\u610f\u4f4d\u7f6e<\/span>
\n if<\/span> match<\/span>:<\/span>
\n print<\/span>(<\/span>match<\/span>.<\/span>group(<\/span>)<\/span>)<\/span> # ABC-123, ABC-456, ABC-789<\/span><\/p>\n\n
\n3. \u9879\u76ee\u5b9e\u6218：\u81ea\u52a8\u5bf9\u8d26\u5de5\u5177<\/h3>\n
\u73af\u5883\u51c6\u5907<\/h4>\n
\n
\u4f9d\u8d56\u7248\u672c\u8bf4\u660e<\/tr>\n \n\n Python<\/td>\n 3.13.14<\/td>\n \u57fa\u51c6\u7248\u672c<\/td>\n<\/tr>\n \n \u65e0\u9700\u7b2c\u4e09\u65b9\u5e93<\/td>\n \u2014<\/td>\n re\u3001csv\u3001json\u3001pathlib \u5747\u4e3a\u6807\u51c6\u5e93<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\npython -m<\/span> venv .venv
\n.venv\\\\<\/span>Scripts\\\\<\/span>activate<\/p>\n\u5206\u6b65\u5b9e\u73b0<\/h4>\n
\u6b65\u9aa41：\u7f16\u5199\u7f16\u7801\u81ea\u9002\u5e94\u6587\u4ef6\u8bfb\u53d6\u5668（\u76ee\u6807：\u5904\u7406 UTF-8\/GBK\/BOM \u6df7\u5408\u7f16\u7801）<\/h5>\n
\nimport<\/span> json
\nfrom<\/span> pathlib import<\/span> Path
\nfrom<\/span> typing import<\/span> Iterator,<\/span> Any<\/p>\n
\n """\u5c1d\u8bd5\u591a\u4e2a\u7f16\u7801\u6253\u5f00\u6587\u4ef6，\u8fd4\u56de\u7b2c\u4e00\u4e2a\u6210\u529f\u7684\u7f16\u7801"""<\/span>
\n raw_bytes =<\/span> file_path.<\/span>read_bytes(<\/span>)<\/span>[<\/span>:<\/span>sample_size]<\/span><\/p>\n
\n if<\/span> raw_bytes[<\/span>:<\/span>3<\/span>]<\/span> ==<\/span> b"\\\\xef\\\\xbb\\\\xbf"<\/span>:<\/span>
\n return<\/span> "utf-8-sig"<\/span><\/p>\n
\n for<\/span> enc in<\/span> ENCODINGS_TO_TRY:<\/span>
\n try<\/span>:<\/span>
\n raw_bytes.<\/span>decode(<\/span>enc)<\/span>
\n return<\/span> enc
\n except<\/span> (<\/span>UnicodeDecodeError,<\/span> LookupError)<\/span>:<\/span>
\n continue<\/span><\/p>\n
\n return<\/span> "latin-1"<\/span><\/p>\n
\n """\u5b89\u5168\u9010\u884c\u8bfb\u53d6\u2014\u2014\u81ea\u52a8\u68c0\u6d4b\u7f16\u7801 + \u8df3\u8fc7\u7a7a\u884c"""<\/span>
\n path =<\/span> Path(<\/span>file_path)<\/span>
\n if<\/span> not<\/span> path.<\/span>exists(<\/span>)<\/span>:<\/span>
\n raise<\/span> FileNotFoundError(<\/span>f"\u5bf9\u8d26\u6587\u4ef6\u4e0d\u5b58\u5728: <\/span>{<\/span>file_path}<\/span><\/span>"<\/span><\/span>)<\/span><\/p>\n
\n print<\/span>(<\/span>f"[\u6587\u4ef6] <\/span>{<\/span>path.<\/span>name}<\/span><\/span> \u2192 \u68c0\u6d4b\u7f16\u7801: <\/span>{<\/span>encoding}<\/span><\/span>"<\/span><\/span>)<\/span><\/p>\n
\n for<\/span> line in<\/span> f:<\/span>
\n stripped =<\/span> line.<\/span>rstrip(<\/span>"\\\\n\\\\r"<\/span>)<\/span>
\n if<\/span> stripped:<\/span> # \u8df3\u8fc7\u7a7a\u884c<\/span>
\n yield<\/span> stripped<\/p>\n
\n """\u8bfb\u53d6 CSV \u5bf9\u8d26\u6587\u4ef6\u4e3a\u5b57\u5178\u5217\u8868"""<\/span>
\n path =<\/span> Path(<\/span>file_path)<\/span>
\n encoding =<\/span> detect_encoding(<\/span>path)<\/span><\/p>\n
\n with<\/span> open<\/span>(<\/span>path,<\/span> encoding=<\/span>encoding,<\/span> errors=<\/span>"replace"<\/span>,<\/span> newline=<\/span>""<\/span>)<\/span> as<\/span> f