業務連絡　カツ丼向け　その２☆（＾ｑ＾）

# py -m pip install pandas
import pandas as pd
import json

df = pd.read_csv('./kifuwarabe-result.csv')

def main():
    print("hello.world")
    print(df)
    print("hello.world2")

    buf = '{"gameResult":[\n'

    # len(df)
    for i in range(0, len(df)):
        buf = round(buf, i)
    # 末尾のカンマを外す
    if buf.endswith(','):
        buf = buf[:-1]

    buf += "]}"

    print(buf)
    print("hello.world3")

    data = json.loads(buf)
    with open('kifuwarabe-result.json', 'w') as writer:
        a = json.dumps(data, indent=2)
        print(a)
        writer.write(a)

def round(buf:str, row:int):
    return f"""{buf}
{{
    "round":"{df.iloc[row]["round"]}",
    "name":"{df.iloc[row]["name"]}",
    "result1":"{df.iloc[row]["result1"]}",
    "result2":"{df.iloc[row]["result2"]}",
    "link1":"{df.iloc[row]["link1"]}",
    "link2":"{df.iloc[row]["link2"]}"
}},"""

main()