import requests
import json
import pandas

thread = 1108576

responce = json.loads(requests.get(f'https://2ch.hk/kpop/res/{thread}.json').content)


posts = responce["threads"][0]["posts"]

data_set = []

for post in posts:
    icon_name = None

    if str(post).find("icon") > 0:
        icon = post['icon']
        icon_title_index = icon.index('title=')+6
        icon_name = icon[icon_title_index:-2:]

    likes = post['likes']
    dislikes = post['dislikes']
    name = post['name']
    num = post['num']

    row = [num, name, icon_name, likes, dislikes]
    data_set.append(row)

xlsx_rows = pandas.DataFrame(data_set, columns=['num', 'name', 'icon', 'likes', 'dislikes'])
with pandas.ExcelWriter('kpop.xlsx') as excel:
    xlsx_rows.to_excel(excel)