# 하위 폴더 순회
count = 0
#확인하기
log_draw =[]
log_lose = []
cont_log_win = []
cont_log_lose = []
draw_log = []

for folder_name in os.listdir(base_path):
    count +=1
    file_count = 0
    folder_name = normalize_korean(folder_name)

    folder_path = os.path.join(base_path, folder_name)
    if not os.path.isdir(folder_path):
        continue

    match = re.search(pattern, folder_name)
    if not match:
        print(f"폴더명 형식 불일치: {folder_name}")
        continue
    #경기 지역이 3이상이면 팀이름이 거의 안나옴 -> 그냥 제외
    stadium = re.search(pattern_stadium, folder_name)
    if len(stadium.group(1))>2:
        print(stadium.group(1))
        continue

    team1, score1, score2, team2 = match.groups()
    score1, score2 = int(score1), int(score2)
    team1, team2 = normalize_korean(team1), normalize_korean(team2)

    # 승패 판단
    if score1 == score2:
        win_team, lose_team = '', ''
        log_draw.append(folder_name)
        draw_log.append([team1,folder_name])
        draw_log.append([team2,folder_name])
    elif score1 > score2:
        win_team, lose_team = team1, team2
        log_lose.append(folder_name)
        cont_log_win.append([win_team, folder_name])
        cont_log_lose.append([lose_team,folder_name])
    else:
        log_lose.append(folder_name)
        win_team, lose_team = team2, team1
        cont_log_win.append([win_team, folder_name])
        cont_log_lose.append([lose_team,folder_name])

    # 폴더 내 파일 순회
    for file in os.listdir(folder_path):
        file_count +=1
        file_path = os.path.join(folder_path, file)
        if not file.endswith('.csv'):
            continue

        file = normalize_korean(file)

        try:
            df = pd.read_csv(file_path)

            if '투구기록' in file:
                if win_team == '':
                    if file_count//2 == 0:
                        df['팀명'] = team2
                    else:
                        df['팀명'] = team1
                    df['경기기록']= folder_name
                    df_draw_pitcher = pd.concat([df_draw_pitcher, df])
                elif win_team in file:
                    df['팀명']= win_team
                    df['경기기록']= folder_name
                    df_win_team_pitcher = pd.concat([df_win_team_pitcher, df])
                elif lose_team in file:
                    df['팀명']= lose_team
                    df['경기기록']= folder_name
                    df_lose_pitcher = pd.concat([df_lose_pitcher, df])

            elif '타격기록' in file:
                if win_team == '':
                    if file_count//2 == 0:
                        df['팀명'] = team2
                    else:
                        df['팀명'] = team1
                    df['경기기록']= folder_name
                    df_draw_bat = pd.concat([df_draw_bat, df])
                elif win_team in file:
                    df['팀명']= win_team
                    df['경기기록']= folder_name
                    df_win_team_bat = pd.concat([df_win_team_bat, df])
                elif lose_team in file:
                    df['팀명']= lose_team
                    df['경기기록']= folder_name
                    df_lose_bat = pd.concat([df_lose_bat, df])

            elif '수비기록' in file:
                if win_team=='':
                    if file_count//2 == 0:
                        df['팀명'] = team2
                    else:
                        df['팀명'] = team1
                    df['경기기록']= folder_name
                    df_draw_field = pd.concat([df_draw_field, df])
                elif win_team in file:
                    df['팀명']= win_team
                    df['경기기록']= folder_name
                    df_win_team_field = pd.concat([df_win_team_field, df])
                elif lose_team in file:
                    df['팀명']= lose_team
                    df['경기기록']= folder_name
                    df_lose_field = pd.concat([df_lose_field, df])

        except Exception as e:
            print(f"오류 발생: {file_path}, {e}")