我有一个类似这样的列表:
[
{
"timeline": "2014-10",
"total_prescriptions": 17
},
{
"timeline": "2014-11",
"total_prescriptions": 14
},
{
"timeline": "2014-12",
"total_prescriptions": 8
{
"timeline": "2015-1",
"total_prescriptions": 4
},
{
"timeline": "2015-3",
"total_prescriptions": 10
},
{
"timeline": "2015-4",
"total_prescriptions": 3
}
]
这基本上是Django中原始SQL查询的输出,它按月计算total_prescriptions并按升序排列数据。然而,MYSQL count的性质是对于null值不会返回0。因此,二月份完全被跳过,而不是有一个total_prescriptions等于0的条目。
我打算在Python中遍历列表,并手动添加所有缺失月份的total_prescriptions = 0,以便输出看起来像这样:
[
{
"timeline": "2014-10",
"total_prescriptions": 17
},
{
"timeline": "2014-11",
"total_prescriptions": 14
},
{
"timeline": "2014-12",
"total_prescriptions": 8
{
"timeline": "2015-1",
"total_prescriptions": 4
},
{
"timeline": "2015-2",
"total_prescriptions": 0
},
{
"timeline": "2015-3",
"total_prescriptions": 10
},
{
"timeline": "2015-4",
"total_prescriptions": 3
}
]
我该如何做到这一点?