![\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/09\/20260910182502-6aa2f5fe96964.png\")
<\/p>\n<\/p>\n
\u4e00\u5ea7\u73b0\u4ee3\u5316\u57ce\u5e02\u6bcf\u5929\u90fd\u5728"\u547c\u5438"\u2014\u2014\u6865\u6881\u627f\u53d7\u7740\u8f66\u6d41\u8377\u8f7d，\u5730\u94c1\u96a7\u9053\u7ecf\u53d7\u7740\u5730\u5c42\u538b\u529b，\u4f9b\u6c34\u7ba1\u7f51\u65e5\u591c\u8f93\u9001\u7740\u751f\u6d3b\u7528\u6c34\u3002\u8fd9\u4e9b\u57fa\u7840\u8bbe\u65bd\u7684\u5065\u5eb7\u72b6\u6001，\u76f4\u63a5\u5173\u7cfb\u5230\u6570\u767e\u4e07\u5e02\u6c11\u7684\u751f\u547d\u5b89\u5168\u3002\u672c\u6587\u5c06\u63a2\u8ba8\u5982\u4f55\u5229\u7528\u65f6\u5e8f\u5927\u6a21\u578b TimechoAI，\u5bf9\u57ce\u5e02\u57fa\u7840\u8bbe\u65bd\u7684\u76d1\u6d4b\u6570\u636e\u8fdb\u884c\u667a\u80fd\u5316\u5206\u6790，\u5b9e\u73b0\u4ece"\u88ab\u52a8\u62a2\u4fee"\u5230"\u4e3b\u52a8\u9884\u8b66"\u7684\u8de8\u8d8a\u3002<\/p>\n
\u6211\u56fd\u57ce\u9547\u5316\u8fdb\u7a0b\u6301\u7eed\u63a8\u8fdb，\u57ce\u5e02\u57fa\u7840\u8bbe\u65bd\u7684\u89c4\u6a21\u548c\u590d\u6742\u5ea6\u90fd\u5728\u5feb\u901f\u589e\u957f\u3002\u636e\u4f4f\u5efa\u90e8\u6570\u636e，\u5168\u56fd\u57ce\u5e02\u6865\u6881\u8d85\u8fc7 100 \u4e07\u5ea7，\u8f68\u9053\u4ea4\u901a\u8fd0\u8425\u91cc\u7a0b\u7a81\u7834 1 \u4e07\u516c\u91cc，\u4f9b\u6c34\u7ba1\u7f51\u603b\u957f\u5ea6\u8d85\u8fc7 100 \u4e07\u516c\u91cc\u3002<\/p>\n
\u8fd9\u4e9b\u8bbe\u65bd\u7684\u5b89\u5168\u76d1\u6d4b\u9762\u4e34\u4e09\u5927\u6838\u5fc3\u6311\u6218：<\/p>\n
\u6311\u6218\u4e00：\u6570\u636e\u91cf\u5927，\u5206\u6790\u80fd\u529b\u8ddf\u4e0d\u4e0a<\/p>\n
\u4e00\u5ea7\u5927\u578b\u6865\u6881\u90e8\u7f72\u7684\u4f20\u611f\u5668\u53ef\u8fbe\u6570\u5343\u4e2a，\u6bcf\u79d2\u91c7\u96c6\u5e94\u53d8\u3001\u4f4d\u79fb\u3001\u52a0\u901f\u5ea6\u3001\u6e29\u5ea6\u7b49\u6570\u636e\u3002\u4f20\u7edf\u505a\u6cd5\u662f\u8bbe\u5b9a\u56fa\u5b9a\u9608\u503c\u8fdb\u884c\u544a\u8b66，\u4f46\u5927\u91cf\u8bef\u62a5\u548c\u6f0f\u62a5\u8ba9\u8fd0\u7ef4\u4eba\u5458\u75b2\u4e8e\u5e94\u5bf9，\u771f\u6b63\u6709\u4ef7\u503c\u7684\u5f02\u5e38\u4fe1\u53f7\u53cd\u800c\u88ab\u6df9\u6ca1\u5728\u6d77\u91cf\u6570\u636e\u4e2d\u3002<\/p>\n
\u6311\u6218\u4e8c：\u591a\u6e90\u6570\u636e\u5272\u88c2，\u7f3a\u4e4f\u5173\u8054\u5206\u6790<\/p>\n
\u57ce\u5e02\u57fa\u7840\u8bbe\u65bd\u7684\u76d1\u6d4b\u7cfb\u7edf\u5f80\u5f80\u662f\u5206\u671f\u5efa\u8bbe\u3001\u5206\u7cfb\u7edf\u90e8\u7f72\u7684\u3002\u6865\u6881\u5065\u5eb7\u76d1\u6d4b\u3001\u96a7\u9053\u7ed3\u6784\u76d1\u6d4b\u3001\u7ba1\u7f51\u6cc4\u6f0f\u68c0\u6d4b\u5404\u81ea\u72ec\u7acb\u8fd0\u884c，\u6570\u636e\u683c\u5f0f\u4e0d\u7edf\u4e00，\u5206\u6790\u6a21\u578b\u4e0d\u590d\u7528\u3002\u7136\u800c，\u5f88\u591a\u5b89\u5168\u9690\u60a3\u6070\u6070\u9690\u85cf\u5728\u8de8\u7cfb\u7edf\u7684\u5173\u8054\u4fe1\u53f7\u4e2d\u2014\u2014\u6bd4\u5982\u5730\u94c1\u65bd\u5de5\u5f15\u8d77\u7684\u5468\u8fb9\u6865\u6881\u632f\u52a8\u5f02\u5e38\u3002<\/p>\n
\u6311\u6218\u4e09：\u6a21\u578b\u96be\u4ee5\u590d\u7528，\u90e8\u7f72\u6210\u672c\u9ad8<\/p>\n
\u4e3a\u67d0\u5ea7\u6865\u6881\u8bad\u7ec3\u7684\u6545\u969c\u8bca\u65ad\u6a21\u578b，\u65e0\u6cd5\u76f4\u63a5\u8fc1\u79fb\u5230\u53e6\u4e00\u5ea7\u6865\u3002\u6bcf\u63a5\u5165\u4e00\u4e2a\u65b0\u8bbe\u65bd，\u90fd\u9700\u8981\u91cd\u65b0\u91c7\u96c6\u6570\u636e\u3001\u6807\u6ce8\u6837\u672c\u3001\u8bad\u7ec3\u6a21\u578b，\u5468\u671f\u957f\u8fbe\u6570\u6708\u3002\u8fd9\u5bf9\u4e8e\u9700\u8981\u7ba1\u7406\u6210\u767e\u4e0a\u5343\u4e2a\u8bbe\u65bd\u7684\u57ce\u5e02\u8fd0\u7ef4\u90e8\u95e8\u6765\u8bf4，\u6210\u672c\u5b8c\u5168\u4e0d\u53ef\u63a7\u3002<\/p>\n
\u65f6\u5e8f\u5927\u6a21\u578b TimechoAI（\u8bbf\u95ee https:\/\/ai.timecho.com\/ \u5728\u7ebf\u4f53\u9a8c）\u6b63\u662f\u4e3a\u4e86\u89e3\u51b3\u8fd9\u4e9b\u6311\u6218\u800c\u8bbe\u8ba1\u2014\u2014\u4e00\u4e2a\u6a21\u578b\u8986\u76d6\u591a\u7c7b\u8bbe\u65bd\u3001\u591a\u79cd\u4efb\u52a1，\u5f00\u7bb1\u5373\u7528\u3002<\/p>\n
TimechoAI \u7531\u5929\u8c0b\u79d1\u6280（https:\/\/timecho.com ）\u7814\u53d1，\u662f\u9762\u5411\u65f6\u5e8f\u6570\u636e\u7684\u57fa\u7840\u5927\u6a21\u578b\u3002\u5b83\u5728\u7535\u529b\u3001\u5236\u9020\u3001\u4ea4\u901a\u3001\u80fd\u6e90\u7b49\u591a\u884c\u4e1a\u7684\u6d77\u91cf\u65f6\u5e8f\u6570\u636e\u4e0a\u5b8c\u6210\u4e86\u9884\u8bad\u7ec3，\u5929\u7136\u9002\u5408\u57ce\u5e02\u57fa\u7840\u8bbe\u65bd\u8fd9\u7c7b\u591a\u8bbe\u65bd\u3001\u591a\u4f20\u611f\u5668\u3001\u591a\u573a\u666f\u7684\u76d1\u6d4b\u5206\u6790\u9700\u6c42\u3002<\/p>\n
\u5927\u578b\u6865\u6881\u662f\u57ce\u5e02\u4ea4\u901a\u7684\u547d\u8109\u3002TimechoAI \u5728\u6865\u6881\u76d1\u6d4b\u4e2d\u7684\u5178\u578b\u5e94\u7528：<\/p>\n
\u5730\u94c1\u96a7\u9053\u5728\u8fd0\u8425\u671f\u95f4\u6301\u7eed\u627f\u53d7\u5730\u5c42\u538b\u529b\u3001\u5730\u4e0b\u6c34\u6e17\u900f\u7b49\u8377\u8f7d\u3002TimechoAI \u7684\u5e94\u7528\u5305\u62ec：<\/p>\n
\u57ce\u5e02\u4f9b\u6c34\u7ba1\u7f51\u5206\u5e03\u8303\u56f4\u5e7f\u3001\u8fd0\u884c\u73af\u5883\u590d\u6742\u3002TimechoAI \u53ef\u4ee5\u5e2e\u52a9：<\/p>\n
\u4e0b\u9762\u4ee5\u4e00\u5ea7\u8de8\u6c5f\u5927\u6865\u7684\u7ed3\u6784\u5065\u5eb7\u76d1\u6d4b\u6570\u636e\u4e3a\u4f8b，\u6f14\u793a TimechoAI \u7684\u5b8c\u6574\u5206\u6790\u6d41\u7a0b\u3002<\/p>\n
\u6865\u6881\u76d1\u6d4b\u7cfb\u7edf\u5df2\u901a\u8fc7 IoTDB \u65f6\u5e8f\u6570\u636e\u5e93\u5b58\u50a8\u4e86\u4f20\u611f\u5668\u6570\u636e，\u9996\u5148\u5efa\u7acb\u8fde\u63a5\u5e76\u67e5\u8be2：<\/p>\n
import<\/span> logging # \u914d\u7f6e\u65e5\u5fd7<\/span> # ========== \u914d\u7f6e\u53c2\u6570 ==========<\/span> BRIDGE_DEVICE =<\/span> "root.bridge.monitor.section_03"<\/span> # ========== \u8fde\u63a5 IoTDB \u5e76\u67e5\u8be2\u6570\u636e ==========<\/span> sql =<\/span> f""" records =<\/span> [<\/span>]<\/span> df =<\/span> pd.<\/span>DataFrame(<\/span>records)<\/span> except<\/span> Exception as<\/span> e
\nimport<\/span> pandas as<\/span> pd
\nimport<\/span> numpy as<\/span> np
\nimport<\/span> matplotlib.<\/span>pyplot as<\/span> plt
\nfrom<\/span> iotdb.<\/span>Session import<\/span> Session
\nfrom<\/span> timecho_ai import<\/span> TimechoAnalyzer<\/p>\n
\nlogging.<\/span>basicConfig(<\/span>
\n level=<\/span>logging.<\/span>INFO,<\/span>
\n format<\/span>=<\/span>"%(asctime)s [%(levelname)s] %(message)s"<\/span>
\n)<\/span>
\nlogger =<\/span> logging.<\/span>getLogger(<\/span>__name__)<\/span><\/p>\n
\nIOTDB_CONFIG =<\/span> {<\/span>
\n "host"<\/span>:<\/span> "127.0.0.1"<\/span>,<\/span>
\n "port"<\/span>:<\/span> 6667<\/span>,<\/span>
\n "username"<\/span>:<\/span> "root"<\/span>,<\/span>
\n "password"<\/span>:<\/span> "root"<\/span>
\n}<\/span><\/p>\n
\nQUERY_START =<\/span> "2025-06-01T00:00:00"<\/span>
\nQUERY_END =<\/span> "2025-06-30T23:59:59"<\/span>
\nSENSOR_LIST =<\/span> [<\/span>"strain"<\/span>,<\/span> "acceleration"<\/span>,<\/span> "temperature"<\/span>,<\/span> "wind_speed"<\/span>]<\/span><\/p>\n
\nsession =<\/span> Session(<\/span>**<\/span>IOTDB_CONFIG)<\/span>
\ntry<\/span>:<\/span>
\n session.<\/span>open<\/span>(<\/span>False<\/span>)<\/span>
\n logger.<\/span>info(<\/span>"IoTDB \u8fde\u63a5\u6210\u529f"<\/span>)<\/span><\/p>\n
\n SELECT <\/span>{<\/span>', '<\/span>.<\/span>join(<\/span>SENSOR_LIST)<\/span>}<\/span><\/span>
\n FROM <\/span>{<\/span>BRIDGE_DEVICE}<\/span><\/span>
\n WHERE time >= <\/span>{<\/span>QUERY_START}<\/span><\/span> AND time <= <\/span>{<\/span>QUERY_END}<\/span><\/span>
\n ORDER BY time ASC
\n """<\/span><\/span>
\n dataset =<\/span> session.<\/span>execute_query_statement(<\/span>sql)<\/span><\/p>\n
\n while<\/span> dataset.<\/span>has_next(<\/span>)<\/span>:<\/span>
\n row =<\/span> dataset.<\/span>next<\/span>(<\/span>)<\/span>
\n records.<\/span>append(<\/span>{<\/span>
\n "timestamp"<\/span>:<\/span> pd.<\/span>to_datetime(<\/span>row.<\/span>get_timestamp(<\/span>)<\/span>,<\/span> unit=<\/span>"ms"<\/span>)<\/span>,<\/span>
\n "strain"<\/span>:<\/span> float<\/span>(<\/span>row.<\/span>get_value(<\/span>"strain"<\/span>)<\/span>)<\/span>,<\/span>
\n "acceleration"<\/span>:<\/span> float<\/span>(<\/span>row.<\/span>get_value(<\/span>"acceleration"<\/span>)<\/span>)<\/span>,<\/span>
\n "temperature"<\/span>:<\/span> float<\/span>(<\/span>row.<\/span>get_value(<\/span>"temperature"<\/span>)<\/span>)<\/span>,<\/span>
\n "wind_speed"<\/span>:<\/span> float<\/span>(<\/span>row.<\/span>get_value(<\/span>"wind_speed"<\/span>)<\/span>)<\/span>
\n }<\/span>)<\/span><\/p>\n
\n df[<\/span>"timestamp"<\/span>]<\/span> =<\/span> pd.<\/span>to_datetime(<\/span>df[<\/span>"timestamp"<\/span>]<\/span>)<\/span>
\n logger.<\/span>info(<\/span>f"\u52a0\u8f7d\u6570\u636e: <\/span>{<\/span>len<\/span>(<\/span>df)<\/span>}<\/span><\/span> \u6761, \u65f6\u95f4\u8de8\u5ea6: <\/span>{<\/span>df[<\/span>'timestamp'<\/span>]<\/span>.<\/span>min<\/span>(<\/span>)<\/span>}<\/span><\/span> ~ <\/span>{<\/span>df[<\/span>'timestamp'<\/span>]<\/span>.<\/span>max<\/span>(<\/span>)<\/span>}<\/span><\/span>"<\/span><\/span>)<\/span>
\n logger.<\/span>info(<\/span>f"\\\\n<\/span>{<\/span>df.<\/span>describe(<\/span>)<\/span>.<\/span>to_string(<\/span>)<\/span>}<\/span><\/span>"<\/span><\/span>)<\/span><\/p>\n