Python jsonpath库处理JSON数据

妖狐艹你老母 2023-10-05 21:33 20阅读 0赞

jsonpath官方文档：[https://goessner.net/articles/JsonPath/][https_goessner.net_articles_JsonPath]

**1.语法：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70][]

**2.bookstore.xml文件案例：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 1][] ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 2][]

**3.安装第三方库 pip install jsonpath**

查看 pip list

![20210419112525843.png][]

**4.json文件**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 3][]

code:

#使用jsonpath方法
    def usejsonpath():
        #1.url
        url='https://www.lagou.com/lbs/getAllCitySearchLabels.json'
        #2.请求头信息
        headers={
          'User-Agent':ua.random
        }
        #3.响应数据
        res=requests.get(url,headers=headers)
        # print(res.text)
    
        #4.将json字符串转换成python字典
        dic=json.loads(res.text)
        print(dic)
    
        # 第一种:通过jsonpath
        # 提取A里面的所有name元素
        #$.根节点content所有数据
        # result =jsonpath(dic,'$.content')
        #$..A的数据
        # result =jsonpath(dic,'$..A')
        #$..A的name数据
        # result =jsonpath(dic,'$..A[*].name')
    
        # 获取到所有的name
        # $ 代表从根节点开始 
        # ..是不管什么位置
        result =jsonpath(dic,'$..name')
        # print(result)
    
        # 第二种:通过字典的键取值
        resBList=dic['content']['data']['allCitySearchLabels']['B']
        # print(resBList)
        # #循环列表
        for res in resBList:
            print(res)
            # print(res['name'])

![20210419114216705.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 4][]

**总之： 使用了jsonpath与字典取值，但比较一下，其实jsonpath要简单，而字典就是要层层进入，再循环遍历。**

[https_goessner.net_articles_JsonPath]: https://goessner.net/articles/JsonPath/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20210419112049714.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20210419112250311.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20210419112311132.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4,size_16,color_FFFFFF,t_70
[20210419112525843.png]: https://img-blog.csdnimg.cn/20210419112525843.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20210419113330104.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4,size_16,color_FFFFFF,t_70
[20210419114216705.png]: https://img-blog.csdnimg.cn/20210419114216705.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20210419114313768.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4,size_16,color_FFFFFF,t_70