使用 yamltodb 将 YAML 数据转换为数据框 [英] Conversion of YAML Data to Data Frame using yamltodb

问题描述

我正在尝试通过带有 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()

这篇关于使用 yamltodb 将 YAML 数据转换为数据框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！