{"id":106811,"date":"2026-09-18T10:48:52","date_gmt":"2026-09-18T02:48:52","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/106811.html"},"modified":"2026-09-18T10:48:52","modified_gmt":"2026-09-18T02:48:52","slug":"%e9%87%8f%e5%8c%96%e6%95%b0%e6%8d%ae%e8%bf%9b%e9%98%b6%ef%bc%9a%e5%a4%9a%e7%bb%b4%e5%ae%9e%e6%88%98%e7%af%87%ef%bc%88%e7%ac%ac-10-%e7%af%87%ef%bc%89%ef%bc%9a%e6%9d%bf%e5%9d%97%e8%bd%ae%e5%8a%a8","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/106811.html","title":{"rendered":"\u91cf\u5316\u6570\u636e\u8fdb\u9636\uff1a\u591a\u7ef4\u5b9e\u6218\u7bc7\uff08\u7b2c 10 \u7bc7\uff09\uff1a\u677f\u5757\u8f6e\u52a8\uff1a\u884c\u4e1a\u8d44\u91d1\u6d41\u5411\u4e0e\u9f99\u5934\u80a1\u6355\u6349"},"content":{"rendered":"<h2>\u91cf\u5316\u6570\u636e\u8fdb\u9636&#xff1a;\u591a\u7ef4\u5b9e\u6218\u7bc7&#xff08;\u7b2c 10 \u7bc7&#xff09;&#xff1a;\u677f\u5757\u8f6e\u52a8&#xff1a;\u884c\u4e1a\u8d44\u91d1\u6d41\u5411\u4e0e\u9f99\u5934\u80a1\u6355\u6349<\/h2>\n<h3>\u4e00\u3001\u524d\u8a00<\/h3>\n<p>\u4e0a\u4e00\u7bc7\u300a\u81ea\u7814\u6307\u6807&#xff1a;\u91cf\u4ef7\u80cc\u79bb\u3001\u6362\u624b\u5f02\u52a8\u4e0e\u632f\u5e45\u300b\u6211\u4eec\u5b8c\u6210\u4e86\u300c\u6a21\u5757\u4e09\u00b7\u6280\u672f\u6307\u6807\u300d\u7684\u6536\u5b98&#xff0c;\u4e5f\u5b8c\u6210\u4e86\u4e00\u6b21\u8f6c\u8eab&#xff1a;\u53ea\u62ff\u88f8\u5b57\u6bb5&#xff0c;\u7eaf Python \u624b\u5199\u56e0\u5b50\u3002\u4f46\u90a3\u4e00\u7bc7\u7684\u89c6\u89d2\u59cb\u7ec8\u505c\u5728\u4e00\u53ea\u80a1\u7968\u4e0a\u2014\u2014\u4ef7\u683c\u5206\u4f4d\u3001\u91cf\u80fd\u5206\u4f4d\u3001\u6362\u624b Z-Score&#xff0c;\u5168\u90e8\u662f\u300c\u4e2a\u80a1\u81ea\u8eab\u7684\u65f6\u95f4\u5e8f\u5217\u300d\u3002<\/p>\n<p>\u771f\u5b9e\u76d8\u9762\u91cc&#xff0c;\u4e2a\u80a1\u5f88\u5c11\u72ec\u81ea\u4e0a\u6da8\u3002\u8d44\u91d1\u901a\u5e38\u5148\u6d8c\u5165\u67d0\u4e2a\u884c\u4e1a&#xff0c;\u518d\u7531\u884c\u4e1a\u5185\u7684\u9f99\u5934\u80a1\u628a\u6da8\u5e45\u4f20\u5bfc\u5f00\u6765&#xff0c;\u8fd9\u5c31\u662f\u6240\u8c13\u7684\u677f\u5757\u8f6e\u52a8\u3002\u53ea\u770b\u4e2a\u80a1&#xff0c;\u4f60\u6c38\u8fdc\u4e0d\u77e5\u9053\u300c\u4e3a\u4ec0\u4e48\u6da8\u300d&#xff1b;\u53ea\u770b\u6307\u6570&#xff0c;\u4f60\u53c8\u6293\u4e0d\u5230\u300c\u8c01\u5728\u6da8\u300d\u3002<\/p>\n<p>\u672c\u7bc7\u8fdb\u5165\u300c\u6a21\u5757\u56db\u00b7\u677f\u5757\u4e0e\u8d44\u91d1\u300d&#xff0c;\u7528\u4e09\u4e2a\u63a5\u53e3\u628a\u89c6\u89d2\u4ece\u300c\u4e2a\u80a1\u300d\u62ac\u5347\u5230\u300c\u884c\u4e1a\u300d&#xff1a;<\/p>\n<ul>\n<li>hizj\/zjh&#xff1a;\u8bc1\u76d1\u4f1a\u884c\u4e1a\u8d44\u91d1\u6d41&#xff0c;\u4e00\u6b21\u8fd4\u56de\u5168\u5e02\u573a\u5404\u884c\u4e1a\u7684\u8fd1 3 \/ 5 \/ 10 \u65e5\u6da8\u8dcc\u5e45\u4e0e\u51c0\u6d41\u989d&#xff1b;<\/li>\n<li>hibk\/zjhhy&#xff1a;\u8bc1\u76d1\u4f1a\u884c\u4e1a\u677f\u5757&#xff0c;\u4e00\u6b21\u8fd4\u56de\u5404\u677f\u5757\u7684\u5747\u4ef7\u3001\u6da8\u8dcc\u5e45\u3001\u6d41\u5165\u6d41\u51fa\u8d44\u91d1\u3001\u51c0\u6d41\u5165&#xff0c;\u4ee5\u53ca\u8be5\u677f\u5757\u7684\u9f99\u5934\u80a1&#xff1b;<\/li>\n<li>higg\/jlr&#xff1a;\u4e2a\u80a1\u51c0\u6d41\u5165\u699c&#xff0c;\u7528\u4e8e\u5bf9\u884c\u4e1a\u9f99\u5934\u80a1\u505a\u4e8c\u6b21\u9a8c\u8bc1\u3002<\/li>\n<\/ul>\n<p>\u4e09\u8005\u7ed3\u5408&#xff0c;\u6211\u4eec\u81ea\u7814\u300c\u8d44\u91d1\u6d41\u5411\u6392\u540d\u300d\u300c\u8f6e\u52a8\u5f3a\u5ea6\u300d\u300c\u591a\u5468\u671f\u8d44\u91d1\u5171\u632f\u300d\u300c\u51c0\u6d41\u7387\u80cc\u79bb\u300d\u300c\u9f99\u5934\u80a1\u6355\u6349\u300d\u300c\u677f\u5757\u2192\u4e2a\u80a1\u7a7f\u900f\u300d\u516d\u7ec4\u6307\u6807&#xff0c;\u628a\u300c\u54ea\u53ea\u80a1\u7968\u5728\u6da8\u300d\u5347\u7ea7\u4e3a\u300c\u54ea\u6761\u8d44\u91d1\u94fe\u5728\u52a8\u300d\u3002<\/p>\n<p>\u8854\u63a5\u8bf4\u660e&#xff1a;\u672c\u7bc7\u662f\u300c\u6a21\u5757\u56db\u00b7\u677f\u5757\u4e0e\u8d44\u91d1\u300d\u7684\u5f00\u7bc7\u3002\u4e0a\u4e00\u7bc7\u89e3\u51b3\u4e86\u300c\u4e2a\u80a1\u5c42\u9762\u7684\u81ea\u7814\u56e0\u5b50\u300d&#xff0c;\u672c\u7bc7\u89e3\u51b3\u300c\u884c\u4e1a\u5c42\u9762\u7684\u8d44\u91d1\u4e0e\u9f99\u5934\u300d&#xff0c;\u4e0b\u4e00\u7bc7\u5c06\u56de\u5230\u98ce\u63a7&#xff0c;\u8865\u9f50\u672c\u7cfb\u5217\u6700\u540e\u4e00\u5757\u62fc\u56fe\u3002<\/p>\n<p>\u90d1\u91cd\u8bf4\u660e&#xff1a;\u672c\u6587\u6240\u6709\u6392\u540d\u3001\u6253\u6807\u3001\u5171\u632f\u3001\u80cc\u79bb\u3001\u9a8c\u8bc1\u903b\u8f91\u5168\u90e8\u662f\u81ea\u7814\u56e0\u5b50&#xff0c;\u4e0d\u662f\u5fc5\u76c8\u63a5\u53e3\u63d0\u4f9b\u7684\u529f\u80fd\u3002\u4e09\u4e2a\u63a5\u53e3\u53ea\u63d0\u4f9b\u88f8\u5b57\u6bb5&#xff0c;\u6240\u6709\u6392\u540d\u3001\u5206\u4f4d\u3001\u8c61\u9650\u5206\u7c7b\u3001\u540c\u53f7\u5171\u632f\u3001\u7b26\u53f7\u80cc\u79bb\u3001\u9f99\u5934\u6821\u9a8c\u5747\u7531\u672c\u6587\u4ee3\u7801\u5728\u672c\u5730\u7b97\u51fa\u3002<\/p>\n<h3>\u4e8c\u3001\u63a5\u53e3\u5b57\u6bb5\u89e3\u8bfb<\/h3>\n<h4>2.1 \u8bc1\u76d1\u4f1a\u884c\u4e1a\u8d44\u91d1\u6d41 hizj\/zjh<\/h4>\n<p>http:\/\/api.biyingapi.com\/hizj\/zjh\/{LICENCE}<\/p>\n<p>\u8def\u5f84\u53c2\u6570&#xff1a;<\/p>\n<table>\n<tr>\u53c2\u6570\u53d6\u503c\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>LICENCE<\/td>\n<td>\u60a8\u7684 licence<\/td>\n<td>\u9274\u6743\u4e32<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8fd4\u56de\u5b57\u6bb5&#xff08;\u4ec5\u4ee5\u4e0b\u5b57\u6bb5&#xff09;&#xff1a;<\/p>\n<table>\n<tr>\u5b57\u6bb5\u7c7b\u578b\u542b\u4e49<\/tr>\n<tbody>\n<tr>\n<td>t<\/td>\n<td>string<\/td>\n<td>\u65f6\u95f4<\/td>\n<\/tr>\n<tr>\n<td>mc<\/td>\n<td>string<\/td>\n<td>\u884c\u4e1a\u540d\u79f0<\/td>\n<\/tr>\n<tr>\n<td>dm<\/td>\n<td>string<\/td>\n<td>\u884c\u4e1a\u4ee3\u7801<\/td>\n<\/tr>\n<tr>\n<td>ac3<\/td>\n<td>number<\/td>\n<td>\u8fd1 3 \u65e5\u6da8\u8dcc\u5e45&#xff08;%&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>net3<\/td>\n<td>number<\/td>\n<td>\u8fd1 3 \u65e5\u51c0\u6d41\u989d<\/td>\n<\/tr>\n<tr>\n<td>ra3<\/td>\n<td>number<\/td>\n<td>\u8fd1 3 \u65e5\u51c0\u6d41\u7387&#xff08;%&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>ac5<\/td>\n<td>number<\/td>\n<td>\u8fd1 5 \u65e5\u6da8\u8dcc\u5e45&#xff08;%&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>net5<\/td>\n<td>number<\/td>\n<td>\u8fd1 5 \u65e5\u51c0\u6d41\u989d<\/td>\n<\/tr>\n<tr>\n<td>ra5<\/td>\n<td>number<\/td>\n<td>\u8fd1 5 \u65e5\u51c0\u6d41\u7387&#xff08;%&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>ac10<\/td>\n<td>number<\/td>\n<td>\u8fd1 10 \u65e5\u6da8\u8dcc\u5e45&#xff08;%&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>net10<\/td>\n<td>number<\/td>\n<td>\u8fd1 10 \u65e5\u51c0\u6d41\u989d<\/td>\n<\/tr>\n<tr>\n<td>ra10<\/td>\n<td>number<\/td>\n<td>\u8fd1 10 \u65e5\u51c0\u6d41\u7387&#xff08;%&#xff09;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;\u8fd9\u4e2a\u63a5\u53e3\u7684\u4ef7\u503c\u5728\u4e8e\u540c\u65f6\u7ed9\u4e86\u300c\u4ef7\u300d\u4e0e\u300c\u94b1\u300d\u4e24\u7ec4\u4e09\u5468\u671f\u6570\u636e\u2014\u2014ac3\/ac5\/ac10 \u662f\u4ef7\u683c\u7ed3\u679c&#xff0c;net3\/net5\/net10 \u662f\u8d44\u91d1\u539f\u56e0&#xff0c;ra3\/ra5\/ra10 \u662f\u628a\u8d44\u91d1\u6309\u6d41\u901a\u89c4\u6a21\u5f52\u4e00\u5316\u540e\u7684\u6bd4\u7387\u3002\u4e09\u5468\u671f \u00d7 \u4e09\u53e3\u5f84 &#061; \u4e5d\u4e2a\u6570&#xff0c;\u591a\u5468\u671f\u5171\u632f\u4e0e\u80cc\u79bb\u5c31\u5efa\u7acb\u5728\u8fd9\u4e5d\u4e2a\u6570\u4e4b\u4e0a\u3002<\/p>\n<h4>2.2 \u8bc1\u76d1\u4f1a\u884c\u4e1a\u677f\u5757 hibk\/zjhhy<\/h4>\n<p>http:\/\/api.biyingapi.com\/hibk\/zjhhy\/{LICENCE}<\/p>\n<p>\u8fd4\u56de\u5b57\u6bb5&#xff08;\u4ec5\u4ee5\u4e0b\u5b57\u6bb5&#xff09;&#xff1a;<\/p>\n<table>\n<tr>\u5b57\u6bb5\u7c7b\u578b\u542b\u4e49<\/tr>\n<tbody>\n<tr>\n<td>t<\/td>\n<td>string<\/td>\n<td>\u65f6\u95f4<\/td>\n<\/tr>\n<tr>\n<td>mc<\/td>\n<td>string<\/td>\n<td>\u677f\u5757\u540d\u79f0<\/td>\n<\/tr>\n<tr>\n<td>dm<\/td>\n<td>string<\/td>\n<td>\u677f\u5757\u4ee3\u7801<\/td>\n<\/tr>\n<tr>\n<td>jj<\/td>\n<td>number<\/td>\n<td>\u5747\u4ef7&#xff08;\u5143&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>zdf<\/td>\n<td>number<\/td>\n<td>\u6da8\u8dcc\u5e45&#xff08;%&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>lrzj<\/td>\n<td>number<\/td>\n<td>\u6d41\u5165\u8d44\u91d1<\/td>\n<\/tr>\n<tr>\n<td>lczj<\/td>\n<td>number<\/td>\n<td>\u6d41\u51fa\u8d44\u91d1<\/td>\n<\/tr>\n<tr>\n<td>jlr<\/td>\n<td>number<\/td>\n<td>\u51c0\u6d41\u5165<\/td>\n<\/tr>\n<tr>\n<td>jlrl<\/td>\n<td>number<\/td>\n<td>\u51c0\u6d41\u5165\u7387&#xff08;%&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>lzgmc<\/td>\n<td>string<\/td>\n<td>\u9f99\u5934\u80a1\u540d\u79f0<\/td>\n<\/tr>\n<tr>\n<td>lzgdm<\/td>\n<td>string<\/td>\n<td>\u9f99\u5934\u80a1\u4ee3\u7801<\/td>\n<\/tr>\n<tr>\n<td>lzgjlrl<\/td>\n<td>number<\/td>\n<td>\u9f99\u5934\u80a1\u51c0\u6d41\u5165\u7387&#xff08;%&#xff09;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bf4\u660e&#xff1a;lrzj &#8211; lczj &#061; jlr&#xff0c;\u63a5\u53e3\u628a\u6d41\u5165\u3001\u6d41\u51fa\u3001\u51c0\u989d\u4e09\u4e2a\u6570\u90fd\u7ed9\u4e86&#xff0c;\u53ef\u4ee5\u76f4\u63a5\u6821\u9a8c\u6570\u636e\u81ea\u6d3d\u6027\u3002\u66f4\u5173\u952e\u7684\u662f lzgmc \/ lzgdm \/ lzgjlrl\u2014\u2014\u63a5\u53e3\u76f4\u63a5\u544a\u8bc9\u4f60\u6bcf\u4e2a\u677f\u5757\u5f53\u524d\u8d44\u91d1\u7684\u300c\u65d7\u624b\u300d\u662f\u8c01&#xff0c;\u8fd9\u662f\u672c\u7bc7\u9f99\u5934\u80a1\u6355\u6349\u7684\u6570\u636e\u57fa\u7840\u3002<\/p>\n<h4>2.3 \u4e2a\u80a1\u51c0\u6d41\u5165 higg\/jlr<\/h4>\n<p>http:\/\/api.biyingapi.com\/higg\/jlr\/{LICENCE}<\/p>\n<p>\u8fd4\u56de\u5b57\u6bb5&#xff08;\u4ec5\u4ee5\u4e0b\u5b57\u6bb5&#xff09;&#xff1a;<\/p>\n<table>\n<tr>\u5b57\u6bb5\u7c7b\u578b\u542b\u4e49<\/tr>\n<tbody>\n<tr>\n<td>t<\/td>\n<td>string<\/td>\n<td>\u65f6\u95f4<\/td>\n<\/tr>\n<tr>\n<td>mc<\/td>\n<td>string<\/td>\n<td>\u540d\u79f0<\/td>\n<\/tr>\n<tr>\n<td>dm<\/td>\n<td>string<\/td>\n<td>\u4ee3\u7801<\/td>\n<\/tr>\n<tr>\n<td>zxj<\/td>\n<td>number<\/td>\n<td>\u6700\u65b0\u4ef7&#xff08;\u5143&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>zdf<\/td>\n<td>number<\/td>\n<td>\u6da8\u8dcc\u5e45&#xff08;%&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>hsl<\/td>\n<td>number<\/td>\n<td>\u6362\u624b\u7387&#xff08;%&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>cje<\/td>\n<td>number<\/td>\n<td>\u6210\u4ea4\u989d<\/td>\n<\/tr>\n<tr>\n<td>lczj<\/td>\n<td>number<\/td>\n<td>\u6d41\u51fa\u8d44\u91d1<\/td>\n<\/tr>\n<tr>\n<td>lrzj<\/td>\n<td>number<\/td>\n<td>\u6d41\u5165\u8d44\u91d1<\/td>\n<\/tr>\n<tr>\n<td>jlr<\/td>\n<td>number<\/td>\n<td>\u51c0\u6d41\u5165<\/td>\n<\/tr>\n<tr>\n<td>jlrl<\/td>\n<td>number<\/td>\n<td>\u51c0\u6d41\u5165\u7387&#xff08;%&#xff09;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u6ce8\u610f&#xff1a;\u4e09\u4e2a\u63a5\u53e3\u90fd\u6709 t\u3001mc\u3001dm\u3001zdf\u3001jlr\u3001jlrl \u7b49\u540c\u540d\u5b57\u6bb5&#xff0c;\u4f46 hizj\/zjh \u7684 dm \u662f\u884c\u4e1a\u4ee3\u7801\u3001hibk\/zjhhy \u7684 dm \u662f\u677f\u5757\u4ee3\u7801\u3001higg\/jlr \u7684 dm \u662f\u80a1\u7968\u4ee3\u7801\u2014\u2014\u540c\u540d\u4e0d\u540c\u57df\u3002\u672c\u6587\u5728\u51fd\u6570\u4e2d\u663e\u5f0f\u533a\u5206&#xff0c;\u8de8\u8868\u5173\u8054\u65f6\u5fc5\u987b\u5e26\u4e0a\u8bed\u4e49\u524d\u7f00&#xff0c;\u7edd\u4e0d\u628a\u884c\u4e1a\u4ee3\u7801\u4e0e\u80a1\u7968\u4ee3\u7801\u6df7\u4e3a\u4e00\u8c08\u3002<\/p>\n<h3>\u4e09\u3001\u81ea\u7814\u884d\u751f\u6307\u6807 \/ \u4e1a\u52a1\u903b\u8f91<\/h3>\n<p>\u63a5\u53e3\u53ea\u7ed9\u88f8\u5b57\u6bb5&#xff0c;\u4ee5\u4e0b\u5168\u90e8\u7528 Python \u624b\u5199&#xff08;\u5747\u4e3a\u81ea\u7814\u56e0\u5b50&#xff0c;\u975e\u63a5\u53e3\u80fd\u529b&#xff09;&#xff1a;<\/p>\n<li>\u8d44\u91d1\u6d41\u5411\u6392\u540d flow_rank&#xff08;\u81ea\u7814&#xff09;&#xff1a;\u6309\u51c0\u6d41\u5165 jlr \u964d\u5e8f\u6392\u540d&#xff0c;rank(ascending&#061;False, method&#061;&#034;min&#034;)&#xff0c;\u6392\u540d 1 \u8868\u793a\u51c0\u6d41\u5165\u6700\u5927\u3002\u7f3a\u5931\u503c\u4e0d\u53c2\u4e0e\u6392\u540d&#xff0c;\u6392\u540d\u7ed3\u679c\u8bb0\u4e3a NaN\u3002<\/li>\n<li>\u8d44\u91d1\u5206\u4f4d flow_pct&#xff08;\u81ea\u7814&#xff09;&#xff1a;(N &#8211; flow_rank) \/ (N &#8211; 1) * 100&#xff0c;\u53d6\u503c 0~100&#xff0c;\u628a\u6392\u540d\u5f52\u4e00\u5316\u6210\u53ef\u8de8\u65e5\u671f\u6bd4\u8f83\u7684\u5206\u4f4d\u3002\u6837\u672c\u6570 N &lt;&#061; 1 \u65f6\u65e0\u6cd5\u8ba1\u7b97&#xff0c;\u8fd4\u56de NaN\u3002<\/li>\n<li>Top N \/ Bottom N \u699c\u5355&#xff08;\u81ea\u7814&#xff09;&#xff1a;\u6392\u5e8f\u540e head(TOP_N) \u4e0e tail(BOTTOM_N)&#xff0c;Bottom \u518d iloc[::-1] \u53cd\u8f6c&#xff0c;\u4fdd\u8bc1\u8f93\u51fa\u662f\u4ece\u300c\u6d41\u51fa\u6700\u591a\u300d\u5411\u4e0b\u6392\u5217&#xff0c;\u800c\u4e0d\u662f\u5012\u5e8f\u7684\u5c3e\u90e8\u3002<\/li>\n<li>\u6da8\u8dcc\u5e45\u6392\u540d price_rank \u4e0e\u4ef7\u683c\u5206\u4f4d price_pct&#xff08;\u81ea\u7814&#xff09;&#xff1a;\u4e0e\u8d44\u91d1\u6392\u540d\u540c\u6784&#xff0c;\u4f46\u6309 zdf \u964d\u5e8f\u3002\u6709\u4e86\u300c\u8d44\u91d1\u5206\u4f4d\u300d\u4e0e\u300c\u4ef7\u683c\u5206\u4f4d\u300d\u4e24\u5957\u5750\u6807&#xff0c;\u624d\u80fd\u6bd4\u8f83\u94b1\u7684\u4f4d\u7f6e\u4e0e\u4ef7\u7684\u4f4d\u7f6e\u662f\u5426\u5339\u914d\u3002<\/li>\n<li>\u8f6e\u52a8\u7c7b\u578b rotation_type&#xff08;\u81ea\u7814&#xff0c;\u56db\u8c61\u9650\u6253\u6807&#xff09;&#xff1a;\u8fd9\u662f\u300c\u8f6e\u52a8\u5f3a\u5ea6\u300d\u7684\u6838\u5fc3\u3002\u4ee5 zdf&#xff08;\u4ef7\u683c\u65b9\u5411&#xff09;\u4e0e jlr&#xff08;\u8d44\u91d1\u65b9\u5411&#xff09;\u6784\u9020\u56db\u8c61\u9650&#xff1a;zdf &gt; 0 \u4e14 jlr &gt; 0 \u2192 \u300c\u91cf\u4ef7\u9f50\u5347\u300d&#xff1b;zdf &lt;&#061; 0 \u4e14 jlr &gt; 0 \u2192 \u300c\u9006\u52bf\u5438\u7b79\u300d&#xff1b;zdf &gt; 0 \u4e14 jlr &lt;&#061; 0 \u2192 \u300c\u4ef7\u5347\u91cf\u51fa\u300d&#xff1b;zdf &lt;&#061; 0 \u4e14 jlr &lt;&#061; 0 \u2192 \u300c\u91cf\u4ef7\u9f50\u8dcc\u300d\u3002\u4e24\u8005\u4efb\u4e00\u4e3a 0 \u6216\u7f3a\u5931\u65f6\u8bb0\u300c\u65e0\u53ef\u5224\u5b9a\u300d&#xff0c;\u4e0d\u786c\u585e\u8fdb\u8c61\u9650\u3002<\/li>\n<li>\u8d44\u91d1\u9886\u5148\u5ea6 lead_score&#xff08;\u81ea\u7814&#xff09;&#xff1a;flow_pct &#8211; price_pct&#xff0c;\u53d6\u503c -100~100\u3002\u663e\u8457\u4e3a\u6b63 &#061; \u8d44\u91d1\u5206\u4f4d\u8fdc\u9ad8\u4e8e\u4ef7\u683c\u5206\u4f4d &#061; \u94b1\u5df2\u7ecf\u8fdb\u53bb\u4e86\u3001\u4ef7\u683c\u8fd8\u6ca1\u8ddf\u4e0a&#xff0c;\u662f\u8f6e\u52a8\u7684\u65e9\u671f\u7279\u5f81&#xff1b;\u663e\u8457\u4e3a\u8d1f &#061; \u4ef7\u683c\u5df2\u5728\u9ad8\u4f4d\u4f46\u8d44\u91d1\u5206\u4f4d\u9760\u540e&#xff0c;\u662f\u8f6e\u52a8\u7684\u672b\u671f\u7279\u5f81\u3002\u5b83\u56de\u7b54\u7684\u662f\u300c\u8d44\u91d1\u6bd4\u4ef7\u683c\u9886\u5148\u591a\u5c11\u300d&#xff0c;\u4e0e\u56db\u8c61\u9650\u6807\u7b7e\u4e92\u8865\u3002<\/li>\n<li>\u591a\u5468\u671f\u5171\u632f\u8ba1\u6570 resonance_cnt&#xff08;\u81ea\u7814&#xff09;&#xff1a;\u53d6\u540c\u4e00\u884c\u4e1a\u7684 net3\u3001net5\u3001net10&#xff0c;\u7edf\u8ba1\u5176\u4e2d\u7b26\u53f7\u76f8\u540c\u7684\u6700\u5927\u4e2a\u6570&#xff08;\u6b63\u6570\u4e2a\u6570\u4e0e\u8d1f\u6570\u4e2a\u6570\u53d6\u8f83\u5927\u8005&#xff09;&#xff0c;\u53d6\u503c 1~3\u3002\u4e09\u4e2a\u5468\u671f\u4e2d\u4efb\u4e00\u7f3a\u5931\u65f6\u8fd4\u56de None&#xff0c;\u4e0d\u505a\u90e8\u5206\u5224\u5b9a\u3002<\/li>\n<li>\u591a\u5468\u671f\u5171\u632f\u6807\u8bb0 resonance_flag&#xff08;\u81ea\u7814&#xff09;&#xff1a;resonance_cnt &#061;&#061; 3 \u65f6&#xff0c;\u82e5\u4e09\u4e2a\u51c0\u6d41\u989d\u5168\u4e3a\u6b63\u8bb0 1&#xff08;\u8d44\u91d1\u5171\u632f\u6d41\u5165&#xff09;&#xff0c;\u5168\u4e3a\u8d1f\u8bb0 -1&#xff08;\u8d44\u91d1\u5171\u632f\u6d41\u51fa&#xff09;&#xff1b;\u672a\u8fbe\u4e09\u6761\u540c\u53f7\u8bb0 0&#xff1b;\u6570\u636e\u7f3a\u5931\u8bb0 None\u3002\u77ed\u3001\u4e2d\u3001\u957f\u4e09\u4e2a\u5468\u671f\u540c\u5411&#xff0c;\u8bf4\u660e\u8d44\u91d1\u884c\u4e3a\u4e0d\u662f\u5355\u65e5\u8109\u51b2&#xff0c;\u800c\u662f\u6301\u7eed\u6027\u7684\u3002<\/li>\n<li>\u51c0\u6d41\u7387\u4e0e\u6da8\u8dcc\u5e45\u80cc\u79bb diverge_10&#xff08;\u81ea\u7814&#xff09;&#xff1a;ra10 * ac10 &lt; 0 \u65f6\u8bb0 1&#xff0c;\u8868\u793a\u8fd1 10 \u65e5\u300c\u8d44\u91d1\u51c0\u6d41\u7387\u65b9\u5411\u300d\u4e0e\u300c\u6da8\u8dcc\u5e45\u65b9\u5411\u300d\u76f8\u53cd\u2014\u2014\u8d44\u91d1\u5728\u6d41\u5165\u4f46\u4ef7\u683c\u5728\u8dcc&#xff0c;\u6216\u8d44\u91d1\u5728\u6d41\u51fa\u4f46\u4ef7\u683c\u5728\u6da8&#xff0c;\u4e24\u8005\u5fc5\u6709\u4e00\u4e2a\u4e0d\u53ef\u6301\u7eed\u3002\u540c\u53f7\u8bb0 0&#xff1b;ra10 \u6216 ac10 \u7f3a\u5931\u8bb0 None&#xff1b;\u4efb\u4e00\u6070\u4e3a 0 \u65f6\u540c\u6837\u8bb0 0&#xff0c;\u907f\u514d\u628a\u96f6\u503c\u8bef\u5224\u4e3a\u300c\u76f8\u53cd\u300d\u3002<\/li>\n<li>\u4ee3\u7801\u5f52\u4e00\u5316 normalize_code()&#xff08;\u81ea\u7814\u5de5\u5177&#xff09;&#xff1a;\u9f99\u5934\u80a1\u4ee3\u7801 lzgdm \u4e0e\u4e2a\u80a1\u699c dm \u53ef\u80fd\u4e00\u4e2a\u5e26\u4ea4\u6613\u6240\u540e\u7f00\u3001\u4e00\u4e2a\u4e0d\u5e26\u3002\u7edf\u4e00 split(&#034;.&#034;)[0] \u53bb\u6389\u540e\u7f00&#xff0c;\u518d\u7528\u7cfb\u5217\u5de5\u5177\u51fd\u6570 with_exchange_suffix() \u6309\u4ee3\u7801\u524d\u7f00\u8865\u56de&#xff0c;\u4e24\u4fa7\u90fd\u5f52\u4e00\u5316\u540e\u518d\u6bd4\u5bf9&#xff0c;\u907f\u514d\u300c600519\u300d\u4e0e\u300c600519.SH\u300d\u5339\u914d\u4e0d\u4e0a\u3002<\/li>\n<li>\u9f99\u5934\u80a1\u4e8c\u6b21\u9a8c\u8bc1 leader_verified&#xff08;\u81ea\u7814&#xff09;&#xff1a;\u677f\u5757\u63a5\u53e3\u8bf4\u5b83\u662f\u9f99\u5934&#xff0c;\u4e2a\u80a1\u51c0\u6d41\u5165\u699c\u91cc\u80fd\u4e0d\u80fd\u627e\u5230\u5b83&#xff1f;\u627e\u5f97\u5230\u8bb0 1&#xff0c;\u627e\u4e0d\u5230\u8bb0 0&#xff0c;\u9f99\u5934\u80a1\u4ee3\u7801\u7f3a\u5931\u8bb0 None\u3002\u63a5\u53e3\u7ed9\u7684\u9f99\u5934\u662f\u4e00\u56de\u4e8b&#xff0c;\u771f\u91d1\u767d\u94f6\u7684\u51c0\u6d41\u5165\u699c\u8ba4\u4e0d\u8ba4\u662f\u53e6\u4e00\u56de\u4e8b&#xff0c;\u4e24\u8005\u90fd\u6210\u7acb\u624d\u7b97\u9a8c\u8bc1\u901a\u8fc7\u3002<\/li>\n<li>\u9f99\u5934\u80a1\u699c\u5185\u6392\u540d leader_stock_rank&#xff08;\u81ea\u7814&#xff09;&#xff1a;\u9f99\u5934\u80a1\u5728\u5168\u5e02\u573a\u4e2a\u80a1\u51c0\u6d41\u5165\u699c\u4e2d\u7684\u6392\u540d\u3002\u6392\u540d\u8d8a\u9760\u524d&#xff0c;\u8bf4\u660e\u8d44\u91d1\u5728\u4e2a\u80a1\u5c42\u9762\u4e0e\u677f\u5757\u5c42\u9762\u662f\u540c\u4e00\u6279\u94b1&#xff0c;\u9f99\u5934\u5730\u4f4d\u8d8a\u624e\u5b9e\u3002<\/li>\n<li>\u677f\u5757 \u2192 \u4e2a\u80a1\u7a7f\u900f penetrate_board()&#xff08;\u81ea\u7814&#xff09;&#xff1a;\u5148\u6309 flow_rank \u4e0e rotation_type \u5b9a\u5f3a\u52bf\u677f\u5757&#xff0c;\u518d\u4ee5\u8be5\u677f\u5757\u7684 lzgdm \u4e3a\u951a\u70b9\u5728\u4e2a\u80a1\u699c\u4e2d\u5b9a\u4f4d&#xff0c;\u540c\u65f6\u8f93\u51fa\u5168\u5e02\u573a\u51c0\u6d41\u5165\u699c\u524d PENETRATE_TOP \u53ea\u4f5c\u4e3a\u8d44\u91d1\u5019\u9009\u6c60\u3002\u5fc5\u987b\u8bda\u5b9e\u8bf4\u660e&#xff1a;higg\/jlr \u4e0d\u8fd4\u56de\u4e2a\u80a1\u6240\u5c5e\u884c\u4e1a\u5b57\u6bb5&#xff0c;\u56e0\u6b64\u5019\u9009\u6c60\u4e2a\u80a1\u65e0\u6cd5\u58f0\u79f0\u5f52\u5c5e\u4e8e\u67d0\u4e2a\u677f\u5757&#xff0c;\u7a7f\u900f\u53ea\u80fd\u505a\u5230\u300c\u9f99\u5934\u951a\u70b9 &#043; \u5168\u5e02\u573a\u8d44\u91d1\u5019\u9009\u6c60\u300d\u8fd9\u4e00\u6b65&#xff0c;\u4e2a\u80a1\u7684\u884c\u4e1a\u5f52\u5c5e\u9700\u8981\u81ea\u5efa\u6620\u5c04\u8868\u624d\u80fd\u95ed\u73af\u3002<\/li>\n<li>null \u503c\u9632\u5fa1\u8d2f\u7a7f\u5168\u7a0b&#xff1a;\u4ee5\u4e0a\u6bcf\u4e00\u9879\u5728\u8ba1\u7b97\u524d\u7edf\u4e00 pd.isna \u5224\u7a7a&#xff0c;\u5206\u6bcd&#xff08;\u6837\u672c\u6570 N-1\u3001\u51c0\u6d41\u989d\u96f6\u503c&#xff09;\u5355\u72ec\u5224\u96f6&#xff0c;\u7edd\u4e0d\u8ba9 None \u53c2\u4e0e\u6bd4\u8f83\u4e0e\u56db\u5219\u8fd0\u7b97&#xff1b;\u300c\u6570\u636e\u4e0d\u8db3\u65e0\u6cd5\u5224\u5b9a\u300d\u4e00\u5f8b\u8fd4\u56de None&#xff0c;\u4e0e\u300c\u5df2\u8ba1\u7b97\u4f46\u65e0\u4fe1\u53f7\u300d\u7684 0 \u4e25\u683c\u533a\u5206\u3002<\/li>\n<h3>\u56db\u3001\u6570\u636e\u8868\u8bbe\u8ba1<\/h3>\n<p><span class=\"token comment\">&#8212; \u88681&#xff1a;\u884c\u4e1a\u8d44\u91d1\u6d41&#xff08;\u5bf9\u5e94 hizj\/zjh&#xff0c;\u5168\u5b57\u6bb5\u539f\u6837\u843d\u5e93&#xff09;<\/span><br \/>\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TABLE<\/span> <span class=\"token keyword\">IF<\/span> <span class=\"token operator\">NOT<\/span> <span class=\"token keyword\">EXISTS<\/span> industry_fund <span class=\"token punctuation\">(<\/span><br \/>\n    id <span class=\"token keyword\">INTEGER<\/span> <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span> AUTOINCREMENT<span class=\"token punctuation\">,<\/span><br \/>\n    t <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span> mc <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span> dm <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    ac3 <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> net3 <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> ra3 <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    ac5 <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> net5 <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> ra5 <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    ac10 <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> net10 <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> ra10 <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    collected_at <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token keyword\">UNIQUE<\/span><span class=\"token punctuation\">(<\/span>t<span class=\"token punctuation\">,<\/span> dm<span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u88682&#xff1a;\u884c\u4e1a\u677f\u5757\u4e0e\u9f99\u5934\u80a1&#xff08;\u5bf9\u5e94 hibk\/zjhhy&#xff0c;\u5168\u5b57\u6bb5\u539f\u6837\u843d\u5e93&#xff09;<\/span><br \/>\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TABLE<\/span> <span class=\"token keyword\">IF<\/span> <span class=\"token operator\">NOT<\/span> <span class=\"token keyword\">EXISTS<\/span> industry_board <span class=\"token punctuation\">(<\/span><br \/>\n    id <span class=\"token keyword\">INTEGER<\/span> <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span> AUTOINCREMENT<span class=\"token punctuation\">,<\/span><br \/>\n    t <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span> mc <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span> dm <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    jj <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> zdf <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    lrzj <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> lczj <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> jlr <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> jlrl <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    lzgmc <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span> lzgdm <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span> lzgjlrl <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    collected_at <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token keyword\">UNIQUE<\/span><span class=\"token punctuation\">(<\/span>t<span class=\"token punctuation\">,<\/span> dm<span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u88683&#xff1a;\u4e2a\u80a1\u51c0\u6d41\u5165&#xff08;\u5bf9\u5e94 higg\/jlr&#xff0c;\u5168\u5b57\u6bb5\u539f\u6837\u843d\u5e93&#xff09;<\/span><br \/>\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TABLE<\/span> <span class=\"token keyword\">IF<\/span> <span class=\"token operator\">NOT<\/span> <span class=\"token keyword\">EXISTS<\/span> stock_netflow <span class=\"token punctuation\">(<\/span><br \/>\n    id <span class=\"token keyword\">INTEGER<\/span> <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span> AUTOINCREMENT<span class=\"token punctuation\">,<\/span><br \/>\n    t <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span> mc <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span> dm <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    zxj <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> zdf <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> hsl <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> cje <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    lczj <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> lrzj <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> jlr <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> jlrl <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    collected_at <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token keyword\">UNIQUE<\/span><span class=\"token punctuation\">(<\/span>t<span class=\"token punctuation\">,<\/span> dm<span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u88684&#xff1a;\u81ea\u7814\u8f6e\u52a8\u4fe1\u53f7&#xff08;\u9664 t\/dm\/mc \u4e0e\u5c11\u91cf\u539f\u503c\u5217\u5916&#xff0c;\u5176\u4f59\u5168\u90e8\u81ea\u7814&#xff09;<\/span><br \/>\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TABLE<\/span> <span class=\"token keyword\">IF<\/span> <span class=\"token operator\">NOT<\/span> <span class=\"token keyword\">EXISTS<\/span> rotation_signal <span class=\"token punctuation\">(<\/span><br \/>\n    id <span class=\"token keyword\">INTEGER<\/span> <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span> AUTOINCREMENT<span class=\"token punctuation\">,<\/span><br \/>\n    t <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span> dm <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span> mc <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    zdf <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> jlr <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> jlrl <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span>                    <span class=\"token comment\">&#8212; \u539f\u503c&#xff0c;\u4fbf\u4e8e\u56de\u770b\u6821\u9a8c<\/span><br \/>\n    ac10 <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> net10 <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> ra10 <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span>                 <span class=\"token comment\">&#8212; \u539f\u503c&#xff0c;\u80cc\u79bb\u5224\u5b9a\u8f93\u5165<\/span><br \/>\n    flow_rank <span class=\"token keyword\">INTEGER<\/span><span class=\"token punctuation\">,<\/span> flow_pct <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span>                 <span class=\"token comment\">&#8212; \u81ea\u7814&#xff1a;\u8d44\u91d1\u6392\u540d\u4e0e\u5206\u4f4d<\/span><br \/>\n    price_rank <span class=\"token keyword\">INTEGER<\/span><span class=\"token punctuation\">,<\/span> price_pct <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span>               <span class=\"token comment\">&#8212; \u81ea\u7814&#xff1a;\u6da8\u8dcc\u5e45\u6392\u540d\u4e0e\u5206\u4f4d<\/span><br \/>\n    rotation_type <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span>                               <span class=\"token comment\">&#8212; \u81ea\u7814&#xff1a;\u91cf\u4ef7\u9f50\u5347\/\u9006\u52bf\u5438\u7b79\/\u4ef7\u5347\u91cf\u51fa\/\u91cf\u4ef7\u9f50\u8dcc<\/span><br \/>\n    lead_score <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span>                                  <span class=\"token comment\">&#8212; \u81ea\u7814&#xff1a;\u8d44\u91d1\u9886\u5148\u5ea6 -100~100<\/span><br \/>\n    resonance_cnt <span class=\"token keyword\">INTEGER<\/span><span class=\"token punctuation\">,<\/span> resonance_flag <span class=\"token keyword\">INTEGER<\/span><span class=\"token punctuation\">,<\/span>    <span class=\"token comment\">&#8212; \u81ea\u7814&#xff1a;\u591a\u5468\u671f\u5171\u632f\u8ba1\u6570\u4e0e\u65b9\u5411<\/span><br \/>\n    diverge_10 <span class=\"token keyword\">INTEGER<\/span><span class=\"token punctuation\">,<\/span>                               <span class=\"token comment\">&#8212; \u81ea\u7814&#xff1a;\u51c0\u6d41\u7387\u4e0e\u6da8\u8dcc\u5e45\u80cc\u79bb<\/span><br \/>\n    lzgdm <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span> lzgmc <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span> lzgjlrl <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span>             <span class=\"token comment\">&#8212; \u539f\u503c&#xff1a;\u677f\u5757\u9f99\u5934\u80a1<\/span><br \/>\n    leader_verified <span class=\"token keyword\">INTEGER<\/span><span class=\"token punctuation\">,<\/span> leader_stock_rank <span class=\"token keyword\">INTEGER<\/span><span class=\"token punctuation\">,<\/span>  <span class=\"token comment\">&#8212; \u81ea\u7814&#xff1a;\u9f99\u5934\u4e8c\u6b21\u9a8c\u8bc1<\/span><br \/>\n    leader_jlr <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span> leader_jlrl <span class=\"token keyword\">REAL<\/span><span class=\"token punctuation\">,<\/span>                <span class=\"token comment\">&#8212; \u81ea\u7814&#xff1a;\u9f99\u5934\u4e2a\u80a1\u51c0\u6d41\u5165<\/span><br \/>\n    collected_at <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token keyword\">UNIQUE<\/span><span class=\"token punctuation\">(<\/span>t<span class=\"token punctuation\">,<\/span> dm<span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u8bf4\u660e&#xff1a;rotation_signal \u4e2d\u9664 t \/ dm \/ mc \/ zdf \/ jlr \/ jlrl \/ ac10 \/ net10 \/ ra10 \/ lzgdm \/ lzgmc \/ lzgjlrl \u5916&#xff0c;\u5176\u4f59\u5217\u5168\u90e8\u662f\u672c\u6587\u81ea\u7814\u884d\u751f\u5217&#xff0c;\u4e0d\u662f\u63a5\u53e3\u5b57\u6bb5&#xff0c;\u5b98\u65b9\u63a5\u53e3\u4e0d\u63d0\u4f9b\u4efb\u4f55\u4e00\u5217\u3002\u524d\u4e09\u5f20\u8868\u662f\u7eaf\u539f\u59cb\u5feb\u7167&#xff0c;\u4fdd\u8bc1\u4efb\u4f55\u65f6\u5019\u90fd\u80fd\u4ece\u88f8\u6570\u636e\u91cd\u7b97\u51fa\u6307\u6807\u3002<\/p>\n<h3>\u4e94\u3001\u5b8c\u6574\u53ef\u8fd0\u884c\u4ee3\u7801<\/h3>\n<p><span class=\"token keyword\">import<\/span> requests<br \/>\n<span class=\"token keyword\">import<\/span> logging<br \/>\n<span class=\"token keyword\">import<\/span> time<br \/>\n<span class=\"token keyword\">import<\/span> sqlite3<br \/>\n<span class=\"token keyword\">from<\/span> datetime <span class=\"token keyword\">import<\/span> datetime<br \/>\n<span class=\"token keyword\">import<\/span> pandas <span class=\"token keyword\">as<\/span> pd<br \/>\n<span class=\"token keyword\">import<\/span> numpy <span class=\"token keyword\">as<\/span> np<\/p>\n<p><span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061; \u5168\u5c40\u914d\u7f6e &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;<\/span><br \/>\nLICENCE <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#034;\u4f60\u7684licence&#034;<\/span><br \/>\nDB_PATH <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#034;quant.db&#034;<\/span><br \/>\nLOG_FILE <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#034;quant_collect.log&#034;<\/span><br \/>\nAPI_BASE <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#034;http:\/\/api.biyingapi.com&#034;<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u5e38\u91cf&#xff1a;\u63a5\u53e3\u8fd4\u56de\u5b57\u6bb5&#xff08;\u4e25\u683c\u5bf9\u7167\u5b98\u65b9\u6587\u6863&#xff0c;\u4e0d\u589e\u4e0d\u51cf&#xff09; &#8212;&#8212;&#8212;-<\/span><br \/>\nFUND_FIELDS <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;mc&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ac3&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;net3&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ra3&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n               <span class=\"token string\">&#034;ac5&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;net5&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ra5&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ac10&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;net10&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ra10&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\nFUND_NUMERIC <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;ac3&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;net3&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ra3&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ac5&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;net5&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ra5&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;ac10&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;net10&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ra10&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\nBOARD_FIELDS <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;mc&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jj&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;zdf&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;lrzj&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;lczj&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlrl&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;lzgmc&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;lzgdm&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;lzgjlrl&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\nBOARD_NUMERIC <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;jj&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;zdf&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;lrzj&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;lczj&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlrl&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;lzgjlrl&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\nSTOCK_FIELDS <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;mc&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;zxj&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;zdf&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;hsl&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;cje&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;lczj&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;lrzj&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlrl&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\nSTOCK_NUMERIC <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;zxj&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;zdf&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;hsl&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;cje&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;lczj&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;lrzj&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlrl&#034;<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u5e38\u91cf&#xff1a;\u81ea\u7814\u6307\u6807\u53c2\u6570 &#8212;&#8212;&#8212;-<\/span><br \/>\nTOP_N <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">5<\/span>              <span class=\"token comment\"># \u8d44\u91d1\u6d41\u5165\u699c Top N<\/span><br \/>\nBOTTOM_N <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">5<\/span>           <span class=\"token comment\"># \u8d44\u91d1\u6d41\u51fa\u699c Bottom N<\/span><br \/>\nPENETRATE_TOP <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">10<\/span>     <span class=\"token comment\"># \u677f\u5757\u7a7f\u900f\u65f6\u7684\u4e2a\u80a1\u5019\u9009\u6c60\u5927\u5c0f<\/span><br \/>\nRESONANCE_PERIODS <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">3<\/span>  <span class=\"token comment\"># \u5171\u632f\u8981\u6c42\u7684\u540c\u53f7\u5468\u671f\u6570&#xff08;net3\/net5\/net10&#xff09;<\/span><br \/>\nFLOW_EPS <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1e-9<\/span>        <span class=\"token comment\"># \u96f6\u503c\u5224\u5b9a\u4e0b\u9650&#xff0c;\u9632\u9664\u96f6\u4e0e\u7b26\u53f7\u8bef\u5224<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u843d\u5e93\u5217 &#8212;&#8212;&#8212;-<\/span><br \/>\nFUND_COLUMNS <span class=\"token operator\">&#061;<\/span> FUND_FIELDS <span class=\"token operator\">&#043;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;collected_at&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\nBOARD_COLUMNS <span class=\"token operator\">&#061;<\/span> BOARD_FIELDS <span class=\"token operator\">&#043;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;collected_at&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\nSTOCK_COLUMNS <span class=\"token operator\">&#061;<\/span> STOCK_FIELDS <span class=\"token operator\">&#043;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;collected_at&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\nSIGNAL_COLUMNS <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><br \/>\n    <span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;mc&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;zdf&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlrl&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ac10&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;net10&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ra10&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;flow_rank&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;flow_pct&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;price_rank&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;price_pct&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;rotation_type&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;lead_score&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;resonance_cnt&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;resonance_flag&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;diverge_10&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;lzgdm&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;lzgmc&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;lzgjlrl&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;leader_verified&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;leader_stock_rank&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;leader_jlr&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;leader_jlrl&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;collected_at&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n<span class=\"token punctuation\">]<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u65e5\u5fd7\u521d\u59cb\u5316 &#8212;&#8212;&#8212;-<\/span><br \/>\nlogging<span class=\"token punctuation\">.<\/span>basicConfig<span class=\"token punctuation\">(<\/span><br \/>\n    filename<span class=\"token operator\">&#061;<\/span>LOG_FILE<span class=\"token punctuation\">,<\/span><br \/>\n    level<span class=\"token operator\">&#061;<\/span>logging<span class=\"token punctuation\">.<\/span>INFO<span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token builtin\">format<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;%(asctime)s %(levelname)s %(message)s&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    datefmt<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;%Y-%m-%d %H:%M:%S&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    filemode<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;a&#034;<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><br \/>\nlogger <span class=\"token operator\">&#061;<\/span> logging<span class=\"token punctuation\">.<\/span>getLogger<span class=\"token punctuation\">(<\/span>__name__<span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u5e26\u91cd\u8bd5 HTTP \u8bf7\u6c42&#xff08;\u590d\u7528&#xff09; &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">biying_api_get_retry<\/span><span class=\"token punctuation\">(<\/span>full_url<span class=\"token punctuation\">,<\/span> timeout<span class=\"token operator\">&#061;<\/span><span class=\"token number\">15<\/span><span class=\"token punctuation\">,<\/span> max_retry<span class=\"token operator\">&#061;<\/span><span class=\"token number\">3<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token keyword\">for<\/span> attempt <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> max_retry <span class=\"token operator\">&#043;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            resp <span class=\"token operator\">&#061;<\/span> requests<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span>full_url<span class=\"token punctuation\">,<\/span> timeout<span class=\"token operator\">&#061;<\/span>timeout<span class=\"token punctuation\">)<\/span><br \/>\n            <span class=\"token keyword\">if<\/span> resp<span class=\"token punctuation\">.<\/span>status_code <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token number\">200<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                <span class=\"token keyword\">return<\/span> resp<span class=\"token punctuation\">.<\/span>json<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            logger<span class=\"token punctuation\">.<\/span>warning<span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;HTTP\u72b6\u6001\u7801\u5f02\u5e38&#xff1a;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>resp<span class=\"token punctuation\">.<\/span>status_code<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#xff0c;\u7b2c<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>attempt<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\u6b21\u91cd\u8bd5&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">except<\/span> Exception <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n            logger<span class=\"token punctuation\">.<\/span>warning<span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u7f51\u7edc\u8bf7\u6c42\u5f02\u5e38&#xff0c;\u7b2c<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>attempt<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\u6b21\u91cd\u8bd5&#xff0c;\u9519\u8bef\u4fe1\u606f&#xff1a;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">str<\/span><span class=\"token punctuation\">(<\/span>e<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        time<span class=\"token punctuation\">.<\/span>sleep<span class=\"token punctuation\">(<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    logger<span class=\"token punctuation\">.<\/span>error<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;\u8fbe\u5230\u6700\u5927\u91cd\u8bd5\u6b21\u6570&#xff0c;\u63a5\u53e3\u8bf7\u6c42\u5931\u8d25&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u4ee3\u7801\u8865\u5e02\u573a\u540e\u7f00 &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">with_exchange_suffix<\/span><span class=\"token punctuation\">(<\/span>code<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    code <span class=\"token operator\">&#061;<\/span> <span class=\"token builtin\">str<\/span><span class=\"token punctuation\">(<\/span>code<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> code<span class=\"token punctuation\">.<\/span>startswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;60&#034;<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">or<\/span> code<span class=\"token punctuation\">.<\/span>startswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;68&#034;<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">or<\/span> code<span class=\"token punctuation\">.<\/span>startswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;9&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> code <span class=\"token operator\">&#043;<\/span> <span class=\"token string\">&#034;.SH&#034;<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> code<span class=\"token punctuation\">.<\/span>startswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;00&#034;<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">or<\/span> code<span class=\"token punctuation\">.<\/span>startswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;30&#034;<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">or<\/span> code<span class=\"token punctuation\">.<\/span>startswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;2&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> code <span class=\"token operator\">&#043;<\/span> <span class=\"token string\">&#034;.SZ&#034;<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> code<span class=\"token punctuation\">.<\/span>startswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;8&#034;<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">or<\/span> code<span class=\"token punctuation\">.<\/span>startswith<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;4&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> code <span class=\"token operator\">&#043;<\/span> <span class=\"token string\">&#034;.BJ&#034;<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> code <span class=\"token operator\">&#043;<\/span> <span class=\"token string\">&#034;.SH&#034;<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u81ea\u7814\u5de5\u5177&#xff1a;\u4ee3\u7801\u5f52\u4e00\u5316&#xff08;\u884c\u4e1a\u4ee3\u7801 \/ \u677f\u5757\u4ee3\u7801 \/ \u80a1\u7968\u4ee3\u7801\u901a\u7528&#xff09; &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">normalize_code<\/span><span class=\"token punctuation\">(<\/span>code<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u53bb\u6389\u53ef\u80fd\u5df2\u6709\u7684\u4ea4\u6613\u6240\u540e\u7f00&#xff0c;\u518d\u7528 with_exchange_suffix \u8865\u9f50&#xff0c;\u4fdd\u8bc1\u4e24\u4fa7\u53ef\u6bd4&#034;&#034;&#034;<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> code <span class=\"token keyword\">is<\/span> <span class=\"token boolean\">None<\/span> <span class=\"token keyword\">or<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token keyword\">not<\/span> <span class=\"token builtin\">isinstance<\/span><span class=\"token punctuation\">(<\/span>code<span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">str<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">and<\/span> pd<span class=\"token punctuation\">.<\/span>isna<span class=\"token punctuation\">(<\/span>code<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">None<\/span><br \/>\n    raw <span class=\"token operator\">&#061;<\/span> <span class=\"token builtin\">str<\/span><span class=\"token punctuation\">(<\/span>code<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>strip<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>split<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;.&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> raw<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">None<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> with_exchange_suffix<span class=\"token punctuation\">(<\/span>raw<span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u6293\u53d6&#xff1a;\u884c\u4e1a\u8d44\u91d1\u6d41 hizj\/zjh &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">fetch_industry_fund<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    url <span class=\"token operator\">&#061;<\/span> <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>API_BASE<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\/hizj\/zjh\/<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>LICENCE<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><br \/>\n    data <span class=\"token operator\">&#061;<\/span> biying_api_get_retry<span class=\"token punctuation\">(<\/span>url<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token builtin\">isinstance<\/span><span class=\"token punctuation\">(<\/span>data<span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">dict<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        data <span class=\"token operator\">&#061;<\/span> data<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;data&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> <span class=\"token builtin\">isinstance<\/span><span class=\"token punctuation\">(<\/span>data<span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">list<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">[<\/span>row <span class=\"token keyword\">for<\/span> row <span class=\"token keyword\">in<\/span> data <span class=\"token keyword\">if<\/span> <span class=\"token builtin\">isinstance<\/span><span class=\"token punctuation\">(<\/span>row<span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">dict<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u6293\u53d6&#xff1a;\u884c\u4e1a\u677f\u5757 hibk\/zjhhy &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">fetch_industry_board<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    url <span class=\"token operator\">&#061;<\/span> <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>API_BASE<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\/hibk\/zjhhy\/<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>LICENCE<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><br \/>\n    data <span class=\"token operator\">&#061;<\/span> biying_api_get_retry<span class=\"token punctuation\">(<\/span>url<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token builtin\">isinstance<\/span><span class=\"token punctuation\">(<\/span>data<span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">dict<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        data <span class=\"token operator\">&#061;<\/span> data<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;data&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> <span class=\"token builtin\">isinstance<\/span><span class=\"token punctuation\">(<\/span>data<span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">list<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">[<\/span>row <span class=\"token keyword\">for<\/span> row <span class=\"token keyword\">in<\/span> data <span class=\"token keyword\">if<\/span> <span class=\"token builtin\">isinstance<\/span><span class=\"token punctuation\">(<\/span>row<span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">dict<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u6293\u53d6&#xff1a;\u4e2a\u80a1\u51c0\u6d41\u5165 higg\/jlr &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">fetch_stock_netflow<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    url <span class=\"token operator\">&#061;<\/span> <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>API_BASE<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\/higg\/jlr\/<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>LICENCE<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><br \/>\n    data <span class=\"token operator\">&#061;<\/span> biying_api_get_retry<span class=\"token punctuation\">(<\/span>url<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token builtin\">isinstance<\/span><span class=\"token punctuation\">(<\/span>data<span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">dict<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        data <span class=\"token operator\">&#061;<\/span> data<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;data&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> <span class=\"token builtin\">isinstance<\/span><span class=\"token punctuation\">(<\/span>data<span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">list<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">[<\/span>row <span class=\"token keyword\">for<\/span> row <span class=\"token keyword\">in<\/span> data <span class=\"token keyword\">if<\/span> <span class=\"token builtin\">isinstance<\/span><span class=\"token punctuation\">(<\/span>row<span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">dict<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- pandas \u6e05\u6d17\u94fe&#xff1a;\u884c\u4e1a\u8d44\u91d1\u6d41 &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">clean_fund_frame<\/span><span class=\"token punctuation\">(<\/span>rows<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    df <span class=\"token operator\">&#061;<\/span> pd<span class=\"token punctuation\">.<\/span>DataFrame<span class=\"token punctuation\">(<\/span>rows<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> df<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> df<br \/>\n    <span class=\"token keyword\">for<\/span> col <span class=\"token keyword\">in<\/span> FUND_FIELDS<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">if<\/span> col <span class=\"token keyword\">not<\/span> <span class=\"token keyword\">in<\/span> df<span class=\"token punctuation\">.<\/span>columns<span class=\"token punctuation\">:<\/span><br \/>\n            df<span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> np<span class=\"token punctuation\">.<\/span>nan<br \/>\n    df <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>reindex<span class=\"token punctuation\">(<\/span>columns<span class=\"token operator\">&#061;<\/span>FUND_FIELDS<span class=\"token punctuation\">)<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>astype<span class=\"token punctuation\">(<\/span><span class=\"token builtin\">str<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>astype<span class=\"token punctuation\">(<\/span><span class=\"token builtin\">str<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">for<\/span> col <span class=\"token keyword\">in<\/span> FUND_NUMERIC<span class=\"token punctuation\">:<\/span><br \/>\n        df<span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> pd<span class=\"token punctuation\">.<\/span>to_numeric<span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> errors<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;coerce&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    df <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>dropna<span class=\"token punctuation\">(<\/span>subset<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    df <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>drop_duplicates<span class=\"token punctuation\">(<\/span>subset<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> keep<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;last&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    df <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>reset_index<span class=\"token punctuation\">(<\/span>drop<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">True<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> df<\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- pandas \u6e05\u6d17\u94fe&#xff1a;\u884c\u4e1a\u677f\u5757 &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">clean_board_frame<\/span><span class=\"token punctuation\">(<\/span>rows<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    df <span class=\"token operator\">&#061;<\/span> pd<span class=\"token punctuation\">.<\/span>DataFrame<span class=\"token punctuation\">(<\/span>rows<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> df<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> df<br \/>\n    <span class=\"token keyword\">for<\/span> col <span class=\"token keyword\">in<\/span> BOARD_FIELDS<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">if<\/span> col <span class=\"token keyword\">not<\/span> <span class=\"token keyword\">in<\/span> df<span class=\"token punctuation\">.<\/span>columns<span class=\"token punctuation\">:<\/span><br \/>\n            df<span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> np<span class=\"token punctuation\">.<\/span>nan<br \/>\n    df <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>reindex<span class=\"token punctuation\">(<\/span>columns<span class=\"token operator\">&#061;<\/span>BOARD_FIELDS<span class=\"token punctuation\">)<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>astype<span class=\"token punctuation\">(<\/span><span class=\"token builtin\">str<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>astype<span class=\"token punctuation\">(<\/span><span class=\"token builtin\">str<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">for<\/span> col <span class=\"token keyword\">in<\/span> BOARD_NUMERIC<span class=\"token punctuation\">:<\/span><br \/>\n        df<span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> pd<span class=\"token punctuation\">.<\/span>to_numeric<span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> errors<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;coerce&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    df <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>dropna<span class=\"token punctuation\">(<\/span>subset<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    df <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>drop_duplicates<span class=\"token punctuation\">(<\/span>subset<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> keep<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;last&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    df <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>reset_index<span class=\"token punctuation\">(<\/span>drop<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">True<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> df<\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- pandas \u6e05\u6d17\u94fe&#xff1a;\u4e2a\u80a1\u51c0\u6d41\u5165 &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">clean_stock_frame<\/span><span class=\"token punctuation\">(<\/span>rows<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    df <span class=\"token operator\">&#061;<\/span> pd<span class=\"token punctuation\">.<\/span>DataFrame<span class=\"token punctuation\">(<\/span>rows<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> df<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> df<br \/>\n    <span class=\"token keyword\">for<\/span> col <span class=\"token keyword\">in<\/span> STOCK_FIELDS<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">if<\/span> col <span class=\"token keyword\">not<\/span> <span class=\"token keyword\">in<\/span> df<span class=\"token punctuation\">.<\/span>columns<span class=\"token punctuation\">:<\/span><br \/>\n            df<span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> np<span class=\"token punctuation\">.<\/span>nan<br \/>\n    df <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>reindex<span class=\"token punctuation\">(<\/span>columns<span class=\"token operator\">&#061;<\/span>STOCK_FIELDS<span class=\"token punctuation\">)<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>astype<span class=\"token punctuation\">(<\/span><span class=\"token builtin\">str<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>astype<span class=\"token punctuation\">(<\/span><span class=\"token builtin\">str<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">for<\/span> col <span class=\"token keyword\">in<\/span> STOCK_NUMERIC<span class=\"token punctuation\">:<\/span><br \/>\n        df<span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> pd<span class=\"token punctuation\">.<\/span>to_numeric<span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> errors<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;coerce&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    df <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>dropna<span class=\"token punctuation\">(<\/span>subset<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    df <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>drop_duplicates<span class=\"token punctuation\">(<\/span>subset<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> keep<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;last&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    df <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>reset_index<span class=\"token punctuation\">(<\/span>drop<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">True<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> df<\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u81ea\u7814\u6307\u6807 1&#xff1a;\u964d\u5e8f\u6392\u540d &#043; \u5206\u4f4d &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">add_rank_columns<\/span><span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">,<\/span> value_col<span class=\"token punctuation\">,<\/span> rank_col<span class=\"token punctuation\">,<\/span> pct_col<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u6392\u540d 1 &#061; \u6700\u5927\u503c&#xff1b;\u5206\u4f4d &#061; (N &#8211; rank) \/ (N &#8211; 1) * 100&#xff0c;\u53d6\u503c 0~100&#034;&#034;&#034;<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> df<span class=\"token punctuation\">.<\/span>empty <span class=\"token keyword\">or<\/span> value_col <span class=\"token keyword\">not<\/span> <span class=\"token keyword\">in<\/span> df<span class=\"token punctuation\">.<\/span>columns<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> df<br \/>\n    valid <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">[<\/span>value_col<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>notna<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    cnt <span class=\"token operator\">&#061;<\/span> <span class=\"token builtin\">int<\/span><span class=\"token punctuation\">(<\/span>valid<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">sum<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span>rank_col<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">[<\/span>value_col<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>rank<span class=\"token punctuation\">(<\/span>ascending<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">False<\/span><span class=\"token punctuation\">,<\/span> method<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;min&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> cnt <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        df<span class=\"token punctuation\">[<\/span>pct_col<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">(<\/span>cnt <span class=\"token operator\">&#8211;<\/span> df<span class=\"token punctuation\">[<\/span>rank_col<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">\/<\/span> <span class=\"token punctuation\">(<\/span>cnt <span class=\"token operator\">&#8211;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">*<\/span> <span class=\"token number\">100<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">round<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        df<span class=\"token punctuation\">[<\/span>pct_col<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> np<span class=\"token punctuation\">.<\/span>nan<br \/>\n    df<span class=\"token punctuation\">.<\/span>loc<span class=\"token punctuation\">[<\/span><span class=\"token operator\">~<\/span>valid<span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">[<\/span>rank_col<span class=\"token punctuation\">,<\/span> pct_col<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> np<span class=\"token punctuation\">.<\/span>nan<br \/>\n    <span class=\"token keyword\">return<\/span> df<\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u81ea\u7814\u6307\u6807 2&#xff1a;Top N \/ Bottom N \u699c\u5355 &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">top_bottom<\/span><span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">,<\/span> value_col<span class=\"token punctuation\">,<\/span> name_col<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;mc&#034;<\/span><span class=\"token punctuation\">,<\/span> top_n<span class=\"token operator\">&#061;<\/span>TOP_N<span class=\"token punctuation\">,<\/span> bottom_n<span class=\"token operator\">&#061;<\/span>BOTTOM_N<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> df<span class=\"token punctuation\">.<\/span>empty <span class=\"token keyword\">or<\/span> value_col <span class=\"token keyword\">not<\/span> <span class=\"token keyword\">in<\/span> df<span class=\"token punctuation\">.<\/span>columns<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> pd<span class=\"token punctuation\">.<\/span>DataFrame<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> pd<span class=\"token punctuation\">.<\/span>DataFrame<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    sub <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>dropna<span class=\"token punctuation\">(<\/span>subset<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span>value_col<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>sort_values<span class=\"token punctuation\">(<\/span>value_col<span class=\"token punctuation\">,<\/span> ascending<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">False<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> sub<span class=\"token punctuation\">.<\/span>head<span class=\"token punctuation\">(<\/span>top_n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> sub<span class=\"token punctuation\">.<\/span>tail<span class=\"token punctuation\">(<\/span>bottom_n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>iloc<span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">:<\/span><span class=\"token punctuation\">:<\/span><span class=\"token operator\">&#8211;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u81ea\u7814\u6307\u6807 3&#xff1a;\u8f6e\u52a8\u7c7b\u578b\u56db\u8c61\u9650\u6253\u6807 &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">label_rotation<\/span><span class=\"token punctuation\">(<\/span>zdf<span class=\"token punctuation\">,<\/span> jlr<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;zdf \u4e0e jlr \u6784\u9020\u56db\u8c61\u9650&#xff1b;\u4efb\u4e00\u4e3a 0 \u6216\u7f3a\u5931\u65f6\u4e0d\u786c\u585e\u8fdb\u8c61\u9650&#034;&#034;&#034;<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> pd<span class=\"token punctuation\">.<\/span>isna<span class=\"token punctuation\">(<\/span>zdf<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">or<\/span> pd<span class=\"token punctuation\">.<\/span>isna<span class=\"token punctuation\">(<\/span>jlr<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">None<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token builtin\">abs<\/span><span class=\"token punctuation\">(<\/span>zdf<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&lt;<\/span> FLOW_EPS <span class=\"token keyword\">or<\/span> <span class=\"token builtin\">abs<\/span><span class=\"token punctuation\">(<\/span>jlr<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&lt;<\/span> FLOW_EPS<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token string\">&#034;\u65e0\u53ef\u5224\u5b9a&#034;<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> zdf <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0<\/span> <span class=\"token keyword\">and<\/span> jlr <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token string\">&#034;\u91cf\u4ef7\u9f50\u5347&#034;<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> zdf <span class=\"token operator\">&lt;&#061;<\/span> <span class=\"token number\">0<\/span> <span class=\"token keyword\">and<\/span> jlr <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token string\">&#034;\u9006\u52bf\u5438\u7b79&#034;<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> zdf <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0<\/span> <span class=\"token keyword\">and<\/span> jlr <span class=\"token operator\">&lt;&#061;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token string\">&#034;\u4ef7\u5347\u91cf\u51fa&#034;<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> <span class=\"token string\">&#034;\u91cf\u4ef7\u9f50\u8dcc&#034;<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u81ea\u7814\u6307\u6807 4&#xff1a;\u591a\u5468\u671f\u8d44\u91d1\u5171\u632f &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">multi_period_resonance<\/span><span class=\"token punctuation\">(<\/span>net3<span class=\"token punctuation\">,<\/span> net5<span class=\"token punctuation\">,<\/span> net10<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;net3\/net5\/net10 \u4e09\u8005\u540c\u53f7 -&gt; \u5171\u632f&#xff1b;\u8fd4\u56de (\u540c\u53f7\u4e2a\u6570, \u65b9\u5411\u6807\u8bb0)&#034;&#034;&#034;<\/span><br \/>\n    vals <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>net3<span class=\"token punctuation\">,<\/span> net5<span class=\"token punctuation\">,<\/span> net10<span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token builtin\">any<\/span><span class=\"token punctuation\">(<\/span>pd<span class=\"token punctuation\">.<\/span>isna<span class=\"token punctuation\">(<\/span>v<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">for<\/span> v <span class=\"token keyword\">in<\/span> vals<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    pos <span class=\"token operator\">&#061;<\/span> <span class=\"token builtin\">sum<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span> <span class=\"token keyword\">for<\/span> v <span class=\"token keyword\">in<\/span> vals <span class=\"token keyword\">if<\/span> v <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    neg <span class=\"token operator\">&#061;<\/span> <span class=\"token builtin\">sum<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span> <span class=\"token keyword\">for<\/span> v <span class=\"token keyword\">in<\/span> vals <span class=\"token keyword\">if<\/span> v <span class=\"token operator\">&lt;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    cnt <span class=\"token operator\">&#061;<\/span> <span class=\"token builtin\">max<\/span><span class=\"token punctuation\">(<\/span>pos<span class=\"token punctuation\">,<\/span> neg<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> cnt <span class=\"token operator\">&#061;&#061;<\/span> RESONANCE_PERIODS<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">(<\/span>cnt<span class=\"token punctuation\">,<\/span> <span class=\"token number\">1<\/span> <span class=\"token keyword\">if<\/span> pos <span class=\"token operator\">&#061;&#061;<\/span> RESONANCE_PERIODS <span class=\"token keyword\">else<\/span> <span class=\"token operator\">&#8211;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">(<\/span>cnt<span class=\"token punctuation\">,<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u81ea\u7814\u6307\u6807 5&#xff1a;\u51c0\u6d41\u7387\u4e0e\u6da8\u8dcc\u5e45\u80cc\u79bb &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">calc_divergence<\/span><span class=\"token punctuation\">(<\/span>ra10<span class=\"token punctuation\">,<\/span> ac10<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;ra10 \u4e0e ac10 \u7b26\u53f7\u76f8\u53cd\u8bb0 1&#xff0c;\u540c\u53f7\u8bb0 0&#xff0c;\u7f3a\u5931\u8bb0 None&#034;&#034;&#034;<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> pd<span class=\"token punctuation\">.<\/span>isna<span class=\"token punctuation\">(<\/span>ra10<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">or<\/span> pd<span class=\"token punctuation\">.<\/span>isna<span class=\"token punctuation\">(<\/span>ac10<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">None<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token builtin\">abs<\/span><span class=\"token punctuation\">(<\/span>ra10<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&lt;<\/span> FLOW_EPS <span class=\"token keyword\">or<\/span> <span class=\"token builtin\">abs<\/span><span class=\"token punctuation\">(<\/span>ac10<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&lt;<\/span> FLOW_EPS<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token number\">0<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> <span class=\"token number\">1<\/span> <span class=\"token keyword\">if<\/span> ra10 <span class=\"token operator\">*<\/span> ac10 <span class=\"token operator\">&lt;<\/span> <span class=\"token number\">0<\/span> <span class=\"token keyword\">else<\/span> <span class=\"token number\">0<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u81ea\u7814\u6307\u6807 6&#xff1a;\u9f99\u5934\u80a1\u4e8c\u6b21\u9a8c\u8bc1 &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">match_leader<\/span><span class=\"token punctuation\">(<\/span>lzgdm<span class=\"token punctuation\">,<\/span> stock_df<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u677f\u5757\u63a5\u53e3\u8ba4\u5b9a\u7684\u9f99\u5934&#xff0c;\u4e2a\u80a1\u51c0\u6d41\u5165\u699c\u91cc\u8ba4\u4e0d\u8ba4&#xff1f;<br \/>\n    \u8fd4\u56de (\u662f\u5426\u547d\u4e2d, \u4e2a\u80a1\u699c\u6392\u540d, jlr, jlrl)&#xff1b;\u4ee3\u7801\u7f3a\u5931\u8fd4\u56de\u5168 None\u3002<br \/>\n    &#034;&#034;&#034;<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> stock_df <span class=\"token keyword\">is<\/span> <span class=\"token boolean\">None<\/span> <span class=\"token keyword\">or<\/span> stock_df<span class=\"token punctuation\">.<\/span>empty <span class=\"token keyword\">or<\/span> <span class=\"token string\">&#034;dm&#034;<\/span> <span class=\"token keyword\">not<\/span> <span class=\"token keyword\">in<\/span> stock_df<span class=\"token punctuation\">.<\/span>columns<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    target <span class=\"token operator\">&#061;<\/span> normalize_code<span class=\"token punctuation\">(<\/span>lzgdm<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> target <span class=\"token keyword\">is<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    codes <span class=\"token operator\">&#061;<\/span> stock_df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">map<\/span><span class=\"token punctuation\">(<\/span>normalize_code<span class=\"token punctuation\">)<\/span><br \/>\n    hit <span class=\"token operator\">&#061;<\/span> stock_df<span class=\"token punctuation\">[<\/span>codes <span class=\"token operator\">&#061;&#061;<\/span> target<span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> hit<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    row <span class=\"token operator\">&#061;<\/span> hit<span class=\"token punctuation\">.<\/span>iloc<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> row<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;stock_rank&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> row<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> row<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;jlrl&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u81ea\u7814\u6307\u6807 7&#xff1a;\u677f\u5757 -&gt; \u4e2a\u80a1\u7a7f\u900f &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">penetrate_board<\/span><span class=\"token punctuation\">(<\/span>board_row<span class=\"token punctuation\">,<\/span> stock_df<span class=\"token punctuation\">,<\/span> top_n<span class=\"token operator\">&#061;<\/span>PENETRATE_TOP<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u4ee5\u677f\u5757\u9f99\u5934\u80a1 lzgdm \u4e3a\u951a\u70b9\u7a7f\u900f\u5230\u4e2a\u80a1&#xff0c;\u5e76\u8f93\u51fa\u5168\u5e02\u573a\u51c0\u6d41\u5165\u5019\u9009\u6c60\u3002<br \/>\n    \u6ce8\u610f&#xff1a;higg\/jlr \u4e0d\u8fd4\u56de\u4e2a\u80a1\u6240\u5c5e\u884c\u4e1a&#xff0c;\u5019\u9009\u6c60\u4e2a\u80a1\u65e0\u6cd5\u58f0\u79f0\u5f52\u5c5e\u8be5\u677f\u5757\u3002<br \/>\n    &#034;&#034;&#034;<\/span><br \/>\n    info <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n        <span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">:<\/span> board_row<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#034;mc&#034;<\/span><span class=\"token punctuation\">:<\/span> board_row<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;mc&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#034;lzgmc&#034;<\/span><span class=\"token punctuation\">:<\/span> board_row<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;lzgmc&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#034;lzgdm&#034;<\/span><span class=\"token punctuation\">:<\/span> board_row<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;lzgdm&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#034;leader_verified&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#034;leader_stock_rank&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#034;leader_jlr&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#034;leader_jlrl&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#034;candidates&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token punctuation\">}<\/span><br \/>\n    verified<span class=\"token punctuation\">,<\/span> rank<span class=\"token punctuation\">,<\/span> jlr<span class=\"token punctuation\">,<\/span> jlrl <span class=\"token operator\">&#061;<\/span> match_leader<span class=\"token punctuation\">(<\/span>board_row<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;lzgdm&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> stock_df<span class=\"token punctuation\">)<\/span><br \/>\n    info<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;leader_verified&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> verified<br \/>\n    info<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;leader_stock_rank&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> rank<br \/>\n    info<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;leader_jlr&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> jlr<br \/>\n    info<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;leader_jlrl&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> jlrl<br \/>\n    <span class=\"token keyword\">if<\/span> stock_df <span class=\"token keyword\">is<\/span> <span class=\"token boolean\">None<\/span> <span class=\"token keyword\">or<\/span> stock_df<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> info<br \/>\n    pool <span class=\"token operator\">&#061;<\/span> stock_df<span class=\"token punctuation\">.<\/span>dropna<span class=\"token punctuation\">(<\/span>subset<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>sort_values<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">,<\/span> ascending<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">False<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    cols <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>c <span class=\"token keyword\">for<\/span> c <span class=\"token keyword\">in<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;mc&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;zxj&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;zdf&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlrl&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;stock_rank&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n            <span class=\"token keyword\">if<\/span> c <span class=\"token keyword\">in<\/span> pool<span class=\"token punctuation\">.<\/span>columns<span class=\"token punctuation\">]<\/span><br \/>\n    info<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;candidates&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> pool<span class=\"token punctuation\">.<\/span>head<span class=\"token punctuation\">(<\/span>top_n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">[<\/span>cols<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>to_dict<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;records&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> info<\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u6c47\u603b&#xff1a;\u751f\u6210\u81ea\u7814\u8f6e\u52a8\u4fe1\u53f7\u8868 &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">build_rotation_frame<\/span><span class=\"token punctuation\">(<\/span>board_df<span class=\"token punctuation\">,<\/span> fund_df<span class=\"token punctuation\">,<\/span> stock_df<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> board_df<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> pd<span class=\"token punctuation\">.<\/span>DataFrame<span class=\"token punctuation\">(<\/span>columns<span class=\"token operator\">&#061;<\/span>SIGNAL_COLUMNS<span class=\"token punctuation\">)<\/span><br \/>\n    df <span class=\"token operator\">&#061;<\/span> board_df<span class=\"token punctuation\">.<\/span>copy<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    fund_part <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ac3&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;net3&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ra3&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ac5&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;net5&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ra5&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                 <span class=\"token string\">&#034;ac10&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;net10&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ra10&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> fund_df<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n        df <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>merge<span class=\"token punctuation\">(<\/span>fund_df<span class=\"token punctuation\">[<\/span>fund_part<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> on<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;t&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;dm&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> how<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;left&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">for<\/span> col <span class=\"token keyword\">in<\/span> fund_part<span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">if<\/span> col <span class=\"token keyword\">not<\/span> <span class=\"token keyword\">in<\/span> df<span class=\"token punctuation\">.<\/span>columns<span class=\"token punctuation\">:<\/span><br \/>\n                df<span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> np<span class=\"token punctuation\">.<\/span>nan<\/p>\n<p>    df <span class=\"token operator\">&#061;<\/span> add_rank_columns<span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;flow_rank&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;flow_pct&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    df <span class=\"token operator\">&#061;<\/span> add_rank_columns<span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;zdf&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;price_rank&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;price_pct&#034;<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;rotation_type&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>label_rotation<span class=\"token punctuation\">(<\/span>z<span class=\"token punctuation\">,<\/span> j<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">for<\/span> z<span class=\"token punctuation\">,<\/span> j <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">zip<\/span><span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;zdf&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;lead_score&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;flow_pct&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#8211;<\/span> df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;price_pct&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">round<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    res <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>multi_period_resonance<span class=\"token punctuation\">(<\/span>a<span class=\"token punctuation\">,<\/span> b<span class=\"token punctuation\">,<\/span> c<span class=\"token punctuation\">)<\/span><br \/>\n           <span class=\"token keyword\">for<\/span> a<span class=\"token punctuation\">,<\/span> b<span class=\"token punctuation\">,<\/span> c <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">zip<\/span><span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;net3&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;net5&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;net10&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;resonance_cnt&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>r<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">for<\/span> r <span class=\"token keyword\">in<\/span> res<span class=\"token punctuation\">]<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;resonance_flag&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>r<span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">for<\/span> r <span class=\"token keyword\">in<\/span> res<span class=\"token punctuation\">]<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;diverge_10&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>calc_divergence<span class=\"token punctuation\">(<\/span>r<span class=\"token punctuation\">,<\/span> a<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">for<\/span> r<span class=\"token punctuation\">,<\/span> a <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">zip<\/span><span class=\"token punctuation\">(<\/span>df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;ra10&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;ac10&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p>    lead <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>match_leader<span class=\"token punctuation\">(<\/span>d<span class=\"token punctuation\">,<\/span> stock_df<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">for<\/span> d <span class=\"token keyword\">in<\/span> df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;lzgdm&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;leader_verified&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>x<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">for<\/span> x <span class=\"token keyword\">in<\/span> lead<span class=\"token punctuation\">]<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;leader_stock_rank&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>x<span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">for<\/span> x <span class=\"token keyword\">in<\/span> lead<span class=\"token punctuation\">]<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;leader_jlr&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>x<span class=\"token punctuation\">[<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">for<\/span> x <span class=\"token keyword\">in<\/span> lead<span class=\"token punctuation\">]<\/span><br \/>\n    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;leader_jlrl&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>x<span class=\"token punctuation\">[<\/span><span class=\"token number\">3<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">for<\/span> x <span class=\"token keyword\">in<\/span> lead<span class=\"token punctuation\">]<\/span><\/p>\n<p>    df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;collected_at&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> datetime<span class=\"token punctuation\">.<\/span>now<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>strftime<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;%Y-%m-%d %H:%M:%S&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> df<span class=\"token punctuation\">.<\/span>reindex<span class=\"token punctuation\">(<\/span>columns<span class=\"token operator\">&#061;<\/span>SIGNAL_COLUMNS<span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u5efa\u8868 &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">init_db<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    conn <span class=\"token operator\">&#061;<\/span> sqlite3<span class=\"token punctuation\">.<\/span>connect<span class=\"token punctuation\">(<\/span>DB_PATH<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        conn<span class=\"token punctuation\">.<\/span>execute<span class=\"token punctuation\">(<\/span><span class=\"token triple-quoted-string string\">&#034;&#034;&#034;<br \/>\n            CREATE TABLE IF NOT EXISTS industry_fund (<br \/>\n                id INTEGER PRIMARY KEY AUTOINCREMENT,<br \/>\n                t TEXT, mc TEXT, dm TEXT,<br \/>\n                ac3 REAL, net3 REAL, ra3 REAL,<br \/>\n                ac5 REAL, net5 REAL, ra5 REAL,<br \/>\n                ac10 REAL, net10 REAL, ra10 REAL,<br \/>\n                collected_at TEXT,<br \/>\n                UNIQUE(t, dm)<br \/>\n            )<br \/>\n        &#034;&#034;&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        conn<span class=\"token punctuation\">.<\/span>execute<span class=\"token punctuation\">(<\/span><span class=\"token triple-quoted-string string\">&#034;&#034;&#034;<br \/>\n            CREATE TABLE IF NOT EXISTS industry_board (<br \/>\n                id INTEGER PRIMARY KEY AUTOINCREMENT,<br \/>\n                t TEXT, mc TEXT, dm TEXT,<br \/>\n                jj REAL, zdf REAL,<br \/>\n                lrzj REAL, lczj REAL, jlr REAL, jlrl REAL,<br \/>\n                lzgmc TEXT, lzgdm TEXT, lzgjlrl REAL,<br \/>\n                collected_at TEXT,<br \/>\n                UNIQUE(t, dm)<br \/>\n            )<br \/>\n        &#034;&#034;&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        conn<span class=\"token punctuation\">.<\/span>execute<span class=\"token punctuation\">(<\/span><span class=\"token triple-quoted-string string\">&#034;&#034;&#034;<br \/>\n            CREATE TABLE IF NOT EXISTS stock_netflow (<br \/>\n                id INTEGER PRIMARY KEY AUTOINCREMENT,<br \/>\n                t TEXT, mc TEXT, dm TEXT,<br \/>\n                zxj REAL, zdf REAL, hsl REAL, cje REAL,<br \/>\n                lczj REAL, lrzj REAL, jlr REAL, jlrl REAL,<br \/>\n                collected_at TEXT,<br \/>\n                UNIQUE(t, dm)<br \/>\n            )<br \/>\n        &#034;&#034;&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        conn<span class=\"token punctuation\">.<\/span>execute<span class=\"token punctuation\">(<\/span><span class=\"token triple-quoted-string string\">&#034;&#034;&#034;<br \/>\n            CREATE TABLE IF NOT EXISTS rotation_signal (<br \/>\n                id INTEGER PRIMARY KEY AUTOINCREMENT,<br \/>\n                t TEXT, dm TEXT, mc TEXT,<br \/>\n                zdf REAL, jlr REAL, jlrl REAL,<br \/>\n                ac10 REAL, net10 REAL, ra10 REAL,<br \/>\n                flow_rank INTEGER, flow_pct REAL,<br \/>\n                price_rank INTEGER, price_pct REAL,<br \/>\n                rotation_type TEXT,<br \/>\n                lead_score REAL,<br \/>\n                resonance_cnt INTEGER, resonance_flag INTEGER,<br \/>\n                diverge_10 INTEGER,<br \/>\n                lzgdm TEXT, lzgmc TEXT, lzgjlrl REAL,<br \/>\n                leader_verified INTEGER, leader_stock_rank INTEGER,<br \/>\n                leader_jlr REAL, leader_jlrl REAL,<br \/>\n                collected_at TEXT,<br \/>\n                UNIQUE(t, dm)<br \/>\n            )<br \/>\n        &#034;&#034;&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        conn<span class=\"token punctuation\">.<\/span>commit<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">finally<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        conn<span class=\"token punctuation\">.<\/span>close<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u843d\u5e93&#xff08;INSERT OR REPLACE \u5e42\u7b49\u5199\u5165&#xff09; &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">save_frame<\/span><span class=\"token punctuation\">(<\/span>table<span class=\"token punctuation\">,<\/span> columns<span class=\"token punctuation\">,<\/span> df<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> df <span class=\"token keyword\">is<\/span> <span class=\"token boolean\">None<\/span> <span class=\"token keyword\">or<\/span> df<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">return<\/span><br \/>\n    conn <span class=\"token operator\">&#061;<\/span> sqlite3<span class=\"token punctuation\">.<\/span>connect<span class=\"token punctuation\">(<\/span>DB_PATH<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        data <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">.<\/span>copy<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">for<\/span> col <span class=\"token keyword\">in<\/span> columns<span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">if<\/span> col <span class=\"token keyword\">not<\/span> <span class=\"token keyword\">in<\/span> data<span class=\"token punctuation\">.<\/span>columns<span class=\"token punctuation\">:<\/span><br \/>\n                data<span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> np<span class=\"token punctuation\">.<\/span>nan<br \/>\n        data <span class=\"token operator\">&#061;<\/span> data<span class=\"token punctuation\">[<\/span>columns<span class=\"token punctuation\">]<\/span><br \/>\n        data<span class=\"token punctuation\">.<\/span>to_sql<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;tmp_frame&#034;<\/span><span class=\"token punctuation\">,<\/span> conn<span class=\"token punctuation\">,<\/span> if_exists<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;replace&#034;<\/span><span class=\"token punctuation\">,<\/span> index<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">False<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        cols <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#034;, &#034;<\/span><span class=\"token punctuation\">.<\/span>join<span class=\"token punctuation\">(<\/span>columns<span class=\"token punctuation\">)<\/span><br \/>\n        conn<span class=\"token punctuation\">.<\/span>execute<span class=\"token punctuation\">(<\/span><br \/>\n            <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;INSERT OR REPLACE INTO <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>table<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> (<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>cols<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">) SELECT <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>cols<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> FROM tmp_frame&#034;<\/span><\/span><br \/>\n        <span class=\"token punctuation\">)<\/span><br \/>\n        conn<span class=\"token punctuation\">.<\/span>execute<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;DROP TABLE IF EXISTS tmp_frame&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        conn<span class=\"token punctuation\">.<\/span>commit<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        logger<span class=\"token punctuation\">.<\/span>info<span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u843d\u5e93 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>table<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u5171 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>data<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u6761&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">except<\/span> Exception <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span><br \/>\n        logger<span class=\"token punctuation\">.<\/span>error<span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u843d\u5e93 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>table<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u5931\u8d25&#xff1a;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">str<\/span><span class=\"token punctuation\">(<\/span>e<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">finally<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        conn<span class=\"token punctuation\">.<\/span>close<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u6253\u5370\u8f85\u52a9&#xff1a;\u699c\u5355 &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">print_board<\/span><span class=\"token punctuation\">(<\/span>title<span class=\"token punctuation\">,<\/span> frame<span class=\"token punctuation\">,<\/span> value_col<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\\\\n&#8212; <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>title<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> &#8212;&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> frame<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;&#xff08;\u65e0\u6709\u6548\u6570\u636e&#xff09;&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">return<\/span><br \/>\n    <span class=\"token keyword\">for<\/span> _<span class=\"token punctuation\">,<\/span> r <span class=\"token keyword\">in<\/span> frame<span class=\"token punctuation\">.<\/span>iterrows<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;mc&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | \u4ee3\u7801 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;dm&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>value_col<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span>value_col<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> &#034;<\/span><\/span><br \/>\n              <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;| \u6da8\u8dcc\u5e45 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;zdf&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | \u51c0\u6d41\u5165 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;jlr&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | \u51c0\u6d41\u5165\u7387 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;jlrl&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token comment\"># &#8212;&#8212;&#8212;- \u6f14\u793a\u5165\u53e3 &#8212;&#8212;&#8212;-<\/span><br \/>\n<span class=\"token keyword\">def<\/span> <span class=\"token function\">demo<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    init_db<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    fund_df <span class=\"token operator\">&#061;<\/span> clean_fund_frame<span class=\"token punctuation\">(<\/span>fetch_industry_fund<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    board_df <span class=\"token operator\">&#061;<\/span> clean_board_frame<span class=\"token punctuation\">(<\/span>fetch_industry_board<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    stock_df <span class=\"token operator\">&#061;<\/span> clean_stock_frame<span class=\"token punctuation\">(<\/span>fetch_stock_netflow<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u884c\u4e1a\u8d44\u91d1\u6d41 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>fund_df<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u6761 | \u884c\u4e1a\u677f\u5757 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>board_df<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u6761 | \u4e2a\u80a1\u51c0\u6d41\u5165 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>stock_df<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u6761&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token comment\"># \u4e2a\u80a1\u699c&#xff1a;\u5148\u6392\u540d&#xff0c;\u4f9b\u9f99\u5934\u80a1\u4e8c\u6b21\u9a8c\u8bc1\u4f7f\u7528<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> stock_df<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n        stock_df <span class=\"token operator\">&#061;<\/span> add_rank_columns<span class=\"token punctuation\">(<\/span>stock_df<span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;stock_rank&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;stock_pct&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        stock_df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;stock_rank&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> np<span class=\"token punctuation\">.<\/span>nan<br \/>\n        stock_df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;stock_pct&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> np<span class=\"token punctuation\">.<\/span>nan<\/p>\n<p>    <span class=\"token keyword\">if<\/span> fund_df<span class=\"token punctuation\">.<\/span>empty <span class=\"token keyword\">and<\/span> board_df<span class=\"token punctuation\">.<\/span>empty <span class=\"token keyword\">and<\/span> stock_df<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n        logger<span class=\"token punctuation\">.<\/span>error<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;\u4e09\u4e2a\u63a5\u53e3\u5747\u65e0\u6709\u6548\u6570\u636e&#xff0c;\u8bf7\u68c0\u67e5 licence \u4e0e\u7f51\u7edc&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;\u4e09\u4e2a\u63a5\u53e3\u5747\u65e0\u6709\u6548\u6570\u636e&#xff0c;\u8bf7\u68c0\u67e5 licence \u4e0e\u7f51\u7edc&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">return<\/span><\/p>\n<p>    <span class=\"token comment\"># &#8212;&#8212;&#8212;- 1. \u539f\u59cb\u4e09\u8868\u843d\u5e93 &#8212;&#8212;&#8212;-<\/span><br \/>\n    now <span class=\"token operator\">&#061;<\/span> datetime<span class=\"token punctuation\">.<\/span>now<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>strftime<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;%Y-%m-%d %H:%M:%S&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">for<\/span> frame <span class=\"token keyword\">in<\/span> <span class=\"token punctuation\">(<\/span>fund_df<span class=\"token punctuation\">,<\/span> board_df<span class=\"token punctuation\">,<\/span> stock_df<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> frame<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n            frame<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;collected_at&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> now<br \/>\n    save_frame<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;industry_fund&#034;<\/span><span class=\"token punctuation\">,<\/span> FUND_COLUMNS<span class=\"token punctuation\">,<\/span> fund_df<span class=\"token punctuation\">)<\/span><br \/>\n    save_frame<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;industry_board&#034;<\/span><span class=\"token punctuation\">,<\/span> BOARD_COLUMNS<span class=\"token punctuation\">,<\/span> board_df<span class=\"token punctuation\">)<\/span><br \/>\n    save_frame<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;stock_netflow&#034;<\/span><span class=\"token punctuation\">,<\/span> STOCK_COLUMNS<span class=\"token punctuation\">,<\/span> stock_df<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token comment\"># &#8212;&#8212;&#8212;- 2. \u81ea\u7814\u4fe1\u53f7 &#8212;&#8212;&#8212;-<\/span><br \/>\n    signal <span class=\"token operator\">&#061;<\/span> build_rotation_frame<span class=\"token punctuation\">(<\/span>board_df<span class=\"token punctuation\">,<\/span> fund_df<span class=\"token punctuation\">,<\/span> stock_df<span class=\"token punctuation\">)<\/span><br \/>\n    save_frame<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;rotation_signal&#034;<\/span><span class=\"token punctuation\">,<\/span> SIGNAL_COLUMNS<span class=\"token punctuation\">,<\/span> signal<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token comment\"># &#8212;&#8212;&#8212;- 3. \u8d44\u91d1\u6d41\u5411\u6392\u540d &#8212;&#8212;&#8212;-<\/span><br \/>\n    top_df<span class=\"token punctuation\">,<\/span> bottom_df <span class=\"token operator\">&#061;<\/span> top_bottom<span class=\"token punctuation\">(<\/span>signal<span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">,<\/span> top_n<span class=\"token operator\">&#061;<\/span>TOP_N<span class=\"token punctuation\">,<\/span> bottom_n<span class=\"token operator\">&#061;<\/span>BOTTOM_N<span class=\"token punctuation\">)<\/span><br \/>\n    print_board<span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u884c\u4e1a\u677f\u5757\u51c0\u6d41\u5165 Top <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>TOP_N<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">,<\/span> top_df<span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    print_board<span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u884c\u4e1a\u677f\u5757\u51c0\u6d41\u51fa Bottom <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>BOTTOM_N<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">,<\/span> bottom_df<span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;jlr&#034;<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> fund_df<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n        f_top<span class=\"token punctuation\">,<\/span> f_bottom <span class=\"token operator\">&#061;<\/span> top_bottom<span class=\"token punctuation\">(<\/span>fund_df<span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;net10&#034;<\/span><span class=\"token punctuation\">,<\/span> top_n<span class=\"token operator\">&#061;<\/span>TOP_N<span class=\"token punctuation\">,<\/span> bottom_n<span class=\"token operator\">&#061;<\/span>BOTTOM_N<span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\\\\n&#8212; \u884c\u4e1a\u8d44\u91d1\u6d41\u8fd110\u65e5\u51c0\u6d41\u989d Top <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>TOP_N<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> &#8212;&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">for<\/span> _<span class=\"token punctuation\">,<\/span> r <span class=\"token keyword\">in<\/span> f_top<span class=\"token punctuation\">.<\/span>iterrows<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;mc&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | \u4ee3\u7801 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;dm&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | net10 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;net10&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> &#034;<\/span><\/span><br \/>\n                  <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;| ra10 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;ra10&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | ac10 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;ac10&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\\\\n&#8212; \u884c\u4e1a\u8d44\u91d1\u6d41\u8fd110\u65e5\u51c0\u6d41\u989d Bottom <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>BOTTOM_N<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> &#8212;&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">for<\/span> _<span class=\"token punctuation\">,<\/span> r <span class=\"token keyword\">in<\/span> f_bottom<span class=\"token punctuation\">.<\/span>iterrows<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;mc&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | \u4ee3\u7801 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;dm&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | net10 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;net10&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> &#034;<\/span><\/span><br \/>\n                  <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;| ra10 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;ra10&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | ac10 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;ac10&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token comment\"># &#8212;&#8212;&#8212;- 4. \u8f6e\u52a8\u7c7b\u578b\u5206\u5e03 &#8212;&#8212;&#8212;-<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> signal<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;\\\\n&#8212; \u8f6e\u52a8\u7c7b\u578b\u5206\u5e03 &#8212;&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">for<\/span> name<span class=\"token punctuation\">,<\/span> cnt <span class=\"token keyword\">in<\/span> signal<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;rotation_type&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>value_counts<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>items<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>name<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#xff1a;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">int<\/span><span class=\"token punctuation\">(<\/span>cnt<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u4e2a\u677f\u5757&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        strong <span class=\"token operator\">&#061;<\/span> signal<span class=\"token punctuation\">[<\/span>signal<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;rotation_type&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>isin<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;\u91cf\u4ef7\u9f50\u5347&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;\u9006\u52bf\u5438\u7b79&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><br \/>\n        strong <span class=\"token operator\">&#061;<\/span> strong<span class=\"token punctuation\">.<\/span>dropna<span class=\"token punctuation\">(<\/span>subset<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;lead_score&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>sort_values<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;lead_score&#034;<\/span><span class=\"token punctuation\">,<\/span> ascending<span class=\"token operator\">&#061;<\/span><span class=\"token boolean\">False<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\\\\n&#8212; \u5f3a\u52bf\u677f\u5757\u8d44\u91d1\u9886\u5148\u5ea6 Top <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>TOP_N<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#xff08;\u91cf\u4ef7\u9f50\u5347 \/ \u9006\u52bf\u5438\u7b79&#xff09;&#8212;&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">for<\/span> _<span class=\"token punctuation\">,<\/span> r <span class=\"token keyword\">in<\/span> strong<span class=\"token punctuation\">.<\/span>head<span class=\"token punctuation\">(<\/span>TOP_N<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>iterrows<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;mc&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | \u7c7b\u578b <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;rotation_type&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> &#034;<\/span><\/span><br \/>\n                  <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;| \u8d44\u91d1\u5206\u4f4d <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;flow_pct&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | \u4ef7\u683c\u5206\u4f4d <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;price_pct&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> &#034;<\/span><\/span><br \/>\n                  <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;| \u9886\u5148\u5ea6 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;lead_score&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token comment\"># &#8212;&#8212;&#8212;- 5. \u5171\u632f\u4e0e\u80cc\u79bb &#8212;&#8212;&#8212;-<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;\\\\n&#8212; \u591a\u5468\u671f\u8d44\u91d1\u5171\u632f\u4e0e\u80cc\u79bb\u7edf\u8ba1 &#8212;&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u5171\u632f\u6d41\u5165&#xff08;resonance_flag&#061;1&#xff09;&#xff1a;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">int<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">(<\/span>signal<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;resonance_flag&#039;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">sum<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u4e2a\u677f\u5757&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u5171\u632f\u6d41\u51fa&#xff08;resonance_flag&#061;-1&#xff09;&#xff1a;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">int<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">(<\/span>signal<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;resonance_flag&#039;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token operator\">&#8211;<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">sum<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u4e2a\u677f\u5757&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u672a\u5171\u632f&#xff08;resonance_flag&#061;0&#xff09;&#xff1a;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">int<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">(<\/span>signal<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;resonance_flag&#039;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">sum<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u4e2a\u677f\u5757&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u8fd110\u65e5\u51c0\u6d41\u7387\u4e0e\u6da8\u8dcc\u5e45\u80cc\u79bb&#xff1a;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">int<\/span><span class=\"token punctuation\">(<\/span>signal<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;diverge_10&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>fillna<span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">sum<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u4e2a\u677f\u5757&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        res_hit <span class=\"token operator\">&#061;<\/span> signal<span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">(<\/span>signal<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;resonance_flag&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&amp;<\/span> <span class=\"token punctuation\">(<\/span>signal<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;diverge_10&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u65e2\u5171\u632f\u6d41\u5165\u53c8\u80cc\u79bb&#xff08;\u8d44\u91d1\u6301\u7eed\u8fdb\u3001\u4ef7\u683c\u6ca1\u8ddf\u4e0a&#xff09;&#xff1a;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>res_hit<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u4e2a\u677f\u5757&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">for<\/span> _<span class=\"token punctuation\">,<\/span> r <span class=\"token keyword\">in<\/span> res_hit<span class=\"token punctuation\">.<\/span>head<span class=\"token punctuation\">(<\/span>TOP_N<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>iterrows<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;  <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;mc&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | net10 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;net10&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | ra10 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;ra10&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> &#034;<\/span><\/span><br \/>\n                  <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;| ac10 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;ac10&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | \u9886\u5148\u5ea6 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;lead_score&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token comment\"># &#8212;&#8212;&#8212;- 6. \u9f99\u5934\u80a1\u6355\u6349\u4e0e\u677f\u5757\u7a7f\u900f &#8212;&#8212;&#8212;-<\/span><br \/>\n    <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> signal<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n        verified <span class=\"token operator\">&#061;<\/span> signal<span class=\"token punctuation\">[<\/span>signal<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;leader_verified&#034;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span><br \/>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\\\\n&#8212; \u9f99\u5934\u80a1\u4e8c\u6b21\u9a8c\u8bc1&#xff1a;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>verified<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \/ <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>signal<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u4e2a\u677f\u5757\u9f99\u5934\u51fa\u73b0\u5728\u4e2a\u80a1\u51c0\u6d41\u5165\u699c &#8212;&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> verified<span class=\"token punctuation\">.<\/span>empty<span class=\"token punctuation\">:<\/span><br \/>\n            v <span class=\"token operator\">&#061;<\/span> verified<span class=\"token punctuation\">.<\/span>dropna<span class=\"token punctuation\">(<\/span>subset<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;leader_stock_rank&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>sort_values<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;leader_stock_rank&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n            <span class=\"token keyword\">for<\/span> _<span class=\"token punctuation\">,<\/span> r <span class=\"token keyword\">in<\/span> v<span class=\"token punctuation\">.<\/span>head<span class=\"token punctuation\">(<\/span>TOP_N<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>iterrows<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;mc&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> -&gt; <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;lzgmc&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#xff08;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;lzgdm&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#xff09;&#034;<\/span><\/span><br \/>\n                      <span class=\"token string-interpolation\"><span class=\"token string\">f&#034; | \u4e2a\u80a1\u699c\u6392\u540d <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;leader_stock_rank&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> &#034;<\/span><\/span><br \/>\n                      <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;| \u4e2a\u80a1\u51c0\u6d41\u5165 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;leader_jlr&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | \u9f99\u5934\u51c0\u6d41\u5165\u7387 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>r<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;lzgjlrl&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\\\\n&#8212; \u677f\u5757 -&gt; \u4e2a\u80a1\u7a7f\u900f&#xff08;\u53d6\u51c0\u6d41\u5165 Top <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>TOP_N<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u677f\u5757&#xff09;&#8212;&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">for<\/span> _<span class=\"token punctuation\">,<\/span> r <span class=\"token keyword\">in<\/span> top_df<span class=\"token punctuation\">.<\/span>iterrows<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            info <span class=\"token operator\">&#061;<\/span> penetrate_board<span class=\"token punctuation\">(<\/span>r<span class=\"token punctuation\">,<\/span> stock_df<span class=\"token punctuation\">,<\/span> top_n<span class=\"token operator\">&#061;<\/span>PENETRATE_TOP<span class=\"token punctuation\">)<\/span><br \/>\n            <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\\\\n\u3010<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>info<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;mc&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\u3011\u9f99\u5934 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>info<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;lzgmc&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#xff08;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>info<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;lzgdm&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#xff09;&#034;<\/span><\/span><br \/>\n                  <span class=\"token string-interpolation\"><span class=\"token string\">f&#034; \u9a8c\u8bc1 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>info<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;leader_verified&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u4e2a\u80a1\u699c\u6392\u540d <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>info<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;leader_stock_rank&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n            <span class=\"token keyword\">for<\/span> c <span class=\"token keyword\">in<\/span> info<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;candidates&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">3<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">:<\/span><br \/>\n                <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;  \u5019\u9009 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>c<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;mc&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#xff08;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>c<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;dm&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#xff09;| \u6700\u65b0\u4ef7 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>c<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;zxj&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> &#034;<\/span><\/span><br \/>\n                      <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;| \u6da8\u8dcc\u5e45 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>c<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;zdf&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> | \u51c0\u6d41\u5165 <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>c<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;jlr&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n            <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;  &#xff08;\u5019\u9009\u6c60\u6765\u81ea\u5168\u5e02\u573a\u4e2a\u80a1\u51c0\u6d41\u5165\u699c\u524d <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>PENETRATE_TOP<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\"> \u53ea&#xff0c;&#034;<\/span><\/span><br \/>\n                  <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u63a5\u53e3\u4e0d\u8fd4\u56de\u4e2a\u80a1\u6240\u5c5e\u884c\u4e1a&#xff0c;\u4e0d\u505a\u884c\u4e1a\u5f52\u5c5e\u65ad\u8a00&#xff09;&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;\\\\n\u3010\u4ec5\u4e3a\u6570\u636e\u6f14\u793a&#xff0c;\u4e0d\u6784\u6210\u6295\u8d44\u5efa\u8bae\u3011\u5df2\u91c7\u96c6\u5e76\u843d\u5e93\u677f\u5757\u8f6e\u52a8\u6570\u636e&#034;<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token keyword\">if<\/span> __name__ <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token string\">&#034;__main__&#034;<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    demo<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>\u4ee3\u7801\u8fd0\u884c\u540e&#xff0c;\u4f1a\u4f9d\u6b21\u6253\u5370&#xff1a;\u4e09\u4e2a\u63a5\u53e3\u5404\u81ea\u8fd4\u56de\u7684\u6570\u636e\u6761\u6570&#xff1b;\u884c\u4e1a\u677f\u5757\u51c0\u6d41\u5165 Top \/ Bottom \u699c\u5355&#xff08;\u542b\u6da8\u8dcc\u5e45\u3001\u51c0\u6d41\u5165\u3001\u51c0\u6d41\u5165\u7387&#xff09;&#xff1b;\u884c\u4e1a\u8d44\u91d1\u6d41\u8fd1 10 \u65e5\u51c0\u6d41\u989d Top \/ Bottom&#xff08;\u542b ra10 \u4e0e ac10&#xff09;&#xff1b;\u8f6e\u52a8\u56db\u8c61\u9650\u7684\u7c7b\u578b\u5206\u5e03&#xff1b;\u5f3a\u52bf\u677f\u5757\u7684\u8d44\u91d1\u5206\u4f4d\u3001\u4ef7\u683c\u5206\u4f4d\u4e0e\u8d44\u91d1\u9886\u5148\u5ea6&#xff1b;\u591a\u5468\u671f\u5171\u632f\u4e0e\u80cc\u79bb\u7684\u677f\u5757\u8ba1\u6570&#xff0c;\u4ee5\u53ca\u300c\u65e2\u5171\u632f\u6d41\u5165\u53c8\u80cc\u79bb\u300d\u7684\u677f\u5757\u6e05\u5355&#xff1b;\u9f99\u5934\u80a1\u4e8c\u6b21\u9a8c\u8bc1\u7684\u547d\u4e2d\u7387\u4e0e\u547d\u4e2d\u677f\u5757\u7684\u4e2a\u80a1\u699c\u6392\u540d&#xff1b;\u6700\u540e\u662f\u677f\u5757 \u2192 \u4e2a\u80a1\u7a7f\u900f\u7ed3\u679c\u3002\u6240\u6709\u6570\u503c\u5747\u7531\u5b9e\u9645\u63a5\u53e3\u8fd4\u56de\u8ba1\u7b97\u5f97\u51fa&#xff0c;\u672c\u6587\u4e0d\u9884\u8bbe\u4efb\u4f55\u5177\u4f53\u7ed3\u679c\u3002<\/p>\n<h3>\u516d\u3001\u4e1a\u52a1\u5173\u952e\u70b9<\/h3>\n<li>\u4e09\u4e2a\u63a5\u53e3\u7684 dm \u662f\u4e09\u79cd\u4e0d\u540c\u7684\u4e1c\u897f&#xff1a;hizj\/zjh \u7684 dm \u662f\u884c\u4e1a\u4ee3\u7801&#xff0c;hibk\/zjhhy \u7684 dm \u662f\u677f\u5757\u4ee3\u7801&#xff0c;higg\/jlr \u7684 dm \u662f\u80a1\u7968\u4ee3\u7801\u3002\u672c\u6587\u5728 build_rotation_frame() \u91cc\u53ea\u6562\u7528 (t, dm) \u53bb\u5173\u8054\u524d\u4e24\u5f20\u8868&#xff08;\u540c\u4e3a\u8bc1\u76d1\u4f1a\u884c\u4e1a\u5206\u7c7b\u53e3\u5f84&#xff09;&#xff0c;\u7edd\u4e0d\u628a\u884c\u4e1a\u4ee3\u7801\u4e0e\u80a1\u7968\u4ee3\u7801\u653e\u5728\u4e00\u8d77 join\u3002\u8de8\u8868\u5173\u8054\u524d\u52a1\u5fc5\u786e\u8ba4\u4e24\u4fa7\u4ee3\u7801\u540c\u57df&#xff0c;\u8fd9\u662f\u8fd9\u7c7b\u591a\u63a5\u53e3\u7ec4\u5408\u6700\u5bb9\u6613\u51fa\u9759\u9ed8\u9519\u8bef\u7684\u5730\u65b9\u2014\u2014\u5173\u8054\u4e0d\u4e0a\u65f6 merge \u4e0d\u4f1a\u62a5\u9519&#xff0c;\u53ea\u4f1a\u7ed9\u4f60\u4e00\u7247 NaN\u3002<\/li>\n<li>lrzj &#8211; lczj &#061; jlr \u662f\u4e00\u4e2a\u514d\u8d39\u7684\u6570\u636e\u81ea\u6d3d\u6821\u9a8c&#xff1a;\u884c\u4e1a\u677f\u5757\u63a5\u53e3\u628a\u6d41\u5165\u3001\u6d41\u51fa\u3001\u51c0\u989d\u4e09\u4e2a\u6570\u90fd\u7ed9\u4e86\u3002\u843d\u5e93\u540e\u53ef\u4ee5\u8dd1\u4e00\u6761 SELECT COUNT(*) FROM industry_board WHERE ABS(lrzj &#8211; lczj &#8211; jlr) &gt; \u9608\u503c \u68c0\u67e5\u63a5\u53e3\u662f\u5426\u6709\u5f02\u5e38\u884c\u3002\u540c\u7406 higg\/jlr \u4e5f\u6709 lrzj \/ lczj \/ jlr \u4e09\u4ef6\u5957&#xff0c;\u540c\u6837\u53ef\u6821\u9a8c\u3002\u8fd9\u7c7b\u300c\u63a5\u53e3\u81ea\u5df1\u7ed9\u81ea\u5df1\u51fa\u7684\u6821\u9a8c\u9898\u300d\u6210\u672c\u6781\u4f4e&#xff0c;\u5efa\u8bae\u6bcf\u6b21\u63a5\u65b0\u63a5\u53e3\u90fd\u5148\u627e\u4e00\u904d\u3002<\/li>\n<li>\u300c\u8f6e\u52a8\u5f3a\u5ea6\u300d\u4e0d\u80fd\u7528\u5355\u4e00\u6570\u5b57\u6982\u62ec&#xff0c;\u672c\u6587\u62c6\u6210\u4e09\u4e2a\u4e92\u8865\u89c6\u89d2&#xff1a;\u56db\u8c61\u9650 rotation_type \u56de\u7b54\u300c\u4ef7\u4e0e\u94b1\u662f\u5426\u540c\u5411\u300d&#xff1b;lead_score \u56de\u7b54\u300c\u8d44\u91d1\u6bd4\u4ef7\u683c\u9886\u5148\u591a\u5c11\u300d&#xff1b;resonance_flag \u56de\u7b54\u300c\u8fd9\u79cd\u540c\u5411\u6301\u7eed\u4e86\u51e0\u4e2a\u5468\u671f\u300d\u3002\u4e09\u8005\u5408\u8d77\u6765\u624d\u6784\u6210\u53ef\u89e3\u91ca\u7684\u5224\u65ad\u94fe\u2014\u2014\u53ea\u770b jlr \u6392\u540d&#xff0c;\u4f60\u4f1a\u628a\u300c\u8fde\u7eed\u4e09\u5929\u6d41\u5165\u4f46\u4eca\u5929\u5df2\u5f00\u59cb\u4e0b\u8dcc\u300d\u548c\u300c\u4eca\u5929\u521a\u5f00\u59cb\u6d41\u5165\u300d\u6df7\u4e3a\u4e00\u8c08\u3002<\/li>\n<li>\u96f6\u503c\u5fc5\u987b\u5355\u72ec\u5224&#xff0c;\u4e0d\u80fd\u76f4\u63a5\u770b\u7b26\u53f7&#xff1a;zdf \u4e3a 0&#xff08;\u5e73\u76d8&#xff09;\u6216 jlr \u4e3a 0&#xff08;\u8d44\u91d1\u6301\u5e73&#xff09;\u65f6&#xff0c;zdf &gt; 0 \u4e0e zdf &lt;&#061; 0 \u7684\u5206\u652f\u4f1a\u628a\u5b83\u8bef\u5212\u8fdb\u300c\u9006\u52bf\u5438\u7b79\u300d\u6216\u300c\u91cf\u4ef7\u9f50\u8dcc\u300d\u3002\u672c\u6587\u7528 FLOW_EPS \u62e6\u5728\u524d\u9762&#xff0c;\u96f6\u503c\u4e00\u5f8b\u8bb0\u300c\u65e0\u53ef\u5224\u5b9a\u300d\u3002\u540c\u7406\u80cc\u79bb\u5224\u5b9a\u91cc abs(ra10) &lt; FLOW_EPS or abs(ac10) &lt; FLOW_EPS \u76f4\u63a5\u8bb0 0\u2014\u2014\u96f6\u65e2\u4e0d\u662f\u6b63\u4e5f\u4e0d\u662f\u8d1f&#xff0c;\u62ff\u5b83\u53bb\u4e58\u53e6\u4e00\u4e2a\u6570\u5224\u7b26\u53f7\u76f8\u53cd&#xff0c;\u5f97\u5230\u7684\u6c38\u8fdc\u662f\u9519\u7684\u7ed3\u8bba\u3002<\/li>\n<li>\u5171\u632f\u8981\u6c42\u300c\u4e09\u6761\u540c\u53f7\u300d\u662f\u6709\u610f\u4e3a\u4e4b&#xff1a;net3\u3001net5\u3001net10 \u4e09\u53d6\u4e09\u540c\u53f7&#xff0c;\u6761\u4ef6\u76f8\u5f53\u4e25\u683c&#xff0c;\u547d\u4e2d\u677f\u5757\u6570\u91cf\u901a\u5e38\u5f88\u5c11&#xff0c;\u8fd9\u662f\u523b\u610f\u7684\u2014\u2014\u5171\u632f\u7684\u610f\u4e49\u5728\u4e8e\u6392\u9664\u5355\u65e5\u8109\u51b2\u3002\u5982\u679c\u4f60\u60f3\u653e\u5bbd&#xff0c;\u628a RESONANCE_PERIODS \u6539\u6210 2 \u5373\u53ef&#xff0c;\u4ee3\u7801\u91cc resonance_cnt \u5df2\u7ecf\u628a\u300c\u51e0\u689d\u540c\u53f7\u300d\u8bb0\u4e0b\u6765&#xff0c;\u4e0d\u9700\u8981\u6539\u5224\u5b9a\u903b\u8f91\u3002\u4f46\u8981\u6ce8\u610f&#xff1a;resonance_cnt \u53d6\u7684\u662f\u300c\u6b63\u6570\u4e2a\u6570\u4e0e\u8d1f\u6570\u4e2a\u6570\u7684\u8f83\u5927\u8005\u300d&#xff0c;\u82e5\u4e09\u4e2a\u6570\u91cc\u6709\u4e00\u4e2a\u6070\u597d\u4e3a 0&#xff0c;\u5b83\u65e2\u4e0d\u8ba1\u5165 pos \u4e5f\u4e0d\u8ba1\u5165 neg&#xff0c;\u6b64\u65f6 cnt \u6700\u5927\u53ea\u80fd\u662f 2&#xff0c;\u4e0d\u4f1a\u8bef\u5224\u4e3a\u5171\u632f\u3002<\/li>\n<li>\u9f99\u5934\u80a1\u4ee3\u7801\u5fc5\u987b\u5f52\u4e00\u5316\u540e\u518d\u6bd4\u5bf9&#xff1a;lzgdm \u4e0e higg\/jlr \u7684 dm \u8c01\u5e26\u540e\u7f00\u3001\u8c01\u4e0d\u5e26&#xff0c;\u4e0d\u540c\u6279\u6b21\u53ef\u80fd\u4e0d\u4e00\u81f4\u3002\u672c\u6587 normalize_code() \u5148 split(&#034;.&#034;)[0] \u53bb\u6389\u540e\u7f00&#xff0c;\u518d\u7528\u7cfb\u5217\u5de5\u5177\u51fd\u6570 with_exchange_suffix() \u6309\u524d\u7f00\u8865\u56de&#xff0c;\u4e24\u4fa7\u90fd\u8d70\u540c\u4e00\u6761\u8def\u5f84&#xff0c;\u675c\u7edd\u300c600519\u300d\u4e0e\u300c600519.SH\u300d\u5339\u914d\u4e0d\u4e0a\u7684\u5047\u9634\u6027\u3002<\/li>\n<li>\u9f99\u5934\u80a1\u300c\u9a8c\u8bc1\u4e0d\u901a\u8fc7\u300d\u4e0d\u7b49\u4e8e\u300c\u4e0d\u662f\u9f99\u5934\u300d&#xff1a;higg\/jlr \u8fd4\u56de\u7684\u662f\u51c0\u6d41\u5165\u699c&#xff0c;\u672c\u8d28\u662f\u4e00\u4e2a\u622a\u65ad\u7684\u699c\u5355&#xff0c;\u4e0d\u662f\u5168\u5e02\u573a\u80a1\u7968\u6e05\u5355\u3002\u9f99\u5934\u80a1\u6ca1\u51fa\u73b0\u5728\u699c\u4e0a&#xff0c;\u53ef\u80fd\u662f\u8d44\u91d1\u6ca1\u8fdb\u5b83&#xff0c;\u4e5f\u53ef\u80fd\u53ea\u662f\u5b83\u6392\u5728\u699c\u5916\u3002\u6240\u4ee5 leader_verified &#061; 0 \u53ea\u80fd\u89e3\u8bfb\u4e3a\u300c\u4e2a\u80a1\u51c0\u6d41\u5165\u699c\u672a\u8986\u76d6\u300d&#xff0c;\u4e0d\u80fd\u89e3\u8bfb\u4e3a\u300c\u9f99\u5934\u5931\u683c\u300d\u3002\u8fd9\u4e5f\u662f\u672c\u6587\u628a\u5b83\u547d\u540d\u4e3a\u300c\u9a8c\u8bc1\u300d\u800c\u4e0d\u662f\u300c\u8bc1\u4f2a\u300d\u7684\u539f\u56e0\u3002<\/li>\n<li>\u677f\u5757 \u2192 \u4e2a\u80a1\u7a7f\u900f\u5728\u672c\u63a5\u53e3\u4f53\u7cfb\u4e0b\u65e0\u6cd5\u5b8c\u5168\u95ed\u73af&#xff1a;\u4efb\u52a1\u63cf\u8ff0\u91cc\u8bf4\u300c\u5728\u8be5\u677f\u5757\u7684\u4e2a\u80a1\u51c0\u6d41\u5165\u699c\u4e2d\u53d6\u9760\u524d\u6807\u7684\u300d&#xff0c;\u4f46 higg\/jlr \u7684\u5b57\u6bb5\u8868\u91cc\u6ca1\u6709\u4efb\u4f55\u884c\u4e1a\u5f52\u5c5e\u5b57\u6bb5\u2014\u2014\u5b83\u8fd4\u56de\u7684\u662f\u4e00\u4efd\u8de8\u884c\u4e1a\u7684\u4e2a\u80a1\u51c0\u6d41\u5165\u699c\u3002\u672c\u6587\u7684\u7a7f\u900f\u56e0\u6b64\u9000\u5316\u4e3a\u300c\u4ee5\u677f\u5757\u9f99\u5934\u80a1\u4e3a\u951a\u70b9 &#043; \u5168\u5e02\u573a\u51c0\u6d41\u5165\u5019\u9009\u6c60\u300d\u4e24\u6b65&#xff0c;\u5e76\u5728\u8f93\u51fa\u91cc\u660e\u786e\u6807\u6ce8\u300c\u4e0d\u505a\u884c\u4e1a\u5f52\u5c5e\u65ad\u8a00\u300d\u3002\u8981\u5b9e\u73b0\u771f\u6b63\u7684\u677f\u5757\u6210\u5206\u80a1\u7a7f\u900f&#xff0c;\u5fc5\u987b\u81ea\u5df1\u7ef4\u62a4\u4e00\u4efd\u300c\u80a1\u7968\u4ee3\u7801 \u2192 \u884c\u4e1a\u4ee3\u7801\u300d\u6620\u5c04\u8868&#xff08;\u53ef\u4ece\u677f\u5757\u6210\u5206\u80a1\u63a5\u53e3\u6216\u672c\u5730\u884c\u4e1a\u5206\u7c7b\u8868\u6784\u5efa&#xff09;&#xff0c;\u8fd9\u662f\u672c\u7bc7\u7559\u4e0b\u7684\u6269\u5c55\u53e3\u5b50&#xff0c;\u4e0d\u8981\u5047\u88c5\u63a5\u53e3\u7ed9\u4e86\u4f60\u6ca1\u7ed9\u7684\u4e1c\u897f\u3002<\/li>\n<li>\u4e09\u4e2a\u63a5\u53e3\u7684 t \u672a\u5fc5\u4e25\u683c\u4e00\u81f4&#xff1a;\u8d44\u91d1\u6d41\u3001\u677f\u5757\u3001\u4e2a\u80a1\u4e09\u4e2a\u63a5\u53e3\u5404\u81ea\u8fd4\u56de\u81ea\u5df1\u7684\u66f4\u65b0\u65f6\u95f4&#xff0c;\u843d\u5e93\u540e\u53ef\u80fd\u51fa\u73b0 t \u76f8\u5dee\u4e00\u4e24\u5206\u949f\u7684\u60c5\u51b5\u3002\u672c\u6587\u7528 (t, dm) \u5173\u8054\u524d\u4e24\u5f20\u8868&#xff0c;\u82e5\u4e24\u4fa7 t \u4e0d\u5b8c\u5168\u76f8\u540c&#xff0c;merge \u4f1a\u5927\u9762\u79ef\u5931\u914d\u3002\u751f\u4ea7\u73af\u5883\u5efa\u8bae\u5148\u6309\u300c\u65e5\u671f &#043; \u6700\u8fd1\u65f6\u70b9\u300d\u505a\u4e00\u5c42\u65f6\u95f4\u5bf9\u9f50&#xff08;\u4f8b\u5982\u7edf\u4e00\u53d6\u5f53\u65e5\u6700\u65b0\u7684\u90a3\u4e2a t \u4f5c\u4e3a\u5173\u8054\u952e&#xff09;&#xff0c;\u6216\u5355\u72ec\u7ef4\u62a4\u4e00\u5f20\u300c\u4ea4\u6613\u65f6\u70b9\u300d\u7ef4\u8868\u3002<\/li>\n<li>rotation_signal \u662f\u53ef\u91cd\u7b97\u7684\u4e2d\u95f4\u4ea7\u7269&#xff0c;\u4e0d\u662f\u539f\u59cb\u6570\u636e&#xff1a;\u524d\u4e09\u5f20\u8868 industry_fund \/ industry_board \/ stock_netflow \u662f\u7eaf\u539f\u59cb\u5feb\u7167&#xff0c;\u4efb\u4f55\u65f6\u5019\u90fd\u80fd\u4ece\u88f8\u6570\u636e\u91cd\u7b97\u51fa\u5168\u90e8\u6307\u6807\u3002\u82e5\u54ea\u5929\u4f60\u6539\u4e86 TOP_N\u3001\u628a RESONANCE_PERIODS \u4ece 3 \u8c03\u5230 2\u3001\u6216\u8005\u6362\u4e86\u56db\u8c61\u9650\u7684\u5212\u5206\u9608\u503c&#xff0c;\u76f4\u63a5\u4ece\u539f\u59cb\u8868\u91cd\u8dd1\u5373\u53ef&#xff0c;\u4e0d\u7528\u91cd\u65b0\u91c7\u96c6\u3002\u81ea\u7814\u56e0\u5b50\u7684\u5168\u90e8\u4ee3\u4ef7\u4e0e\u81ea\u7531&#xff0c;\u90fd\u843d\u5728\u300c\u539f\u59cb\u5c42\u4e0e\u6d3e\u751f\u5c42\u5fc5\u987b\u4e25\u683c\u5206\u79bb\u300d\u8fd9\u4e00\u6761\u4e0a\u3002<\/li>\n<h3>\u4e03\u3001\u62d3\u5c55\u7ec3\u4e60<\/h3>\n<li>\u628a TOP_N \u6539\u6210 10\u3001RESONANCE_PERIODS \u6539\u6210 2 \u5206\u522b\u91cd\u8dd1&#xff0c;\u7edf\u8ba1 rotation_signal \u8868\u4e2d\u300c\u65e2\u5171\u632f\u6d41\u5165\u53c8\u80cc\u79bb\u300d\u7684\u677f\u5757\u6570\u91cf\u53d8\u5316&#xff0c;\u4f53\u4f1a\u9608\u503c\u677e\u7d27\u5bf9\u4fe1\u53f7\u6570\u91cf\u7684\u5f71\u54cd\u2014\u2014\u4fe1\u53f7\u53d8\u591a\u4e0d\u7b49\u4e8e\u53d8\u597d&#xff0c;\u5173\u952e\u662f\u770b\u5b83\u4eec\u5728\u4e0b\u4e00\u65f6\u70b9\u662f\u5426\u4ecd\u7136\u6210\u7acb\u3002<\/li>\n<li>\u7528 rotation_signal \u6309 dm \u505a\u81ea\u5173\u8054&#xff1a;\u53d6\u5f53\u65e5 rotation_type &#061; &#039;\u9006\u52bf\u5438\u7b79&#039; \u4e14 lead_score &gt; 30 \u7684\u677f\u5757&#xff0c;\u56de\u770b\u5b83\u4eec\u5728\u540e\u7eed\u82e5\u5e72\u91c7\u96c6\u65f6\u70b9\u4e2d rotation_type \u662f\u5426\u5207\u6362\u4e3a\u300c\u91cf\u4ef7\u9f50\u5347\u300d&#xff0c;\u68c0\u9a8c\u300c\u8d44\u91d1\u9886\u5148\u5ea6\u300d\u662f\u5426\u771f\u7684\u9886\u5148\u4ef7\u683c\u3002<\/li>\n<li>\u81ea\u5efa\u4e00\u5f20 stock_industry \u6620\u5c04\u8868&#xff08;\u5b57\u6bb5\u81ea\u62df&#xff0c;\u81f3\u5c11\u542b\u80a1\u7968\u4ee3\u7801\u4e0e\u884c\u4e1a\u4ee3\u7801&#xff09;&#xff0c;\u628a higg\/jlr \u7684\u4e2a\u80a1\u6309\u884c\u4e1a\u5206\u7ec4\u540e\u518d\u505a\u51c0\u6d41\u5165\u6392\u540d&#xff0c;\u4e0e\u672c\u6587\u300c\u5168\u5e02\u573a\u5019\u9009\u6c60\u300d\u7684\u505a\u6cd5\u5bf9\u6bd4&#xff0c;\u89c2\u5bdf\u9f99\u5934\u80a1\u5728\u300c\u677f\u5757\u5185\u6392\u540d\u300d\u4e0e\u300c\u5168\u5e02\u573a\u6392\u540d\u300d\u4e24\u4e2a\u53e3\u5f84\u4e0b\u7684\u5dee\u5f02\u3002<\/li>\n<h3>\u516b\u3001\u4e0b\u7bc7\u9884\u544a<\/h3>\n<p>\u4e0b\u4e00\u7bc7\u300a\u5386\u53f2\u6da8\u8dcc\u505c\u4ef7&#xff1a;\u6da8\u8dcc\u505c\u5e8f\u5217\u4e0e\u6b62\u635f\u7ebf\u6d4b\u7b97\u300b\u5c06\u7528 hsstock\/stopprice\/history \u62ff\u5230\u6bcf\u53ea\u80a1\u7968\u5386\u53f2\u6bcf\u65e5\u7684\u6da8\u505c\u4ef7 h \u4e0e\u8dcc\u505c\u4ef7 l&#xff0c;\u5e76\u81ea\u7814\u300c\u6da8\u8dcc\u505c\u4ef7\u5e8f\u5217\u5206\u6790\u300d\u300c\u8dcc\u505c\u4ef7\u504f\u79bb\u5ea6\u6b62\u635f\u7ebf\u300d\u300c\u6ce2\u52a8\u7387\u81ea\u9002\u5e94\u6b62\u635f\u300d\u7b49\u98ce\u63a7\u6307\u6807\u2014\u2014\u8fd9\u662f\u672c\u7cfb\u5217\u5728\u300c\u8fdb\u653b\u300d\u4e4b\u5916\u8865\u4e0a\u7684\u6700\u540e\u4e00\u5757\u300c\u9632\u5b88\u300d\u62fc\u56fe\u3002<\/p>\n<h3>\u4e5d\u3001\u514d\u8d23\u7533\u660e<\/h3>\n<p>\u514d\u8d23\u7533\u660e&#xff1a;\u6587\u4e2d\u6240\u6709\u6570\u636e\u5904\u7406\u903b\u8f91\u4ec5\u4e3a\u7f16\u7a0b\u6f14\u793a&#xff0c;\u4ec5\u4e3a\u6570\u636e\u6f14\u793a&#xff0c;\u4e0d\u6784\u6210\u6295\u8d44\u5efa\u8bae\u3002\u5e02\u573a\u6709\u98ce\u9669&#xff0c;\u6295\u8d44\u9700\u8c28\u614e\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u91cf\u5316\u6570\u636e\u8fdb\u9636&#xff1a;\u591a\u7ef4\u5b9e\u6218\u7bc7&#xff08;\u7b2c 10 \u7bc7&#xff09;&#xff1a;\u677f\u5757\u8f6e\u52a8&#xff1a;\u884c\u4e1a\u8d44\u91d1\u6d41\u5411\u4e0e\u9f99\u5934\u80a1\u6355\u6349<br \/>\n\u4e00\u3001\u524d\u8a00<br \/>\n\u4e0a\u4e00\u7bc7\u300a\u81ea\u7814\u6307\u6807&#xff1a;\u91cf\u4ef7\u80cc\u79bb\u3001\u6362\u624b\u5f02\u52a8\u4e0e\u632f\u5e45\u300b\u6211\u4eec\u5b8c\u6210\u4e86\u300c\u6a21\u5757\u4e09\u00b7\u6280\u672f\u6307\u6807\u300d\u7684\u6536\u5b98&#xff0c;\u4e5f\u5b8c\u6210\u4e86\u4e00\u6b21\u8f6c\u8eab&#xff1a;\u53ea\u62ff\u88f8\u5b57\u6bb5&#xff0c;\u7eaf Python \u624b\u5199\u56e0\u5b50\u3002\u4f46\u90a3\u4e00\u7bc7\u7684\u89c6\u89d2\u59cb\u7ec8\u505c\u5728\u4e00\u53ea\u80a1\u7968\u4e0a\u2014\u2014\u4ef7\u683c\u5206\u4f4d\u3001\u91cf\u80fd\u5206\u4f4d\u3001\u6362\u624b Z-Score&#xff0c;\u5168\u90e8\u662f\u300c\u4e2a\u80a1\u81ea\u8eab\u7684\u65f6\u95f4\u5e8f\u5217\u300d\u3002<br \/>\n\u771f<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[11653,11350,12127,12126,99,81],"topic":[],"class_list":["post-106811","post","type-post","status-publish","format-standard","hentry","category-server","tag-11653","tag-11350","tag-api","tag-12126","tag-java","tag-python"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u91cf\u5316\u6570\u636e\u8fdb\u9636\uff1a\u591a\u7ef4\u5b9e\u6218\u7bc7\uff08\u7b2c 10 \u7bc7\uff09\uff1a\u677f\u5757\u8f6e\u52a8\uff1a\u884c\u4e1a\u8d44\u91d1\u6d41\u5411\u4e0e\u9f99\u5934\u80a1\u6355\u6349 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/106811.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u91cf\u5316\u6570\u636e\u8fdb\u9636\uff1a\u591a\u7ef4\u5b9e\u6218\u7bc7\uff08\u7b2c 10 \u7bc7\uff09\uff1a\u677f\u5757\u8f6e\u52a8\uff1a\u884c\u4e1a\u8d44\u91d1\u6d41\u5411\u4e0e\u9f99\u5934\u80a1\u6355\u6349 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u91cf\u5316\u6570\u636e\u8fdb\u9636&#xff1a;\u591a\u7ef4\u5b9e\u6218\u7bc7&#xff08;\u7b2c 10 \u7bc7&#xff09;&#xff1a;\u677f\u5757\u8f6e\u52a8&#xff1a;\u884c\u4e1a\u8d44\u91d1\u6d41\u5411\u4e0e\u9f99\u5934\u80a1\u6355\u6349 \u4e00\u3001\u524d\u8a00 \u4e0a\u4e00\u7bc7\u300a\u81ea\u7814\u6307\u6807&#xff1a;\u91cf\u4ef7\u80cc\u79bb\u3001\u6362\u624b\u5f02\u52a8\u4e0e\u632f\u5e45\u300b\u6211\u4eec\u5b8c\u6210\u4e86\u300c\u6a21\u5757\u4e09\u00b7\u6280\u672f\u6307\u6807\u300d\u7684\u6536\u5b98&#xff0c;\u4e5f\u5b8c\u6210\u4e86\u4e00\u6b21\u8f6c\u8eab&#xff1a;\u53ea\u62ff\u88f8\u5b57\u6bb5&#xff0c;\u7eaf Python \u624b\u5199\u56e0\u5b50\u3002\u4f46\u90a3\u4e00\u7bc7\u7684\u89c6\u89d2\u59cb\u7ec8\u505c\u5728\u4e00\u53ea\u80a1\u7968\u4e0a\u2014\u2014\u4ef7\u683c\u5206\u4f4d\u3001\u91cf\u80fd\u5206\u4f4d\u3001\u6362\u624b Z-Score&#xff0c;\u5168\u90e8\u662f\u300c\u4e2a\u80a1\u81ea\u8eab\u7684\u65f6\u95f4\u5e8f\u5217\u300d\u3002 \u771f\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/106811.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-18T02:48:52+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"19 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/106811.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/106811.html\",\"name\":\"\u91cf\u5316\u6570\u636e\u8fdb\u9636\uff1a\u591a\u7ef4\u5b9e\u6218\u7bc7\uff08\u7b2c 10 \u7bc7\uff09\uff1a\u677f\u5757\u8f6e\u52a8\uff1a\u884c\u4e1a\u8d44\u91d1\u6d41\u5411\u4e0e\u9f99\u5934\u80a1\u6355\u6349 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-09-18T02:48:52+00:00\",\"dateModified\":\"2026-09-18T02:48:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/106811.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/106811.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/106811.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u91cf\u5316\u6570\u636e\u8fdb\u9636\uff1a\u591a\u7ef4\u5b9e\u6218\u7bc7\uff08\u7b2c 10 \u7bc7\uff09\uff1a\u677f\u5757\u8f6e\u52a8\uff1a\u884c\u4e1a\u8d44\u91d1\u6d41\u5411\u4e0e\u9f99\u5934\u80a1\u6355\u6349\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u91cf\u5316\u6570\u636e\u8fdb\u9636\uff1a\u591a\u7ef4\u5b9e\u6218\u7bc7\uff08\u7b2c 10 \u7bc7\uff09\uff1a\u677f\u5757\u8f6e\u52a8\uff1a\u884c\u4e1a\u8d44\u91d1\u6d41\u5411\u4e0e\u9f99\u5934\u80a1\u6355\u6349 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/106811.html","og_locale":"zh_CN","og_type":"article","og_title":"\u91cf\u5316\u6570\u636e\u8fdb\u9636\uff1a\u591a\u7ef4\u5b9e\u6218\u7bc7\uff08\u7b2c 10 \u7bc7\uff09\uff1a\u677f\u5757\u8f6e\u52a8\uff1a\u884c\u4e1a\u8d44\u91d1\u6d41\u5411\u4e0e\u9f99\u5934\u80a1\u6355\u6349 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u91cf\u5316\u6570\u636e\u8fdb\u9636&#xff1a;\u591a\u7ef4\u5b9e\u6218\u7bc7&#xff08;\u7b2c 10 \u7bc7&#xff09;&#xff1a;\u677f\u5757\u8f6e\u52a8&#xff1a;\u884c\u4e1a\u8d44\u91d1\u6d41\u5411\u4e0e\u9f99\u5934\u80a1\u6355\u6349 \u4e00\u3001\u524d\u8a00 \u4e0a\u4e00\u7bc7\u300a\u81ea\u7814\u6307\u6807&#xff1a;\u91cf\u4ef7\u80cc\u79bb\u3001\u6362\u624b\u5f02\u52a8\u4e0e\u632f\u5e45\u300b\u6211\u4eec\u5b8c\u6210\u4e86\u300c\u6a21\u5757\u4e09\u00b7\u6280\u672f\u6307\u6807\u300d\u7684\u6536\u5b98&#xff0c;\u4e5f\u5b8c\u6210\u4e86\u4e00\u6b21\u8f6c\u8eab&#xff1a;\u53ea\u62ff\u88f8\u5b57\u6bb5&#xff0c;\u7eaf Python \u624b\u5199\u56e0\u5b50\u3002\u4f46\u90a3\u4e00\u7bc7\u7684\u89c6\u89d2\u59cb\u7ec8\u505c\u5728\u4e00\u53ea\u80a1\u7968\u4e0a\u2014\u2014\u4ef7\u683c\u5206\u4f4d\u3001\u91cf\u80fd\u5206\u4f4d\u3001\u6362\u624b Z-Score&#xff0c;\u5168\u90e8\u662f\u300c\u4e2a\u80a1\u81ea\u8eab\u7684\u65f6\u95f4\u5e8f\u5217\u300d\u3002 \u771f","og_url":"https:\/\/www.wsisp.com\/helps\/106811.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-09-18T02:48:52+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"19 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/106811.html","url":"https:\/\/www.wsisp.com\/helps\/106811.html","name":"\u91cf\u5316\u6570\u636e\u8fdb\u9636\uff1a\u591a\u7ef4\u5b9e\u6218\u7bc7\uff08\u7b2c 10 \u7bc7\uff09\uff1a\u677f\u5757\u8f6e\u52a8\uff1a\u884c\u4e1a\u8d44\u91d1\u6d41\u5411\u4e0e\u9f99\u5934\u80a1\u6355\u6349 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-09-18T02:48:52+00:00","dateModified":"2026-09-18T02:48:52+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/106811.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/106811.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/106811.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u91cf\u5316\u6570\u636e\u8fdb\u9636\uff1a\u591a\u7ef4\u5b9e\u6218\u7bc7\uff08\u7b2c 10 \u7bc7\uff09\uff1a\u677f\u5757\u8f6e\u52a8\uff1a\u884c\u4e1a\u8d44\u91d1\u6d41\u5411\u4e0e\u9f99\u5934\u80a1\u6355\u6349"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/106811","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=106811"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/106811\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=106811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=106811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=106811"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=106811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}