importjsonimportcsvfromdatetimeimportdatetimepath_f="followers_tk.txt"output="followers_tk_info.csv"f_list=[]output_list=[]withopen(path_f,'r',encoding='utf-8')asf:forlineinf:line=line.strip()ifnotline:continuetry:data=json.loads(line)["userList"]# print(f"{len(data)} data added")f_list.extend(data)exceptjson.JSONDecodeErrorase:print(e)f_len=len(f_list)print(f"{f_len} data loaded")fori,finenumerate(f_list):output_list.append({"id":f["user"]["id"],"nickname":f["user"]["nickname"],"secUid":f["user"]["secUid"],"uniqueId":f["user"]["uniqueId"],"verified":f["user"]["verified"],"diggCount":f["stats"]["diggCount"],"followerCount":f["stats"]["followerCount"],"followingCount":f["stats"]["followingCount"],"friendCount":f["stats"]["friendCount"],"heart":f["stats"]["heart"],"heartCount":f["stats"]["heartCount"],"videoCount":f["stats"]["videoCount"],})print(f"\r[{i}] ok",end="")print("")withopen(output,mode='w',newline='',encoding='utf-8-sig')asf:writer=csv.DictWriter(f,fieldnames=output_list[0].keys())writer.writeheader()writer.writerows(output_list)print(f"saved: {output}")
Warning
LINK
You are about to visit a link which has been flagged with the above content warnings. Do you wish to continue?