将
import yaml
import pandas as pddef yaml_to_excel(yaml_file, excel_file):# 读取YAML文件with open(yaml_file, 'r', encoding='utf-8') as file:data = yaml.safe_load(file)# 如果是列表数据if isinstance(data, list):df = pd.DataFrame(data)# 如果是嵌套字典elif isinstance(data, dict):# 尝试展平嵌套结构normalized = pd.json_normalize(data, sep='_')df = pd.DataFrame(normalized)else:df = pd.DataFrame([data])# 保存为Exceldf.to_excel(excel_file, index=False)print(f"转换完成！文件已保存为: {excel_file}")# 使用示例
yaml_to_excel('470.yaml', 'output.xlsx')