如何将CLI命令输出转换为表格并保存为DataFrame
CLI输出转换后的中文表格
| 类型 | 状态 | F | S | P | VPI | VCI | 标签 |
|---|---|---|---|---|---|---|---|
| vdl | down | 0 | 3 | 62 | 0 | 35 | 390 |
| vdl | down | 0 | 3 | 62 | - | - | 390 |
| vdl | up | 0 | 4 | 49 | 0 | 35 | 453 |
| vdl | up | 0 | 4 | 49 | - | - | 453 |
| vdl | down | 0 | 2 | 26 | 0 | 35 | 278 |
| vdl | down | 0 | 2 | 26 | - | - | 278 |
| vdl | up | 0 | 2 | 30 | 0 | 35 | 282 |
| vdl | up | 0 | 2 | 30 | - | - | 282 |
| vdl | up | 0 | 4 | 62 | 0 | 35 | 466 |
| vdl | up | 0 | 4 | 62 | - | - | 466 |
| vdl | down | 0 | 2 | 20 | 0 | 35 | 272 |
| vdl | down | 0 | 2 | 20 | - | - | 272 |
转换为DataFrame的Python代码
import pandas as pd # 整理CLI输出数据 data = [ ["vdl", "down", 0, 3, 62, "0", "35", 390], ["vdl", "down", 0, 3, 62, "-", "-", 390], ["vdl", "up", 0, 4, 49, "0", "35", 453], ["vdl", "up", 0, 4, 49, "-", "-", 453], ["vdl", "down", 0, 2, 26, "0", "35", 278], ["vdl", "down", 0, 2, 26, "-", "-", 278], ["vdl", "up", 0, 2, 30, "0", "35", 282], ["vdl", "up", 0, 2, 30, "-", "-", 282], ["vdl", "up", 0, 4, 62, "0", "35", 466], ["vdl", "up", 0, 4, 62, "-", "-", 466], ["vdl", "down", 0, 2, 20, "0", "35", 272], ["vdl", "down", 0, 2, 20, "-", "-", 272] ] # 设置中文列名 columns = ["类型", "状态", "F", "S", "P", "VPI", "VCI", "标签"] # 创建DataFrame df = pd.DataFrame(data, columns=columns) # 可直接查看或保存DataFrame print(df)
内容的提问来源于stack exchange,提问作者asmaa mahmoud
相关产品推荐
相关产品推荐

