使用 yamltodb 将 YAML 数据转换为数据框

2022-01-14 00:00:00 python pandas yaml

问题描述

我正在尝试通过带有 yamltodb 包的 pandas 将 YAML 数据转换为数据框.但它只显示带有标题的单行，并且只显示一个数据.我尝试将 Yaml 文件转换为 JSON 文件，然后尝试规范化功能.但这行不通.附上 JSON 函数输出的截图.我需要将其归类为蝙蝠侠、投球手和跑步等.代码输出图像及其代码..

I am Trying to convert the YAML Data to Data frame through pandas with yamltodb package. but it is showing only the single row enclosed with header and only one data is showing. I tried to convert the Yaml file to JSON file and then tried normalize function. But it is not working out. Attached the screenshot for JSON function output. I need to categorize it under batman, bowler and runs etc. Code Output Image and their code..

解决方案

只是猜测，因为我不知道您的数据实际上是什么样的

Just guessing, as I don’t know what your data actually looks like 

import pandas as pd
import yaml

with open('fName.yaml', 'r') as f:
    df = pd.io.json.json_normalize(yaml.load(f))

df.head()

相关文章