python如何循环获取其中的数据

zxx1988328

背景：日志文件每行的数据 ，每个手机用户的不同时间的状态值，想获取每行当中的最新的status的值，条件是根据uodatetime时间段判断是最新的status，处理前的数据是如下是四行，而且每行的json串不固定，比如第一行是4个，第二行是2个，第三行是1个，处理后的数据也是四行，每行获取一个最新的status的值，求各位大牛，如何处理

1. [{"status":2,"mobile":13912345678,"updatetime":"2016-08-29 09:34:07"},{"status":2,"mobile":13912345678,"updatetime":"2016-08-17 12:18:10"},{"status":5,"mobile":13912345678,"updatetime":"2016-08-17 12:14:09"},{"status":4,"mobile":13912345678,"updatetime":"2016-08-17 12:05:23"}]
   
2. [{"status":2,"mobile":13312345678,"updatetime":"2016-05-15 22:07:33"}]
   
3. [{"status":1,"mobile":17712345678,"updatetime":"2016-02-29 09:34:07"},{"status":5,"mobile":17712345678,"updatetime":"2016-08-17 12:14:09"},{"status":5,"mobile":17712345678,"updatetime":"2016-08-17 12:05:23"}]
   
4. [{"status":3,"mobile":15512345678,"updatetime":"2016-02-29 09:34:07"},{"status":1,"mobile":15512345678,"updatetime":"2016-08-17 12:05:23"}]
   

复制代码

处理后的数据格式
status 2
status 1
status 5
status 3

ulmer

1. the json data is like dictionary of list
2. sort values fron dictionary
3. reverse it to make newest  updatetime to first

Sample:
json_data = [{"status":2,"mobile":13912345678,"updatetime":"2016-08-29 09:34:07"},{"status":2,"mobile":13912345678,"updatetime":"2016-08-17 12:18    :10"},{"status":5,"mobile":13912345678,"updatetime":"2016-08-17 12:14:09"},{"status":4,"mobile":13912345678,"updatetime":"2016-08-17 12:05:23"}]
newlist = sorted(json_data, key=lambda k: k['updatetime'])

print json_data
print newlist
revlist =  list(reversed(newlist))
print revlist

ulmer

Make your data [..][..].. as valid json data structure like: [ [..], .., [..] ]
Put(or read from a file) them into a variable, which you will get full valid json data.
You can access this json's variable to do what you want!

Sample:
test_data_file.json:

1. [
   
2. [{"status":2,"mobile":13912345678,"updatetime":"2016-08-29 09:34:07"},{"status":2,"mobile":13912345678,"updatetime":"2016-08-17 12:18:10"},{"status":5,"mobile":13912345678,"updatetime":"2016-08-17 12:14:09"},{"status":4,"mobile":13912345678,"updatetime":"2016-08-17 12:05:23"}],
   
3. [{"status":2,"mobile":13312345678,"updatetime":"2016-05-15 22:07:33"}],
   
4. [{"status":1,"mobile":17712345678,"updatetime":"2016-02-29 09:34:07"},{"status":5,"mobile":17712345678,"updatetime":"2016-08-17 12:14:09"},{"status":5,"mobile":17712345678,"updatetime":"2016-08-17 12:05:23"}],
   
5. [{"status":3,"mobile":15512345678,"updatetime":"2016-02-29 09:34:07"},{"status":1,"mobile":15512345678,"updatetime":"2016-08-17 12:05:23"}]
   
6. ]
   
7. 
   

复制代码

test.py:

1. 
   
2. import json
   
3. 
   
4. file_path = './test_data_file.json'
   
5. data_records = [];
   
6. with open (file_path) as json_data:
   
7.     data_records = json.load(json_data)
   
8. 
   
9. # call all updatetime's value in the first data record:
   
10. print(data_records[0][0]['updatetime'])
    

复制代码

ulmer

Refreshed

zxx1988328

回复 2# ulmer
大神英文这么好，代码也写的这么牛逼，厉害了，能再接着指点一下，如何获取每行的最新的status的值吗，允许直接可以获得最终的结果：

1. status:1
   
2. status:2
   
3. status:5
   
4. status:1

复制代码

yizuwei520

import json
path ='你的这个文件存放路径‘
records = [json.loads(line) for line in open(path)]
status = [rec['status'] for rec in records if 'status' in rec]

yizuwei520

import json
path = '文件名.txt'
reccords = [json.loads(line) for line in open(path)]
status_count = [rec['status'] for rec in records if 'status' in rec]