专家 Prompt 版 FFT 幅值谱导出
本报告严格围绕 policy/originrequirement.txt:从事件 CSV 指定的文件与发生时间截取波形,
做非 2 次幂补零的 FFT,输出 0Hz,100Hz,200Hz,...,1000000Hz 的幅值谱。
输出口径
- csv_duration:按 CSV 中
时长/单位秒 截取。
- fixed_10ms:同一发生时间起,统一截取 10ms,即 2MHz 下 20000 点。
- 两套口径都使用不补零 FFT;若原始频点不是 100Hz 网格,则插值到 100Hz 网格导出。
- 幅值谱为
|rfft(x-mean)| 的单边峰值幅值标定结果,不是功率谱。
汇总
{
"events_csv": "/Users/mv/Desktop/cncmock/policy/副本传生2M采集记录.csv",
"raw_dir": "/Users/mv/Desktop/cncmock/1-机床移动",
"valid_event_count": 22,
"variants": [
"csv_duration",
"fixed_10ms"
],
"frequency_grid_hz": "0..1000000 step 100",
"compact_rows": 142,
"wide_rows": 142,
"qc_status_counts": {
"ok": 44
},
"note": "FFT is non-zero-padded. Export grid is interpolated to 100 Hz for comparison."
}
QC 明细
| variant | event_index | project | data_name | channel_count | requested_duration_s | actual_samples | fft_bin_hz | status |
|---|
| csv_duration | 1 | 吹气 | 1-机床移动 26-07-06 17-11-19 | 2 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 1 | 吹气 | 1-机床移动 26-07-06 17-11-19 | 2 | 1.00% | 20000 | 100 | ok |
| csv_duration | 2 | 敲击放大器-清诚1 | 1-机床移动 26-07-06 17-16-27 | 2 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 2 | 敲击放大器-清诚1 | 1-机床移动 26-07-06 17-16-27 | 2 | 1.00% | 20000 | 100 | ok |
| csv_duration | 3 | 敲击放大器-清诚2 | 1-机床移动 26-07-06 17-19-14 | 2 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 3 | 敲击放大器-清诚2 | 1-机床移动 26-07-06 17-19-14 | 2 | 1.00% | 20000 | 100 | ok |
| csv_duration | 4 | F600--T10-L100:X+ | 1-机床移动 26-07-07 10-46-12 | 3 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 4 | F600--T10-L100:X+ | 1-机床移动 26-07-07 10-46-12 | 3 | 1.00% | 20000 | 100 | ok |
| csv_duration | 5 | F60--T10-L10:X+ | 1-机床移动 26-07-07 11-34-54 | 3 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 5 | F60--T10-L10:X+ | 1-机床移动 26-07-07 11-34-54 | 3 | 1.00% | 20000 | 100 | ok |
| csv_duration | 6 | 门-敲 | 1-机床移动 26-07-07 13-44-32 | 3 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 6 | 门-敲 | 1-机床移动 26-07-07 13-44-32 | 3 | 1.00% | 20000 | 100 | ok |
| csv_duration | 7 | 门-拍 | 1-机床移动 26-07-07 13-44-32 | 3 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 7 | 门-拍 | 1-机床移动 26-07-07 13-44-32 | 3 | 1.00% | 20000 | 100 | ok |
| csv_duration | 8 | 左钣金-敲 | 1-机床移动 26-07-07 13-45-47 | 3 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 8 | 左钣金-敲 | 1-机床移动 26-07-07 13-45-47 | 3 | 1.00% | 20000 | 100 | ok |
| csv_duration | 9 | 左钣金-拍 | 1-机床移动 26-07-07 13-45-47 | 3 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 9 | 左钣金-拍 | 1-机床移动 26-07-07 13-45-47 | 3 | 1.00% | 20000 | 100 | ok |
| csv_duration | 10 | X左护罩-敲 | 1-机床移动 26-07-07 13-47-48 | 3 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 10 | X左护罩-敲 | 1-机床移动 26-07-07 13-47-48 | 3 | 1.00% | 20000 | 100 | ok |
| csv_duration | 11 | X左护罩-拍 | 1-机床移动 26-07-07 13-47-48 | 3 | 0.40% | 8000 | 250 | ok |
| fixed_10ms | 11 | X左护罩-拍 | 1-机床移动 26-07-07 13-47-48 | 3 | 1.00% | 20000 | 100 | ok |
| csv_duration | 12 | 工作台-敲 | 1-机床移动 26-07-07 13-48-46 | 3 | 0.50% | 10000 | 200 | ok |
| fixed_10ms | 12 | 工作台-敲 | 1-机床移动 26-07-07 13-48-46 | 3 | 1.00% | 20000 | 100 | ok |
| csv_duration | 13 | 工作台-拍 | 1-机床移动 26-07-07 13-48-46 | 3 | 0.50% | 10000 | 200 | ok |
| fixed_10ms | 13 | 工作台-拍 | 1-机床移动 26-07-07 13-48-46 | 3 | 1.00% | 20000 | 100 | ok |
| csv_duration | 14 | 静止 | 1-机床移动 26-07-07 13-53-45 | 3 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 14 | 静止 | 1-机床移动 26-07-07 13-53-45 | 3 | 1.00% | 20000 | 100 | ok |
| csv_duration | 15 | 关机 | 1-机床移动 26-07-07 14-27-36 | 4 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 15 | 关机 | 1-机床移动 26-07-07 14-27-36 | 4 | 1.00% | 20000 | 100 | ok |
| csv_duration | 16 | 急停-未开启系统 | 1-机床移动 26-07-07 14-29-14 | 4 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 16 | 急停-未开启系统 | 1-机床移动 26-07-07 14-29-14 | 4 | 1.00% | 20000 | 100 | ok |
| csv_duration | 17 | 关机 | 1-机床移动 26-07-07 15-00-06 | 4 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 17 | 关机 | 1-机床移动 26-07-07 15-00-06 | 4 | 1.00% | 20000 | 100 | ok |
| csv_duration | 18 | 上电 | 1-机床移动 26-07-07 15-00-55 | 4 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 18 | 上电 | 1-机床移动 26-07-07 15-00-55 | 4 | 1.00% | 20000 | 100 | ok |
| csv_duration | 19 | 开机-急停 | 1-机床移动 26-07-07 15-04-28 | 4 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 19 | 开机-急停 | 1-机床移动 26-07-07 15-04-28 | 4 | 1.00% | 20000 | 100 | ok |
| csv_duration | 20 | 静止 | 1-机床移动 26-07-07 15-16-02 | 4 | 1.00% | 20000 | 100 | ok |
| fixed_10ms | 20 | 静止 | 1-机床移动 26-07-07 15-16-02 | 4 | 1.00% | 20000 | 100 | ok |
| csv_duration | 21 | D4M4:-0.010mm/L6mm/F120/S500/T3 | 1-机床移动 26-07-07 16-51-45 | 4 | 0.50% | 10000 | 200 | ok |
| fixed_10ms | 21 | D4M4:-0.010mm/L6mm/F120/S500/T3 | 1-机床移动 26-07-07 16-51-45 | 4 | 1.00% | 20000 | 100 | ok |
| csv_duration | 22 | D4M3:0.010mm/L6mm/F120/S500/T3 | 1-机床移动 26-07-07 16-59-18 | 4 | 2.00% | 40000 | 50 | ok |
| fixed_10ms | 22 | D4M3:0.010mm/L6mm/F120/S500/T3 | 1-机床移动 26-07-07 16-59-18 | 4 | 1.00% | 20000 | 100 | ok |