python生成json文件,使用Python从JSON创建数据结构

I'm new to python and I have a json file that I'm trying to use to create a data structure using python.

Here is a sample of what one of the lines would look like:

[{'name': 'Nick', 'age': '35', 'city': 'New York'}...]

I read it into memory, but am unsure what additional steps I would need to take to use it to create a table.

Here is what I have tried so far:

import json

import csv

from pprint import pprint

with open("/desktop/customer_records.json") as customer_records:

data=json.load(customer_records)

for row in data:

print(row)

Ideally, I would it in the following format:

Name Age City

Nick 35 New York

Any help would be appreciated. Thanks in advance.

解决方案

Your problem is not specified too precisely, but if you want to generate SQL that can be inserted into MySQL, here's a little program that converts JSON to a sequence of SQL statements:

#!/usr/bin/env python

import json

# Load data

with open("zz.json") as f:

data=json.load(f)

# Find all keys

keys = []

for row in data:

for key in row.keys():

if key not in keys:

keys.append(key)

# Print table definition

print """CREATE TABLE MY_TABLE(

{0}

);""".format(",\n ".join(map(lambda key: "{0} VARCHAR".format(key), keys)))

# Now, for all rows, print values

for row in data:

print """INSERT INTO MY_TABLE VALUES({0});""".format(

",".join(map(lambda key: "'{0}'".format(row[key]) if key in row else "NULL", keys)))

For this JSON file:

[

{"name": "Nick", "age": "35", "city": "New York"},

{"name": "Joe", "age": "21", "city": "Boston"},

{"name": "Alice", "city": "Washington"},

{"name": "Bob", "age": "49"}

]

It generates

CREATE TABLE MY_TABLE(

city VARCHAR,

age VARCHAR,

name VARCHAR

);

INSERT INTO MY_TABLE VALUES('New York','35','Nick');

INSERT INTO MY_TABLE VALUES('Boston','21','Joe');

INSERT INTO MY_TABLE VALUES('Washington',NULL,'Alice');

INSERT INTO MY_TABLE VALUES(NULL,'49','Bob');

And for the future, please make your question WAY more specific :)