{"id":12864,"date":"2024-05-30T16:02:49","date_gmt":"2024-05-30T07:02:49","guid":{"rendered":"https:\/\/www.sambuichi.jp\/?p=12864"},"modified":"2024-05-31T10:52:11","modified_gmt":"2024-05-31T01:52:11","slug":"%e8%b2%a1%e5%8b%99%e5%a0%b1%e5%91%8a%e3%81%ab%e3%81%8a%e3%81%91%e3%82%8b%e9%9a%8e%e5%b1%a4%e7%9a%84%e6%95%b4%e9%a0%93%e3%83%87%e3%83%bc%e3%82%bf%e3%81%ae%e5%8f%96%e3%82%8a%e6%89%b1%e3%81%84","status":"publish","type":"post","link":"https:\/\/www.sambuichi.jp\/?p=12864","title":{"rendered":"\u8ca1\u52d9\u5831\u544a\u306b\u304a\u3051\u308b\u968e\u5c64\u7684\u6574\u9813\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u6271\u3044"},"content":{"rendered":"

Views: 27<\/p>

\n

\u8ca1\u52d9\u5831\u544a\u306b\u304a\u3051\u308b\u968e\u5c64\u7684\u6574\u9813\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u6271\u3044<\/h1>\n
\n Nobuyuki SAMBUICHI<\/span>\n <\/div>\n<\/p><\/div>\n
\n
\n
\n
\n

\n \u3053\u306e\u30d6\u30ed\u30b0\u6295\u7a3f\u3067\u306f\u3001\u8ca1\u52d9\u5831\u544a\u306b\u304a\u3051\u308b\u968e\u5c64\u7684\u6574\u9813\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u6271\u3044\u65b9\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002\u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0\u3001\u53e3\u5ea7\u756a\u53f7\u3001\u6708\u306b\u57fa\u3065\u3044\u3066\u91d1\u984d\u3092\u96c6\u8a08\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u5bfe\u8c61\u884c\u306b\u30de\u30fc\u30b8\u3057\u3001\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u7ba1\u7406\u3092\u78ba\u4fdd\u3057\u3066\u5197\u9577\u6027\u3092\u56de\u907f\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002\n <\/p><\/blockquote><\/div>\n<\/p><\/div>\n<\/p><\/div>\n

\n

1. \u968e\u5c64\u7684\u6574\u9813\u30c7\u30fc\u30bf\u306e\u7279\u5fb4<\/h2>\n
\n
\n

\u968e\u5c64\u7684\u6574\u9813\u30c7\u30fc\u30bf\u306f\u3001\u7570\u306a\u308b\u884c\u3067\u7570\u306a\u308b\u30ec\u30d9\u30eb\u306e\u89b3\u5bdf\u3092\u5831\u544a\u3059\u308b\u305f\u3081\u3001\u30ec\u30dd\u30fc\u30c8 \u30d5\u30a1\u30a4\u30eb\u304c\u5197\u9577\u306b\u306a\u308b\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u305f\u3060\u3057\u3001\u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0\u3001\u53e3\u5ea7\u756a\u53f7\u3001\u6708\u306b\u57fa\u3065\u3044\u3066\u91d1\u984d\u3092\u96c6\u8a08\u3059\u308b\u306b\u306f\u3001\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u5bfe\u8c61\u884c\u306b\u30de\u30fc\u30b8\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n

\n

\u5165\u529b\u3055\u308c\u305f\u65e5\u4ed8\u306f\u30d8\u30c3\u30c0\u30fc \u30a8\u30f3\u30c8\u30ea \u30ec\u30d9\u30eb\u306e\u884c\u306b\u5831\u544a\u3055\u308c\u3001\u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0\u3001\u79d1\u76ee\u30b3\u30fc\u30c9\u3001\u91d1\u984d\u306e\u30c7\u30fc\u30bf\u306f\u660e\u7d30\u884c\u3067\u5831\u544a\u3055\u308c\u307e\u3059\u3002\u65e5\u4ed8\u3092\u660e\u7d30\u884c\u306e\u30c7\u30fc\u30bf\u306b\u30de\u30fc\u30b8\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u306b\u3064\u3044\u3066\u306f\u3001\u5f8c\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n

\n

\u6700\u7d42\u7d50\u679c\u3002JP04a_GL02_03_month<\/code>\u3001JP05a_GL03_04<\/code>\u3001JP13a_BS16_01<\/code>\u3001JP13a_BS16_02<\/code> \u306e\u5404\u7d44\u307f\u5408\u308f\u305b\u306b\u5bfe\u3059\u308b CC05hW_01_target<\/code> \u306e\u5408\u8a08\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n

\n
\n
7. \u6700\u7d42\u7d50\u679c:\r\n    JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01 JP13a_BS16_02  CC05hW_01_target\r\n  0             2021-04             D            150          \u53d7\u53d6\u624b\u5f62          20392404\r\n  1             2021-04             C            152           \u58f2\u639b\u91d1          29217041\r\n  2             2021-04             D            131          \u666e\u901a\u9810\u91d1           8823062\r\n  3             2021-04             D            741         \u652f\u6255\u624b\u6570\u6599              1575\r\n  4             2021-05             D            152           \u58f2\u639b\u91d1           6682852\r\n  5             2021-05             C            511           \u58f2\u4e0a\u9ad8           6540100<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
2. \u30bd\u30fc\u30b9 \u30b3\u30fc\u30c9\u3068\u8aac\u660e<\/h2>\n
\n
\n
\n
import pandas as pd\r\n  \r\n  # CSV\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u3080\r\n  file_path = '2405\/240530\/tidyGL05-31_3.csv'\r\n  \r\n  # CSV\u30d5\u30a1\u30a4\u30eb\u3092DataFrame\u306b\u8aad\u307f\u8fbc\u3080\r\n  df = pd.read_csv(file_path, encoding='utf-8-sig')\r\n  \r\n  # \u5217\u540d\u306e\u5148\u982d\u304a\u3088\u3073\u672b\u5c3e\u306e\u30b9\u30da\u30fc\u30b9\u3092\u524a\u9664\u3059\u308b\r\n  df.columns = df.columns.str.strip()\r\n  \r\n  # \u95a2\u9023\u3059\u308b\u5217\u3092\u9069\u5207\u306a\u30c7\u30fc\u30bf\u578b\u306b\u5909\u63db\u3059\u308b\r\n  df['JP05a'] = pd.to_numeric(df['JP05a'], errors='coerce').astype('Int64') # \u660e\u7d30\u884c\r\n  df['JP12a'] = pd.to_numeric(df['JP12a'], errors='coerce').astype('Int64') # \u88dc\u52a9\u79d1\u76ee\r\n  df['BS04cc'] = pd.to_numeric(df['BS04cc'], errors='coerce').astype('Int64') # \u90e8\u9580\r\n  df['CC05hW_01'] = pd.to_numeric(df['CC05hW_01'], errors='coerce').astype('Int64') # \u91d1\u984d\r\n  df['JP13a_BS16_01'] = pd.to_numeric(df['JP13a_BS16_01'], errors='coerce').astype('Int64') # \u79d1\u76ee\u30b3\u30fc\u30c9\r\n  \r\n  # \u6bd4\u8f03\u306e\u305f\u3081\u306bJP05a_GL03_04\uff08\u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0\uff09\u3092\u6587\u5b57\u5217\u3068\u3057\u3066\u6b63\u3057\u304f\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3059\u308b\r\n  df['JP05a_GL03_04'] = df['JP05a_GL03_04'].astype(str)\r\n  \r\n  # JP04a_GL02_03\uff08\u4f1d\u7968\u65e5\u4ed8\uff09\u3092\u65e5\u6642\u306b\u5909\u63db\u3057\u3001\u975e\u6a19\u6e96\u306e\u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u51e6\u7406\u3059\u308b\r\n  df['JP04a_GL02_03'] = pd.to_datetime(df['JP04a_GL02_03'], errors='coerce')\r\n  \r\n  # JP04a_GL02_03\uff08\u4f1d\u7968\u65e5\u4ed8\uff09\u304b\u3089\u6708\u3092\u62bd\u51fa\u3057\u3001\u65b0\u3057\u3044\u5217\u306b\u8ffd\u52a0\u3059\u308b\r\n  df['JP04a_GL02_03_month'] = df['JP04a_GL02_03'].dt.to_period('M').astype(str)\r\n  \r\n  # \u521d\u671f\u306eDataFrame\u3092\u8868\u793a\u3059\u308b\r\n  print(\"1. \u521d\u671f\u306eDataFrame:\")\r\n  print(df.head())\r\n  \r\n  # JP12a=0\u304b\u3064BS04cc=0\u306e\u884c\u3092\u62bd\u51fa\u3057\u3001\u5bfe\u8c61\u306eCC05hW_01\uff08\u91d1\u984d\uff09\u306e\u5024\u3092\u53ce\u96c6\u3059\u308b\r\n  target_rows = df[(df['JP12a'] == 0) & (df['BS04cc'] == 0) & (df['JP05a'] != 0)][['JP04a', 'JP05a', 'CC05hW_01']]\r\n  print(\"\\n2. \u5bfe\u8c61\u306e\u884c:\")\r\n  print(target_rows.head())\r\n  \r\n  # \u30de\u30fc\u30b8\u524d\u306b\u5bfe\u8c61\u5217\u3092\u660e\u78ba\u306b\u3059\u308b\u305f\u3081\u306b\u5217\u540d\u3092\u5909\u66f4\u3059\u308b\r\n  target_rows = target_rows.rename(columns={'CC05hW_01': 'CC05hW_01_target'})\r\n  \r\n  # JP04a\uff08\u4ed5\u8a33\u30d8\u30c3\u30c0\uff09\u306b\u5024\u304c\u3042\u308a\u3001JP05a\uff08\u4ed5\u8a33\u660e\u7d30\uff09\u3001JP12a\uff08\u88dc\u52a9\u79d1\u76ee\uff09\u3001BS04cc\uff08\u90e8\u9580\uff09\u304c\u3059\u3079\u3066\u30bc\u30ed\u306e\u884c\u3092\u62bd\u51fa\u3059\u308b\r\n  jp04a_rows = df[(df['JP12a'] == 0) & (df['BS04cc'] == 0) & (df['JP05a'] == 0)][['JP04a', 'JP04a_GL02_03', 'JP04a_GL02_03_month']]\r\n  \r\n  # \u30de\u30fc\u30b8\u524d\u306b\u5217\u540d\u3092\u660e\u78ba\u306b\u3059\u308b\u305f\u3081\u306b\u5217\u540d\u3092\u5909\u66f4\u3059\u308b\r\n  jp04a_rows = jp04a_rows.rename(columns={'JP04a_GL02_03': 'JP04a_GL02_03_value', 'JP04a_GL02_03_month': 'JP04a_GL02_03_month_value'})\r\n  \r\n  # \u5bfe\u8c61\u306eCC05hW_01\uff08\u91d1\u984d\uff09\u306e\u5024\u3092\u30e1\u30a4\u30f3\u306eDataFrame\u306b\u30de\u30fc\u30b8\u3059\u308b\r\n  df = pd.merge(df, target_rows, on=['JP04a', 'JP05a'], how='left')\r\n  \r\n  # JP04a_GL02_03\uff08\u4f1d\u7968\u65e5\u4ed8\uff09\u304a\u3088\u3073JP04a_GL02_03_month\uff08\u4f1d\u7968\u65e5\u4ed8\u306e\u6708\uff09\u306e\u5024\u3092\u30e1\u30a4\u30f3\u306eDataFrame\u306b\u30de\u30fc\u30b8\u3059\u308b\r\n  df = pd.merge(df, jp04a_rows, on='JP04a', how='left')\r\n  \r\n  # \u6b63\u3057\u3044JP04a_GL02_03\uff08\u4f1d\u7968\u65e5\u4ed8\uff09\u304a\u3088\u3073JP04a_GL02_03_month\uff08\u4f1d\u7968\u65e5\u4ed8\u306e\u6708\uff09\u306e\u5024\u3067\u30e1\u30a4\u30f3\u306eDataFrame\u3092\u66f4\u65b0\u3059\u308b\r\n  df['JP04a_GL02_03'] = df['JP04a_GL02_03_value'].combine_first(df['JP04a_GL02_03'])\r\n  df['JP04a_GL02_03_month'] = df['JP04a_GL02_03_month_value'].combine_first(df['JP04a_GL02_03_month'])\r\n  \r\n  # \u30de\u30fc\u30b8\u306b\u4f7f\u7528\u3057\u305f\u4e00\u6642\u7684\u306a\u5217\u3092\u524a\u9664\u3059\u308b\r\n  df.drop(columns=['JP04a_GL02_03_value', 'JP04a_GL02_03_month_value'], inplace=True)\r\n  \r\n  # \u30de\u30fc\u30b8\u3068\u66f4\u65b0\u5f8c\u306eDataFrame\u3092\u8868\u793a\u3059\u308b\r\n  print(\"\\n3. \u30de\u30fc\u30b8\u3068\u66f4\u65b0\u5f8c\u306eDataFrame:\")\r\n  print(df.head())\r\n  \r\n  # JP05a_GL03_04\uff08\u8cb8\u65b9\/\u501f\u65b9\u30d5\u30e9\u30b0\uff09\u3001JP13a_BS16_01\uff08\u79d1\u76ee\u30b3\u30fc\u30c9\uff09\u3001\u304a\u3088\u3073JP13a_BS16_02\uff08\u79d1\u76ee\u540d\uff09\u306e\u3059\u3079\u3066\u306e\u30e6\u30cb\u30fc\u30af\u306a\u7d44\u307f\u5408\u308f\u305b\u3092\u53ce\u96c6\u3059\u308b\r\n  unique_combinations = df[['JP05a_GL03_04', 'JP13a_BS16_01', 'JP13a_BS16_02']].drop_duplicates()\r\n  print(\"\\n4. \u30e6\u30cb\u30fc\u30af\u306a\u7d44\u307f\u5408\u308f\u305b:\")\r\n  print(unique_combinations)\r\n  \r\n  # \u7d50\u679c\u3092\u4fdd\u5b58\u3059\u308b\u305f\u3081\u306b\u7a7a\u306eDataFrame\u3092\u521d\u671f\u5316\u3059\u308b\r\n  results = pd.DataFrame()\r\n  \r\n  # \u5404\u30e6\u30cb\u30fc\u30af\u306a\u7d44\u307f\u5408\u308f\u305b\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3057\u3001\u30c7\u30fc\u30bf\u3092\u96c6\u8a08\u3059\u308b\r\n  for _, row in unique_combinations.iterrows():\r\n      jp05a_gl03_04 = row['JP05a_GL03_04'] # \u8cb8\u65b9\/\u501f\u65b9\u30d5\u30e9\u30b0\r\n      jp13a_bs16_01 = row['JP13a_BS16_01'] # \u79d1\u76ee\u30b3\u30fc\u30c9\r\n      jp13a_bs16_02 = row['JP13a_BS16_02'] # \u79d1\u76ee\u540d\r\n      \r\n      # \u73fe\u5728\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u57fa\u3065\u3044\u3066DataFrame\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3059\u308b\r\n      filtered_df = df[(df['JP05a_GL03_04'] == jp05a_gl03_04) & # \u8cb8\u65b9\/\u501f\u65b9\u30d5\u30e9\u30b0\r\n                       (df['JP13a_BS16_01'] == jp13a_bs16_01) & # \u79d1\u76ee\u30b3\u30fc\u30c9\r\n                       (df['JP13a_BS16_02'] == jp13a_bs16_02) & # \u79d1\u76ee\u540d\r\n                       df['CC05hW_01_target'].notna()] # \u91d1\u984d\r\n  \r\n      print(f\"\\n5. \u73fe\u5728\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u57fa\u3065\u3044\u3066\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3055\u308c\u305fDataFrame ({jp05a_gl03_04}, {jp13a_bs16_01}, {jp13a_bs16_02}):\")\r\n      print(filtered_df)\r\n  \r\n      if not filtered_df.empty:\r\n          # NaN\u5024\u3092\u524a\u9664\u305b\u305a\u306b\u7d50\u679c\u3092\u8868\u793a\u3059\u308b\r\n          for _, filtered_row in filtered_df.iterrows():\r\n              date = filtered_row['JP04a_GL02_03'] if pd.notna(filtered_row['JP04a_GL02_03']) else 'N\/A'\r\n              debit_credit_code = filtered_row['JP05a_GL03_04'] if pd.notna(filtered_row['JP05a_GL03_04']) else 'N\/A'\r\n              ledger_account_number = filtered_row['JP13a_BS16_01'] if pd.notna(filtered_row['JP13a_BS16_01']) else 'N\/A'\r\n              ledger_account_name = filtered_row['JP13a_BS16_02'] if pd.notna(filtered_row['JP13a_BS16_02']) else 'N\/A'\r\n              amount = filtered_row['CC05hW_01_target'] if pd.notna(filtered_row['CC05hW_01_target']) else 'N\/A'\r\n  \r\n              print(f\"\u65e5\u4ed8: {date}, \"\r\n                    f\"\u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: {debit_credit_code}, \"\r\n                    f\"\u79d1\u76ee\u30b3\u30fc\u30c9: {ledger_account_number}, \"\r\n                    f\"\u79d1\u76ee\u540d: {ledger_account_name}, \"\r\n                    f\"\u91d1\u984d: {amount}\")\r\n  \r\n          # \u30b0\u30eb\u30fc\u30d7\u5316\u306b\u4f7f\u7528\u3059\u308b\u5217\u304cnull\u3067\u306a\u3044\u3053\u3068\u3092\u4fdd\u8a3c\u3059\u308b\r\n          filtered_df = filtered_df.fillna('N\/A')\r\n  \r\n          # \u5fc5\u8981\u306a\u5217\u3067\u30b0\u30eb\u30fc\u30d7\u5316\u3057\u3001'CC05hW_01_target'\u306e\u5408\u8a08\u3092\u96c6\u8a08\u3059\u308b\r\n          result = filtered_df.groupby(\r\n              ['JP04a_GL02_03_month', 'JP05a_GL03_04', 'JP13a_BS16_01', 'JP13a_BS16_02']\r\n          )['CC05hW_01_target'].sum().reset_index()\r\n  \r\n          print(\"\\n6. \u9014\u4e2d\u7d50\u679c:\")\r\n          print(result)\r\n  \r\n          # \u7d50\u679c\u3092\u7d50\u679cDataFrame\u306b\u8ffd\u52a0\u3059\u308b\r\n          results = pd.concat([results, result], ignore_index=True)\r\n  \r\n  # \u6700\u7d42\u7d50\u679c\u3092\u8868\u793a\u3059\u308b\r\n  print(\"\\n7. \u6700\u7d42\u7d50\u679c:\")\r\n  print(results)\r\n  \r\n  # \u7d50\u679c\u3092\u65b0\u3057\u3044CSV\u30d5\u30a1\u30a4\u30eb\u306b\u4fdd\u5b58\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u5834\u5408\u3001\u4ee5\u4e0b\u306e\u884c\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u5916\u3059\uff1a\r\n  # results.to_csv('data\/_PCA\/try\/sum_by_combination.csv', index=False, encoding='utf-8-sig')<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3. \u5404\u30b9\u30c6\u30c3\u30d7\u306e\u8aac\u660e<\/h2>\n
\n
\n
3.1. CSV \u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u8fbc\u307f\u3068\u8aad\u307f\u53d6\u308a:<\/h3>\n
\n
\u307e\u305a\u3001\u521d\u671f\u30c7\u30fc\u30bf\u3068\u3001\u305d\u308c\u3092\u51e6\u7406\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u306a\u8a2d\u5b9a\u304b\u3089\u59cb\u3081\u307e\u3057\u3087\u3046\u3002\u30bd\u30fc\u30b9 CSV \u30d5\u30a1\u30a4\u30eb\u306b\u306f\u3001\u968e\u5c64\u5316\u3055\u308c\u305f\u6574\u9813\u3055\u308c\u305f\u30c7\u30fc\u30bf\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n
\n
\u6b21\u306e Python \u30b9\u30af\u30ea\u30d7\u30c8\u306f\u3001CSV \u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u53d6\u308a\u3001\u30c7\u30fc\u30bf\u3092\u51e6\u7406\u3057\u3001\u5fc5\u8981\u306a\u60c5\u5831\u3092\u5bfe\u8c61\u884c\u306b\u30de\u30fc\u30b8\u3057\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n
\n
\n
# CSV\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u3080\r\n  file_path = '2405\/240530\/tidyGL05-31_3.csv'\r\n  \r\n  # CSV\u30d5\u30a1\u30a4\u30eb\u3092DataFrame\u306b\u8aad\u307f\u8fbc\u3080\r\n  df = pd.read_csv(file_path, encoding='utf-8-sig')<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.2. \u5217\u540d\u306e\u5148\u982d\/\u672b\u5c3e\u306e\u30b9\u30da\u30fc\u30b9\u3092\u524a\u9664\u3057\u307e\u3059:<\/h3>\n
\n
\n
df.columns = df.columns.str.strip()<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u3053\u308c\u306b\u3088\u308a\u3001\u5217\u540d\u306b\u542b\u307e\u308c\u308b\u4f59\u5206\u306a\u30b9\u30da\u30fc\u30b9\u304c\u524a\u9664\u3055\u308c\u3001\u30c7\u30fc\u30bf\u64cd\u4f5c\u4e2d\u306e\u30a8\u30e9\u30fc\u3092\u56de\u907f\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.3. \u95a2\u9023\u3059\u308b\u5217\u3092\u9069\u5207\u306a\u30c7\u30fc\u30bf\u578b\u306b\u5909\u63db\u3057\u307e\u3059:<\/h3>\n
\n
\n
# \u95a2\u9023\u3059\u308b\u5217\u3092\u9069\u5207\u306a\u30c7\u30fc\u30bf\u578b\u306b\u5909\u63db\u3059\u308b\r\n  df['JP05a'] = pd.to_numeric(df['JP05a'], errors='coerce').astype('Int64') # \u660e\u7d30\u884c\r\n  df['JP12a'] = pd.to_numeric(df['JP12a'], errors='coerce').astype('Int64') # \u88dc\u52a9\u79d1\u76ee\r\n  df['BS04cc'] = pd.to_numeric(df['BS04cc'], errors='coerce').astype('Int64') # \u90e8\u9580\r\n  df['CC05hW_01'] = pd.to_numeric(df['CC05hW_01'], errors='coerce').astype('Int64') # \u91d1\u984d\r\n  df['JP13a_BS16_01'] = pd.to_numeric(df['JP13a_BS16_01'], errors='coerce').astype('Int64') # \u79d1\u76ee\u30b3\u30fc\u30c9<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u5217 ‘JP05a’\u3001’JP12a’\u3001’BS04cc’ \u306f\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3 \u30b7\u30fc\u30b1\u30f3\u30b9\u756a\u53f7\u3067\u3059\u3002
\n  \u5217 ‘CC05hW_01’ \u306f\u3001\u5c0f\u5358\u4f4d\u306e\u306a\u3044 JPY \u3067\u306e\u91d1\u984d\u3067\u3059\u3002
\n  \u5217 ‘JP13a_BS16_01’ \u306f\u3001\u52d8\u5b9a\u79d1\u76ee\u306e\u756a\u53f7\u3067\u3059\u3002
\n  \u3053\u308c\u3089\u306e\u884c\u306f\u3001\u7279\u5b9a\u306e\u5217\u3092\u6570\u5024\u30c7\u30fc\u30bf\u578b\u306b\u5909\u63db\u3057\u3001\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u5834\u5408\u306f\u305d\u308c\u3089\u3092 NaN \u306b\u5f37\u5236\u5909\u63db\u3057\u3066\u304b\u3089\u3001null \u8a31\u5bb9\u6574\u6570\u578b (Int64<\/code>) \u306b\u5909\u63db\u3057\u3066\u51e6\u7406\u3057\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.4. JP05a_GL03_04 \u304c\u6587\u5b57\u5217\u3068\u3057\u3066\u6b63\u3057\u304f\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059:<\/h3>\n
\n
\n
# \u6bd4\u8f03\u306e\u305f\u3081\u306bJP05a_GL03_04\uff08\u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0\uff09\u3092\u6587\u5b57\u5217\u3068\u3057\u3066\u6b63\u3057\u304f\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3059\u308b\r\n  df['JP05a_GL03_04'] = df['JP05a_GL03_04'].astype(str)<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u3053\u308c\u306b\u3088\u308a\u3001JP05a_GL03_04<\/code> \u304c\u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0\u3067\u3042\u308a\u3001\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u304a\u3088\u3073\u30de\u30fc\u30b8\u64cd\u4f5c\u4e2d\u306b\u4e00\u8cab\u3057\u305f\u6bd4\u8f03\u3092\u884c\u3046\u305f\u3081\u306b\u6587\u5b57\u5217\u3068\u3057\u3066\u6271\u308f\u308c\u308b\u3053\u3068\u304c\u4fdd\u8a3c\u3055\u308c\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.5. JP04a_GL02_03 \u3092 Datetime \u306b\u5909\u63db:<\/h3>\n
\n
\n
# JP04a_GL02_03\uff08\u4f1d\u7968\u65e5\u4ed8\uff09\u3092\u65e5\u6642\u306b\u5909\u63db\u3057\u3001\u975e\u6a19\u6e96\u306e\u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u51e6\u7406\u3059\u308b\r\n  df['JP04a_GL02_03'] = pd.to_datetime(df['JP04a_GL02_03'], errors='coerce')<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u3053\u306e\u884c\u306f\u3001JP04a_GL02_03<\/code> \u5217\u3092 datetime \u5f62\u5f0f\u306b\u5909\u63db\u3057\u3001\u30a8\u30e9\u30fc\u3092 NaT \u306b\u5f37\u5236\u5909\u63db\u3059\u308b\u3053\u3068\u3067\u975e\u6a19\u6e96\u306e\u65e5\u4ed8\u5f62\u5f0f\u3092\u51e6\u7406\u3057\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.6. JP04a_GL02_03 \u304b\u3089\u6708\u3092\u62bd\u51fa:<\/h3>\n
\n
\n
# JP04a_GL02_03\uff08\u4f1d\u7968\u65e5\u4ed8\uff09\u304b\u3089\u6708\u3092\u62bd\u51fa\u3057\u3001\u65b0\u3057\u3044\u5217\u306b\u8ffd\u52a0\u3059\u308b\r\n  df['JP04a_GL02_03_month'] = df['JP04a_GL02_03'].dt.to_period('M').astype(str)<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u3053\u308c\u306b\u3088\u308a\u3001JP04a_GL02_03<\/code> datetime \u5217\u304b\u3089\u6708\u304c\u62bd\u51fa\u3055\u308c\u3001\u65b0\u3057\u3044\u5217 JP04a_GL02_03_month<\/code> \u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.7. \u521d\u671f\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u5370\u5237:<\/h3>\n
\n
\n
# \u521d\u671f\u306eDataFrame\u3092\u8868\u793a\u3059\u308b\r\n  print(\"1. \u521d\u671f\u306eDataFrame:\")\r\n  print(df.head())<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u521d\u671f\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u5370\u5237\u3059\u308b\u3068\u3001\u521d\u671f\u30c7\u30fc\u30bf\u3092\u691c\u8a3c\u3057\u3001\u30c7\u30fc\u30bf\u578b\u3068\u5024\u304c\u6b63\u3057\u304f\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n
\n
\n
1. \u521d\u671f\u306eDataFrame:\r\n     JP04a  JP05a  JP12a  BS04cc            CC03dh_01  JP04a_GL02_01 JP04a_GL02_03      JP04a_GL02_04  ...     JP12a_03  CC05hZ_01 JP01c_BS28_01  JP01c_BS28_02  BS04cc_01 BS04cc_02   BS04cc_03 JP04a_GL02_03_month\r\n  0      1      0      0       0  2021-02-01T13:55:00          273.0    2021-04-25  4\u670825\u65e5\u4f1d\u7968No201\u4eca\u4e95\u767e\u8ca8\u5e97  ...          NaN        NaN           NaN            NaN        NaN       NaN         NaN             2021-04\r\n  1      1      2      0       0                  NaN            NaN           NaT                NaN  ...          NaN        0.0            00            \u5bfe\u8c61\u5916        NaN       NaN         NaN                 NaT\r\n  2      1      2      0       1                  NaN            NaN           NaT                NaN  ...          NaN        NaN           NaN            NaN        0.0      \u5171\u901a\u90e8\u9580  Department                 NaT\r\n  3      1      3      0       0                  NaN            NaN           NaT                NaN  ...          NaN        0.0            00            \u5bfe\u8c61\u5916        NaN       NaN         NaN                 NaT\r\n  4      1      3      1       0                  NaN            NaN           NaT                NaN  ...  Sub-Account        NaN           NaN            NaN        NaN       NaN         NaN                 NaT\r\n  \r\n  [5 rows x 24 columns]<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.8. \u5bfe\u8c61\u884c\u3092\u62bd\u51fa:<\/h3>\n
\n
\n
target_rows = df[(df['JP12a'] == 0) & (df['BS04cc'] == 0) & (df['JP05a'] != 0)][['JP04a', 'JP05a', 'CC05hW_01']]\r\n  print(\"\\n2. \u5bfe\u8c61\u306e\u884c:\")\r\n  print(target_rows.head())<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
JP12a<\/code> \u3068 BS04cc<\/code> \u304c\u30bc\u30ed\u3067 JP05a<\/code> \u304c\u30bc\u30ed\u3067\u306a\u3044\u884c\u3092\u62bd\u51fa\u3057\u3001CC05hW_01<\/code> \u5024\u3092\u53ce\u96c6\u3057\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n
\n
\n
2. \u5bfe\u8c61\u306e\u884c:\r\n      JP04a  JP05a  CC05hW_01\r\n  1       1      2   20392404\r\n  3       1      3   20392404\r\n  7       2      2    2186153\r\n  10      2      3    2186153\r\n  13      2      5        735<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.9. \u308f\u304b\u308a\u3084\u3059\u304f\u3059\u308b\u305f\u3081\u306b\u30bf\u30fc\u30b2\u30c3\u30c8\u5217\u306e\u540d\u524d\u3092\u5909\u66f4\u3057\u307e\u3059:<\/h3>\n
\n
\n
target_rows = target_rows.rename(columns={'CC05hW_01': 'CC05hW_01_target'})<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u30bf\u30fc\u30b2\u30c3\u30c8\u5217\u306e\u540d\u524d\u3092\u5909\u66f4\u3059\u308b\u3068\u3001\u30de\u30fc\u30b8 \u30d7\u30ed\u30bb\u30b9\u4e2d\u306b\u533a\u5225\u3057\u3084\u3059\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.10. JP04a \u5024\u306e\u307f\u306e\u884c\u3092\u62bd\u51fa:<\/h3>\n
\n
\n
# JP04a\uff08\u4ed5\u8a33\u30d8\u30c3\u30c0\uff09\u306b\u5024\u304c\u3042\u308a\u3001JP05a\uff08\u4ed5\u8a33\u660e\u7d30\uff09\u3001JP12a\uff08\u88dc\u52a9\u79d1\u76ee\uff09\u3001BS04cc\uff08\u90e8\u9580\uff09\u304c\u3059\u3079\u3066\u30bc\u30ed\u306e\u884c\u3092\u62bd\u51fa\u3059\u308b\r\n  jp04a_rows = df[(df['JP12a'] == 0) & (df['BS04cc'] == 0) & (df['JP05a'] == 0)][['JP04a', 'JP04a_GL02_03', 'JP04a_GL02_03_month']]\r\n  \r\n  # \u30de\u30fc\u30b8\u524d\u306b\u5217\u540d\u3092\u660e\u78ba\u306b\u3059\u308b\u305f\u3081\u306b\u5217\u540d\u3092\u5909\u66f4\u3059\u308b\r\n  jp04a_rows = jp04a_rows.rename(columns={'JP04a_GL02_03': 'JP04a_GL02_03_value', 'JP04a_GL02_03_month': 'JP04a_GL02_03_month_value'})<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u3053\u308c\u306f\u3001JP04a<\/code> \u306b\u5024\u304c\u3042\u308a\u3001\u4ed6\u306e\u6307\u5b9a\u3055\u308c\u305f\u5217\u304c\u30bc\u30ed\u3067\u3042\u308b\u884c\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002\u95a2\u9023\u3059\u308b\u5217\u306f\u3001\u30de\u30fc\u30b8\u4e2d\u306b\u308f\u304b\u308a\u3084\u3059\u304f\u3059\u308b\u305f\u3081\u306b\u540d\u524d\u304c\u5909\u66f4\u3055\u308c\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.11. \u5bfe\u8c61\u884c\u3092\u30e1\u30a4\u30f3 DataFrame \u306b\u30de\u30fc\u30b8\u3057\u307e\u3059:<\/h3>\n
\n
\n
# \u5bfe\u8c61\u306eCC05hW_01\uff08\u91d1\u984d\uff09\u306e\u5024\u3092\u30e1\u30a4\u30f3\u306eDataFrame\u306b\u30de\u30fc\u30b8\u3059\u308b\r\n  df = pd.merge(df, target_rows, on=['JP04a', 'JP05a'], how='left')<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u3053\u308c\u306f\u3001JP04a<\/code> \u3068 JP05a<\/code> \u306b\u57fa\u3065\u3044\u3066\u3001\u30bf\u30fc\u30b2\u30c3\u30c8 CC05hW_01<\/code> \u5024\u3092\u30e1\u30a4\u30f3 DataFrame \u306b\u30de\u30fc\u30b8\u3057\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.12. JP04a \u306e\u5024\u3092\u30e1\u30a4\u30f3 DataFrame \u306b\u30de\u30fc\u30b8\u3057\u307e\u3059:<\/h3>\n
\n
\n
# JP04a_GL02_03\uff08\u4f1d\u7968\u65e5\u4ed8\uff09\u304a\u3088\u3073JP04a_GL02_03_month\uff08\u4f1d\u7968\u65e5\u4ed8\u306e\u6708\uff09\u306e\u5024\u3092\u30e1\u30a4\u30f3\u306eDataFrame\u306b\u30de\u30fc\u30b8\u3059\u308b\r\n  df = pd.merge(df, jp04a_rows, on='JP04a', how='left')<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u3053\u308c\u306b\u3088\u308a\u3001JP04a_GL02_03<\/code> \u3068 JP04a_GL02_03_month<\/code> \u306e\u5024\u304c JP04a<\/code> \u306b\u57fa\u3065\u3044\u3066\u30e1\u30a4\u30f3 DataFrame \u306b\u30de\u30fc\u30b8\u3055\u308c\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.13. \u30e1\u30a4\u30f3 DataFrame \u3092\u6b63\u3057\u3044\u5024\u3067\u66f4\u65b0:<\/h3>\n
\n
\n
# \u6b63\u3057\u3044JP04a_GL02_03\uff08\u4f1d\u7968\u65e5\u4ed8\uff09\u304a\u3088\u3073JP04a_GL02_03_month\uff08\u4f1d\u7968\u65e5\u4ed8\u306e\u6708\uff09\u306e\u5024\u3067\u30e1\u30a4\u30f3\u306eDataFrame\u3092\u66f4\u65b0\u3059\u308b\r\n  df['JP04a_GL02_03'] = df['JP04a_GL02_03_value'].combine_first(df['JP04a_GL02_03'])\r\n  df['JP04a_GL02_03_month'] = df['JP04a_GL02_03_month_value'].combine_first(df['JP04a_GL02_03_month'])\r\n  \r\n  # \u30de\u30fc\u30b8\u306b\u4f7f\u7528\u3057\u305f\u4e00\u6642\u7684\u306a\u5217\u3092\u524a\u9664\u3059\u308b\r\n  df.drop(columns=['JP04a_GL02_03_value', 'JP04a_GL02_03_month_value'], inplace=True)<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u3053\u308c\u306b\u3088\u308a\u3001\u30e1\u30a4\u30f3 DataFrame \u304c\u6b63\u3057\u3044 JP04a_GL02_03<\/code> \u3067\u66f4\u65b0\u3055\u308c\u3001 JP04a_GL02_03_month<\/code> \u306e\u5024\u306f\u3001combine_first<\/code> \u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u3066\u3001\u6700\u521d\u306e\u30b7\u30ea\u30fc\u30ba\u306e\u975e null \u5024\u3092\u512a\u5148\u3057\u307e\u3059\u3002\u305d\u306e\u5f8c\u3001\u30de\u30fc\u30b8\u306b\u4f7f\u7528\u3055\u308c\u308b\u4e00\u6642\u5217\u306f\u524a\u9664\u3055\u308c\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.14. \u30de\u30fc\u30b8\u304a\u3088\u3073\u66f4\u65b0\u5f8c\u306e DataFrame \u3092\u5370\u5237:<\/h3>\n
\n
\n
# \u30de\u30fc\u30b8\u3068\u66f4\u65b0\u5f8c\u306eDataFrame\u3092\u8868\u793a\u3059\u308b\r\n  print(\"\\n3. \u30de\u30fc\u30b8\u3068\u66f4\u65b0\u5f8c\u306eDataFrame:\")\r\n  print(df.head())<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u30de\u30fc\u30b8\u304a\u3088\u3073\u66f4\u65b0\u5f8c\u306e DataFrame \u3092\u5370\u5237\u3059\u308b\u3068\u3001\u30c7\u30fc\u30bf\u304c\u6b63\u3057\u304f\u30de\u30fc\u30b8\u304a\u3088\u3073\u66f4\u65b0\u3055\u308c\u305f\u3053\u3068\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n
\n
\n
3. \u30de\u30fc\u30b8\u3068\u66f4\u65b0\u5f8c\u306eDataFrame:\r\n     JP04a  JP05a  JP12a  BS04cc            CC03dh_01  JP04a_GL02_01 JP04a_GL02_03      JP04a_GL02_04  ...  CC05hZ_01  JP01c_BS28_01 JP01c_BS28_02  BS04cc_01  BS04cc_02   BS04cc_03  JP04a_GL02_03_month CC05hW_01_target\r\n  0      1      0      0       0  2021-02-01T13:55:00          273.0    2021-04-25  4\u670825\u65e5\u4f1d\u7968No201\u4eca\u4e95\u767e\u8ca8\u5e97  ...        NaN            NaN           NaN        NaN        NaN         NaN              2021-04\r\n      <NA>\r\n  1      1      2      0       0                  NaN            NaN    2021-04-25                NaN  ...        0.0             00           \u5bfe\u8c61\u5916        NaN        NaN         NaN              2021-04         20392404\r\n  2      1      2      0       1                  NaN            NaN    2021-04-25                NaN  ...        NaN            NaN           NaN        0.0       \u5171\u901a\u90e8\u9580  Department              2021-04         20392404\r\n  3      1      3      0       0                  NaN            NaN    2021-04-25                NaN  ...        0.0             00           \u5bfe\u8c61\u5916        NaN        NaN         NaN              2021-04         20392404\r\n  4      1      3      1       0                  NaN            NaN    2021-04-25                NaN  ...        NaN            NaN           NaN        NaN        NaN         NaN              2021-04         20392404<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.15. \u4e00\u610f\u306e\u7d44\u307f\u5408\u308f\u305b\u3092\u53ce\u96c6:<\/h3>\n
\n
\n
# JP05a_GL03_04\uff08\u8cb8\u65b9\/\u501f\u65b9\u30d5\u30e9\u30b0\uff09\u3001JP13a_BS16_01\uff08\u79d1\u76ee\u30b3\u30fc\u30c9\uff09\u3001\u304a\u3088\u3073JP13a_BS16_02\uff08\u79d1\u76ee\u540d\uff09\u306e\u3059\u3079\u3066\u306e\u30e6\u30cb\u30fc\u30af\u306a\u7d44\u307f\u5408\u308f\u305b\u3092\u53ce\u96c6\u3059\u308b\r\n  unique_combinations = df[['JP05a_GL03_04', 'JP13a_BS16_01', 'JP13a_BS16_02']].drop_duplicates()\r\n  print(\"\\n4. \u30e6\u30cb\u30fc\u30af\u306a\u7d44\u307f\u5408\u308f\u305b:\")\r\n  print(unique_combinations)<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u3053\u308c\u306b\u3088\u308a\u3001JP05a_GL03_04<\/code>\u3001JP13a_BS16_01<\/code>\u3001JP13a_BS16_02<\/code> \u306e\u3059\u3079\u3066\u306e\u4e00\u610f\u306e\u7d44\u307f\u5408\u308f\u305b\u304c\u53ce\u96c6\u3055\u308c\u3001\u30c7\u30fc\u30bf\u306e\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3068\u96c6\u8a08\u304c\u5bb9\u6613\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n
\n
\n
4. \u30e6\u30cb\u30fc\u30af\u306a\u7d44\u307f\u5408\u308f\u305b:\r\n     JP05a_GL03_04  JP13a_BS16_01 JP13a_BS16_02\r\n  0            nan           <NA>           NaN\r\n  1              D            150          \u53d7\u53d6\u624b\u5f62\r\n  3              C            152           \u58f2\u639b\u91d1\r\n  7              D            131          \u666e\u901a\u9810\u91d1\r\n  13             D            741         \u652f\u6255\u624b\u6570\u6599\r\n  31             D            152           \u58f2\u639b\u91d1\r\n  34             C            511           \u58f2\u4e0a\u9ad8<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.16. \u7d50\u679c\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u521d\u671f\u5316\u3057\u307e\u3059:<\/h3>\n
\n
\n
# \u7d50\u679c\u3092\u4fdd\u5b58\u3059\u308b\u305f\u3081\u306b\u7a7a\u306eDataFrame\u3092\u521d\u671f\u5316\u3059\u308b\r\n  results = pd.DataFrame()<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u96c6\u8a08\u306e\u7d50\u679c\u3092\u683c\u7d0d\u3059\u308b\u305f\u3081\u306b\u3001\u7a7a\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u304c\u521d\u671f\u5316\u3055\u308c\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.17. \u5404\u4e00\u610f\u306e\u7d44\u307f\u5408\u308f\u305b\u3092\u53cd\u5fa9\u51e6\u7406\u3057\u3066\u30c7\u30fc\u30bf\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u304a\u3088\u3073\u96c6\u8a08\u3057\u307e\u3059:<\/h3>\n
\n
\n
# \u7d50\u679c\u3092\u4fdd\u5b58\u3059\u308b\u305f\u3081\u306b\u7a7a\u306eDataFrame\u3092\u521d\u671f\u5316\u3059\u308b\r\n  results = pd.DataFrame()\r\n  \r\n  # \u5404\u30e6\u30cb\u30fc\u30af\u306a\u7d44\u307f\u5408\u308f\u305b\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3057\u3001\u30c7\u30fc\u30bf\u3092\u96c6\u8a08\u3059\u308b\r\n  for _, row in unique_combinations.iterrows():\r\n      jp05a_gl03_04 = row['JP05a_GL03_04'] # \u8cb8\u65b9\/\u501f\u65b9\u30d5\u30e9\u30b0\r\n      jp13a_bs16_01 = row['JP13a_BS16_01'] # \u79d1\u76ee\u30b3\u30fc\u30c9\r\n      jp13a_bs16_02 = row['JP13a_BS16_02'] # \u79d1\u76ee\u540d\r\n      \r\n      # \u73fe\u5728\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u57fa\u3065\u3044\u3066DataFrame\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3059\u308b\r\n      filtered_df = df[(df['JP05a_GL03_04'] == jp05a_gl03_04) & # \u8cb8\u65b9\/\u501f\u65b9\u30d5\u30e9\u30b0\r\n                       (df['JP13a_BS16_01'] == jp13a_bs16_01) & # \u79d1\u76ee\u30b3\u30fc\u30c9\r\n                       (df['JP13a_BS16_02'] == jp13a_bs16_02) & # \u79d1\u76ee\u540d\r\n                       df['CC05hW_01_target'].notna()] # \u91d1\u984d\r\n  \r\n      print(f\"\\n5. \u73fe\u5728\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u57fa\u3065\u3044\u3066\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3055\u308c\u305fDataFrame ({jp05a_gl03_04}, {jp13a_bs16_01}, {jp13a_bs16_02}):\")\r\n      print(filtered_df)\r\n  \r\n      if not filtered_df.empty:\r\n          # NaN\u5024\u3092\u524a\u9664\u305b\u305a\u306b\u7d50\u679c\u3092\u8868\u793a\u3059\u308b\r\n          for _, filtered_row in filtered_df.iterrows():\r\n              date = filtered_row['JP04a_GL02_03'] if pd.notna(filtered_row['JP04a_GL02_03']) else 'N\/A'\r\n              debit_credit_code = filtered_row['JP05a_GL03_04'] if pd.notna(filtered_row['JP05a_GL03_04']) else 'N\/A'\r\n              ledger_account_number = filtered_row['JP13a_BS16_01'] if pd.notna(filtered_row['JP13a_BS16_01']) else 'N\/A'\r\n              ledger_account_name = filtered_row['JP13a_BS16_02'] if pd.notna(filtered_row['JP13a_BS16_02']) else 'N\/A'\r\n              amount = filtered_row['CC05hW_01_target'] if pd.notna(filtered_row['CC05hW_01_target']) else 'N\/A'\r\n  \r\n              print(f\"\u65e5\u4ed8: {date}, \"\r\n                    f\"\u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: {debit_credit_code}, \"\r\n                    f\"\u79d1\u76ee\u30b3\u30fc\u30c9: {ledger_account_number}, \"\r\n                    f\"\u79d1\u76ee\u540d: {ledger_account_name}, \"\r\n                    f\"\u91d1\u984d: {amount}\")\r\n  \r\n          # \u30b0\u30eb\u30fc\u30d7\u5316\u306b\u4f7f\u7528\u3059\u308b\u5217\u304cnull\u3067\u306a\u3044\u3053\u3068\u3092\u4fdd\u8a3c\u3059\u308b\r\n          filtered_df = filtered_df.fillna('N\/A')\r\n  \r\n          # \u5fc5\u8981\u306a\u5217\u3067\u30b0\u30eb\u30fc\u30d7\u5316\u3057\u3001'CC05hW_01_target'\u306e\u5408\u8a08\u3092\u96c6\u8a08\u3059\u308b\r\n          result = filtered_df.groupby(\r\n              ['JP04a_GL02_03_month', 'JP05a_GL03_04', 'JP13a_BS16_01', 'JP13a_BS16_02']\r\n          )['CC05hW_01_target'].sum().reset_index()\r\n  \r\n          print(\"\\n6. \u9014\u4e2d\u7d50\u679c:\")\r\n          print(result)\r\n  \r\n          # \u7d50\u679c\u3092\u7d50\u679cDataFrame\u306b\u8ffd\u52a0\u3059\u308b\r\n          results = pd.concat([results, result], ignore_index=True)<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u5404\u4e00\u610f\u306e\u7d44\u307f\u5408\u308f\u305b\u3092\u53cd\u5fa9\u51e6\u7406\u3057\u3001DataFrame \u3092\u30d5\u30a3\u30eb\u30bf\u30fc\u51e6\u7406\u3057\u3001\u4e2d\u9593\u7d50\u679c\u3092\u51fa\u529b\u3057\u3001CC05hW_01_target<\/code> \u306e\u5408\u8a08\u3092\u96c6\u8a08\u3057\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n
\n
\n
5. \u73fe\u5728\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u57fa\u3065\u3044\u3066\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3055\u308c\u305fDataFrame (nan, <NA>, nan):\r\n  Empty DataFrame\r\n  Columns: [JP04a, JP05a, JP12a, BS04cc, CC03dh_01, JP04a_GL02_01, JP04a_GL02_03, JP04a_GL02_04, GL05c_01, BS15c_01, JP05a_GL03_04, CC05hW_01, JP13a_BS16_01, JP13a_BS16_02, JP12a_01, JP12a_02, JP12a_03, CC05hZ_01, JP01c_BS28_01, JP01c_BS28_02, BS04cc_01, BS04cc_02, BS04cc_03, JP04a_GL02_03_month, CC05hW_01_target]\r\n  Index: []\r\n  \r\n  5. \u73fe\u5728\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u57fa\u3065\u3044\u3066\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3055\u308c\u305fDataFrame (D, 150, \u53d7\u53d6\u624b\u5f62):\r\n     JP04a  JP05a  JP12a  BS04cc CC03dh_01  JP04a_GL02_01 JP04a_GL02_03 JP04a_GL02_04  GL05c_01  ...  JP12a_03 CC05hZ_01  JP01c_BS28_01  JP01c_BS28_02 BS04cc_01  BS04cc_02 BS04cc_03 JP04a_GL02_03_month  CC05hW_01_target1      1      2      0       0       NaN            NaN    2021-04-25           NaN       NaN  ...       NaN       0.0             00            \u5bfe\u8c61\u5916       NaN        NaN       NaN             2021-04          20392404\r\n  \r\n  [1 rows x 25 columns]\r\n  \u65e5\u4ed8: 2021-04-25 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: D, \u79d1\u76ee\u30b3\u30fc\u30c9: 150, \u79d1\u76ee\u540d: \u53d7\u53d6\u624b\u5f62, \u91d1\u984d: 20392404\r\n  \r\n  6. \u9014\u4e2d\u7d50\u679c:\r\n    JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01 JP13a_BS16_02  CC05hW_01_target\r\n  0             2021-04             D            150          \u53d7\u53d6\u624b\u5f62          20392404\r\n  \r\n  5. \u73fe\u5728\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u57fa\u3065\u3044\u3066\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3055\u308c\u305fDataFrame (C, 152, \u58f2\u639b\u91d1):\r\n      JP04a  JP05a  JP12a  BS04cc CC03dh_01  JP04a_GL02_01 JP04a_GL02_03 JP04a_GL02_04  GL05c_01  ...  JP12a_03 CC05hZ_01  JP01c_BS28_01  JP01c_BS28_02 BS04cc_01  BS04cc_02 BS04cc_03 JP04a_GL02_03_month  CC05hW_01_target\r\n  3       1      3      0       0       NaN            NaN    2021-04-25           NaN       NaN  ...       NaN       0.0             00            \u5bfe\u8c61\u5916       NaN        NaN       NaN             2021-04          20392404\r\n  10      2      3      0       0       NaN            NaN    2021-04-25           NaN       NaN  ...       NaN       0.0             00            \u5bfe\u8c61\u5916       NaN        NaN       NaN             2021-04           2186153\r\n  15      2      6      0       0       NaN            NaN    2021-04-25           NaN       NaN  ...       NaN       0.0             00            \u5bfe\u8c61\u5916       NaN        NaN       NaN             2021-04\r\n   735\r\n  22      3      3      0       0       NaN            NaN    2021-04-25           NaN       NaN  ...       NaN       0.0             00            \u5bfe\u8c61\u5916       NaN        NaN       NaN             2021-04           6636909\r\n  27      3      6      0       0       NaN            NaN    2021-04-25           NaN       NaN  ...       NaN       0.0             00            \u5bfe\u8c61\u5916       NaN        NaN       NaN             2021-04\r\n   840\r\n  \r\n  [5 rows x 25 columns]\r\n  \u65e5\u4ed8: 2021-04-25 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: C, \u79d1\u76ee\u30b3\u30fc\u30c9: 152, \u79d1\u76ee\u540d: \u58f2\u639b\u91d1, \u91d1\u984d: 20392404\r\n  \u65e5\u4ed8: 2021-04-25 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: C, \u79d1\u76ee\u30b3\u30fc\u30c9: 152, \u79d1\u76ee\u540d: \u58f2\u639b\u91d1, \u91d1\u984d: 2186153\r\n  \u65e5\u4ed8: 2021-04-25 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: C, \u79d1\u76ee\u30b3\u30fc\u30c9: 152, \u79d1\u76ee\u540d: \u58f2\u639b\u91d1, \u91d1\u984d: 735\r\n  \u65e5\u4ed8: 2021-04-25 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: C, \u79d1\u76ee\u30b3\u30fc\u30c9: 152, \u79d1\u76ee\u540d: \u58f2\u639b\u91d1, \u91d1\u984d: 6636909\r\n  \u65e5\u4ed8: 2021-04-25 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: C, \u79d1\u76ee\u30b3\u30fc\u30c9: 152, \u79d1\u76ee\u540d: \u58f2\u639b\u91d1, \u91d1\u984d: 840\r\n  \r\n  6. \u9014\u4e2d\u7d50\u679c:\r\n    JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01 JP13a_BS16_02  CC05hW_01_target\r\n  0             2021-04             C            152           \u58f2\u639b\u91d1          29217041\r\n  \r\n  5. \u73fe\u5728\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u57fa\u3065\u3044\u3066\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3055\u308c\u305fDataFrame (D, 131, \u666e\u901a\u9810\u91d1):\r\n      JP04a  JP05a  JP12a  BS04cc CC03dh_01  JP04a_GL02_01 JP04a_GL02_03 JP04a_GL02_04  GL05c_01  ...  JP12a_03 CC05hZ_01  JP01c_BS28_01  JP01c_BS28_02 BS04cc_01  BS04cc_02 BS04cc_03 JP04a_GL02_03_month  CC05hW_01_target\r\n  7       2      2      0       0       NaN            NaN    2021-04-25           NaN       NaN  ...       NaN       0.0             00            \u5bfe\u8c61\u5916       NaN        NaN       NaN             2021-04           2186153\r\n  19      3      2      0       0       NaN            NaN    2021-04-25           NaN       NaN  ...       NaN       0.0             00            \u5bfe\u8c61\u5916       NaN        NaN       NaN             2021-04           6636909\r\n  \r\n  [2 rows x 25 columns]\r\n  \u65e5\u4ed8: 2021-04-25 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: D, \u79d1\u76ee\u30b3\u30fc\u30c9: 131, \u79d1\u76ee\u540d: \u666e\u901a\u9810\u91d1, \u91d1\u984d: 2186153\r\n  \u65e5\u4ed8: 2021-04-25 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: D, \u79d1\u76ee\u30b3\u30fc\u30c9: 131, \u79d1\u76ee\u540d: \u666e\u901a\u9810\u91d1, \u91d1\u984d: 6636909\r\n  \r\n  6. \u9014\u4e2d\u7d50\u679c:\r\n    JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01 JP13a_BS16_02  CC05hW_01_target\r\n  0             2021-04             D            131          \u666e\u901a\u9810\u91d1           8823062\r\n  \r\n  5. \u73fe\u5728\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u57fa\u3065\u3044\u3066\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3055\u308c\u305fDataFrame (D, 741, \u652f\u6255\u624b\u6570\u6599):\r\n      JP04a  JP05a  JP12a  BS04cc CC03dh_01  JP04a_GL02_01 JP04a_GL02_03 JP04a_GL02_04  GL05c_01  ...  JP12a_03 CC05hZ_01  JP01c_BS28_01  JP01c_BS28_02 BS04cc_01  BS04cc_02 BS04cc_03 JP04a_GL02_03_month  CC05hW_01_target\r\n  13      2      5      0       0       NaN            NaN    2021-04-25           NaN       NaN  ...       NaN      66.0             Q5          \u4ed5\u516510%       NaN        NaN       NaN             2021-04\r\n  735\r\n  25      3      5      0       0       NaN            NaN    2021-04-25           NaN       NaN  ...       NaN      76.0             Q5          \u4ed5\u516510%       NaN        NaN       NaN             2021-04\r\n  840\r\n  \r\n  [2 rows x 25 columns]\r\n  \u65e5\u4ed8: 2021-04-25 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: D, \u79d1\u76ee\u30b3\u30fc\u30c9: 741, \u79d1\u76ee\u540d: \u652f\u6255\u624b\u6570\u6599, \u91d1\u984d: 735\r\n  \u65e5\u4ed8: 2021-04-25 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: D, \u79d1\u76ee\u30b3\u30fc\u30c9: 741, \u79d1\u76ee\u540d: \u652f\u6255\u624b\u6570\u6599, \u91d1\u984d: 840\r\n  \r\n  6. \u9014\u4e2d\u7d50\u679c:\r\n    JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01 JP13a_BS16_02  CC05hW_01_target\r\n  0             2021-04             D            741         \u652f\u6255\u624b\u6570\u6599              1575\r\n  \r\n  5. \u73fe\u5728\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u57fa\u3065\u3044\u3066\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3055\u308c\u305fDataFrame (D, 152, \u58f2\u639b\u91d1):\r\n      JP04a  JP05a  JP12a  BS04cc CC03dh_01  JP04a_GL02_01 JP04a_GL02_03 JP04a_GL02_04  GL05c_01  ...  JP12a_03 CC05hZ_01  JP01c_BS28_01  JP01c_BS28_02 BS04cc_01  BS04cc_02 BS04cc_03 JP04a_GL02_03_month  CC05hW_01_target\r\n  31      4      2      0       0       NaN            NaN    2021-05-31           NaN       NaN  ...       NaN       0.0             00            \u5bfe\u8c61\u5916       NaN        NaN       NaN             2021-05           1245400\r\n  36      4      5      0       0       NaN            NaN    2021-05-31           NaN       NaN  ...       NaN       0.0             00            \u5bfe\u8c61\u5916       NaN        NaN       NaN             2021-05           1329984\r\n  41      4      8      0       0       NaN            NaN    2021-05-31           NaN       NaN  ...       NaN       0.0             00            \u5bfe\u8c61\u5916       NaN        NaN       NaN             2021-05           3964716\r\n  46      4     11      0       0       NaN            NaN    2021-05-31           NaN       NaN  ...       NaN       0.0             00            \u5bfe\u8c61\u5916       NaN        NaN       NaN             2021-05            101952\r\n  51      4     14      0       0       NaN            NaN    2021-05-31           NaN       NaN  ...       NaN       0.0             00            \u5bfe\u8c61\u5916       NaN        NaN       NaN             2021-05             40800\r\n  \r\n  [5 rows x 25 columns]\r\n  \u65e5\u4ed8: 2021-05-31 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: D, \u79d1\u76ee\u30b3\u30fc\u30c9: 152, \u79d1\u76ee\u540d: \u58f2\u639b\u91d1, \u91d1\u984d: 1245400\r\n  \u65e5\u4ed8: 2021-05-31 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: D, \u79d1\u76ee\u30b3\u30fc\u30c9: 152, \u79d1\u76ee\u540d: \u58f2\u639b\u91d1, \u91d1\u984d: 1329984\r\n  \u65e5\u4ed8: 2021-05-31 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: D, \u79d1\u76ee\u30b3\u30fc\u30c9: 152, \u79d1\u76ee\u540d: \u58f2\u639b\u91d1, \u91d1\u984d: 3964716\r\n  \u65e5\u4ed8: 2021-05-31 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: D, \u79d1\u76ee\u30b3\u30fc\u30c9: 152, \u79d1\u76ee\u540d: \u58f2\u639b\u91d1, \u91d1\u984d: 101952\r\n  \u65e5\u4ed8: 2021-05-31 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: D, \u79d1\u76ee\u30b3\u30fc\u30c9: 152, \u79d1\u76ee\u540d: \u58f2\u639b\u91d1, \u91d1\u984d: 40800\r\n  \r\n  6. \u9014\u4e2d\u7d50\u679c:\r\n    JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01 JP13a_BS16_02  CC05hW_01_target\r\n  0             2021-05             D            152           \u58f2\u639b\u91d1           6682852\r\n  \r\n  5. \u73fe\u5728\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u57fa\u3065\u3044\u3066\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3055\u308c\u305fDataFrame (C, 511, \u58f2\u4e0a\u9ad8):\r\n      JP04a  JP05a  JP12a  BS04cc CC03dh_01  JP04a_GL02_01 JP04a_GL02_03 JP04a_GL02_04  GL05c_01  ...  JP12a_03 CC05hZ_01  JP01c_BS28_01  JP01c_BS28_02 BS04cc_01  BS04cc_02 BS04cc_03 JP04a_GL02_03_month  CC05hW_01_target\r\n  34      4      3      0       0       NaN            NaN    2021-05-31           NaN       NaN  ...       NaN  113218.0             B5          \u58f2\u4e0a10%       NaN        NaN       NaN             2021-05           1245400\r\n  39      4      6      0       0       NaN            NaN    2021-05-31           NaN       NaN  ...       NaN  120907.0             B5          \u58f2\u4e0a10%       NaN        NaN       NaN             2021-05           1329984\r\n  44      4      9      0       0       NaN            NaN    2021-05-31           NaN       NaN  ...       NaN  360428.0             B5          \u58f2\u4e0a10%       NaN        NaN       NaN             2021-05           3964716\r\n  \r\n  [3 rows x 25 columns]\r\n  \u65e5\u4ed8: 2021-05-31 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: C, \u79d1\u76ee\u30b3\u30fc\u30c9: 511, \u79d1\u76ee\u540d: \u58f2\u4e0a\u9ad8, \u91d1\u984d: 1245400\r\n  \u65e5\u4ed8: 2021-05-31 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: C, \u79d1\u76ee\u30b3\u30fc\u30c9: 511, \u79d1\u76ee\u540d: \u58f2\u4e0a\u9ad8, \u91d1\u984d: 1329984\r\n  \u65e5\u4ed8: 2021-05-31 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: C, \u79d1\u76ee\u30b3\u30fc\u30c9: 511, \u79d1\u76ee\u540d: \u58f2\u4e0a\u9ad8, \u91d1\u984d: 3964716\r\n  \r\n  6. \u9014\u4e2d\u7d50\u679c:\r\n    JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01 JP13a_BS16_02  CC05hW_01_target\r\n  0             2021-05             C            511           \u58f2\u4e0a\u9ad8           6540100\r\n  \r\n  5. \u73fe\u5728\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u57fa\u3065\u3044\u3066\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3055\u308c\u305fDataFrame (C, 521, \u58f2\u4e0a\u5024\u5f15\u623b\u308a\u9ad8):\r\n      JP04a  JP05a  JP12a  BS04cc CC03dh_01  JP04a_GL02_01 JP04a_GL02_03 JP04a_GL02_04  GL05c_01  ...  JP12a_03 CC05hZ_01  JP01c_BS28_01  JP01c_BS28_02 BS04cc_01  BS04cc_02 BS04cc_03 JP04a_GL02_03_month  CC05hW_01_target\r\n  49      4     12      0       0       NaN            NaN    2021-05-31           NaN       NaN  ...       NaN    9268.0             C5          \u58f2\u8fd410%       NaN        NaN       NaN             2021-05            101952\r\n  54      4     15      0       0       NaN            NaN    2021-05-31           NaN       NaN  ...       NaN    3709.0             C5          \u58f2\u8fd410%       NaN        NaN       NaN             2021-05             40800\r\n  \r\n  [2 rows x 25 columns]\r\n  \u65e5\u4ed8: 2021-05-31 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: C, \u79d1\u76ee\u30b3\u30fc\u30c9: 521, \u79d1\u76ee\u540d: \u58f2\u4e0a\u5024\u5f15\u623b\u308a\u9ad8, \u91d1\u984d: 101952\r\n  \u65e5\u4ed8: 2021-05-31 00:00:00, \u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0: C, \u79d1\u76ee\u30b3\u30fc\u30c9: 521, \u79d1\u76ee\u540d: \u58f2\u4e0a\u5024\u5f15\u623b\u308a\u9ad8, \u91d1\u984d: 40800\r\n  \r\n  6. \u9014\u4e2d\u7d50\u679c:\r\n    JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01 JP13a_BS16_02  CC05hW_01_target<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
3.18. \u6700\u7d42\u7d50\u679c\u306e\u8868\u793a:<\/h3>\n
\n
\n
# \u6700\u7d42\u7d50\u679c\u3092\u8868\u793a\u3059\u308b\r\n  print(\"\\n7. \u6700\u7d42\u7d50\u679c:\")\r\n  print(results)<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u6700\u5f8c\u306b\u3001JP04a_GL02_03_month<\/code>\u3001JP05a_GL03_04<\/code>\u3001JP05a_GL03_04<\/code> \u306e\u5404\u7d44\u307f\u5408\u308f\u305b\u306b\u5bfe\u3059\u308b CC05hW_01_target<\/code> \u306e\u5408\u8a08\u3092\u793a\u3059\u6700\u7d42\u7d50\u679c\u3092\u8868\u793a\u3057\u307e\u3059\u3002 JP13a_BS16_01<\/code>\u3001\u304a\u3088\u3073 JP13a_BS16_02<\/code>\u3002<\/p>\n<\/p><\/div>\n
\n
\n
7. \u6700\u7d42\u7d50\u679c:\r\n    JP04a_GL02_03_month JP05a_GL03_04  JP13a_BS16_01 JP13a_BS16_02  CC05hW_01_target\r\n  0             2021-04             D            150          \u53d7\u53d6\u624b\u5f62          20392404\r\n  1             2021-04             C            152           \u58f2\u639b\u91d1          29217041\r\n  2             2021-04             D            131          \u666e\u901a\u9810\u91d1           8823062\r\n  3             2021-04             D            741         \u652f\u6255\u624b\u6570\u6599              1575\r\n  4             2021-05             D            152           \u58f2\u639b\u91d1           6682852\r\n  5             2021-05             C            511           \u58f2\u4e0a\u9ad8           6540100<\/code><\/pre>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\u3053\u308c\u3089\u306e\u624b\u9806\u306b\u5f93\u3046\u3053\u3068\u3067\u3001\u968e\u5c64\u7684\u306b\u6574\u9813\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3067\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u7ba1\u7406\u304c\u78ba\u4fdd\u3055\u308c\u3001\u5197\u9577\u6027\u304c\u56de\u907f\u3055\u308c\u3001\u8ca1\u52d9\u30c7\u30fc\u30bf\u3092\u6b63\u78ba\u306b\u8981\u7d04\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
4. \u7d50\u8ad6<\/h2>\n
\n
\n
\u968e\u5c64\u7684\u306a\u6574\u9813\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u51e6\u7406\u3059\u308b\u306b\u306f\u3001\u3055\u307e\u3056\u307e\u306a\u30ec\u30d9\u30eb\u306e\u89b3\u5bdf\u304c\u3069\u306e\u3088\u3046\u306b\u5831\u544a\u3055\u308c\u308b\u304b\u3092\u614e\u91cd\u306b\u8003\u616e\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u5bfe\u8c61\u884c\u306b\u30de\u30fc\u30b8\u3059\u308b\u3053\u3068\u3067\u3001\u501f\u65b9\/\u8cb8\u65b9\u30d5\u30e9\u30b0\u3001\u53e3\u5ea7\u756a\u53f7\u3001\u6708\u306b\u57fa\u3065\u3044\u3066\u91d1\u984d\u3092\u8981\u7d04\u3067\u304d\u308b\u305f\u3081\u3001\u5197\u9577\u6027\u304c\u56de\u907f\u3055\u308c\u3001\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u7ba1\u7406\u304c\u4fdd\u8a3c\u3055\u308c\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n
\n
\u3053\u306e\u8a18\u4e8b\u3067\u6982\u8aac\u3057\u305f\u30a2\u30d7\u30ed\u30fc\u30c1\u306f\u3001Python \u3068 pandas \u3092\u4f7f\u7528\u3057\u3066\u3053\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u3092\u51e6\u7406\u3059\u308b\u65b9\u6cd5\u3092\u793a\u3057\u3001\u8ca1\u52d9\u5831\u544a\u306e\u305f\u3081\u306e\u5805\u7262\u306a\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
5. \u968e\u5c64\u7684\u306a\u6574\u9813\u3055\u308c\u305f\u30c7\u30fc\u30bf \u30d5\u30a1\u30a4\u30eb<\/h2>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n  <\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
JP04a<\/p>\n<\/td>\n
\n
JP05a<\/p>\n<\/td>\n
\n
JP12a<\/p>\n<\/td>\n
\n
BS04cc<\/p>\n<\/td>\n
\n
CC03dh_01<\/p>\n<\/td>\n
\n
JP04a_GL02_01<\/p>\n<\/td>\n
\n
JP04a_GL02_03<\/p>\n<\/td>\n
\n
JP04a_GL02_04<\/p>\n<\/td>\n
\n
GL05c_01<\/p>\n<\/td>\n
\n
BS15c_01<\/p>\n<\/td>\n
\n
JP05a_GL03_04<\/p>\n<\/td>\n
\n
CC05hW_01<\/p>\n<\/td>\n
\n
JP13a_BS16_01<\/p>\n<\/td>\n
\n
JP13a_BS16_02<\/p>\n<\/td>\n
\n
JP12a_01<\/p>\n<\/td>\n
\n
JP12a_02<\/p>\n<\/td>\n
\n
JP12a_03<\/p>\n<\/td>\n
\n
CC05hZ_01<\/p>\n<\/td>\n
\n
JP01c_BS28_01<\/p>\n<\/td>\n
\n
JP01c_BS28_02<\/p>\n<\/td>\n
\n
BS04cc_01<\/p>\n<\/td>\n
\n
BS04cc_02<\/p>\n<\/td>\n
\n
BS04cc_03<\/p>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
2021-02-01T13:55:00<\/p>\n<\/td>\n
\n
273<\/p>\n<\/td>\n
\n
2021-04-25<\/p>\n<\/td>\n
\n
4\u670825\u65e5\u4f1d\u7968No201\u4eca\u4e95\u767e\u8ca8\u5e97<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
21<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
20392404<\/p>\n<\/td>\n
\n
150<\/p>\n<\/td>\n
\n
\u53d7\u53d6\u624b\u5f62<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
\u5bfe\u8c61\u5916<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
000<\/p>\n<\/td>\n
\n
\u5171\u901a\u90e8\u9580<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
20392404<\/p>\n<\/td>\n
\n
152<\/p>\n<\/td>\n
\n
\u58f2\u639b\u91d1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
\u5bfe\u8c61\u5916<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
2<\/p>\n<\/td>\n
\n
\u4eca\u4e95\u767e\u8ca8\u5e97<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
000<\/p>\n<\/td>\n
\n
\u5171\u901a\u90e8\u9580<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
2021-02-01T13:55:00<\/p>\n<\/td>\n
\n
274<\/p>\n<\/td>\n
\n
2021-04-25<\/p>\n<\/td>\n
\n
4\u670825\u65e5\u4f1d\u7968No202\u682a\u5f0f\u4f1a\u793e \u7dcf\u5408\u7d4c\u55b6<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
21<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
2186153<\/p>\n<\/td>\n
\n
131<\/p>\n<\/td>\n
\n
\u666e\u901a\u9810\u91d1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
\u5bfe\u8c61\u5916<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
30<\/p>\n<\/td>\n
\n
\u4e09\u4e95 \u540d\u53e4\u5c4b<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
000<\/p>\n<\/td>\n
\n
\u5171\u901a\u90e8\u9580<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
2186153<\/p>\n<\/td>\n
\n
152<\/p>\n<\/td>\n
\n
\u58f2\u639b\u91d1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
\u5bfe\u8c61\u5916<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
7<\/p>\n<\/td>\n
\n
\u3231\u7dcf\u5408\u7d4c\u55b6<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
000<\/p>\n<\/td>\n
\n
\u5171\u901a\u90e8\u9580<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
735<\/p>\n<\/td>\n
\n
741<\/p>\n<\/td>\n
\n
\u652f\u6255\u624b\u6570\u6599<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
66<\/p>\n<\/td>\n
\n
Q5<\/p>\n<\/td>\n
\n
\u4ed5\u516510%<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
030<\/p>\n<\/td>\n
\n
\u540d\u53e4\u5c4b\u652f\u5e97<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
735<\/p>\n<\/td>\n
\n
152<\/p>\n<\/td>\n
\n
\u58f2\u639b\u91d1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
\u5bfe\u8c61\u5916<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
7<\/p>\n<\/td>\n
\n
\u3231\u7dcf\u5408\u7d4c\u55b6<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
2<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
000<\/p>\n<\/td>\n
\n
\u5171\u901a\u90e8\u9580<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
2021-02-01T13:55:00<\/p>\n<\/td>\n
\n
275<\/p>\n<\/td>\n
\n
2021-04-25<\/p>\n<\/td>\n
\n
4\u670825\u65e5\u4f1d\u7968No203\u682a\u5f0f\u4f1a\u793e \u5c0f\u6797\u30de\u30fc\u30b1\u30c3\u30c8<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
21<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
6636909<\/p>\n<\/td>\n
\n
131<\/p>\n<\/td>\n
\n
\u666e\u901a\u9810\u91d1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
\u5bfe\u8c61\u5916<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
10<\/p>\n<\/td>\n
\n
\u5317\u6d77\u9053 \u99c5\u524d<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
000<\/p>\n<\/td>\n
\n
\u5171\u901a\u90e8\u9580<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
6636909<\/p>\n<\/td>\n
\n
152<\/p>\n<\/td>\n
\n
\u58f2\u639b\u91d1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
\u5bfe\u8c61\u5916<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
25<\/p>\n<\/td>\n
\n
\u3231\u5c0f\u6797\uff8f\uff70\uff79\uff6f\uff84<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
000<\/p>\n<\/td>\n
\n
\u5171\u901a\u90e8\u9580<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
840<\/p>\n<\/td>\n
\n
741<\/p>\n<\/td>\n
\n
\u652f\u6255\u624b\u6570\u6599<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
76<\/p>\n<\/td>\n
\n
Q5<\/p>\n<\/td>\n
\n
\u4ed5\u516510%<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
010<\/p>\n<\/td>\n
\n
\u672d\u5e4c\u55b6\u696d\u6240<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
840<\/p>\n<\/td>\n
\n
152<\/p>\n<\/td>\n
\n
\u58f2\u639b\u91d1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
\u5bfe\u8c61\u5916<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
25<\/p>\n<\/td>\n
\n
\u3231\u5c0f\u6797\uff8f\uff70\uff79\uff6f\uff84<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
3<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
000<\/p>\n<\/td>\n
\n
\u5171\u901a\u90e8\u9580<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
2021-02-01T13:55:00<\/p>\n<\/td>\n
\n
114<\/p>\n<\/td>\n
\n
2021-05-31<\/p>\n<\/td>\n
\n
5\u67081\u65e5\uff5e5\u670831\u65e5\u5206\u58f2\u4e0a<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
21<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
1245400<\/p>\n<\/td>\n
\n
152<\/p>\n<\/td>\n
\n
\u58f2\u639b\u91d1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
\u5bfe\u8c61\u5916<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
5<\/p>\n<\/td>\n
\n
\u3231ABC<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
000<\/p>\n<\/td>\n
\n
\u5171\u901a\u90e8\u9580<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
1245400<\/p>\n<\/td>\n
\n
511<\/p>\n<\/td>\n
\n
\u58f2\u4e0a\u9ad8<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
113218<\/p>\n<\/td>\n
\n
B5<\/p>\n<\/td>\n
\n
\u58f2\u4e0a10%<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
010<\/p>\n<\/td>\n
\n
\u672d\u5e4c\u55b6\u696d\u6240<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
1329984<\/p>\n<\/td>\n
\n
152<\/p>\n<\/td>\n
\n
\u58f2\u639b\u91d1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
\u5bfe\u8c61\u5916<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
14<\/p>\n<\/td>\n
\n
\u3231\u85e4\u7530<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
000<\/p>\n<\/td>\n
\n
\u5171\u901a\u90e8\u9580<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
1329984<\/p>\n<\/td>\n
\n
511<\/p>\n<\/td>\n
\n
\u58f2\u4e0a\u9ad8<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
120907<\/p>\n<\/td>\n
\n
B5<\/p>\n<\/td>\n
\n
\u58f2\u4e0a10%<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
010<\/p>\n<\/td>\n
\n
\u672d\u5e4c\u55b6\u696d\u6240<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
8<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
3964716<\/p>\n<\/td>\n
\n
152<\/p>\n<\/td>\n
\n
\u58f2\u639b\u91d1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
\u5bfe\u8c61\u5916<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
8<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
25<\/p>\n<\/td>\n
\n
\u3231\u5c0f\u6797\uff8f\uff70\uff79\uff6f\uff84<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
8<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
000<\/p>\n<\/td>\n
\n
\u5171\u901a\u90e8\u9580<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
9<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
3964716<\/p>\n<\/td>\n
\n
511<\/p>\n<\/td>\n
\n
\u58f2\u4e0a\u9ad8<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
360428<\/p>\n<\/td>\n
\n
B5<\/p>\n<\/td>\n
\n
\u58f2\u4e0a10%<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
9<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
010<\/p>\n<\/td>\n
\n
\u672d\u5e4c\u55b6\u696d\u6240<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
11<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
101952<\/p>\n<\/td>\n
\n
152<\/p>\n<\/td>\n
\n
\u58f2\u639b\u91d1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
\u5bfe\u8c61\u5916<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
11<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
25<\/p>\n<\/td>\n
\n
\u3231\u5c0f\u6797\uff8f\uff70\uff79\uff6f\uff84<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
11<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
000<\/p>\n<\/td>\n
\n
\u5171\u901a\u90e8\u9580<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
12<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
101952<\/p>\n<\/td>\n
\n
521<\/p>\n<\/td>\n
\n
\u58f2\u4e0a\u5024\u5f15\u623b\u308a\u9ad8<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
9268<\/p>\n<\/td>\n
\n
C5<\/p>\n<\/td>\n
\n
\u58f2\u8fd410%<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
12<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
010<\/p>\n<\/td>\n
\n
\u672d\u5e4c\u55b6\u696d\u6240<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
14<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
D<\/p>\n<\/td>\n
\n
40800<\/p>\n<\/td>\n
\n
152<\/p>\n<\/td>\n
\n
\u58f2\u639b\u91d1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
\u5bfe\u8c61\u5916<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
14<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
5<\/p>\n<\/td>\n
\n
\u3231ABC<\/p>\n<\/td>\n
\n
Sub-Account<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
14<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
000<\/p>\n<\/td>\n
\n
\u5171\u901a\u90e8\u9580<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
15<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
C<\/p>\n<\/td>\n
\n
40800<\/p>\n<\/td>\n
\n
521<\/p>\n<\/td>\n
\n
\u58f2\u4e0a\u5024\u5f15\u623b\u308a\u9ad8<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n\n
3709<\/p>\n<\/td>\n
\n
C5<\/p>\n<\/td>\n
\n
\u58f2\u8fd410%<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n
4<\/p>\n<\/td>\n
\n
15<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n\n
010<\/p>\n<\/td>\n
\n
\u672d\u5e4c\u55b6\u696d\u6240<\/p>\n<\/td>\n
\n
Department<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\n  Last updated 2024-05-31 10:22:07 +0900\n  <\/div>\n<\/p><\/div>\n
\n
\u76ee\u6b21<\/div>\n