import json
import csv
from datetime import datetime
path_f = "followers_tk.txt"
output = "followers_tk_info.csv"
f_list = []
output_list = []
with open(path_f, 'r', encoding='utf-8') as f:
for line in f:
line = line.strip()
if not line:
continue
try:
data = json.loads(line)["userList"]
# print(f"{len(data)} data added")
f_list.extend(data)
except json.JSONDecodeError as e:
print(e)
f_len = len(f_list)
print(f"{f_len} data loaded")
for i, f in enumerate(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("")
with open(output, mode='w', newline='', encoding='utf-8-sig') as f:
writer = csv.DictWriter(f, fieldnames=output_list[0].keys())
writer.writeheader()
writer.writerows(output_list)
print(f"saved: {output}")