python - Create JSON from CSV and add some header lines with Pandas - Stack Overflow

IT技术

更新时间：2025-03-100

admin管理员组
文章数量:1292076

I found this post which initially seemed to be exactly what I was looking for but it didn't help me: Adding Header and Footer to JSON output from Python

I have a csv file which I read in as Pandas dataframe:

import os
import csv
import json
import pandas as pd
csvFilePath = "Mypath"
track = pd.read_csv(csvFilePath, header = 0, skiprows = 0, delimiter = ";")

The example csv looks like this:

Param1;Param2;name;lat;lon;altitude;vert_rate;track;speed;category;Param3;Param4;Param5
999999;9999;rocket;57.878696;11.160667;1089;0;137;2;99;999;16;0
999999;9999;rocket;57.878796;11.160668;2543.963336;152638.0483;137;2;99;999;15;0
999999;9999;rocket;57.878896;11.160670;4226.050004;126781.7063;137;2;99;999;14;0
999999;9999;rocket;57.878796;11.160669;6091.207544;121824.349;137;2;99;999;13;0
999999;9999;rocket;57.878696;11.160667;8098.097372;121471.6581;137;2;99;999;12;0

Now I would like to safe this dataframe with an additional header as a JSON file: The additional header looks like this dictionary:

headlines={
           "now": 1636008051.9,
           "messages": 6236,
           }

The aim JSON should contain the information given by "headlines" (but without its name) and the content of the dataframe:

{
  "now": 1636008051.9,
  "messages": 6236,
  "track": [
    {      
      "Param1": 999999,
      "Param2": "9999",
      "name": "rocket",
      "lat":  57.878696,
      "lon": 11.160667,
      "altitude": 1089,
      "vert_rate": 0,
      "track": 137,
      "speed": 2,
      "category": 99,
      "Param3": 999,
      "Param4": 16,
      "Param5": 0
    }
    {      
      "Param1": 999999,
      "Param2": "9999",
      "name": "rocket",
      "lat":  57.878796,
      "lon": 11.160668,
      "altitude": 2543.963336,
      "vert_rate": 152638.0483,
      "track": 137,
      "speed": 2,
      "category": 99,
      "Param3": 999,
      "Param4": 15,
      "Param5": 0
    }
    {      
      "Param1": 999999,
      "Param2": "9999",
      "name": "rocket",
      "lat":  57.878896,
      "lon": 11.160670,
      "altitude": 4226.050004,
      "vert_rate": 126781.7063,
      "track": 137,
      "speed": 2,
      "category": 99,
      "Param3": 999,
      "Param4": 14,
      "Param5": 0
    }
    {...and so on...}
  ]
}

The dataframe itself I can simply turn to JSON like that:

json = track.to_json(path_out + "result.json", orient='records')

but here I don't know how to add the preceding lines from the "header" dict How can I join the dictionary and the csv to output the JSON? Or is there a simpler way? Or any hint to a post which I didn't find? I need to do it in pandas as the csv-dataframe will be further needed.

I found this post which initially seemed to be exactly what I was looking for but it didn't help me: Adding Header and Footer to JSON output from Python

I have a csv file which I read in as Pandas dataframe:

import os
import csv
import json
import pandas as pd
csvFilePath = "Mypath"
track = pd.read_csv(csvFilePath, header = 0, skiprows = 0, delimiter = ";")

The example csv looks like this:

Param1;Param2;name;lat;lon;altitude;vert_rate;track;speed;category;Param3;Param4;Param5
999999;9999;rocket;57.878696;11.160667;1089;0;137;2;99;999;16;0
999999;9999;rocket;57.878796;11.160668;2543.963336;152638.0483;137;2;99;999;15;0
999999;9999;rocket;57.878896;11.160670;4226.050004;126781.7063;137;2;99;999;14;0
999999;9999;rocket;57.878796;11.160669;6091.207544;121824.349;137;2;99;999;13;0
999999;9999;rocket;57.878696;11.160667;8098.097372;121471.6581;137;2;99;999;12;0

Now I would like to safe this dataframe with an additional header as a JSON file: The additional header looks like this dictionary:

headlines={
           "now": 1636008051.9,
           "messages": 6236,
           }

The aim JSON should contain the information given by "headlines" (but without its name) and the content of the dataframe:

