python - 当数据框中值为 null 时，如何删除 json 对象中的元素？

Question

我有一个像这样的数据框:

   data
0  {"a": null, "b": 12, "c": null}
1  {"a": 15, "b": 12, "c": null}
2  {"a": 23, "b": 8, "c": null}
3  {"a": 5, "b":null, "c": null}

如果值为空，是否可以删除该元素？

输出如下:

   data
0  {"b": 12}
1  {"a": 15, "b": 12}
2  {"a": 23, "b": 8}
3  {"a": 5}

Answer 1

怎么样:

data = """[
{"a": null, "b": 12, "c": null},
{"a": 15, "b": 12, "c": null},
{"a": 23, "b": 8, "c": null},
{"a": 5, "b":null, "c": null}
]"""
data = eval(data.replace("null", '"null"'))
fixed_rows = [{key: val for key, val in row.items() if val != "null"} for row in data]