python数据分析之 json解析

@@python数据分析之json解析

python数据分析之json串解析

非结构化数据json串

param = { “@hostAddr”:“10.2.43.96”
,“message”:“{“cpCooperationMode”:3,“date”:“2021-04-20 11:38:16”
,“copyright”:“CN”
,“langInfo”:[{“country”:“CN”,“lang”:“zh”}]
,“eventCategory”:“a001”
,“channel”:201,“rating”:[{“system”:“China”
,“level”:“Adults” ,“ratingAge”:0}]
,“source”:“SnapShotCarShow”
,“hiBoardDocId”:“826140605_901_kuran1034=4628021517418579”
,“multiUrlDistribution”:0 ,“dislikeReasonCodes”:[]
,“dislikeReasons”:[]
,“image”:“https://contentcenter.dbankcdn.com/pub_1/AssistService_WiseInfo_100_1/89/v3/yI726Xe7Rym6PEcAt7IN8w/6eaa26b4-8205-4352-bad6-38f9880bded9.jpg”
,“hiBoardCpType”:1
,“contentSyncPolicy”:0,“dtype”:21,“pageLevel”:“1”
,“eventType”:“WITHTAGCONTENT”,“hwDocId”:“kuran1034=4628021517418579”
,“expirationAt”:“20591213”,“labels”:“奔驰,德系,轿车”,“tags”:[]
,“isGreen”:“false”,“functionID”:“0”,“ctype”:“video_live”
,“huaweiVideoSpId”:“12”,“authority”:0,“pageQuality”:“1”,“businessTag”:[]
,“isHot”:“2”,“simHash”:[2184298192,371685435],“status”:1,“eventID”:“2d961d8f184ed5ba96c1c6aa6fbb1b0438e36359b44f472a”
,“isGreat”:“2”,“subcat”:“汽车随拍”,“title”:“Mercedes-BenzE55AMGW211BrutalExhaust”,“multiShareUrlData”:[]
,“multiUrlData”:[],“duration”:294
,“iconOfSource”:“https://cinema-pics-drcn.dbankcdn.com/mmp/img/categ5/20190511/11/15575445519923467.jpg”
,“videoUrl”:”{\“spVolumeId\”:\“1034=4628021517418579\”,\“mvId\”:\“kuran1034=4628021517418579\”
,\“volumeId\”:\“kuran1034=4628021517418579\”,\“spId\”:\“12\”}“,“eventTime”:“20210420154533”
,“wiseInfoEntities”:{“Mercedes”:15.123446271751328},“categories”:“xg06000000”,“realDate”:“2021-04-20
11:38:16”
,“timestamp”:1618904733507,“sourceID”:“201905111115518170001125000000”,“summary”:“Mercedes-BenzE55AMGW211BrutalExhaust”
,“green”:false,“cpID”:“901”
,“docid”:“kuran1034=4628021517418579”
,“url”:“https://portal-drcn.video.cloud.huawei.com/share/shortvod/929/kuran1034=4628021517418579.html”
,“videoSize”:{},“imageUrls”:[],“recommPeriod”:“1”,“locations”:[],“category”:“汽车”
,“effectiveFrom”:“20210420”}”
,“@hostName”:“ncn2a-hwassistant-DataCenterService-2-43-96”
,“@logType”:“wiseinfo-feedcontent-to-hive”}

param={
   
"@hostAddr":"10.2.43.96"\
,"message":"{
   \"cpCooperationMode\":3,\"date\":\"2021-04-20 <