{"id":512,"date":"2025-09-09T19:35:33","date_gmt":"2025-09-09T10:35:33","guid":{"rendered":"http:\/\/qmac.kr\/wordpress\/?p=512"},"modified":"2025-09-09T19:35:33","modified_gmt":"2025-09-09T10:35:33","slug":"%eb%b0%b0%eb%93%9c%eb%af%bc%ed%84%b4-%ec%98%88%ec%84%a0%ea%b2%bd%ea%b8%b0-%ec%9d%bc%ec%a0%95%ec%9d%84-vs-code-ai-%ec%97%90%ec%84%9c-xlsx-%ed%8c%8c%ec%9d%bc-%ec%83%9d%ec%84%b1%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/qmac.kr\/wordpress\/%eb%b0%b0%eb%93%9c%eb%af%bc%ed%84%b4-%ec%98%88%ec%84%a0%ea%b2%bd%ea%b8%b0-%ec%9d%bc%ec%a0%95%ec%9d%84-vs-code-ai-%ec%97%90%ec%84%9c-xlsx-%ed%8c%8c%ec%9d%bc-%ec%83%9d%ec%84%b1%ed%95%98%ea%b8%b0\/","title":{"rendered":"\ubc30\ub4dc\ubbfc\ud134 \uc608\uc120\uacbd\uae30 \uc77c\uc815\uc744 VS Code AI \uc5d0\uc11c xlsx \ud30c\uc77c \uc0dd\uc131\ud558\uae30."},"content":{"rendered":"\n

\uc774 \ub178\ud2b8\ubd81 \ud30c\uc77c\uc740 \ubc30\ub4dc\ubbfc\ud134 \uacbd\uae30 \uc77c\uc815 \ub370\uc774\ud130\ub97c \ubd84\uc11d\ud558\uace0, \ub4dc\ub9bc\ud074\ub7fd\uc774 \ucc38\uc5ec\ud558\ub294 \uacbd\uae30\ub9cc \ucd94\ub824\uc11c \uc5d1\uc140 \ud30c\uc77c\ub85c \uc800\uc7a5\ud558\ub294 \uacfc\uc815\uc744 \ub2f4\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ucd08\ubcf4\uc790\ub97c \uc704\ud574 \uac01 \ub2e8\uacc4\ubcc4\ub85c \uc27d\uac8c \uc124\uba85\ub4dc\ub9ac\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n\n\n\n

    \n
  1. \ud544\uc694\ud55c \ub77c\uc774\ube0c\ub7ec\ub9ac \ubd88\ub7ec\uc624\uae30<\/strong><\/li>\n<\/ol>\n\n\n\n
      \n
    • pandas<\/code>, numpy<\/code>, re<\/code> \ub4f1 \ub370\uc774\ud130\ub97c \ub2e4\ub8e8\uae30 \uc704\ud55c \ud30c\uc774\uc36c \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \ubd88\ub7ec\uc635\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n
        \n
      1. \ud14d\uc2a4\ud2b8 \ud30c\uc77c\uc5d0\uc11c \ub370\uc774\ud130 \uc77d\uae30<\/strong><\/li>\n<\/ol>\n\n\n\n
          \n
        • \uacbd\uae30 \uc77c\uc815\uc774 \ub2f4\uae34 \ud14d\uc2a4\ud2b8 \ud30c\uc77c(0913.txt, 0914.txt)\uc744 \ud55c \uc904\uc529 \uc77d\uc5b4\uc635\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n
            \n
          1. \uacbd\uae30 \uc815\ubcf4 \ucd94\ucd9c<\/strong><\/li>\n<\/ol>\n\n\n\n
              \n
            • \uac01 \uc904\uc744 \ubd84\uc11d\ud574\uc11c \ucf54\ud2b8, \uacbd\uae30 \uc2dc\uac04, \uacbd\uae30\uc885\ubaa9, \ud074\ub7fd \uc774\ub984, \uc120\uc218 \uc774\ub984 \ub4f1 \ud544\uc694\ud55c \uc815\ubcf4\ub97c \ubf51\uc544\ub0c5\ub2c8\ub2e4.<\/li>\n\n\n\n
            • \ud55c \uacbd\uae30\uc758 \uc815\ubcf4\uac00 \ubaa8\ub450 \ubaa8\uc774\uba74 \ub9ac\uc2a4\ud2b8\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n
                \n
              1. \ub4dc\ub9bc\ud074\ub7fd \uacbd\uae30\ub9cc \ucd94\ub9ac\uae30<\/strong><\/li>\n<\/ol>\n\n\n\n
                  \n
                • \uc804\uccb4 \uacbd\uae30 \uc911\uc5d0\uc11c \ub4dc\ub9bc\ud074\ub7fd\uc774 \ucc38\uc5ec\ud55c \uacbd\uae30\ub9cc \uace8\ub77c\ub0c5\ub2c8\ub2e4.<\/li>\n\n\n\n
                • \ub9cc\uc57d \ub4dc\ub9bc\ud074\ub7fd\uc774 \uc0c1\ub300\ud300\uc73c\ub85c \ub098\uc628 \uacbd\uc6b0, \uc815\ubcf4\uc758 \uc704\uce58\ub97c \ubc14\uafd4\uc11c \ub4dc\ub9bc\ud074\ub7fd\uc774 \ud56d\uc0c1 ‘\ud074\ub7fd’ \uce78\uc5d0 \uc624\ub3c4\ub85d \uc815\ub9ac\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n
                    \n
                  1. \ub370\uc774\ud130 \uc815\ub9ac \ubc0f \uac00\uacf5<\/strong><\/li>\n<\/ol>\n\n\n\n
                      \n
                    • \uacbd\uae30 \uc2dc\uac04 \uc21c\uc11c\ub300\ub85c \uc815\ub82c\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
                    • \uc120\uc218 \uc774\ub984\uc740 3\uae00\uc790\ub9c8\ub2e4 \uc27c\ud45c\ub85c \uad6c\ubd84\ud574\uc11c \ubcf4\uae30 \uc27d\uac8c \ub9cc\ub4ed\ub2c8\ub2e4.<\/li>\n\n\n\n
                    • \uac01 \uacbd\uae30\ub9c8\ub2e4 \ubc88\ud638\ub97c \ubd99\uc785\ub2c8\ub2e4.<\/li>\n\n\n\n
                    • \uc6d0\ud558\ub294 \uc21c\uc11c\ub300\ub85c \uc5f4(\uceec\ub7fc)\uc744 \uc7ac\ubc30\uce58\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n
                        \n
                      1. \uc5d1\uc140 \ud30c\uc77c\ub85c \uc800\uc7a5<\/strong><\/li>\n<\/ol>\n\n\n\n
                          \n
                        • \uc815\ub9ac\ub41c \ub370\uc774\ud130\ub97c \uc5d1\uc140 \ud30c\uc77c\ub85c \uc800\uc7a5\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \ud1a0\uc608\uc120.xlsx, \uc77c<\/em>\uc608\uc120.xlsx \ub4f1\uc73c\ub85c \uc800\uc7a5\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n

                          \uc774 \ub178\ud2b8\ubd81\uc744 \uc2e4\ud589\ud558\uba74, \ub4dc\ub9bc\ud074\ub7fd\uc774 \ucc38\uc5ec\ud558\ub294 \uacbd\uae30\ub9cc \uc2dc\uac04\uc21c\uc73c\ub85c \uc815\ub9ac\ub41c \uc5d1\uc140 \ud30c\uc77c\uc744 \uc790\ub3d9\uc73c\ub85c \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                          \ucd08\ubcf4\uc790\ub3c4 \uac01 \uc140\uc744 \uc21c\uc11c\ub300\ub85c \uc2e4\ud589\ud558\uba74 \uacb0\uacfc\ub97c \uc27d\uac8c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                          \uad81\uae08\ud55c \ubd80\ubd84\uc774\ub098 \ub354 \uc54c\uace0 \uc2f6\uc740 \ub0b4\uc6a9\uc774 \uc788\uc73c\uba74 \uc5b8\uc81c\ub4e0 \uc9c8\ubb38\ud574 \uc8fc\uc138\uc694!<\/p>\n\n\n\n

                          Excel \ud30c\uc77c\ub85c \uc800\uc7a5<\/h1>\n\n\n\n

                          \ud14d\uc2a4\ud2b8 \ud30c\uc77c\uc5d0\uc11c \ub370\uc774\ud130 \uc77d\uae30<\/h1>\n\n\n\n

                          with open(‘0914.txt’, ‘r’, encoding=’utf-8′) as file:
                          lines = file.readlines()<\/p>\n\n\n\n

                          \uacbd\uae30 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560 \ub9ac\uc2a4\ud2b8<\/h1>\n\n\n\n

                          matches = []<\/p>\n\n\n\n

                          \ub370\uc774\ud130 \ud30c\uc2f1<\/h1>\n\n\n\n

                          current_match = {}
                          for line in lines:
                          line = line.strip()
                          if not line:
                          continue<\/p>\n\n\n\n

                          if '\ucf54\ud2b8 - ' in line and '\uacbd\uae30' in line:\n    if current_match:\n        matches.append(current_match.copy())\n    current_match = {}\n    court_info = line.split(' - ')\n    current_match['\ucf54\ud2b8'] = court_info[0]\n\nelif ':' in line:\n    current_match['\uc2dc\uac04'] = line\n\nelif '\uac1c\uc778\uc804' in line:\n    current_match['\uacbd\uae30\uc885\ubaa9'] = line\n\nelif any(club in line for club in ['\ub4dc\ub9bc\ud074\ub7fd', '\ud568\ub9c8\ub8e8\ud074\ub7fd', '\uc2dc\ud654\ud074\ub7fd', '\ubaa9\uac10\ud074\ub7fd']):\n    club_name = line.strip()\n    if '\ud074\ub7fd' not in current_match:\n        current_match['\ud074\ub7fd'] = club_name\n        current_match['\uc120\uc218'] = ''\n    else:\n        current_match['\uc0c1\ub300\ud074\ub7fd'] = club_name\n        current_match['\uc0c1\ub300\uc120\uc218'] = ''\n\nelif line != '\uacbd\uae30\uc608\uc815' and not line.startswith('\ucf54\ud2b8'):\n    if '\uc120\uc218' not in current_match or not current_match['\uc120\uc218']:\n        current_match['\uc120\uc218'] = line\n    else:\n        current_match['\uc0c1\ub300\uc120\uc218'] = line<\/code><\/pre>\n\n\n\n
                          \ub9c8\uc9c0\ub9c9 \uacbd\uae30 \ucd94\uac00<\/h1>\n\n\n\n
                          if current_match:
                          matches.append(current_match)<\/p>\n\n\n\n
                          DataFrame \uc0dd\uc131<\/h1>\n\n\n\n
                          df = pd.DataFrame(matches)<\/p>\n\n\n\n
                          \ub4dc\ub9bc\ud074\ub7fd \uacbd\uae30\ub9cc \ud544\ud130\ub9c1\ud558\uace0 \uc815\ubcf4 \uc7ac\uc815\ub82c<\/h1>\n\n\n\n
                          dream_club_matches = df[df[‘\ud074\ub7fd’].str.contains(‘\ub4dc\ub9bc\ud074\ub7fd’) | df[‘\uc0c1\ub300\ud074\ub7fd’].str.contains(‘\ub4dc\ub9bc\ud074\ub7fd’)].copy()<\/p>\n\n\n\n
                          \ub4dc\ub9bc\ud074\ub7fd\uc774 \uc0c1\ub300\ud074\ub7fd\uc778 \uacbd\uc6b0 \uc815\ubcf4 \uad50\ud658<\/h1>\n\n\n\n
                          mask = dream_club_matches[‘\uc0c1\ub300\ud074\ub7fd’].str.contains(‘\ub4dc\ub9bc\ud074\ub7fd’, na=False)
                          dream_club_matches.loc[mask, [‘\ud074\ub7fd’, ‘\uc120\uc218’, ‘\uc0c1\ub300\ud074\ub7fd’, ‘\uc0c1\ub300\uc120\uc218’]] = \\
                          dream_club_matches.loc[mask, [‘\uc0c1\ub300\ud074\ub7fd’, ‘\uc0c1\ub300\uc120\uc218’, ‘\ud074\ub7fd’, ‘\uc120\uc218’]].values<\/p>\n\n\n\n
                          \uc2dc\uac04\uc21c\uc73c\ub85c \uc815\ub82c<\/h1>\n\n\n\n
                          dream_club_matches = dream_club_matches.sort_values(‘\uc2dc\uac04’)<\/p>\n\n\n\n
                          \uc120\uc218 \uc774\ub984 \ubd84\ub9ac (\uacf5\ubc31\uc744 \ucf64\ub9c8\ub85c \ubcc0\uacbd)<\/h1>\n\n\n\n
                          dream_club_matches[‘\uc120\uc218’] = dream_club_matches[‘\uc120\uc218’].str.replace(‘ ‘, ‘, ‘)
                          dream_club_matches[‘\uc0c1\ub300\uc120\uc218’] = dream_club_matches[‘\uc0c1\ub300\uc120\uc218’].str.replace(‘ ‘, ‘, ‘)<\/p>\n\n\n\n
                          \ubc88\ud638 \ucd94\uac00<\/h1>\n\n\n\n
                          dream_club_matches.insert(0, ‘\ubc88\ud638’, range(1, len(dream_club_matches) + 1))<\/p>\n\n\n\n
                          \uceec\ub7fc \uc21c\uc11c \uc7ac\uc815\ub82c<\/h1>\n\n\n\n
                          columns_order = [‘\ubc88\ud638’, ‘\uc2dc\uac04’, ‘\uacbd\uae30\uc885\ubaa9’, ‘\ucf54\ud2b8’, ‘\ud074\ub7fd’, ‘\uc120\uc218’, ‘\uc0c1\ub300\ud074\ub7fd’, ‘\uc0c1\ub300\uc120\uc218’]
                          dream_club_matches = dream_club_matches[columns_order]<\/p>\n\n\n\n
                          \uacb0\uacfc \ucd9c\ub825<\/h1>\n\n\n\n
                          display(dream_club_matches)<\/p>\n\n\n\n
                          dream_club_matches.to_excel(‘\ub4dc\ub9bc\uc77c<\/em>\uc608\uc120\uacbd\uae30.xlsx’, index=False)
                          print(‘\uc5d1\uc140 \ud30c\uc77c\uc774 \uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4: \ub4dc\ub9bc\uc77c<\/em>\uc608\uc120\uacbd\uae30.xlsx’)<\/p>\n\n\n\n
                          Excel \ud30c\uc77c\ub85c \uc800\uc7a5<\/h1>\n\n\n\n
                          dream_club_matches.to_excel(‘\ub4dc\ub9bc\uc77c<\/em>\uc608\uc120\uacbd\uae30.xlsx’, index=False)
                          print(‘\uc5d1\uc140 \ud30c\uc77c\uc774 \uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4: \ub4dc\ub9bc\uc77c<\/em>\uc608\uc120\uacbd\uae30.xlsx’)<\/p>\n\n\n\n
                          import pandas as pd
                          import re<\/p>\n\n\n\n
                          def split_name_by_three(name):
                          # \ud55c\uae00 3\uae00\uc790\ub9c8\ub2e4 \uc27c\ud45c \ucd94\uac00
                          return ‘, ‘.join([name[i:i+3] for i in range(0, len(name), 3)])<\/p>\n\n\n\n
                          with open(‘0913.txt’, ‘r’, encoding=’utf-8′) as file:
                          lines = file.readlines()<\/p>\n\n\n\n
                          matches = []
                          current_match = {}
                          for line in lines:
                          line = line.strip()
                          if not line:
                          continue
                          # \ucf54\ud2b8 – \uba87\uacbd\uae30
                          if re.match(r’\\d+\ucf54\ud2b8 – \\d+\uacbd\uae30’, line):
                          if current_match:
                          matches.append(current_match.copy())
                          current_match = {}
                          current_match[‘\ucf54\ud2b8 – \uba87\uacbd\uae30’] = line
                          elif ‘:’ in line:
                          current_match[‘\uc2dc\uac04’] = line
                          elif ‘\uac1c\uc778\uc804’ in line:
                          current_match[‘\uacbd\uae30\uc885\ubaa9’] = line
                          elif any(club in line for club in [‘\ub4dc\ub9bc\ud074\ub7fd’, ‘\ud568\ub9c8\ub8e8\ud074\ub7fd’, ‘\uc2dc\ud654\ud074\ub7fd’, ‘\ubaa9\uac10\ud074\ub7fd’]):
                          club_name = line.strip()
                          if ‘\ud074\ub7fd’ not in current_match:
                          current_match[‘\ud074\ub7fd’] = club_name
                          current_match[‘\uc120\uc218’] = ”
                          else:
                          current_match[‘\uc0c1\ub300\ud074\ub7fd’] = club_name
                          current_match[‘\uc0c1\ub300\uc120\uc218’] = ”
                          elif line != ‘\uacbd\uae30\uc608\uc815’ and not line.startswith(‘\ucf54\ud2b8’):
                          if ‘\uc120\uc218’ not in current_match or not current_match[‘\uc120\uc218’]:
                          current_match[‘\uc120\uc218’] = line
                          else:
                          current_match[‘\uc0c1\ub300\uc120\uc218’] = line
                          if current_match:
                          matches.append(current_match)
                          df = pd.DataFrame(matches)<\/p>\n\n\n\n
                          \ub4dc\ub9bc\ud074\ub7fd \uacbd\uae30\ub9cc \ud544\ud130\ub9c1<\/h1>\n\n\n\n
                          dream_club_matches = df[df[‘\ud074\ub7fd’].str.contains(‘\ub4dc\ub9bc\ud074\ub7fd’) | df[‘\uc0c1\ub300\ud074\ub7fd’].str.contains(‘\ub4dc\ub9bc\ud074\ub7fd’)].copy()<\/p>\n\n\n\n
                          \ub4dc\ub9bc\ud074\ub7fd\uc774 \uc0c1\ub300\ud074\ub7fd\uc778 \uacbd\uc6b0 \uc815\ubcf4 \uad50\ud658<\/h1>\n\n\n\n
                          mask = dream_club_matches[‘\uc0c1\ub300\ud074\ub7fd’].str.contains(‘\ub4dc\ub9bc\ud074\ub7fd’, na=False)
                          dream_club_matches.loc[mask, [‘\ud074\ub7fd’, ‘\uc120\uc218’, ‘\uc0c1\ub300\ud074\ub7fd’, ‘\uc0c1\ub300\uc120\uc218’]] = \\
                          dream_club_matches.loc[mask, [‘\uc0c1\ub300\ud074\ub7fd’, ‘\uc0c1\ub300\uc120\uc218’, ‘\ud074\ub7fd’, ‘\uc120\uc218’]].values<\/p>\n\n\n\n
                          \uc2dc\uac04\uc21c\uc73c\ub85c \uc815\ub82c<\/h1>\n\n\n\n
                          dream_club_matches = dream_club_matches.sort_values(‘\uc2dc\uac04’)<\/p>\n\n\n\n
                          \uc120\uc218 \uc774\ub984 3\uae00\uc790\ub9c8\ub2e4 \uc27c\ud45c<\/h1>\n\n\n\n
                          dream_club_matches[‘\uc120\uc218’] = dream_club_matches[‘\uc120\uc218’].apply(split_name_by_three)
                          dream_club_matches[‘\uc0c1\ub300\uc120\uc218’] = dream_club_matches[‘\uc0c1\ub300\uc120\uc218’].apply(split_name_by_three)<\/p>\n\n\n\n
                          \ubc88\ud638 \ucd94\uac00<\/h1>\n\n\n\n
                          dream_club_matches.insert(0, ‘\ubc88\ud638’, range(1, len(dream_club_matches) + 1))<\/p>\n\n\n\n
                          \uceec\ub7fc \uc21c\uc11c \ubc0f \uc774\ub984 \ub9de\ucd94\uae30<\/h1>\n\n\n\n
                          columns_order = [‘\ubc88\ud638’, ‘\uc2dc\uac04’, ‘\uacbd\uae30\uc885\ubaa9’, ‘\ucf54\ud2b8 – \uba87\uacbd\uae30’, ‘\ud074\ub7fd’, ‘\uc120\uc218’, ‘\uc0c1\ub300\ud074\ub7fd’, ‘\uc0c1\ub300\uc120\uc218’]
                          dream_club_matches = dream_club_matches[columns_order]
                          dream_club_matches.to_excel(‘\ud1a0\uc608\uc120.xlsx’, index=False) print(‘\uc5d1\uc140 \ud30c\uc77c\uc774 \uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4: \ud1a0<\/em>\uc608\uc120.xlsx’)<\/p>\n\n\n\n
                          import pandas as pd
                          import re<\/p>\n\n\n\n
                          def split_name_by_three(name):
                          return ‘, ‘.join([name[i:i+3] for i in range(0, len(name), 3)])<\/p>\n\n\n\n
                          with open(‘0914.txt’, ‘r’, encoding=’utf-8′) as file:
                          lines = file.readlines()<\/p>\n\n\n\n
                          matches = []
                          current_match = {}
                          for line in lines:
                          line = line.strip()
                          if not line:
                          continue
                          if re.match(r’\\d+\ucf54\ud2b8 – \\d+\uacbd\uae30’, line):
                          if current_match:
                          matches.append(current_match.copy())
                          current_match = {}
                          current_match[‘\ucf54\ud2b8 – \uba87\uacbd\uae30’] = line
                          elif ‘:’ in line:
                          current_match[‘\uc2dc\uac04’] = line
                          elif ‘\uac1c\uc778\uc804’ in line:
                          current_match[‘\uacbd\uae30\uc885\ubaa9’] = line
                          elif any(club in line for club in [‘\ub4dc\ub9bc\ud074\ub7fd’, ‘\ud568\ub9c8\ub8e8\ud074\ub7fd’, ‘\uc2dc\ud654\ud074\ub7fd’, ‘\ubaa9\uac10\ud074\ub7fd’]):
                          club_name = line.strip()
                          if ‘\ud074\ub7fd’ not in current_match:
                          current_match[‘\ud074\ub7fd’] = club_name
                          current_match[‘\uc120\uc218’] = ”
                          else:
                          current_match[‘\uc0c1\ub300\ud074\ub7fd’] = club_name
                          current_match[‘\uc0c1\ub300\uc120\uc218’] = ”
                          elif line != ‘\uacbd\uae30\uc608\uc815’ and not line.startswith(‘\ucf54\ud2b8’):
                          if ‘\uc120\uc218’ not in current_match or not current_match[‘\uc120\uc218’]:
                          current_match[‘\uc120\uc218’] = line
                          else:
                          current_match[‘\uc0c1\ub300\uc120\uc218’] = line
                          if current_match:
                          matches.append(current_match)
                          df = pd.DataFrame(matches)
                          dream_club_matches = df[df[‘\ud074\ub7fd’].str.contains(‘\ub4dc\ub9bc\ud074\ub7fd’) | df[‘\uc0c1\ub300\ud074\ub7fd’].str.contains(‘\ub4dc\ub9bc\ud074\ub7fd’)].copy()
                          mask = dream_club_matches[‘\uc0c1\ub300\ud074\ub7fd’].str.contains(‘\ub4dc\ub9bc\ud074\ub7fd’, na=False)
                          dream_club_matches.loc[mask, [‘\ud074\ub7fd’, ‘\uc120\uc218’, ‘\uc0c1\ub300\ud074\ub7fd’, ‘\uc0c1\ub300\uc120\uc218’]] = \\
                          dream_club_matches.loc[mask, [‘\uc0c1\ub300\ud074\ub7fd’, ‘\uc0c1\ub300\uc120\uc218’, ‘\ud074\ub7fd’, ‘\uc120\uc218’]].values
                          dream_club_matches = dream_club_matches.sort_values(‘\uc2dc\uac04’)
                          dream_club_matches[‘\uc120\uc218’] = dream_club_matches[‘\uc120\uc218’].apply(split_name_by_three)
                          dream_club_matches[‘\uc0c1\ub300\uc120\uc218’] = dream_club_matches[‘\uc0c1\ub300\uc120\uc218’].apply(split_name_by_three)
                          dream_club_matches.insert(0, ‘\ubc88\ud638’, range(1, len(dream_club_matches) + 1))
                          columns_order = [‘\ubc88\ud638’, ‘\uc2dc\uac04’, ‘\uacbd\uae30\uc885\ubaa9’, ‘\ucf54\ud2b8 – \uba87\uacbd\uae30’, ‘\ud074\ub7fd’, ‘\uc120\uc218’, ‘\uc0c1\ub300\ud074\ub7fd’, ‘\uc0c1\ub300\uc120\uc218’]
                          dream_club_matches = dream_club_matches[columns_order]
                          dream_club_matches.to_excel(‘\uc77c\uc608\uc120.xlsx’, index=False) print(‘\uc5d1\uc140 \ud30c\uc77c\uc774 \uc0dd\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4: \uc77c<\/em>\uc608\uc120.xlsx’)<\/p>\n\n\n\n
                          \ub4dc\ub9bc\ud074\ub7fd \uacbd\uae30 \uc77c\uc815 \ubd84\uc11d \ub178\ud2b8\ubd81 \uc548\ub0b4 (\ucd08\ubcf4\uc790\uc6a9)<\/h1>\n\n\n\n
                          \uc774 \ub178\ud2b8\ubd81\uc740 \ubc30\ub4dc\ubbfc\ud134 \ub300\ud68c\uc5d0\uc11c \ub4dc\ub9bc\ud074\ub7fd\uc774 \ucc38\uac00\ud558\ub294 \uacbd\uae30 \uc77c\uc815\uc744 \uc815\ub9ac\ud558\uace0, \uc5d1\uc140 \ud30c\uc77c\ub85c \uc800\uc7a5\ud558\ub294 \uacfc\uc815\uc744 \ub2f4\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ucd08\ubcf4\uc790\ub3c4 \uc27d\uac8c \ub530\ub77c\ud560 \uc218 \uc788\ub3c4\ub85d \uac01 \ub2e8\uacc4\ubcc4\ub85c \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n
                            \n
                          1. \ud544\uc694\ud55c \ub77c\uc774\ube0c\ub7ec\ub9ac \ubd88\ub7ec\uc624\uae30<\/strong><\/li>\n<\/ol>\n\n\n\n
                              \n
                            • \ub370\uc774\ud130 \ubd84\uc11d\uc5d0 \ud544\uc694\ud55c \ud30c\uc774\uc36c \ub77c\uc774\ube0c\ub7ec\ub9ac(pandas, numpy \ub4f1)\ub97c \ubd88\ub7ec\uc635\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n
                                \n
                              1. \ud14d\uc2a4\ud2b8 \ud30c\uc77c\uc5d0\uc11c \ub370\uc774\ud130 \uc77d\uae30<\/strong><\/li>\n<\/ol>\n\n\n\n
                                  \n
                                • \uacbd\uae30 \uc77c\uc815\uc774 \ub2f4\uae34 \ud14d\uc2a4\ud2b8 \ud30c\uc77c(\uc608: 0913.txt, 0914.txt)\uc744 \ud55c \uc904\uc529 \uc77d\uc5b4\uc635\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n
                                    \n
                                  1. \uacbd\uae30 \uc815\ubcf4 \ucd94\ucd9c<\/strong><\/li>\n<\/ol>\n\n\n\n
                                      \n
                                    • \uac01 \uc904\uc744 \ubd84\uc11d\ud574\uc11c \ucf54\ud2b8, \uc2dc\uac04, \uacbd\uae30\uc885\ubaa9, \ud074\ub7fd, \uc120\uc218 \ub4f1 \ud544\uc694\ud55c \uc815\ubcf4\ub97c \ubf51\uc544\ub0c5\ub2c8\ub2e4.<\/li>\n\n\n\n
                                    • \ud55c \uacbd\uae30\uc758 \uc815\ubcf4\uac00 \ubaa8\ub450 \ubaa8\uc774\uba74 \ub9ac\uc2a4\ud2b8\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n
                                        \n
                                      1. \ub4dc\ub9bc\ud074\ub7fd \uacbd\uae30\ub9cc \ucd94\ub9ac\uae30<\/strong><\/li>\n<\/ol>\n\n\n\n
                                          \n
                                        • \uc804\uccb4 \uacbd\uae30 \uc911\uc5d0\uc11c \ub4dc\ub9bc\ud074\ub7fd\uc774 \ucc38\uc5ec\ud55c \uacbd\uae30\ub9cc \uace8\ub77c\ub0c5\ub2c8\ub2e4.<\/li>\n\n\n\n
                                        • \ub4dc\ub9bc\ud074\ub7fd\uc774 \uc0c1\ub300\ud300\uc73c\ub85c \ub098\uc628 \uacbd\uc6b0, \uc815\ubcf4\uc758 \uc704\uce58\ub97c \ubc14\uafd4\uc11c \ub4dc\ub9bc\ud074\ub7fd\uc774 \ud56d\uc0c1 ‘\ud074\ub7fd’ \uce78\uc5d0 \uc624\ub3c4\ub85d \uc815\ub9ac\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n
                                            \n
                                          1. \ub370\uc774\ud130 \uc815\ub9ac \ubc0f \uac00\uacf5<\/strong><\/li>\n<\/ol>\n\n\n\n
                                              \n
                                            • \uacbd\uae30 \uc2dc\uac04 \uc21c\uc11c\ub300\ub85c \uc815\ub82c\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
                                            • \uc120\uc218 \uc774\ub984\uc740 \ubcf4\uae30 \uc27d\uac8c \uc27c\ud45c\ub85c \uad6c\ubd84\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
                                            • \uac01 \uacbd\uae30\ub9c8\ub2e4 \ubc88\ud638\ub97c \ubd99\uc785\ub2c8\ub2e4.<\/li>\n\n\n\n
                                            • \uc6d0\ud558\ub294 \uc21c\uc11c\ub300\ub85c \uc5f4(\uceec\ub7fc)\uc744 \uc7ac\ubc30\uce58\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n
                                                \n
                                              1. \uc5d1\uc140 \ud30c\uc77c\ub85c \uc800\uc7a5<\/strong><\/li>\n<\/ol>\n\n\n\n
                                                  \n
                                                • \uc815\ub9ac\ub41c \ub370\uc774\ud130\ub97c \uc5d1\uc140 \ud30c\uc77c\ub85c \uc800\uc7a5\ud569\ub2c8\ub2e4. (\uc608: \ud1a0\uc608\uc120.xlsx, \uc77c<\/em>\uc608\uc120.xlsx \ub4f1)<\/li>\n<\/ul>\n\n\n\n
                                                  \uc774 \ub178\ud2b8\ubd81\uc744 \uc140 \uc21c\uc11c\ub300\ub85c \uc2e4\ud589\ud558\uba74 \ub4dc\ub9bc\ud074\ub7fd\uc774 \ucc38\uc5ec\ud558\ub294 \uacbd\uae30\ub9cc \uc2dc\uac04\uc21c\uc73c\ub85c \uc815\ub9ac\ub41c \uc5d1\uc140 \ud30c\uc77c\uc744 \uc790\ub3d9\uc73c\ub85c \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
                                                  \uad81\uae08\ud55c \uc810\uc774 \uc788\uc73c\uba74 \uc5b8\uc81c\ub4e0 \uc9c8\ubb38\ud574 \uc8fc\uc138\uc694!<\/p>\n","protected":false},"excerpt":{"rendered":"
                                                  \uc774 \ub178\ud2b8\ubd81 \ud30c\uc77c\uc740 \ubc30\ub4dc\ubbfc\ud134 \uacbd\uae30 \uc77c\uc815 \ub370\uc774\ud130\ub97c \ubd84\uc11d\ud558\uace0, \ub4dc\ub9bc\ud074\ub7fd\uc774 \ucc38\uc5ec\ud558\ub294 \uacbd\uae30\ub9cc \ucd94\ub824\uc11c \uc5d1\uc140 \ud30c\uc77c\ub85c \uc800\uc7a5\ud558\ub294 \uacfc\uc815\uc744 \ub2f4\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ucd08\ubcf4\uc790\ub97c \uc704\ud574 \uac01 \ub2e8\uacc4\ubcc4\ub85c \uc27d\uac8c \uc124\uba85\ub4dc\ub9ac\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4: \uc774 \ub178\ud2b8\ubd81\uc744 \uc2e4\ud589\ud558\uba74, \ub4dc\ub9bc\ud074\ub7fd\uc774 \ucc38\uc5ec\ud558\ub294 \uacbd\uae30\ub9cc \uc2dc\uac04\uc21c\uc73c\ub85c \uc815\ub9ac\ub41c \uc5d1\uc140 \ud30c\uc77c\uc744 \uc790\ub3d9\uc73c\ub85c \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\ucd08\ubcf4\uc790\ub3c4 \uac01 \uc140\uc744 \uc21c\uc11c\ub300\ub85c \uc2e4\ud589\ud558\uba74 \uacb0\uacfc\ub97c \uc27d\uac8c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\uad81\uae08\ud55c \ubd80\ubd84\uc774\ub098 \ub354 \uc54c\uace0 \uc2f6\uc740 \ub0b4\uc6a9\uc774 \uc788\uc73c\uba74 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34,73,75],"tags":[],"class_list":["post-512","post","type-post","status-publish","format-standard","hentry","category-ai","category-openai","category-vs-code"],"_links":{"self":[{"href":"http:\/\/qmac.kr\/wordpress\/wp-json\/wp\/v2\/posts\/512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/qmac.kr\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/qmac.kr\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/qmac.kr\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/qmac.kr\/wordpress\/wp-json\/wp\/v2\/comments?post=512"}],"version-history":[{"count":1,"href":"http:\/\/qmac.kr\/wordpress\/wp-json\/wp\/v2\/posts\/512\/revisions"}],"predecessor-version":[{"id":513,"href":"http:\/\/qmac.kr\/wordpress\/wp-json\/wp\/v2\/posts\/512\/revisions\/513"}],"wp:attachment":[{"href":"http:\/\/qmac.kr\/wordpress\/wp-json\/wp\/v2\/media?parent=512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/qmac.kr\/wordpress\/wp-json\/wp\/v2\/categories?post=512"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/qmac.kr\/wordpress\/wp-json\/wp\/v2\/tags?post=512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}