{
  "now": 1636008051.9,
  "messages": 6236,
  "track": [
    {      
      "Param1": 999999,
      "Param2": "9999",
      "name": "rocket",
      "lat":  57.878696,
      "lon": 11.160667,
      "altitude": 1089,
      "vert_rate": 0,
      "track": 137,
      "speed": 2,
      "category": 99,
      "Param3": 999,
      "Param4": 16,
      "Param5": 0
    }
    {      
      "Param1": 999999,
      "Param2": "9999",
      "name": "rocket",
      "lat":  57.878796,
      "lon": 11.160668,
      "altitude": 2543.963336,
      "vert_rate": 152638.0483,
      "track": 137,
      "speed": 2,
      "category": 99,
      "Param3": 999,
      "Param4": 15,
      "Param5": 0
    }
    {      
      "Param1": 999999,
      "Param2": "9999",
      "name": "rocket",
      "lat":  57.878896,
      "lon": 11.160670,
      "altitude": 4226.050004,
      "vert_rate": 126781.7063,
      "track": 137,
      "speed": 2,
      "category": 99,
      "Param3": 999,
      "Param4": 14,
      "Param5": 0
    }
    {...and so on...}
  ]
}

The dataframe itself I can simply turn to JSON like that:

json = track.to_json(path_out + "result.json", orient='records')

but here I don't know how to add the preceding lines from the "header" dict How can I join the dictionary and the csv to output the JSON? Or is there a simpler way? Or any hint to a post which I didn't find? I need to do it in pandas as the csv-dataframe will be further needed.

Share Improve this question asked Feb 13 at 10:05 Swawa 2113 silver badges14 bronze badges

Add a comment |

1 Answer 1

Sorted by: Reset to default 2

Create a dictionary, assign it as a new dictionary key and export with json.dump:

import json

headlines['track'] = df.to_dict(orient='records')

with open(path_out + 'result.json', 'w') as f:
    json.dump(headlines, f)

Or as a string:

import json

headlines['track'] = df.to_dict(orient='records')

print(json.dumps(headlines, indent=2))

Output:

{
  "now": 1636008051.9,
  "messages": 6236,
  "track": [
    {
      "Param1": 999999,
      "Param2": 9999,
      "name": "rocket",
      "lat": 57.878696,
      "lon": 11.160667,
      "altitude": 1089.0,
      "vert_rate": 0.0,
      "track": 137,
      "speed": 2,
      "category": 99,
      "Param3": 999,
      "Param4": 16,
      "Param5": 0
    },
    {
      "Param1": 999999,
      "Param2": 9999,
      "name": "rocket",
      "lat": 57.878796,
      "lon": 11.160668,
      "altitude": 2543.963336,
      "vert_rate": 152638.0483,
      "track": 137,
      "speed": 2,
      "category": 99,
      "Param3": 999,
      "Param4": 15,
      "Param5": 0
    },
    {
      "Param1": 999999,
      "Param2": 9999,
      "name": "rocket",
      "lat": 57.878896,
      "lon": 11.16067,
      "altitude": 4226.050004,
      "vert_rate": 126781.7063,
      "track": 137,
      "speed": 2,
      "category": 99,
      "Param3": 999,
      "Param4": 14,
      "Param5": 0
    },
    {
      "Param1": 999999,
      "Param2": 9999,
      "name": "rocket",
      "lat": 57.878796,
      "lon": 11.160669,
      "altitude": 6091.207544,
      "vert_rate": 121824.349,
      "track": 137,
      "speed": 2,
      "category": 99,
      "Param3": 999,
      "Param4": 13,
      "Param5": 0
    },
    {
      "Param1": 999999,
      "Param2": 9999,
      "name": "rocket",
      "lat": 57.878696,
      "lon": 11.160667,
      "altitude": 8098.097372,
      "vert_rate": 121471.6581,
      "track": 137,
      "speed": 2,
      "category": 99,
      "Param3": 999,
      "Param4": 12,
      "Param5": 0
    }
  ]
}

本文标签： pythonCreate JSON from CSV and add some header lines with PandasStack Overflow

版权声明：本文标题：python - Create JSON from CSV and add some header lines with Pandas - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人，转载请联系作者并注明出处：http://www.betaflare.com/web/1741549514a2384793.html，本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。

编程频道|软件玩家 - 软件改变生活！

python - Create JSON from CSV and add some header lines with Pandas - Stack Overflow

1 Answer 1

更多相关文章