{"id":492,"date":"2023-10-27T14:14:05","date_gmt":"2023-05-03T11:58:07","guid":{"rendered":"https:\/\/www.silicloud.com\/ja\/blog\/index.php\/2023\/11\/30\/%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0\/"},"modified":"2025-08-01T00:00:19","modified_gmt":"2025-07-31T15:00:19","slug":"%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/ja\/blog\/%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0\/","title":{"rendered":"\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5"},"content":{"rendered":"<p>\u8457\u8005\u306f\u3001\u66f8\u304f\u3053\u3068\u306b\u3088\u308b\u5bc4\u4ed8\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u4e00\u74b0\u3068\u3057\u3066\u3001\u300c\u30d5\u30ea\u30fc\u30fb\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u57fa\u91d1\u300d\u306b\u5bc4\u4ed8\u3059\u308b\u3053\u3068\u3092\u9078\u3073\u307e\u3057\u305f\u3002<\/p>\n<h3>\u306f\u3058\u3081\u306b<\/h3>\n<p>Excel\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3084SQL\u30c6\u30fc\u30d6\u30eb\u306e\u3088\u3046\u306b\u3001pandas\u306eDataFrame\u306f\u884c\u3068\u5217\u306b\u30c7\u30fc\u30bf\u304c\u8868\u793a\u3055\u308c\u308b\u4e8c\u6b21\u5143\u306e\u30c7\u30fc\u30bf\u69cb\u9020\u3067\u3059\u3002\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u306f\u3001\u4e3b\u306b\u79d1\u5b66\u7684\u306a\u5b66\u7fd2\u3001\u30c7\u30fc\u30bf\u30b5\u30a4\u30a8\u30f3\u30b9\u3001\u6a5f\u68b0\u5b66\u7fd2\u3001\u30c7\u30fc\u30bf\u5206\u6790\u306a\u3069\u3001\u30c7\u30fc\u30bf\u306b\u91cd\u70b9\u3092\u7f6e\u3044\u305f\u5206\u91ce\u3067\u4f7f\u7528\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>Python\u3092\u4f7f\u3048\u3070\u3001CSV\u3001Excel\u3001\u307e\u305f\u306fAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089\u30c7\u30fc\u30bf\u3092pandas\u306eDataFrame\u306b\u5909\u63db\u3057\u3001\u5f97\u3089\u308c\u305fDataFrame\u3067\u4f5c\u696d\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002Excel\u3084CSV\u30d5\u30a1\u30a4\u30eb\u306e\u5909\u63db\u306f\u6bd4\u8f03\u7684\u7c21\u5358\u3067\u3059\u304c\u3001API\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306f\u7570\u306a\u308b\u3053\u3068\u304c\u3042\u308a\u3001\u305d\u306e\u60c5\u5831\u304b\u3089DataFrame\u3092\u4f5c\u6210\u3059\u308b\u306e\u306f\u96e3\u3057\u3044\u5834\u5408\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u4e00\u90e8\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306f\u3001\u8aad\u307f\u3084\u3059\u3044\u5f62\u5f0f\u306e\u8f9e\u66f8\u3067\u63d0\u4f9b\u3055\u308c\u3066\u304a\u308a\u3001\u30ad\u30fc\u306f\u5217\u540d\u3092\u8868\u3057\u3001\u5024\u306f\u305d\u306e\u5217\u306b\u5c5e\u3059\u308b\u8981\u7d20\u3092\u8868\u3057\u307e\u3059\u3002\u3057\u304b\u3057\u3001\u4e00\u90e8\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3067\u306f\u5217\u540d\u3068\u305d\u306e\u5024\u304c\u660e\u78ba\u306a\u6587\u8108\u3067\u8868\u3055\u308c\u3066\u304a\u3089\u305a\u3001\u9806\u5e8f\u306e\u306a\u3044API\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3092DataFrame\u306b\u5909\u63db\u3059\u308b\u3053\u3068\u306f\u56f0\u96e3\u3067\u3059\u3002<\/p>\n<p>\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3001\u9806\u4e0d\u540c\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3001\u9069\u5207\u306a\u5f62\u5f0f\u3067pandas\u306eDataFrame\u306b\u8868\u793a\u3057\u307e\u3059\u3002\u307e\u305a\u3001\u9806\u5e8f\u4ed8\u3051\u3089\u308c\u305fAPI\u30c7\u30fc\u30bf\u3092DataFrame\u306b\u5909\u63db\u3059\u308b\u305f\u3081\u306e\u6587\u8108\u3092\u63d0\u4f9b\u3059\u308b\u305f\u3081\u306b\u3001\u3044\u304f\u3064\u304b\u306e\u5f93\u6765\u306eAPI\u5f62\u5f0f\u304b\u3089\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002\u6b21\u306b\u3001\u9806\u4e0d\u540c\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3067\u4f5c\u696d\u3057\u307e\u3059\u3002\u5217\u540d\u3068\u305d\u308c\u306b\u5bfe\u5fdc\u3059\u308b\u8981\u7d20\u3092\u62bd\u51fa\u3057\u3066\u8f9e\u66f8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u6700\u5f8c\u306b\u3001\u3053\u306e\u8f9e\u66f8\u3092pandas\u306eDataFrame\u306b\u6e21\u3057\u3066\u30c7\u30fc\u30bf\u5206\u6790\u306b\u4f7f\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n<h2>\u524d\u63d0\u6761\u4ef6<\/h2>\n<p>\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3092\u9032\u3081\u308b\u306b\u306f\u3001\u6b21\u306e\u3082\u306e\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n<ul class=\"post-ul\">\n<li>Python 3, pip, and the Python venv module installed on your machine. For Ubuntu and other Linux distributions, follow Steps 1 and 2 of our tutorial on How To Install Python 3 and Set Up a Programming Environment. For macOS, follow Steps 1\u20135 of our tutorial on How To Install Python 3 and Set Up a Local Programming Environment on macOS.<\/li>\n<li>Jupyter notebook installed and running on your machine. For remote servers running Ubuntu\/Debian, follow How to Install, Run, and Connect to Jupyter Notebook on a Remote Server. For other operating systems, check the official documentation for installing Jupyter.<\/li>\n<li>A modern web browser that you will use to access Jupyter Notebook.<\/li>\n<li>Familiarity with the fundamentals of Python, such as for loops, functions, and data structures (in particular, lists and dictionaries).<\/li>\n<li>Experience with the Python pandas module for data manipulation and analysis.<\/li>\n<\/ul>\n<h2>\u30b9\u30c6\u30c3\u30d71 \u2014 Jupyter Notebook\u306e\u74b0\u5883\u6e96\u5099<\/h2>\n<p>\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3001\u30c7\u30fc\u30bf\u3092\u6271\u3046\u305f\u3081\u306bJupyter Notebook\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002Jupyter Notebook\u306f\u53cd\u5fa9\u7684\u306a\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002\u5c0f\u3055\u306a\u30b3\u30fc\u30c9\u306e\u65ad\u7247\u3092\u66f8\u304d\u3001\u5b9f\u884c\u3057\u3001\u7d50\u679c\u3092\u8fd4\u3059\u3053\u3068\u304c\u3067\u304d\u308b\u304b\u3089\u3067\u3059\u3002<\/p>\n<p>\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3092Jupyter Notebook\u3067\u30d5\u30a9\u30ed\u30fc\u3059\u308b\u305f\u3081\u306b\u306f\u3001\u65b0\u3057\u3044\u30ce\u30fc\u30c8\u30d6\u30c3\u30af\u3092\u958b\u304d\u3001\u3053\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u5fc5\u8981\u306a\u4f9d\u5b58\u95a2\u4fc2\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u524d\u63d0\u6761\u4ef6\u3068\u3057\u3066\u3001\u30b5\u30fc\u30d0\u30fc\u4e0a\u306bJupyter Notebook\u306e\u74b0\u5883\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002\u30b5\u30fc\u30d0\u30fc\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u305f\u3089\u3001\u4eee\u60f3\u74b0\u5883\u3092\u30a2\u30af\u30c6\u30a3\u30d6\u306b\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"$\"><span class=\"token builtin class-name\">source<\/span> ~\/<mark>environments<\/mark>\/<mark>my_env<\/mark>\/bin\/activate<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u305d\u306e\u5f8c\u3001Jupyter Notebook\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u3057\u3066\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u8d77\u52d5\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"(my_env)\\your_non_root_user@your_server_ip:~$\">jupyter notebook<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"post-conf-note\">\n<p class=\"post-conf-desc\">Note<\/p>\n<div>\u6ce8\u610f: \u30ea\u30e2\u30fc\u30c8\u30b5\u30fc\u30d0\u30fc\u3067\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3092\u5b9f\u884c\u3057\u3066\u3044\u308b\u5834\u5408\u3001\u30dd\u30fc\u30c8\u30d5\u30a9\u30ef\u30fc\u30c7\u30a3\u30f3\u30b0\u3092\u4f7f\u7528\u3057\u3066\u30ed\u30fc\u30ab\u30eb\u30de\u30b7\u30f3\u306e\u30d6\u30e9\u30a6\u30b6\u3067Jupyter Notebook\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u307e\u3059\u3002<br \/>\n\u65b0\u3057\u3044\u30bf\u30fc\u30df\u30ca\u30eb\u3092\u958b\u304d\u3001\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044:<br \/>\nssh -L 8888:localhost:8888 your_non_root_user@your_server_ip<\/div>\n<p>\u30b5\u30fc\u30d0\u30fc\u306b\u63a5\u7d9a\u3059\u308b\u3068\u3001\u51fa\u529b\u3067\u63d0\u4f9b\u3055\u308c\u308b\u30ea\u30f3\u30af\u306b\u79fb\u52d5\u3057\u3066Jupyter Notebook\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u306e\u30bf\u30fc\u30df\u30ca\u30eb\u306f\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u306e\u7d42\u4e86\u307e\u3067\u958b\u3044\u305f\u307e\u307e\u306b\u3057\u3066\u304a\u3044\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<\/div>\n<p>\u5b9f\u884c\u3057\u3066\u63a5\u7d9a\u3057\u305f\u5f8c\u3001\u30d6\u30e9\u30a6\u30b6\u30d9\u30fc\u30b9\u306e\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002\u65b0\u3057\u3044\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u3001Python3\uff08ipykernel\uff09\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u305d\u3046\u3059\u308b\u3068\u3001\u7121\u984c\u306ePython\u30ce\u30fc\u30c8\u30d6\u30c3\u30af\u304c\u958b\u304b\u308c\u305f\u65b0\u3057\u3044\u30bf\u30d6\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u30d5\u30a1\u30a4\u30eb\u306b\u540d\u524d\u3092\u4ed8\u3051\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3001\u30d5\u30a1\u30a4\u30eb\u306e\u540d\u524d\u306fconvert_data.ipynb\u3067\u3059\u3002<\/p>\n<p>\u305d\u306e\u5f8c\u3001\u30d6\u30e9\u30a6\u30b6\u306eJupyter Notebook\u306e\u6700\u521d\u306e\u30bb\u30eb\u3067\u3001\u5fc5\u8981\u306a\u4f9d\u5b58\u95a2\u4fc2\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u305f\u3081\u306bpip\u3092\u4f7f\u7528\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u300cconvert_data.ipynb\u300d\u3092\u65e5\u672c\u8a9e\u306b\u7ffb\u8a33\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/div>\n<pre class=\"post-pre\"><code>pip install pandas\r\npip install requests\r\n<\/code><\/pre>\n<p>DataFrame\u30c7\u30fc\u30bf\u69cb\u9020\u306f\u3001pandas\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u901a\u3058\u3066\u306e\u307f\u30a2\u30af\u30bb\u30b9\u3067\u304d\u307e\u3059\u3002requests\u30e2\u30b8\u30e5\u30fc\u30eb\u306f\u3001URL\u3078\u306e\u30a2\u30af\u30bb\u30b9\u3092\u652f\u63f4\u3057\u307e\u3059\u3002<\/p>\n<p>Jupyter Notebook\u306b\u30b3\u30de\u30f3\u30c9\u3092\u8ffd\u52a0\u3057\u305f\u5f8c\u3001\u5b9f\u884c\u3059\u308b\u305f\u3081\u306b\u30e9\u30f3\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u3042\u306a\u305f\u306eJupyter Notebook\u306f\u3001\u4f9d\u5b58\u95a2\u4fc2\u304c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u793a\u3059\u5b9f\u884c\u7d50\u679c\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002\u3053\u306e\u51fa\u529b\u306e\u4e0b\u306b\u65b0\u3057\u3044\u5165\u529b\u30bb\u30eb\u304c\u5229\u7528\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002\u305d\u3053\u3067\u6b21\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u6b21\u306b\u3001\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b.ipynb<\/div>\n<pre class=\"post-pre\"><code><span class=\"token keyword\">import<\/span> pandas <span class=\"token keyword\">as<\/span> pd\r\n<span class=\"token keyword\">import<\/span> requests\r\n<\/code><\/pre>\n<p>pd\u306f\u3001\u30d1\u30f3\u30c0\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u547c\u3073\u51fa\u3059\u305f\u3081\u306e\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u3068\u3057\u3066\u6a5f\u80fd\u3057\u307e\u3059\u3002pd\u3068\u66f8\u304f\u3060\u3051\u3067\u30d1\u30f3\u30c0\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u547c\u3073\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u306f\u3001Jupyter Notebook\u306e\u74b0\u5883\u3092\u6e96\u5099\u3057\u307e\u3057\u305f\u3002\u6b21\u306b\u3001\u3044\u304f\u3064\u304b\u306e\u57fa\u672c\u7684\u306a\u5909\u63db\u3092\u884c\u3063\u3066\u3001\u8f9e\u66f8\u304b\u3089\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<h2>\u30b9\u30c6\u30c3\u30d72 \u2014 \u4e26\u3079\u66ff\u3048\u3089\u308c\u305fAPI\u30c7\u30fc\u30bf\u3092pandas DataFrame\u306b\u5909\u63db\u3059\u308b<\/h2>\n<p>\u7121\u9806\u5e8f\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u524d\u306b\u3001\u307e\u305a\u7570\u306a\u308b\u5f62\u5f0f\u306e\u8f9e\u66f8\u304b\u3089\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u4f5c\u6210\u3057\u3001URL\u4e0a\u306e\u6574\u7406\u3055\u308c\u305fAPI\u30c7\u30fc\u30bf\u3092\u7528\u610f\u3057\u307e\u3059\u3002<\/p>\n<p>\u591a\u304f\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3067\u306f\u3001\u901a\u5e38\u3001\u30ad\u30fc\u306f\u5217\u540d\u3092\u8868\u3057\u3001\u305d\u308c\u3089\u306e\u30ad\u30fc\u306e\u5024\u306f\u305d\u308c\u305e\u308c\u306e\u5217\u306b\u5c5e\u3059\u308b\u8981\u7d20\u3092\u8868\u3057\u307e\u3059\u3002\u3057\u304b\u3057\u3001\u4e00\u90e8\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306f\u3053\u306e\u5f62\u5f0f\u3067\u306f\u63d0\u4f9b\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002\u3064\u307e\u308a\u3001\u5217\u540d\u3068\u305d\u308c\u306b\u5bfe\u5fdc\u3059\u308b\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u3066\u3001\u8aad\u307f\u3084\u3059\u3044\u8f9e\u66f8\u3092\u4f5c\u6210\u3057\u3001\u305d\u306e\u8f9e\u66f8\u304b\u3089pandas DataFrame\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306e\u65b9\u6cd5\u304c\u5fc5\u8981\u3067\u3059\u3002\u5f93\u6765\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3092pandas DataFrame\u306b\u5909\u63db\u3059\u308b\u305f\u3081\u306e\u4e00\u822c\u7684\u306a\u624b\u6cd5\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068\u3067\u3001\u3053\u306e\u30bf\u30b9\u30af\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u306f\u3001\u7570\u306a\u308b\u5f62\u5f0f\u306e\u8f9e\u66f8\u304b\u3089\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306b\u3001\u3044\u304f\u3064\u304b\u306e\u4e00\u822c\u7684\u306a\u65b9\u6cd5\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<h3>\u65b9\u6cd51 \u2014 \u8f9e\u66f8\u306e\u30ea\u30b9\u30c8\u304b\u3089DataFrame\u3092\u4f5c\u6210<\/h3>\n<p>\u3053\u306e\u65b9\u6cd5\u3067\u306f\u3001\u30ea\u30b9\u30c8\u5185\u306e\u5404\u8f9e\u66f8\u304c\u6700\u7d42\u7684\u306aDataFrame\u306e\u4e00\u884c\u306e\u30c7\u30fc\u30bf\u3092\u8868\u3057\u307e\u3059\u3002DataFrame\u306e\u69cb\u9020\u306f\u3001\u5217\u540d\u3092\u8868\u3059\u30ad\u30fc\u3068\u3001\u5217\u306b\u5c5e\u3059\u308b\u8981\u7d20\u306e\u5024\u3092\u7279\u5fb4\u3068\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u65b9\u6cd5\u3067\u306f\u30013\u4eba\u306e\u500b\u4eba\u306e\u60c5\u5831\u3092\u542b\u3080\u300c\u5e74\u9f62\u300d\u3001\u300cID\u300d\u3001\u304a\u3088\u3073\u300c\u540d\u524d\u300d\u306e\u5217\u3092\u6301\u3064\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p>\u65b0\u3057\u3044\u30bb\u30eb\u3067\u3001\u5909\u6570dict1\u306b\u5272\u308a\u5f53\u3066\u3089\u308c\u305f\u8f9e\u66f8\u306e\u30ea\u30b9\u30c8\u3092\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3059\u308b\u305f\u3081\u306b\u3001\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u304a\u597d\u307f\u3067\u540d\u524d\u3092\u81ea\u5206\u7528\u306b\u7f6e\u304d\u63db\u3048\u3066\u304f\u3060\u3055\u3044\uff09\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308bipynb\u30d5\u30a1\u30a4\u30eb\u3092\u5909\u63db\u3057\u307e\u3059\u3002<\/div>\n<pre class=\"post-pre\"><code><mark>dict1<\/mark><span class=\"token operator\">=<\/span><span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">\"Age\"<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">41<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"ID\"<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">1234<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"Name\"<\/span><span class=\"token punctuation\">:<\/span><span class=\"token string\">\"Bella\"<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">,<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">\"Age\"<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">24<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"ID\"<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">5678<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"Name\"<\/span><span class=\"token punctuation\">:<\/span><span class=\"token string\">\"Mark\"<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">,<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">\"Age\"<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">26<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"ID\"<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">2341<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"Name\"<\/span><span class=\"token punctuation\">:<\/span><span class=\"token string\">\"John\"<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">]<\/span>\r\n\r\ndata<span class=\"token operator\">=<\/span>pd<span class=\"token punctuation\">.<\/span>DataFrame<span class=\"token punctuation\">(<\/span><mark>dict1<\/mark><span class=\"token punctuation\">)<\/span>\r\n\r\ndata<span class=\"token punctuation\">.<\/span>head<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\r\n<\/code><\/pre>\n<p>dict1\u5909\u6570\u306b\u8f9e\u66f8\u306e\u30ea\u30b9\u30c8\u3092\u5272\u308a\u5f53\u3066\u307e\u3059\u3002\u30ea\u30b9\u30c8\u5185\u306e\u5404\u8f9e\u66f8\u306f\u3001\u7d50\u679c\u306eDataFrame\u306e1\u884c\u3092\u8868\u3057\u307e\u3059\u3002Age\u3001ID\u3001\u304a\u3088\u3073Name\u3068\u3044\u3046\u30ad\u30fc\u306f\u5217\u540d\u3092\u8868\u3057\u307e\u3059\u3002\u5404\u30ad\u30fc\u306b\u5272\u308a\u5f53\u3066\u3089\u308c\u305f\u5024\u306f\u3001\u305d\u306e\u884c\u306e\u305d\u306e\u5217\u306e\u5024\u3092\u8868\u3057\u307e\u3059\u3002\u305d\u308c\u304b\u3089\u3053\u306e\u8f9e\u66f8\u3092pandas\u30e2\u30b8\u30e5\u30fc\u30eb\u306b\u6e21\u3057\u3066DataFrame\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p>\u4ee5\u4e0b\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u304c\u5370\u5237\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>Age ID Name 0 41 1234 Bella 1 24 5678 Mark 2 26 2341 John<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u3053\u306eDataFrame\u306f\u8f9e\u66f8\u306e\u30ea\u30b9\u30c8\u304b\u3089\u4f5c\u6210\u3055\u308c\u307e\u3057\u305f\u3002dict1\u30ea\u30b9\u30c8\u5185\u306e\u5404\u8f9e\u66f8\u3067\u5b9a\u7fa9\u3057\u305f\u30ad\u30fc\u306f\u3001\u53d6\u5f97\u3057\u305fDataFrame\u306e\u5217\u540d\u3067\u3059\u3002\u305d\u3057\u3066\u3001\u3053\u308c\u3089\u306e\u8f9e\u66f8\u5185\u306e\u5024\u306f\u3001\u884c\u65b9\u5411\u306e\u30c7\u30fc\u30bf\u3092\u8868\u3057\u307e\u3059\u3002<\/p>\n<h3>\u65b9\u6cd52 &#8211; \u5358\u4e00\u306e\u8f9e\u66f8\u304b\u3089DataFrame\u3092\u4f5c\u6210\u3059\u308b<\/h3>\n<p>\u4ee5\u524d\u306e\u65b9\u6cd5\u3067\u306f\u3001\u884c\u306b\u57fa\u3065\u3044\u3066\u30c7\u30fc\u30bf\u3092\u5b9a\u7fa9\u3057\u3001\u8907\u6570\u306e\u8f9e\u66f8\u3092\u30ea\u30b9\u30c8\u306b\u5165\u529b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3057\u305f\u3002\u5404\u8f9e\u66f8\u306f\u884c\u65b9\u5411\u306e\u30c7\u30fc\u30bf\u3092\u8868\u3057\u3001\u30ad\u30fc\u306f\u5217\u540d\u3001\u5024\u306f\u5217\u306b\u5c5e\u3059\u308b\u8981\u7d20\u3067\u3059\u3002<\/p>\n<p>\u4eca\u56de\u306f\u3001\u30c7\u30fc\u30bf\u3092\u5217\u65b9\u5411\u3067\u5b9a\u7fa9\u3057\u307e\u3059\u3002\u8f9e\u66f8\u3092\u4f7f\u7528\u3057\u3001\u30ad\u30fc\u306f\u5217\u540d\u3067\u3001\u5024\u306f\u305d\u306e\u5217\u306e\u7e26\u306e\u30c7\u30fc\u30bf\u3092\u8868\u3059\u30ea\u30b9\u30c8\u3067\u3059\u3002<\/p>\n<p>\u3053\u306e\u65b9\u6cd5\u3092\u4f7f\u3046\u306b\u306f\u3001\u524d\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u4f7f\u7528\u3057\u305f\u30c7\u30fc\u30bf\u3068\u540c\u3058\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u6b21\u306e\u884c\u3092\u65b0\u3057\u3044\u30bb\u30eb\u3067\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b\u305f\u3081\u306e\u300cconvert_data.ipynb\u300d\u3092\u4f5c\u6210\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/div>\n<pre class=\"post-pre\"><code><mark>dict2<\/mark><span class=\"token operator\">=<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">\"Age\"<\/span><span class=\"token punctuation\">:<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">41<\/span><span class=\"token punctuation\">,<\/span><span class=\"token number\">24<\/span><span class=\"token punctuation\">,<\/span><span class=\"token number\">26<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"ID\"<\/span><span class=\"token punctuation\">:<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">1234<\/span><span class=\"token punctuation\">,<\/span><span class=\"token number\">5678<\/span><span class=\"token punctuation\">,<\/span><span class=\"token number\">2341<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"Name\"<\/span><span class=\"token punctuation\">:<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">\"Bella\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"Mark\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"John\"<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span>\r\n\r\ndata<span class=\"token operator\">=<\/span>pd<span class=\"token punctuation\">.<\/span>DataFrame<span class=\"token punctuation\">(<\/span><mark>dict2<\/mark><span class=\"token punctuation\">)<\/span>\r\n\r\ndata<span class=\"token punctuation\">.<\/span>head<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\r\n<\/code><\/pre>\n<p>\u3053\u3053\u3067\u306f\u3001\u8f9e\u66f8\u3092\u4f7f\u3063\u3066\u5217\u3054\u3068\u306e\u30c7\u30fc\u30bf\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u3002dict2\u306e\u30ad\u30fc\u306f\u5217\u540d\u3067\u3042\u308a\u3001\u5e74\u9f62\u3001ID\u3001\u540d\u524d\u3067\u3059\u3002\u5404\u30ad\u30fc\u306e\u5024\u306f\u3001\u305d\u308c\u305e\u308c\u306e\u5217\u306e\u30c7\u30fc\u30bf\u3092\u8868\u3059\u30ea\u30b9\u30c8\u3067\u3059\u3002<\/p>\n<p>\u4ee5\u4e0b\u306eDataFrame\u306f\u753b\u9762\u306b\u8868\u793a\u3055\u308c\u307e\u3059\uff1a<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>Age ID Name 0 41 1234 Bella 1 24 5678 Mark 2 26 2341 John<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>dict2\u306e\u30ad\u30fc\u306f\uff08\u5e74\u9f62\u3001ID\u3001\u540d\u524d\uff09\u3092\u8868\u3057\u3001\u5404\u5217\u306f\u3001\u305d\u308c\u305e\u308c\u306e\u30ad\u30fc\u306e\u5024\u3068\u3057\u3066\u5b9a\u7fa9\u3055\u308c\u305f\u30ea\u30b9\u30c8\u3067\u57cb\u3081\u3089\u308c\u307e\u3059\u3002\u4f8b\u3048\u3070\u3001\u5e74\u9f62\u5217\u306b\u306f\u300141\u300124\u300126\u306e\u5024\u304c\u5165\u308a\u307e\u3059\u3002<\/p>\n<p>\u3084\u306f\u308a\u3001\u4e21\u65b9\u306e\u65b9\u6cd5\u306f\u540c\u3058\u7d50\u679c\u3092\u751f\u307f\u51fa\u3057\u307e\u3059\u3002\u6700\u521d\u306e2\u3064\u306e\u65b9\u6cd5\u306e\u51fa\u529b\u306f\u540c\u3058\u3067\u3059\u304c\u3001\u884c\u65b9\u5411\u3068\u5217\u65b9\u5411\u306e\u30a2\u30d7\u30ed\u30fc\u30c1\u306e\u4e21\u65b9\u3092\u4f7f\u7528\u3057\u3066DataFrame\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<h3>\u65b9\u6cd53 \u2014 URL\u306eAPI\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u3066DataFrame\u3092\u4f5c\u6210\u3059\u308b<\/h3>\n<p>\u3053\u306e\u65b9\u6cd5\u3067\u306f\u3001URL\u304b\u3089\u62bd\u51fa\u3057\u305fAPI\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u3066DataFrame\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002API\u95a2\u9023\u306eURL\u5185\u3067\u306f\u3001\u901a\u5e38\u3001Method 1\u3067\u4f7f\u7528\u3055\u308c\u308b\u30c7\u30fc\u30bf\u3068\u540c\u69d8\u306e\u8f9e\u66f8\u306e\u30ea\u30b9\u30c8\u5f62\u5f0f\u3067\u30c7\u30fc\u30bf\u304c\u63d0\u793a\u3055\u308c\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u30c7\u30fc\u30bf\u3092\u30cf\u30fc\u30c9\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u3059\u308b\u4ee3\u308f\u308a\u306b\u3001requests\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u4f7f\u7528\u3057\u3066URL\u304b\u3089API\u30c7\u30fc\u30bf\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3001URL\u3078\u306e\u30a2\u30af\u30bb\u30b9\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u65b9\u6cd5\u3067\u306f\u3001JSON API\u306eURL\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u3053\u306eAPI\u306f\u3001\u300c\u56fd\u3068\u9996\u90fd\u306e\u30ea\u30b9\u30c8\u300d\u3092API\u5f62\u5f0f\u3067\u63d0\u4f9b\u3057\u307e\u3059\u3002API\u3092\u8868\u793a\u3059\u308b\u306b\u306f\u3001\u4ee5\u4e0b\u306eURL\u3092\u30d6\u30e9\u30a6\u30b6\u3067\u958b\u3044\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"$\">https:\/\/raw.githubusercontent.com\/dariusk\/corpora\/master\/data\/geography\/countries_with_capitals.json<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>URL\u3067\u63d0\u4f9b\u3055\u308c\u308bAPI\u30c7\u30fc\u30bf\u306e\u59cb\u3081\u306e\u90e8\u5206\u3092\u4ee5\u4e0b\u306b\u793a\u3057\u307e\u3059\u3002<\/p>\n<div>\u300c\u9996\u90fd\u4ed8\u304d\u56fd\u306e\u4e00\u89a7\uff08\u9996\u90fd\u4ed8\u304d\u56fd\u306eURL\u304b\u3089\u306eAPI\u30c7\u30fc\u30bf\uff09\u300d<\/div>\n<pre class=\"post-pre\"><code>{\r\n  \"description\": \"A list of countries and its respective capitals.\",\r\n  \"countries\": [\r\n    {\"name\":\"Afghanistan\", \"capital\":\"Kabul\"},\r\n    {\"name\":\"Albania\", \"capital\":\"Tirana\"},\r\n    {\"name\":\"Algeria\", \"capital\":\"Algiers\"},\r\n    {\"name\":\"Andorra\", \"capital\":\"Andorra la Vella\"},\r\n    {\"name\":\"Angola\", \"capital\":\"Luanda\"},\r\n    {\"name\":\"Antigua &amp; Barbuda\", \"capital\":\"St. John's\"},\r\n    {\"name\":\"Argentina\", \"capital\":\"Buenos Aires\"},\r\n    {\"name\":\"Armenia\", \"capital\":\"Yerevan\"},\r\n    {\"name\":\"Australia\", \"capital\":\"Canberra\"},\r\n    {\"name\":\"Austria\", \"capital\":\"Vienna\"},\r\n...\r\n<\/code><\/pre>\n<p>API\u306f\u8a8d\u8b58\u53ef\u80fd\u306a\u5f62\u5f0f\u3067\u63d0\u4f9b\u3055\u308c\u307e\u3059\u3002\u5916\u90e8\u306e\u8f9e\u66f8\u5185\u306ecountries\u30ad\u30fc\u306b\u306f\u3001\u8f9e\u66f8\u306e\u30ea\u30b9\u30c8\u304c\u542b\u307e\u308c\u3066\u304a\u308a\u3001name\u3068capital\u304c\u5217\u540d\u3067\u3042\u308a\u3001\u305d\u308c\u306b\u5bfe\u5fdc\u3059\u308b\u5024\u304c\u884c\u3054\u3068\u306e\u30c7\u30fc\u30bf\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u3053\u306eURL\u304b\u3089pandas\u306eDataFrame\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3001\u65b0\u3057\u3044\u30bb\u30eb\u3067\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u306e\u5909\u63db.ipynb<\/div>\n<pre class=\"post-pre\"><code>response<span class=\"token operator\">=<\/span>requests<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">'https:\/\/raw.githubusercontent.com\/dariusk\/corpora\/master\/data\/geography\/countries_with_capitals.json'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>json<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\r\n\r\ndf1<span class=\"token operator\">=<\/span>pd<span class=\"token punctuation\">.<\/span>DataFrame<span class=\"token punctuation\">(<\/span>response<span class=\"token punctuation\">[<\/span><span class=\"token string\">'countries'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span>\r\n\r\ndf1<span class=\"token punctuation\">.<\/span>head<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\r\n<\/code><\/pre>\n<p>requests\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001URL\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u5834\u5408\u3001URL\u3092json\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u8aad\u307f\u8fbc\u307f\u3001\u8aad\u307f\u8fbc\u3093\u3060\u30c7\u30fc\u30bf\u3092\u5909\u6570response\u306b\u5272\u308a\u5f53\u3066\u307e\u3059\u3002\u6b21\u306b\u3001\u3053\u306e\u8f9e\u66f8\u306e\u30ea\u30b9\u30c8\uff08countries\u30ad\u30fc\u306e\u5024\u3068\u3057\u3066\u63d0\u4f9b\u3055\u308c\u308b\uff09\u3092pandas\u306b\u63d0\u793a\u3057\u3001pandas\u306fDataFrame\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002df1\u306f\u3001\u4e0e\u3048\u3089\u308c\u305fAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u3066\u6b63\u5e38\u306b\u53d6\u5f97\u3057\u305fDataFrame\u3067\u3059\u3002<\/p>\n<p>\u4e0a\u8a18\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u6b21\u306e\u3088\u3046\u306aDataFrame\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>name capital 0 Afghanistan Kabul 1 Albania Tirana 2 Algeria Algiers 3 Andorra Andorra la Vella 4 Angola Luanda<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u30ea\u30b9\u30c8\u306e\u56fd\u3068\u9996\u90fd\u3092pandas DataFrame\u306b\u6e21\u3057\u305f\u5f8c\u306eDataFrame\u3067\u3059\u3002\u3053\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u8f9e\u66f8\u306e\u30ea\u30b9\u30c8\uff08\u56fd\u306e\u30ad\u30fc\u3068\u3057\u3066\u5024\u304c\u8868\u793a\u3055\u308c\u308b\uff09\u3092pandas DataFrame\u30e2\u30b8\u30e5\u30fc\u30eb\u306b\u6e21\u3057\u307e\u3057\u305f\u3002\u5217\u306e\u540d\u524d\u306f\u3001\u3053\u306e\u30ea\u30b9\u30c8\u306e\u3059\u3079\u3066\u306e\u8f9e\u66f8\u306b\u30ad\u30fc\u3068\u3057\u3066\u5b58\u5728\u3059\u308b\u305f\u3081\u3001name\u3068capital\u3067\u3059\u3002\u307e\u305f\u3001\u5024\u306f\u884c\u3054\u3068\u306e\u30c7\u30fc\u30bf\u3092\u8868\u3057\u3066\u3044\u307e\u3059\uff08\u5404\u8f9e\u66f8\u304c\u884c\u3092\u8868\u3057\u3066\u3044\u308b\u305f\u3081\uff09\u3002<\/p>\n<p>\u3053\u308c\u307e\u3067\u306b\u3001\u57fa\u672c\u7684\u306a\u8f9e\u66f8\u3084\u69cb\u9020\u5316\u3055\u308c\u305f API \u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089 DataFrame \u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002\u69cb\u9020\u5316\u3055\u308c\u305f API \u3092\u542b\u3080 URL \u3092\u6271\u3046\u5834\u5408\u3001\u30c7\u30fc\u30bf\u306f\u4e00\u822c\u7684\u306b Method 1 \u3067\u4f7f\u7528\u3055\u308c\u3066\u3044\u308b\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3068\u3057\u3066\u63d0\u4f9b\u3055\u308c\u307e\u3059\u3002\u5404\u8f9e\u66f8\u304c\u884c\u5358\u4f4d\u306e\u30c7\u30fc\u30bf\u3092\u8868\u3059\u5f62\u5f0f\u3067\u3001\u8f9e\u66f8\u306e\u30ea\u30b9\u30c8\u3068\u3057\u3066\u8868\u73fe\u3055\u308c\u307e\u3059\u3002API \u306e\u30c7\u30fc\u30bf\u304c\u975e\u69cb\u9020\u5316\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3001Method 1 \u307e\u305f\u306f Method 2 \u306e\u5f62\u5f0f\u3092\u4f7f\u7528\u3057\u3066\u3001\u5217\u540d\u3068\u305d\u306e\u30c7\u30fc\u30bf\u3092\u884c\u5358\u4f4d\u307e\u305f\u306f\u5217\u5358\u4f4d\u3067\u62bd\u51fa\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u6b21\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u306f\u3001\u3053\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u4f7f\u7528\u3057\u305f\u3044\u304f\u3064\u304b\u306e\u6226\u7565\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u3001\u975e\u69cb\u9020\u5316\u306e API \u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n<h2>\u30b9\u30c6\u30c3\u30d73 \u2014 \u9806\u4e0d\u540c\u306eAPI\u30c7\u30fc\u30bf\u3092pandas DataFrame\u306b\u5909\u63db\u3059\u308b<\/h2>\n<p>\u3053\u308c\u307e\u3067\u306b\u3001\u3044\u304f\u3064\u304b\u306e\u65b9\u6cd5\u3092\u4f7f\u7528\u3057\u3066\u6ce8\u6587\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092Pandas\u306eDataframe\u306b\u5909\u63db\u3057\u3066\u304d\u307e\u3057\u305f\u3002\u3057\u304b\u3057\u3001\u4eca\u56de\u306f\u7570\u306a\u308b\u5f62\u5f0f\u306e\u30c7\u30fc\u30bf\u3092\u6271\u3046\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u65b0\u3057\u3044URL\u306eAPI\u30c7\u30fc\u30bf\u306f\u901a\u5e38\u306e\u5f62\u5f0f\u3067\u306f\u306a\u3044\u305f\u3081\u3001\u5217\u540d\u3068\u305d\u306e\u30c7\u30fc\u30bf\u3092\u8b58\u5225\u3059\u308b\u3053\u3068\u304c\u96e3\u3057\u3044\u3067\u3059\u3002<\/p>\n<p>\u3053\u306e\u9806\u4e0d\u540c\u306e\u30c7\u30fc\u30bf\u304b\u3089DataFrame\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306b\u306f\u3001\u8ffd\u52a0\u306e\u624b\u9806\u3092\u8e0f\u3080\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u307e\u305a\u3001\u5217\u540d\u3068\u5217\u306e\u5024\u3092\u62bd\u51fa\u3057\u3001\u5217\u540d\u3092\u30ad\u30fc\u3068\u3057\u3066\u5217\u8981\u7d20\uff08\u30ea\u30b9\u30c8\u5f62\u5f0f\uff09\u3092\u5024\u3068\u3057\u305f\u8f9e\u66f8\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u3002\u6700\u7d42\u7684\u306b\u306f\u3001Method 2\u3067\u4f7f\u7528\u3055\u308c\u308b\u5f62\u5f0f\u306b\u4f3c\u305f\u898b\u6804\u3048\u306e\u826f\u3044\u8f9e\u66f8\u3092\u53d6\u5f97\u3057\u3001pandas\u306b\u5909\u63db\u3057\u3066DataFrame\u306b\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u306f\u3001NY\u5b66\u6821\u306e\u4eba\u53e3\u7d71\u8a08\u3068\u8cac\u4efb\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<h3>API\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u5185\u306e\u30ab\u30e9\u30e0\u540d\u306e\u30c8\u30e9\u30c3\u30ad\u30f3\u30b0<\/h3>\n<p>\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001API\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u5185\u306b\u542b\u307e\u308c\u308b\u30c7\u30fc\u30bf\u306e\u5217\u306b\u95a2\u9023\u3059\u308b\u60c5\u5831\u3092\u8ffd\u8de1\u3057\u307e\u3059\u3002<\/p>\n<p>\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u305f\u3081\u306b\u3001\u304a\u597d\u304d\u306a\u30a6\u30a7\u30d6\u30d6\u30e9\u30a6\u30b6\u3067\u3053\u306eURL\u3092\u958b\u3044\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"$\">https:\/\/data.cityofnewyork.us\/api\/views\/ihfw-zy9j\/rows.json<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u3053\u306eURL\u306e\u30c7\u30fc\u30bf\u306f\u3001\u30b9\u30c6\u30c3\u30d72\u3067\u6271\u3063\u305f\u30c7\u30fc\u30bf\u3088\u308a\u3082\u898b\u3084\u3059\u3055\u306b\u6b20\u3051\u307e\u3059\u3002NY\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u30c7\u30fc\u30bf\u306f\u3001\u3042\u308b\u5f62\u5f0f\u306e\u8f9e\u66f8\u3092\u63d0\u4f9b\u3057\u3066\u3044\u308b\u304c\u3001\u30ad\u30fc\u304c\u5217\u540d\u3092\u8868\u3057\u3001\u5024\u304c\u5217\u306e\u8981\u7d20\u3092\u8868\u3059\u8f9e\u66f8\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u884c\u65b9\u5411\u307e\u305f\u306f\u5217\u65b9\u5411\u306e\u30c7\u30fc\u30bf\u3092\u5177\u4f53\u7684\u306b\u793a\u3059\u76f4\u63a5\u7684\u306a\u8f9e\u66f8\u306f\u5b58\u5728\u3057\u306a\u3044\u3088\u3046\u3067\u3059\u3002<\/p>\n<p>\u6700\u521d\u306b\u3001DataFrame\u306b\u95a2\u9023\u3059\u308b\u60c5\u5831\u3092\u898b\u3064\u3051\u308b\u3053\u3068\u304b\u3089\u59cb\u3081\u307e\u3059\u3002\u30d6\u30e9\u30a6\u30b6\u3067API\u306eURL\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u969b\u306b\u306f\u3001CTRL+F\u3092\u5165\u529b\u3057\u3066&#8221;columns:&#8221;\u3068\u691c\u7d22\u3057\u307e\u3059\u3002<\/p>\n<div>\u30b3\u30e9\u30e0\u30bb\u30af\u30b7\u30e7\u30f3\uff08NY\u6821\u5feb\u898b\u8868URL\u304b\u3089\u306eAPI\u30c7\u30fc\u30bf\uff09<\/div>\n<pre class=\"post-pre\"><code>...\r\n<mark>\"columns\" : [ {<\/mark>\r\n        \"id\" : -1,\r\n        \"name\" : \"sid\",\r\n        <mark>\"dataTypeName\" : \"meta_data\",<\/mark>\r\n        \"fieldName\" : \":sid\",\r\n        \"position\" : 0,\r\n        \"renderTypeName\" : \"meta_data\",\r\n        \"format\" : { },\r\n        \"flags\" : [ \"hidden\" ]\r\n      }, {\r\n        \"id\" : -1,\r\n        \"name\" : \"id\",\r\n        <mark>\"dataTypeName\" : \"meta_data\",<\/mark>\r\n        \"fieldName\" : \":id\",\r\n        \"position\" : 0,\r\n        \"renderTypeName\" : \"meta_data\",\r\n        \"format\" : { },\r\n        \"flags\" : [ \"hidden\" ]\r\n      }, {\r\n        \"id\" : -1,\r\n        \"name\" : \"position\",\r\n        <mark>\"dataTypeName\" : \"meta_data\",<\/mark>\r\n        \"fieldName\" : \":position\",\r\n        \"position\" : 0,\r\n        \"renderTypeName\" : \"meta_data\",\r\n        \"format\" : { },\r\n        \"flags\" : [ \"hidden\" ]\r\n...\r\n<\/code><\/pre>\n<p>\u30ab\u30e9\u30e0\u30ad\u30fc\u306e\u5024\u30ea\u30b9\u30c8\u306b\u306f\u3001\u8907\u6570\u306e\u8f9e\u66f8\u304c\u3042\u308a\u307e\u3059\u3002\u305d\u308c\u305e\u308c\u306e\u8f9e\u66f8\u5185\u306b\u306f\u3001dataTypeNam\u30ad\u30fc\u30ba\u306e\u5024\u306b\u6ce8\u76ee\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u6700\u521d\u306e8\u3064\u306e\u8f9e\u66f8\u3067\u306f\u3001dataTypeNam\u30ad\u30fc\u306e\u5024\u304cmeta_data\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u3002\u30e1\u30bf\u30c7\u30fc\u30bf\u306f\u3001\u30c7\u30fc\u30bf\u3092\u8aac\u660e\u3059\u308b\u30c7\u30fc\u30bf\u3067\u3059\u3002\u3053\u306e\u5834\u5408\u3001\u30e1\u30bf\u30c7\u30fc\u30bf\u306f\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u30c7\u30fc\u30bf\u3067\u306f\u306a\u304f\u3001\u30c6\u30fc\u30d6\u30eb\u5168\u4f53\u3092\u8aac\u660e\u3059\u308b\u30c7\u30fc\u30bf\u3067\u3059\u3002\u3057\u305f\u304c\u3063\u3066\u3001dataTypeNam\u30ad\u30fc\u306e\u5024\u304cmeta_data\u3068\u306a\u3063\u3066\u3044\u308b\u3053\u308c\u3089\u306e8\u3064\u306e\u8f9e\u66f8\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u30ab\u30e9\u30e0\u306b\u95a2\u3059\u308b\u60c5\u5831\u3092\u8868\u3057\u3066\u3044\u307e\u305b\u3093\u3002<\/p>\n<p>\u3057\u304b\u3057\u3001\u3053\u306e\u30ea\u30b9\u30c8\u3092\u3055\u3089\u306b\u9032\u3081\u308b\u3068\u3001meta_data\u3092\u5024\u3068\u3057\u3066\u6301\u305f\u306a\u3044dataTypeName\u30ad\u30fc\u306e\u6700\u521d\u306e\u51fa\u73fe\u306b\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u30b3\u30e9\u30e0\u30bb\u30af\u30b7\u30e7\u30f3\uff08NY School Snapshot\u306eAPI\u30c7\u30fc\u30bf\u304b\u3089\u53d6\u5f97\uff09<\/div>\n<pre class=\"post-pre\"><code>...\r\n}, {\r\n       \"id\" : -1,\r\n       \"name\" : \"meta\",\r\n       <mark>\"dataTypeName\" : \"meta_data\",<\/mark>\r\n       \"fieldName\" : \":meta\",\r\n       \"position\" : 0,\r\n       \"renderTypeName\" : \"meta_data\",\r\n       \"format\" : { },\r\n       \"flags\" : [ \"hidden\" ]\r\n     }, {\r\n       <mark>\"id\" : 45985351,<\/mark>\r\n       <mark>\"name\" : \"DBN\",<\/mark>\r\n       <mark>\"dataTypeName\" : \"text\",<\/mark>\r\n       \"fieldName\" : \"dbn\",\r\n       \"position\" : 1,\r\n       \"renderTypeName\" : \"text\",\r\n       \"tableColumnId\" : 8032537,\r\n       \"cachedContents\" : {\r\n         \"non_null\" : \"10075\",\r\n...\r\n<\/code><\/pre>\n<p>id\u304c45985351\u306e\u5024\u3092\u6301\u3064\u8f9e\u66f8\u306f\u3001dataTypeName\u30ad\u30fc\u306e\u5024\u304cmeta_data\u3067\u306f\u306a\u3044\u6700\u521d\u306e\u8f9e\u66f8\u3067\u3059\u3002\u4ee3\u308f\u308a\u306b\u3001\u5024\u306f\u6587\u5b57\u5217\u3067\u3059\u3002\u3053\u306e\u8f9e\u66f8\u306f\u3001\u6700\u7d42\u7684\u306a\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306e\u6700\u521d\u306e\u5217\u306b\u95a2\u3059\u308b\u60c5\u5831\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u5217\u306e\u8981\u7d20\u306f\u3001\u30c6\u30ad\u30b9\u30c8\u5f62\u5f0f\uff08\u3064\u307e\u308a\u3001\u6587\u5b57\u5217\uff09\u3067\u3059\u3002\u3053\u306e\u6700\u521d\u306e\u8f9e\u66f8\u306f\u3001name\u30ad\u30fc\u306bDBN\u306e\u5024\u3092\u6301\u3064\u305f\u3081\u3001DBN\u304c\u6700\u521d\u306e\u5217\u306e\u540d\u524d\u3067\u3042\u308b\u3053\u3068\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u8f9e\u66f8\u306b\u7d9a\u304f\u3059\u3079\u3066\u306e\u8f9e\u66f8\uff08columns\u30ad\u30fc\u5185\uff09\u306f\u3001\u305d\u308c\u3089\u306edataTypeName\u30ad\u30fc\u306e\u5024\u3068\u3057\u3066meta_data\u3092\u6301\u305f\u306a\u3044\u305f\u3081\u3001\u3053\u308c\u3089\u306e\u8f9e\u66f8\u306fDataFrame\u306e\u6b21\u306e\u5217\u306b\u95a2\u3059\u308b\u60c5\u5831\u3092\u8868\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u6b21\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u5217\u306b\u95a2\u3059\u308b\u60c5\u5831\u3092\u898b\u3064\u3051\u308b\u65b9\u6cd5\u306e\u57fa\u672c\u7684\u306a\u7406\u89e3\u304c\u3042\u308b\u306e\u3067\u3001\u3053\u308c\u3089\u306e\u5217\u306e\u540d\u524d\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n<h3>\u30ab\u30e9\u30e0\u540d\u3092\u898b\u3064\u3051\u308b<\/h3>\n<p>\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001API\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089\u53d6\u5f97\u3057\u305f\u3059\u3079\u3066\u306e\u5217\u306e\u540d\u524d\u3092\u3001&#8221;columns&#8221;\u3068\u3044\u3046\u30ea\u30b9\u30c8\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u884c\u3092Jupyter Notebook\u306e\u65b0\u3057\u3044\u30bb\u30eb\u306b\u8ffd\u52a0\u3057\u3001\u30bb\u30eb\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b\u305f\u3081\u306e\u300cconvert_data.ipynb\u300d\u3092\u4f5c\u6210\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"1\">response<span class=\"token operator\">=<\/span>requests<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;https:\/\/data.cityofnewyork.us\/api\/views\/ihfw-zy9j\/rows.json&#8217;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>json<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/li>\n<li data-prefix=\"2\"><\/li>\n<li data-prefix=\"3\">columns<span class=\"token operator\">=<\/span><span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><\/li>\n<li data-prefix=\"4\"><\/li>\n<li data-prefix=\"5\"><span class=\"token keyword\">for<\/span> i <span class=\"token keyword\">in<\/span> response<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#8216;meta&#8217;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#8216;view&#8217;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#8216;columns&#8217;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">:<\/span><\/li>\n<li data-prefix=\"6\"><\/li>\n<li data-prefix=\"7\"><span class=\"token keyword\">if<\/span><span class=\"token punctuation\">(<\/span>i<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#8216;dataTypeName&#8217;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token operator\">==<\/span><span class=\"token string\">&#8216;meta_data&#8217;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><\/li>\n<li data-prefix=\"8\"><\/li>\n<li data-prefix=\"9\"><span class=\"token keyword\">continue<\/span><\/li>\n<li data-prefix=\"10\"><span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span><\/li>\n<li data-prefix=\"11\"><\/li>\n<li data-prefix=\"12\">columns<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>i<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#8216;name&#8217;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u30b9\u30c6\u30c3\u30d72\u306e\u30e1\u30bd\u30c3\u30c93\u3068\u540c\u69d8\u306b\u3001requests\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u4f7f\u7528\u3057\u3066\u3053\u306eURL\u306b\u3042\u308b\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u8fbc\u307f\u3001\u5909\u6570response\u306b\u5272\u308a\u5f53\u3066\u307e\u3059\u3002<\/p>\n<p>3\u884c\u76ee\u3067\u306f\u3001\u30ab\u30e9\u30e0\u306e\u30ea\u30b9\u30c8\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u30025\u884c\u76ee\u3067\u306f\u3001\u30e1\u30bf\u30ad\u30fc\u306e\u5024\u306e\u4e2d\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u30d3\u30e5\u30fc\u30ad\u30fc\u306e\u5024\u306e\u4e2d\u3067\u3001\u30ab\u30e9\u30e0\u30ad\u30fc\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u3002<\/p>\n<p>for\u30eb\u30fc\u30d7\u306f\u3001columns\u30ad\u30fc\u306b\u6dfb\u4ed8\u3055\u308c\u305f\u30ea\u30b9\u30c8\u5185\u306e\u3059\u3079\u3066\u306e\u8f9e\u66f8\u3092\u7e70\u308a\u8fd4\u3057\u51e6\u7406\u3057\u3001\u305d\u308c\u3089\u306e\u8f9e\u66f8\u306edataTypeName\u30ad\u30fc\u306e\u5024\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\u73fe\u5728\u306e\u8f9e\u66f8\u306edataTypeName\u30ad\u30fc\u306e\u5024\u304cmeta_data\u3068\u7b49\u3057\u3044\u5834\u5408\u3001\u6b21\u306e\u8f9e\u66f8\u306b\u9032\u307f\u307e\u3059\u3002\u3082\u3057\u7b49\u3057\u304f\u306a\u3044\u5834\u5408\u306f\u3001name\u30ad\u30fc\u306e\u5024\u3092columns\u30ea\u30b9\u30c8\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n<p>\u6b21\u306b\u3001\u5217\u30ea\u30b9\u30c8\u306e\u5185\u5bb9\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u65b0\u3057\u3044\u30bb\u30eb\u3067\u6b21\u306e\u884c\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308bconvert_data.ipynb<\/div>\n<pre class=\"post-pre\"><code>columns\r\n<\/code><\/pre>\n<p>\u5217\u306e\u540d\u524d\u304c\u753b\u9762\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>[&#8216;DBN&#8217;, &#8216;Name&#8217;, &#8216;schoolyear&#8217;, &#8216;fl_percent&#8217;, &#8216;frl_percent&#8217;, &#8216;total_enrollment&#8217;, &#8216;prek&#8217;, &#8216;k&#8217;, &#8216;grade1&#8217;, &#8216;grade2&#8217;, &#8216;grade3&#8217;, &#8216;grade4&#8217;, &#8216;grade5&#8217;, &#8216;grade6&#8217;, &#8216;grade7&#8217;, &#8216;grade8&#8217;, &#8216;grade9&#8217;, &#8216;grade10&#8217;, &#8216;grade11&#8217;, &#8216;grade12&#8217;, &#8216;ell_num&#8217;, &#8216;ell_percent&#8217;, &#8216;sped_num&#8217;, &#8216;sped_percent&#8217;, &#8216;ctt_num&#8217;, &#8216;selfcontained_num&#8217;, &#8216;asian_num&#8217;, &#8216;asian_per&#8217;, &#8216;black_num&#8217;, &#8216;black_per&#8217;, &#8216;hispanic_num&#8217;, &#8216;hispanic_per&#8217;, &#8216;white_num&#8217;, &#8216;white_per&#8217;, &#8216;male_num&#8217;, &#8216;male_per&#8217;, &#8216;female_num&#8217;, &#8216;female_per&#8217;]<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u51fa\u529b\u7d50\u679c\u306f\u3001dataTypeName\u304cmeta_data\u3067\u306f\u306a\u3044\u4efb\u610f\u306e\u5217\u304ccolumns\u30ea\u30b9\u30c8\u306b\u8ffd\u52a0\u3055\u308c\u305f\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u9806\u4e0d\u540c\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089\u306e\u30ab\u30e9\u30e0\u540d\u306e\u30ea\u30b9\u30c8\u3092\u53d6\u5f97\u3057\u3001\u6700\u7d42\u7684\u306aDataFrame\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u3068\u306a\u308a\u307e\u3059\u3002\u6b21\u306b\u3001\u30ab\u30e9\u30e0\u30ea\u30b9\u30c8\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u30ab\u30e9\u30e0\u306b\u5c5e\u3059\u308b\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<\/p>\n<h3>n\u500b\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u3092\u5b9a\u7fa9\u3059\u308b<\/h3>\n<p>\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001API\u5185\u306e\u5217\u306e\u6570\u3092\u6c7a\u5b9a\u3057\u3001\u3053\u306e\u6570\u306b\u5bfe\u5fdc\u3059\u308b\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u30ea\u30b9\u30c8\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u3002<\/p>\n<p>\u6700\u7d42\u7684\u306b\u306f\u3001\u30b9\u30c6\u30c3\u30d72\u306e\u30e1\u30bd\u30c3\u30c92\u3092\u4f7f\u7528\u3057\u3066\u3001\u5217\u540d\u3092\u793a\u3059\u30ad\u30fc\u3068\u3001\u305d\u308c\u3089\u306e\u30ad\u30fc\u306e\u5024\u304c\u5404\u5217\u306e\u8981\u7d20\u3092\u8868\u3059\u30ea\u30b9\u30c8\u3067\u3042\u308b\u8f9e\u66f8\u304b\u3089pandas\u306eDataFrame\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002API\u306e\u5217\u6570\u3092\u6c7a\u5b9a\u3057\u305f\u5f8c\u3001\u540c\u3058\u6570\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u304b\u3089\u306a\u308b\u30ea\u30b9\u30c8\u3092\u5b9a\u7fa9\u3057\u3001\u5404\u30b5\u30d6\u30ea\u30b9\u30c8\u306b\u306f\u5404\u5217\u306e\u30c7\u30fc\u30bf\u304c\u542b\u307e\u308c\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u64cd\u4f5c\u3092\u4f7f\u7528\u3057\u3066\u8f9e\u66f8\u3092\u5b9a\u7fa9\u3057\u305f\u3089\u3001columns\u306e\u30ea\u30b9\u30c8\u3068\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u30ea\u30b9\u30c8\u3092\u30eb\u30fc\u30d7\u51e6\u7406\u3059\u308b\u3053\u3068\u3067\u3001\u8f9e\u66f8\u306b\u52d5\u7684\u306b\u8ffd\u52a0\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u305f\u3068\u3048\u3070\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b90\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306f\u3001columns\u30ea\u30b9\u30c8\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b90\u306e\u5217\u540d\u306e\u8981\u7d20\u306e\u30ea\u30b9\u30c8\u3068\u3057\u3066\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002\u540c\u69d8\u306b\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b91\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306f\u3001columns\u30ea\u30b9\u30c8\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b91\u306e\u5217\u540d\u306e\u8981\u7d20\u306e\u30ea\u30b9\u30c8\u3068\u3057\u3066\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u524d\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u306f\u3001\u5217\u306e\u540d\u524d\u306e\u30ea\u30b9\u30c8\u3092\u53d6\u5f97\u3057\u307e\u3057\u305f\u3002\u6b21\u306b\u3001\u65b0\u3057\u3044\u30bb\u30eb\u3067\u3053\u306e\u884c\u3092\u5b9f\u884c\u3057\u3066\u3001\u3053\u306e\u30ea\u30b9\u30c8\u306e\u9577\u3055\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b\u305f\u3081\u306econvert_data.ipynb<\/div>\n<pre class=\"post-pre\"><code><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>columns<span class=\"token punctuation\">)<\/span>\r\n<\/code><\/pre>\n<p>columns\u306elen()\u306f\u3001columns\u30ea\u30b9\u30c8\u5185\u306e\u30a2\u30a4\u30c6\u30e0\u6570\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n<p>API\u306b\u542b\u307e\u308c\u308b\u5217\u306e\u6570\u304c\u753b\u9762\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>38<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>38\u5217\u6301\u3063\u3066\u3044\u308b\u306e\u3067\u300138\u500b\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u3092\u5b9a\u7fa9\u3057\u3001\u305d\u308c\u305e\u308c\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306b\u5404\u5217\u306e\u30c7\u30fc\u30bf\u3092\u542b\u3081\u307e\u3059\u3002<\/p>\n<p>\u65b0\u3057\u3044\u30bb\u30eb\u3067\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3057\u3066\u300138\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\uff08\u540d\u524d\u306fd\uff09\u3092\u4f5c\u6210\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u306e\u5909\u63db\u3092\u3059\u308b\u305f\u3081\u306e convert_data.ipynb\u30d5\u30a1\u30a4\u30eb<\/div>\n<pre class=\"post-pre\"><code><mark>d<\/mark> <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">for<\/span> x <span class=\"token keyword\">in<\/span>  <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>columns<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span>\r\n\r\nd\r\n<\/code><\/pre>\n<p>\u30ea\u30b9\u30c8\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306b\u3001\u307e\u305a\u305d\u306e\u540d\u524d\u3092\u3064\u3051\u307e\u3059\uff08\u3053\u306e\u5834\u5408\u3001d\u3068\u3057\u307e\u3059\uff09\u3002\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u5185\u306e\u5404\u914d\u5217\uff08[]\uff09\u306f\u3001\u3055\u304d\u307b\u3069\u898b\u3064\u3051\u305f38\u5217\u306e\u7bc4\u56f2\u304b\u3089\u30c7\u30fc\u30bf\u3092\u542b\u3080\u65b0\u3057\u3044\u30b5\u30d6\u30ea\u30b9\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p>\u4ee5\u4e0b\u306e\u51fa\u529b\u306f\u300138\u500b\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u30ea\u30b9\u30c8\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>[[], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], []]<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u3053\u308c\u3089\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306f\u6700\u521d\u306f\u7a7a\u3067\u3059\u3002\u306a\u305c\u306a\u3089\u3001\u307e\u3060\u8981\u7d20\u3092\u8ffd\u52a0\u3057\u3066\u3044\u306a\u3044\u304b\u3089\u3067\u3059\u3002<\/p>\n<p>\u73fe\u5728\u3001\u30ea\u30b9\u30c8d\u5185\u306b\u306f38\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u304c\u4f5c\u6210\u3055\u308c\u307e\u3057\u305f\u3002\u3053\u308c\u3089\u306e38\u500b\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u5185\u5bb9\u306f\u300138\u500b\u306e\u5217\u306e\u30c7\u30fc\u30bf\u3092\u8868\u3057\u307e\u3059\u3002\u6b21\u306b\u3001\u305d\u306e\u5185\u5bb9\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n<h3>\u30ab\u30e9\u30e0\u306e\u5024\u3092\u53d6\u5f97\u3059\u308b<\/h3>\n<p>\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001API\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089\u5217\u5358\u4f4d\u306e\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u3001\u524d\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u4f5c\u6210\u3057\u305f38\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306b\u305d\u306e\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u3053\u308c\u3092\u884c\u3046\u306b\u306f\u3001\u307e\u305a\u30c7\u30fc\u30bf\u30ad\u30fc\u304cAPI\u5168\u4f53\u3067\u3069\u3053\u306b\u5b58\u5728\u3059\u308b\u304b\u3092\u8abf\u3079\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u30c7\u30fc\u30bf\u30ad\u30fc\u306e\u5024\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u5185\u5bb9\u3092\u8868\u3057\u307e\u3059\u3002<\/p>\n<p>\u30d6\u30e9\u30a6\u30b6\u3067API\u306eURL\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u969b\u306b\u306f\u3001CTRL+F\u3092\u5165\u529b\u3057\u3066\u30c7\u30fc\u30bf\u3092\u691c\u7d22\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u691c\u7d22\u7d50\u679c\u306f\u7d0473\u56de\u898b\u3064\u304b\u308a\u307e\u3059\u3002\u6700\u5f8c\u306e\u51fa\u73fe\u7b87\u6240\u3092\u898b\u3064\u3051\u3001\u4ee5\u4e0b\u306e\u5185\u5bb9\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<div>\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\u306e\u5b66\u6821\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306eURL\u304b\u3089\u306eAPI\u30c7\u30fc\u30bf\u3092\u793a\u3059\u30c7\u30fc\u30bf\u90e8\u5206\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u3002<\/div>\n<pre class=\"post-pre\"><code>...\r\n<mark>\"data\"<\/mark> : [ [ \"row-h6zp~rx75.iwiv\", \"00000000-0000-0000-C205-81EF0C7F0969\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", \"P.S. 015 ROBERTO CLEMENTE\", \"20052006\", \"89.4\", null, \"281\", \"15\", \"36\", \"40\", \"33\", \"38\", \"52\", \"29\", \"38\", null, null, null, null, null, null, \"36\", \"12.8\", \"57\", \"20.3\", \"25\", \"9\", \"10\", \"3.6\", \"74\", \"26.3\", \"189\", \"67.3\", \"5\", \"1.8\", \"158\", \"56.2\", \"123\", \"43.8\" ]\r\n, [ \"row-bgbf_ntuw.ckdq\", \"00000000-0000-0000-9AF5-4D58BAF51C20\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", \"P.S. 015 ROBERTO CLEMENTE\", \"20062007\", \"89.4\", null, \"243\", \"15\", \"29\", \"39\", \"38\", \"34\", \"42\", \"46\", null, null, null, null, null, null, null, \"38\", \"15.6\", \"55\", \"22.6\", \"19\", \"15\", \"18\", \"7.4\", \"68\", \"28\", \"153\", \"63\", \"4\", \"1.6\", \"140\", \"57.6\", \"103\", \"42.4\" ]\r\n, [ \"row-mspc-8wz5_uxb8\", \"00000000-0000-0000-9E11-73B99A1B02D9\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", \"P.S. 015 ROBERTO CLEMENTE\", \"20072008\", \"89.4\", null, \"261\", \"18\", \"43\", \"39\", \"36\", \"38\", \"47\", \"40\", null, null, null, null, null, null, null, \"52\", \"19.9\", \"60\", \"23\", \"20\", \"14\", \"16\", \"6.1\", \"77\", \"29.5\", \"157\", \"60.2\", \"7\", \"2.7\", \"143\", \"54.8\", \"118\", \"45.2\" ]\r\n, [ \"row-p6za~9ikt~ums7\", \"00000000-0000-0000-D2CD-5904BA5DC16E\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", \"P.S. 015 ROBERTO CLEMENTE\", \"20082009\", \"89.4\", null, \"252\", \"17\", \"37\", \"44\", \"32\", \"34\", \"39\", \"49\", null, null, null, null, null, null, null, \"48\", \"19\", \"62\", \"24.6\", \"21\", \"17\", \"16\", \"6.3\", \"75\", \"29.8\", \"149\", \"59.1\", \"7\", \"2.8\", \"149\", \"59.1\", \"103\", \"40.9\" ]\r\n, [ \"row-55ss_ktcg~w7ru\", \"00000000-0000-0000-9425-35118FA9200F\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", \"P.S. 015 ROBERTO CLEMENTE\", \"20092010\", \"   \", \"96.5\", \"208\", \"16\", \"40\", \"28\", \"32\", \"30\", \"24\", \"38\", null, null, null, null, null, null, null, \"40\", \"19.2\", \"46\", \"22.1\", \"14\", \"14\", \"16\", \"7.7\", \"67\", \"32.2\", \"118\", \"56.7\", \"6\", \"2.9\", \"124\", \"59.6\", \"84\", \"40.4\" ]\r\n, [ \"row-ugmn-sxmy_fyiu\", \"00000000-0000-0000-2070-ABC0343F1148\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", \"P.S. 015 ROBERTO CLEMENTE\", \"20102011\", \"   \", \"96.5\", \"203\", \"13\", \"37\", \"35\", \"33\", \"30\", \"30\", \"25\", null, null, null, null, null, null, null, \"30\", \"14.8\", \"46\", \"22.7\", \"21\", \"9\", \"13\", \"6.4\", \"75\", \"36.9\", \"110\", \"54.2\", \"4\", \"2\", \"113\", \"55.7\", \"90\", \"44.3\" ]\r\n, [ \"row-a4rf-xqy7~fvkh\", \"00000000-0000-0000-AF7F-41FA5EB8E91E\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", \"P.S. 015 ROBERTO CLEMENTE                       \", \"20112012\", null, \"89.4\", \"189\", \"13\", \"31\", \"35\", \"28\", \"25\", \"28\", \"29\", \"    \", \"    \", \"    \", \"    \", \"    \", \"    \", \"    \", \"20\", \"10.6\", \"40\", \"21.2\", \"23\", \"7\", \"12\", \"6.3\", \"63\", \"33.3\", \"109\", \"57.7\", \"4\", \"2.1\", \"97\", \"51.3\", \"92\", \"48.7\" ]\r\n...\r\n<\/code><\/pre>\n<p>\u30c7\u30fc\u30bf\u30ad\u30fc\u306b\u5272\u308a\u5f53\u3066\u3089\u308c\u305f\u30ea\u30b9\u30c8\u5185\u306e\u5404\u30b5\u30d6\u30ea\u30b9\u30c8\u306f\u3001\u3042\u306a\u305f\u306e\u898b\u8fbc\u307f\u306e\u3042\u308bDataFrame\u306e1\u884c\u306e\u5024\u3092\u793a\u3057\u307e\u3059\u3002\u5b9f\u969b\u306e\u884c\u30c7\u30fc\u30bf\u304c\u59cb\u307e\u308b\u5834\u6240\u3092\u7279\u5b9a\u3059\u308b\u305f\u3081\u306b\u306f\u3001\u5217\u306e\u6570\u3068\u30c7\u30fc\u30bf\u30bb\u30af\u30b7\u30e7\u30f3\u306e1\u3064\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u5185\u306e\u8981\u7d20\u6570\u3092\u6bd4\u8f03\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u65b0\u3057\u3044\u30bb\u30eb\u3067\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3057\u3066\u3001\u5217\u306e\u6570\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u306e.ipynb\u62e1\u5f35\u5b50<\/div>\n<pre class=\"post-pre\"><code><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>columns<span class=\"token punctuation\">)<\/span>\r\n<\/code><\/pre>\n<p>\u4ee5\u4e0b\u306e\u51fa\u529b\u306f\u3001\u5217\u306e\u6570\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>38<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u6b21\u306b\u3001\u30c7\u30fc\u30bf\u5185\u306e\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u9577\u3055\u3092\u30c1\u30a7\u30c3\u30af\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u6700\u521d\u306e\u884c\u306b\u542b\u307e\u308c\u308b\u5024\u306e\u6570\u3067\u3059\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u5909\u63db.ipynb<\/div>\n<pre class=\"post-pre\"><code>\r\n<span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>response<span class=\"token punctuation\">[<\/span><span class=\"token string\">'data'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span>\r\n<\/code><\/pre>\n<p>\u30c7\u30fc\u30bf\u5185\u306e\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306f\u3001\u305d\u306eID\u756a\u53f7\u304c0\u3067\u6307\u5b9a\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u4ee5\u4e0b\u306e\u51fa\u529b\u306f\u3001\u30c7\u30fc\u30bf\u306e\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u8981\u7d20\u6570\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>46<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u30c7\u30fc\u30bf\u306f\u884c\u65b9\u5411\u306b\u3042\u308b\u306e\u3067\u3001\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u8981\u7d20\u6570\uff0846\uff09\u306f\u5217\u6570\uff0838\uff09\u3068\u7b49\u3057\u3044\u3068\u601d\u3046\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002\u3057\u304b\u3057\u3001\u5404\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u9577\u3055\u306f46\u3067\u3042\u308a\u300138\u3088\u308a\u30828\u591a\u3044\u3067\u3059\u3002\u5217\u306e\u30ad\u30fc\u5185\u306b\u306f\u3001dataTypeName\u30ad\u30fc\u306e\u5024\u3068\u3057\u3066meta_data\u304c\u3042\u308b\u8f9e\u66f8\u304c8\u3064\u3042\u308b\u3053\u3068\u3092\u601d\u3044\u51fa\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3057\u305f\u304c\u3063\u3066\u3001\u3053\u308c\u3089\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u5148\u982d\u306b\u898b\u3089\u308c\u308b\u4f59\u5206\u306a8\u3064\u306e\u5024\u306f\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u5024\u3092\u793a\u3057\u3066\u304a\u308a\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u5185\u5bb9\u3092\u8868\u3057\u3066\u3044\u307e\u305b\u3093\u3002<\/p>\n<p>\u30ea\u30b9\u30c8\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f0\u304b\u3089\u59cb\u307e\u308b\u305f\u3081\u30010\u304b\u30897\u307e\u3067\u306e\u7bc4\u56f2\u306b\u3042\u308b\u3053\u308c\u3089\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u5024\u306fDataFrame\u306e\u5185\u5bb9\u3092\u8868\u3057\u3066\u3044\u306a\u3044\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059\u304c\u3001\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u5024\u3092\u8868\u3057\u3066\u3044\u307e\u3059\u3002\u3057\u305f\u304c\u3063\u3066\u3001\u884c\u5358\u4f4d\u306e\u30c7\u30fc\u30bf\u306e\u5185\u5bb9\u306f\u30a4\u30f3\u30c7\u30c3\u30af\u30b98\u304b\u3089\u59cb\u307e\u308a\u307e\u3059\u3002<\/p>\n<p>\u65b0\u3057\u3044\u30bb\u30eb\u3067\u6b21\u306e\u884c\u3092\u5b9f\u884c\u3057\u3066\u3001\u30c7\u30fc\u30bf\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u5185\u306e\u8981\u7d20\u309246-38\uff088\uff09\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304b\u308946\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u307e\u3067\u306e\u30eb\u30fc\u30d7\u3092\u4f7f\u7528\u3057\u3066\u8ffd\u52a0\u3057\u307e\u3059\u3002\u3053\u308c\u3092\u30c6\u30b9\u30c8\u3059\u308b\u305f\u3081\u306b\u3001\u3059\u3079\u3066\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u304b\u3089\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3059\u308b\u4ee3\u308f\u308a\u306b\u3001\u6700\u521d\u306e\u884c\u304b\u3089\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b\u305f\u3081\u306econvert_data.ipynb\u3002<\/div>\n<pre class=\"post-pre\"><code>count<span class=\"token operator\">=<\/span><span class=\"token number\">0<\/span>\r\n\r\n<span class=\"token keyword\">for<\/span> i <span class=\"token keyword\">in<\/span> response<span class=\"token punctuation\">[<\/span><span class=\"token string\">'data'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>response<span class=\"token punctuation\">[<\/span><span class=\"token string\">'data'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token operator\">-<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>columns<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>response<span class=\"token punctuation\">[<\/span><span class=\"token string\">'data'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token comment\">#from index 8 to 45<\/span>\r\n\r\n    d<span class=\"token punctuation\">[<\/span>count<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>i<span class=\"token punctuation\">)<\/span>\r\n\r\n    count<span class=\"token operator\">=<\/span>count<span class=\"token operator\">+<\/span><span class=\"token number\">1<\/span>\r\n\r\nd\r\n<\/code><\/pre>\n<p>\u3053\u306e\u5834\u5408\u3001\u5909\u6570count\u306f\u3001\u6700\u521d\u306e\u884c\u306e\u5217\u30c7\u30fc\u30bf\u3092n\u756a\u76ee\u306e\u30ea\u30b9\u30c8d\u306e\u672b\u5c3e\u306b\u8ffd\u52a0\u3059\u308b\u306e\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p>\n<p>\u305d\u306e\u5f8c\u3001\u30b3\u30fc\u30c9\u306f\u30c7\u30fc\u30bf\u5185\u306e\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u3092\u53cd\u5fa9\u51e6\u7406\u3057\u3066\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b98\u304b\u308945\u307e\u3067\u306e\u8981\u7d20\uff0838\u500b\u306e\u8981\u7d20\uff09\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n<p>response[&#8216;data&#8217;][0]\u306e\u9577\u3055\u306f\u3001\u30c7\u30fc\u30bf\u30ad\u30fc\u5185\u306e\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u9577\u3055\u3092\u8868\u3057\u3066\u304a\u308a\u3001len(columns)\u306f\u30ea\u30b9\u30c8&#8221;columns&#8221;\u306e\u8981\u7d20\u6570\u3067\u3042\u308a\u3001\u6700\u7d42\u7684\u306aDataFrame\u306e\u5217\u6570\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u6700\u521d\u306e\u6570\u56de\u306e\u7e70\u308a\u8fd4\u3057\u306b\u3064\u3044\u3066\u306e\u6982\u8981\u3092\u4ee5\u4e0b\u306b\u793a\u3057\u307e\u3059\u3002\u30ab\u30a6\u30f3\u30c8\u306f\u6700\u521d\u306b0\u3067\u3059\u3002for\u30eb\u30fc\u30d7\u306b\u5165\u308b\u3068\u3001i\u306fresponse[&#8216;data&#8217;][0][8]\u3067\u3042\u308a\u3001\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u4e2d\u306e\u6700\u521d\u306e\u30e1\u30bf\u30c7\u30fc\u30bf\u4ee5\u5916\u306e\u5024\u3067\u3059\u3002\u6b21\u306b\u3001\u3053\u306ei\u306e\u5024\u3092d[0]\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002\u89d2\u30ab\u30c3\u30b3\u5185\u306e0\u306f\u73fe\u5728\u306e\u30ab\u30a6\u30f3\u30c8\u306e\u5024\u3067\u3059\u3002\u7d50\u679c\u3068\u3057\u3066\u3001\u3053\u306e\u5024\u304c\u30ea\u30b9\u30c8d\u5185\u306e\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306b\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u30ab\u30a6\u30f3\u30c8\u306f1\u305a\u3064\u5897\u52a0\u3057\u307e\u3059\u3002i\u304cresponse[&#8216;data&#8217;][0][9]\uff08\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u5185\u3067\u306e2\u756a\u76ee\u306e\u30e1\u30bf\u30c7\u30fc\u30bf\u4ee5\u5916\u306e\u5024\uff09\u306e\u5834\u5408\u3001i\u306e\u5024\u3092d[1]\u306b\u8ffd\u52a0\u3057\u307e\u3059\uff08count\u306f\u524d\u306e\u53cd\u5fa9\u30671\u5897\u52a0\u3057\u305f\u305f\u3081\u30010\u306f1\u306b\u306a\u308a\u307e\u3059\uff09\u3002\u305d\u306e\u7d50\u679c\u3001\u3053\u306e\u5024\u306f\u30ea\u30b9\u30c8d\u306e2\u756a\u76ee\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306b\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002\u3053\u306e\u30d7\u30ed\u30bb\u30b9\u306f\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b945\u306b\u5230\u9054\u3059\u308b\u307e\u3067\u7d9a\u304d\u307e\u3059\u3002\u4e0a\u8a18\u306e\u30b3\u30fc\u30c9\u306e\u6700\u5f8c\u306e\u884c\u3067\u306f\u3001\u66f4\u65b0\u3055\u308c\u305f\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u30ea\u30b9\u30c8d\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u51fa\u529b\u306b\u306f\u6700\u521d\u306e\u884c\u306e\u30c7\u30fc\u30bf\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>[[&#8217;01M015&#8242;], [&#8216;P.S. 015 ROBERTO CLEMENTE&#8217;], [&#8216;20052006&#8217;], [&#8216;89.4&#8217;], [None], [&#8216;281&#8242;], [&#8217;15&#8217;], [&#8217;36&#8217;], [&#8217;40&#8217;], [&#8217;33&#8217;], [&#8217;38&#8217;], [&#8217;52&#8217;], [&#8217;29&#8217;], [&#8217;38&#8217;], [None], [None], [None], [None], [None], [None], [&#8217;36&#8217;], [&#8216;12.8&#8242;], [&#8217;57&#8217;], [&#8216;20.3&#8242;], [&#8217;25&#8217;], [&#8216;9&#8242;], [&#8217;10&#8217;], [&#8216;3.6&#8242;], [&#8217;74&#8217;], [&#8216;26.3&#8217;], [&#8216;189&#8217;], [&#8216;67.3&#8217;], [&#8216;5&#8217;], [&#8216;1.8&#8217;], [&#8216;158&#8217;], [&#8216;56.2&#8217;], [&#8216;123&#8217;], [&#8216;43.8&#8217;]]<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u6700\u521d\u306e\u884c\u304c\u6b63\u3057\u3044\u30c7\u30fc\u30bf\u3092\u542b\u3093\u3067\u3044\u308b\u304b\u3092\u78ba\u8a8d\u3059\u308b\u306b\u306f\u3001API URL\u306e\u30c7\u30fc\u30bf\u30ad\u30fc\u306e\u5024\u3068\u3057\u3066\u4f7f\u7528\u3055\u308c\u308b\u30ea\u30b9\u30c8\u5185\u306e\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u3068\u6bd4\u8f03\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u8981\u7d20\uff08NY\u5b66\u6821\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8URL\u304b\u3089\u306eAPI\u30c7\u30fc\u30bf\uff09<\/div>\n<pre class=\"post-pre\"><code>...\r\n\"data\" : [ [ \"row-h6zp~rx75.iwiv\", \"00000000-0000-0000-C205-81EF0C7F0969\", 0, 1425758466, null, 1425758466, null, \"{ }\", <mark>\"01M015\", \"P.S. 015 ROBERTO CLEMENTE\", \"20052006\", \"89.4\", null, \"281\", \"15\", \"36\", \"40\", \"33\", \"38\", \"52\", \"29\", \"38\", null, null, null, null, null, null, \"36\", \"12.8\", \"57\", \"20.3\", \"25\", \"9\", \"10\", \"3.6\", \"74\", \"26.3\", \"189\", \"67.3\", \"5\", \"1.8\", \"158\", \"56.2\", \"123\", \"43.8\"<\/mark> ]\r\n...\r\n<\/code><\/pre>\n<p>\u4e0a\u306e\u30dc\u30c3\u30af\u30b9\u306e\u53f3\u5074\u306b\u30b9\u30af\u30ed\u30fc\u30eb\u3057\u3066\u3001\u5b8c\u5168\u306a\u30c7\u30fc\u30bf\u30b9\u30cb\u30da\u30c3\u30c8\u3092\u8868\u793a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n<p>\u6700\u521d\u306e\u3044\u304f\u3064\u304b\u306e\u5024\uff08\u30a4\u30f3\u30c7\u30c3\u30af\u30b90\u304b\u30897\u307e\u3067\uff09\u306f\u3001\u30e1\u30bf\u30c7\u30fc\u30bf\u5217\u306b\u95a2\u9023\u3059\u308b\u60c5\u5831\u3092\u8868\u3057\u3066\u3044\u307e\u3059\u3002\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u5185\u306e\u5f37\u8abf\u3055\u308c\u305f\u5024\uff08\u30a4\u30f3\u30c7\u30c3\u30af\u30b98\u304b\u308945\u307e\u3067\uff09\u306f\u3001\u62bd\u51fa\u306b\u6210\u529f\u3057\u305f\u6700\u521d\u306e\u884c\u306e\u5024\u3067\u3059\u3002<\/p>\n<p>\u3059\u3079\u3066\u306e\u884c\u306b\u5bfe\u3057\u3066\u540c\u3058\u30bf\u30b9\u30af\u3092\u5b9f\u884c\u3059\u308b\u305f\u3081\u306b\u306f\u3001\u524d\u306e\u30b3\u30fc\u30c9\u3092\u66f4\u65b0\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u307e\u305a\u3001\u65b0\u3057\u3044\u30bb\u30eb\u3067\u4ee5\u4e0b\u306e\u884c\u3092\u5b9f\u884c\u3057\u3066\u300138\u3064\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u304b\u3089\u306a\u308bd\u30ea\u30b9\u30c8\u3092\u518d\u5b9a\u7fa9\u3057\u307e\u3059\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u5909\u63db.ipynb<\/div>\n<pre class=\"post-pre\"><code>d <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">for<\/span> x <span class=\"token keyword\">in<\/span>  <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>columns<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span>\r\n<\/code><\/pre>\n<p>\u3042\u306a\u305f\u306f\u3001\u30b5\u30d6\u30ea\u30b9\u30c8d\u306e\u30ea\u30b9\u30c8\u3092\u518d\u5b9a\u7fa9\u3057\u3066\u3044\u307e\u3059\u3002\u73fe\u5728\u3001\u30b5\u30d6\u30ea\u30b9\u30c8d\u306f\u6700\u521d\u306e\u884c\u306e\u3059\u3079\u3066\u306e\u8981\u7d20\u3092\u542b\u3093\u3067\u3044\u307e\u3059\u3002\u4eca\u5ea6\u306f\u3001\u540c\u3058\u64cd\u4f5c\u3092\u6700\u521d\u306e\u884c\u3092\u542b\u3080\u3059\u3079\u3066\u306e\u6b8b\u308a\u306e\u884c\u306b\u5bfe\u3057\u3066\u884c\u3044\u305f\u3044\u3068\u8003\u3048\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u65b0\u3057\u304438\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u30ea\u30b9\u30c8\u3092\u4f5c\u6210\u3057\u305f\u306e\u3067\u3001\u6b21\u306e\u884c\u3092\u65b0\u3057\u3044\u30bb\u30eb\u3067\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u306e\u884c\u306f\u3001\u5c06\u6765\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u306e\u5168\u884c\u306b\u5bfe\u3057\u3066\u30c7\u30fc\u30bf\u62bd\u51fa\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u5909\u63db\u3092\u884c\u3046\u305f\u3081\u306e\u300cconvert_data.ipynb\u300d\u3092\u65e5\u672c\u8a9e\u3067\u8a00\u3044\u63db\u3048\u308b\u3002<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"1\"><span class=\"token keyword\">for<\/span> i <span class=\"token keyword\">in<\/span> response<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#8216;data&#8217;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">:<\/span><\/li>\n<li data-prefix=\"2\">count<span class=\"token operator\">=<\/span><span class=\"token number\">0<\/span><\/li>\n<li data-prefix=\"3\"><span class=\"token keyword\">for<\/span> j <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>response<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#8216;data&#8217;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token operator\">&#8211;<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>columns<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>response<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#8216;data&#8217;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><\/li>\n<li data-prefix=\"4\">d<span class=\"token punctuation\">[<\/span>count<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>i<span class=\"token punctuation\">[<\/span>j<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><\/li>\n<li data-prefix=\"5\">count<span class=\"token operator\">+=<\/span><span class=\"token number\">1<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>1\u884c\u76ee\u306e\u300cfor i in response[&#8216;data&#8217;]\u300d\u3067\u306f\u3001i \u304c\u5404\u30b5\u30d6\u30ea\u30b9\u30c8\u306b\u9806\u756a\u306b\u5272\u308a\u5f53\u3066\u3089\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u610f\u5473\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u3044\u304f\u3064\u304b\u306e\u30a4\u30c6\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u6982\u8981\u3092\u8aac\u660e\u3057\u307e\u3059\u3002\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u3092\u30c7\u30fc\u30bf\u30ad\u30fc\u306b\u5272\u308a\u5f53\u3066\u305f\u30ea\u30b9\u30c8i\u304b\u3089\u59cb\u307e\u308a\u307e\u3059\u3002\u30ab\u30a6\u30f3\u30c8\u306f0\u3067\u3059\u3002<\/p>\n<p>Python\u3067\u306f\u3001Line 3\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u3059\u3079\u3066\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b98\u304b\u308946\u307e\u3067\u306e\u8981\u7d20\u3092\u7e70\u308a\u8fd4\u3057\u51e6\u7406\u3067\u304d\u307e\u3059\u3002for\u30eb\u30fc\u30d7\u306e\u4e0a\u9650\u306fPython\u3067\u306f\u6392\u4ed6\u7684\u306b\u6271\u308f\u308c\u308b\u305f\u3081\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b98\u304b\u308945\u307e\u3067\u306e\u8981\u7d20\u304c\u53d6\u5f97\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u6b21\u306e\u3088\u3046\u306b\u65e5\u672c\u8a9e\u3067\u8a00\u3044\u63db\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\uff1a<\/p>\n<p>&#8220;d[count].append(i[j])&#8221; \u306f &#8220;d[0].append(i[8])&#8221; \u3092\u610f\u5473\u3057\u3001\u3064\u307e\u308a\u73fe\u5728i\u306b\u5272\u308a\u5f53\u3066\u3089\u308c\u3066\u3044\u308b\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b98\u306e\u8981\u7d20\u3092\u3001\u30ea\u30b9\u30c8d\u306e\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306b\u8ffd\u52a0\u3059\u308b\u3053\u3068\u3092\u610f\u5473\u3057\u307e\u3059\u3002count\u306f1\u5897\u52a0\u3057\u307e\u3059\u3002\u3042\u306a\u305f\u306f\u307e\u3060\u5185\u90e8\u30eb\u30fc\u30d7\u306e\u4e2d\u306b\u3044\u307e\u3059\u3002j\u306f\u4eca9\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u4eca\u3001d[1].append(i[9])\u3067\u3042\u308b\u3002\u3053\u308c\u306f\u3001\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\uff08\u5916\u5074\u306e\u30eb\u30fc\u30d7\u3067i\u306b\u5272\u308a\u5f53\u3066\u3089\u308c\u305f\u307e\u307e\uff09\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b99\u306e\u8981\u7d20\u304c\u3001\u30ea\u30b9\u30c8d\u306e2\u756a\u76ee\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306b\u8ffd\u52a0\u3055\u308c\u308b\u3053\u3068\u3092\u610f\u5473\u3059\u308b\u3002\u30ab\u30a6\u30f3\u30c8\u304c\u5897\u52a0\u3059\u308b\u3002\u5185\u5074\u306e\u30eb\u30fc\u30d7\u306f\u30011\u3064\u306e\u884c\u306e\u3059\u3079\u3066\u306e\u5024\u3092d\u306e\u3059\u3079\u3066\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306b\u8ffd\u52a0\u3059\u308b\u307e\u3067\u7d9a\u304f\u3002<\/p>\n<p>\u5185\u5074\u306e\u30eb\u30fc\u30d7\u306e\u6700\u5f8c\u306b\u3001\u6700\u521d\u306e\u884c\u306e\u6700\u5f8c\u306e\u5024\u3092\u8ffd\u52a0\u3059\u308b\u64cd\u4f5c\u306f\u3001\u6b21\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\uff1ad[37].append(i[45])\u3002i\u306e\u6700\u521d\u306e\u30a4\u30c6\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u7d42\u308f\u308a\u306b\u3001\u30ea\u30b9\u30c8d\u306f\u524d\u306e\u51fa\u529b\u3068\u540c\u3058\u3088\u3046\u306b\u306a\u308a\u307e\u3059\uff08d\u306e\u3059\u3079\u3066\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306b\u306f1\u3064\u306e\u8981\u7d20\u3057\u304b\u542b\u307e\u308c\u307e\u305b\u3093\uff09\u3002<\/p>\n<p>\u5185\u5074\u306e\u30eb\u30fc\u30d7\u304b\u3089\u629c\u3051\u51fa\u3059\u3068\u3001\u5916\u5074\u306e\u30eb\u30fc\u30d7\u306b\u79fb\u884c\u3057\u307e\u3059\u3002i\u306b\u306f\u3001\u30c7\u30fc\u30bf\u30ad\u30fc\u306b\u5272\u308a\u5f53\u3066\u3089\u308c\u305f\u30ea\u30b9\u30c8\u5185\u306e\u6b21\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\uff082\u756a\u76ee\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\uff09\u304c\u5272\u308a\u5f53\u3066\u3089\u308c\u307e\u3059\u3002count\u5024\u306f0\u306b\u623b\u308a\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e2\u756a\u76ee\u306ei\u306e\u53cd\u5fa9\u3067\u5185\u90e8\u30eb\u30fc\u30d7\u304b\u3089\u629c\u3051\u308b\u3068\u3001d\u306e\u3059\u3079\u3066\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306b\u306f\u305d\u308c\u305e\u308c2\u3064\u306e\u5024\u304c\u542b\u307e\u308c\u307e\u3059\u3002\u5404\u30b5\u30d6\u30ea\u30b9\u30c8\u306e2\u756a\u76ee\u306e\u5024\u306f\u30012\u884c\u76ee\u306b\u5c5e\u3059\u308b\u30c7\u30fc\u30bf\u3092\u8868\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u30c7\u30fc\u30bf\u30ad\u30fc\u306b\u5272\u308a\u5f53\u3066\u3089\u308c\u305f\u30ea\u30b9\u30c8\u5185\u306b\u5b58\u5728\u3059\u308b\u3059\u3079\u3066\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306b\u9069\u7528\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u53d6\u5f97\u30c7\u30fc\u30bf\u304c\u3069\u306e\u3088\u3046\u306b\u898b\u3048\u308b\u304b\u3092\u30a4\u30e1\u30fc\u30b8\u3059\u308b\u305f\u3081\u306b\u3001d\u306e\u6700\u521d\u306e3\u3064\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u6700\u521d\u306e5\u3064\u306e\u8981\u7d20\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002\u7d50\u679c\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3067\u306f\u3001\u3053\u308c\u3089\u306e\u5024\u306f\u6700\u521d\u306e3\u3064\u306e\u5217\u306e\u6700\u521d\u306e5\u3064\u306e\u8981\u7d20\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>d\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b90\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u6700\u521d\u306e5\u3064\u306e\u8981\u7d20\u3092\u78ba\u8a8d\u3057\u3066\u304b\u3089\u59cb\u3081\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b\u305f\u3081\u306econvert_data.ipynb<\/div>\n<pre class=\"post-pre\"><code>d<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">]<\/span>\r\n<\/code><\/pre>\n<p>\u51fa\u529b\u7d50\u679c\u306f\u6b21\u306e\u3088\u3046\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>[&#8217;01M015&#8242;, &#8217;01M015&#8242;, &#8217;01M015&#8242;, &#8217;01M015&#8242;, &#8217;01M015&#8242;]<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u30d6\u30e9\u30a6\u30b6\u3067\u8868\u793a\u3055\u308c\u308bAPI\u306e\u30c7\u30fc\u30bf\u30bb\u30af\u30b7\u30e7\u30f3\u3068\u6bd4\u8f03\u3059\u308b\u3053\u3068\u3067\u3001\u51fa\u529b\u3092\u691c\u8a3c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<div>\u6700\u521d\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u8981\u7d20\uff08NY School Snapshot URL\u304b\u3089\u306eAPI\u30c7\u30fc\u30bf\uff09<\/div>\n<pre class=\"post-pre\"><code>...\r\n\"data\" : [ [ \"row-h6zp~rx75.iwiv\", \"00000000-0000-0000-C205-81EF0C7F0969\", 0, 1425758466, null, 1425758466, null, \"{ }\", <mark>\"01M015\"<\/mark>, \"P.S. 015 ROBERTO CLEMENTE\", \"20052006\", \"89.4\", null, \"281\", \"15\", \"36\", \"40\", \"33\", \"38\", \"52\", \"29\", \"38\", null, null, null, null, null, null, \"36\", \"12.8\", \"57\", \"20.3\", \"25\", \"9\", \"10\", \"3.6\", \"74\", \"26.3\", \"189\", \"67.3\", \"5\", \"1.8\", \"158\", \"56.2\", \"123\", \"43.8\" ]\r\n, [ \"row-bgbf_ntuw.ckdq\", \"00000000-0000-0000-9AF5-4D58BAF51C20\", 0, 1425758466, null, 1425758466, null, \"{ }\", <mark>\"01M015\"<\/mark>, \"P.S. 015 ROBERTO CLEMENTE\", \"20062007\", \"89.4\", null, \"243\", \"15\", \"29\", \"39\", \"38\", \"34\", \"42\", \"46\", null, null, null, null, null, null, null, \"38\", \"15.6\", \"55\", \"22.6\", \"19\", \"15\", \"18\", \"7.4\", \"68\", \"28\", \"153\", \"63\", \"4\", \"1.6\", \"140\", \"57.6\", \"103\", \"42.4\" ]\r\n, [ \"row-mspc-8wz5_uxb8\", \"00000000-0000-0000-9E11-73B99A1B02D9\", 0, 1425758466, null, 1425758466, null, \"{ }\", <mark>\"01M015\"<\/mark>, \"P.S. 015 ROBERTO CLEMENTE\", \"20072008\", \"89.4\", null, \"261\", \"18\", \"43\", \"39\", \"36\", \"38\", \"47\", \"40\", null, null, null, null, null, null, null, \"52\", \"19.9\", \"60\", \"23\", \"20\", \"14\", \"16\", \"6.1\", \"77\", \"29.5\", \"157\", \"60.2\", \"7\", \"2.7\", \"143\", \"54.8\", \"118\", \"45.2\" ]\r\n, [ \"row-p6za~9ikt~ums7\", \"00000000-0000-0000-D2CD-5904BA5DC16E\", 0, 1425758466, null, 1425758466, null, \"{ }\", <mark>\"01M015\"<\/mark>, \"P.S. 015 ROBERTO CLEMENTE\", \"20082009\", \"89.4\", null, \"252\", \"17\", \"37\", \"44\", \"32\", \"34\", \"39\", \"49\", null, null, null, null, null, null, null, \"48\", \"19\", \"62\", \"24.6\", \"21\", \"17\", \"16\", \"6.3\", \"75\", \"29.8\", \"149\", \"59.1\", \"7\", \"2.8\", \"149\", \"59.1\", \"103\", \"40.9\" ]\r\n, [ \"row-55ss_ktcg~w7ru\", \"00000000-0000-0000-9425-35118FA9200F\", 0, 1425758466, null, 1425758466, null, \"{ }\", <mark>\"01M015\"<\/mark>, \"P.S. 015 ROBERTO CLEMENTE\", \"20092010\", \"   \", \"96.5\", \"208\", \"16\", \"40\", \"28\", \"32\", \"30\", \"24\", \"38\", null, null, null, null, null, null, null, \"40\", \"19.2\", \"46\", \"22.1\", \"14\", \"14\", \"16\", \"7.7\", \"67\", \"32.2\", \"118\", \"56.7\", \"6\", \"2.9\", \"124\", \"59.6\", \"84\", \"40.4\" ]\r\n,\r\n...\r\n<\/code><\/pre>\n<p>\u4e0a\u306e\u30dc\u30c3\u30af\u30b9\u306e\u53f3\u306b\u30b9\u30af\u30ed\u30fc\u30eb\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002\u5b8c\u5168\u306a\u30c7\u30fc\u30bf\u30b9\u30cb\u30da\u30c3\u30c8\u3092\u95b2\u89a7\u3059\u308b\u305f\u3081\u3067\u3059\u3002<\/p>\n<p>\u53d6\u5f97\u3057\u305f\u5024\u306f\u3001\u5404\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b98\u306b\u3042\u308b\u30cf\u30a4\u30e9\u30a4\u30c8\u3055\u308c\u305f\u5024\u3068\u4e00\u81f4\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b90-7\u306e\u8981\u7d20\u306f\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u5024\u3067\u3042\u308a\u3001\u5c06\u6765\u7684\u306a\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u306e\u5024\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u6700\u7d42\u7684\u306b\u306f\u3001\u3053\u308c\u3089\u306e\u5024\u306f\u5217\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b90\u306e\u6700\u521d\u306e5\u3064\u306e\u8981\u7d20\u3092\u8868\u3057\u307e\u3059\u3002<\/p>\n<p>\u6b21\u306b\u3001d\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b91\u306b\u3042\u308b\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u6700\u521d\u306e5\u3064\u306e\u8981\u7d20\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b.convert_data.ipynb<\/div>\n<pre class=\"post-pre\"><code>d<span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">]<\/span>\r\n<\/code><\/pre>\n<p>\u7b2c\u4e8c\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u6700\u521d\u306e5\u3064\u306e\u8981\u7d20\u304c\u753b\u9762\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>[&#8216;P.S. 015 ROBERTO CLEMENTE&#8217;, &#8216;P.S. 015 ROBERTO CLEMENTE&#8217;, &#8216;P.S. 015 ROBERTO CLEMENTE&#8217;, &#8216;P.S. 015 ROBERTO CLEMENTE&#8217;, &#8216;P.S. 015 ROBERTO CLEMENTE&#8217;]<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u3053\u308c\u3089\u306e\u5024\u306f\u3001\u30ab\u30e9\u30e0\u30ea\u30b9\u30c8\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b91\u306e\u5217\u300c\u540d\u524d\u300d\u306e\u6700\u521d\u306e5\u3064\u306e\u8981\u7d20\u3092\u8868\u3057\u3066\u3044\u307e\u3059\u3002API\u306eURL\u306e\u30c7\u30fc\u30bf\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u51fa\u529b\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u7b2c\u4e8c\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u8981\u7d20\uff08NY School Snapshot URL\u304b\u3089\u306eAPI\u30c7\u30fc\u30bf\uff09<\/div>\n<pre class=\"post-pre\"><code>...\r\n\"data\" : [ [ \"row-h6zp~rx75.iwiv\", \"00000000-0000-0000-C205-81EF0C7F0969\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", <mark>\"P.S. 015 ROBERTO CLEMENTE\"<\/mark>, \"20052006\", \"89.4\", null, \"281\", \"15\", \"36\", \"40\", \"33\", \"38\", \"52\", \"29\", \"38\", null, null, null, null, null, null, \"36\", \"12.8\", \"57\", \"20.3\", \"25\", \"9\", \"10\", \"3.6\", \"74\", \"26.3\", \"189\", \"67.3\", \"5\", \"1.8\", \"158\", \"56.2\", \"123\", \"43.8\" ]\r\n, [ \"row-bgbf_ntuw.ckdq\", \"00000000-0000-0000-9AF5-4D58BAF51C20\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", <mark>\"P.S. 015 ROBERTO CLEMENTE\"<\/mark>, \"20062007\", \"89.4\", null, \"243\", \"15\", \"29\", \"39\", \"38\", \"34\", \"42\", \"46\", null, null, null, null, null, null, null, \"38\", \"15.6\", \"55\", \"22.6\", \"19\", \"15\", \"18\", \"7.4\", \"68\", \"28\", \"153\", \"63\", \"4\", \"1.6\", \"140\", \"57.6\", \"103\", \"42.4\" ]\r\n, [ \"row-mspc-8wz5_uxb8\", \"00000000-0000-0000-9E11-73B99A1B02D9\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", <mark>\"P.S. 015 ROBERTO CLEMENTE\"<\/mark>, \"20072008\", \"89.4\", null, \"261\", \"18\", \"43\", \"39\", \"36\", \"38\", \"47\", \"40\", null, null, null, null, null, null, null, \"52\", \"19.9\", \"60\", \"23\", \"20\", \"14\", \"16\", \"6.1\", \"77\", \"29.5\", \"157\", \"60.2\", \"7\", \"2.7\", \"143\", \"54.8\", \"118\", \"45.2\" ]\r\n, [ \"row-p6za~9ikt~ums7\", \"00000000-0000-0000-D2CD-5904BA5DC16E\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", <mark>\"P.S. 015 ROBERTO CLEMENTE\"<\/mark>, \"20082009\", \"89.4\", null, \"252\", \"17\", \"37\", \"44\", \"32\", \"34\", \"39\", \"49\", null, null, null, null, null, null, null, \"48\", \"19\", \"62\", \"24.6\", \"21\", \"17\", \"16\", \"6.3\", \"75\", \"29.8\", \"149\", \"59.1\", \"7\", \"2.8\", \"149\", \"59.1\", \"103\", \"40.9\" ]\r\n, [ \"row-55ss_ktcg~w7ru\", \"00000000-0000-0000-9425-35118FA9200F\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", <mark>\"P.S. 015 ROBERTO CLEMENTE\"<\/mark>, \"20092010\", \"   \", \"96.5\", \"208\", \"16\", \"40\", \"28\", \"32\", \"30\", \"24\", \"38\", null, null, null, null, null, null, null, \"40\", \"19.2\", \"46\", \"22.1\", \"14\", \"14\", \"16\", \"7.7\", \"67\", \"32.2\", \"118\", \"56.7\", \"6\", \"2.9\", \"124\", \"59.6\", \"84\", \"40.4\" ]\r\n,\r\n...\r\n<\/code><\/pre>\n<p>\u4e0a\u306e\u30dc\u30c3\u30af\u30b9\u306e\u53f3\u306b\u30b9\u30af\u30ed\u30fc\u30eb\u3057\u3066\u3001\u5b8c\u5168\u306a\u30c7\u30fc\u30bf\u30b9\u30cb\u30da\u30c3\u30c8\u3092\u8868\u793a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002\u53d6\u5f97\u3057\u305f\u5024\u306f\u3001\u30cf\u30a4\u30e9\u30a4\u30c8\u3055\u308c\u305f\u5024\u3068\u4e00\u81f4\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u6700\u5f8c\u306b\u3001d\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b92\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u6700\u521d\u306e5\u3064\u306e\u8981\u7d20\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b\u3002<\/div>\n<pre class=\"post-pre\"><code>d<span class=\"token punctuation\">[<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">:<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">]<\/span>\r\n<\/code><\/pre>\n<p>\u4ee5\u4e0b\u306e\u51fa\u529b\u306f\u753b\u9762\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>[&#8216;20052006&#8217;, &#8216;20062007&#8217;, &#8216;20072008&#8217;, &#8216;20082009&#8217;, &#8216;20092010&#8217;]<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>API\u306eURL\u306e\u30c7\u30fc\u30bf\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u51fa\u529b\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\u5b66\u6821\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u306eURL\u304b\u3089\u306eAPI\u30c7\u30fc\u30bf\u306e\u30bb\u30ab\u30f3\u30c9\u30b5\u30d6\u30ea\u30b9\u30c8\u306e\u8981\u7d20<\/div>\n<pre class=\"post-pre\"><code>...\r\n\"data\" : [ [ \"row-h6zp~rx75.iwiv\", \"00000000-0000-0000-C205-81EF0C7F0969\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", \"P.S. 015 ROBERTO CLEMENTE\", <mark>\"20052006\"<\/mark>, \"89.4\", null, \"281\", \"15\", \"36\", \"40\", \"33\", \"38\", \"52\", \"29\", \"38\", null, null, null, null, null, null, \"36\", \"12.8\", \"57\", \"20.3\", \"25\", \"9\", \"10\", \"3.6\", \"74\", \"26.3\", \"189\", \"67.3\", \"5\", \"1.8\", \"158\", \"56.2\", \"123\", \"43.8\" ]\r\n, [ \"row-bgbf_ntuw.ckdq\", \"00000000-0000-0000-9AF5-4D58BAF51C20\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", \"P.S. 015 ROBERTO CLEMENTE\", <mark>\"20062007\"<\/mark>, \"89.4\", null, \"243\", \"15\", \"29\", \"39\", \"38\", \"34\", \"42\", \"46\", null, null, null, null, null, null, null, \"38\", \"15.6\", \"55\", \"22.6\", \"19\", \"15\", \"18\", \"7.4\", \"68\", \"28\", \"153\", \"63\", \"4\", \"1.6\", \"140\", \"57.6\", \"103\", \"42.4\" ]\r\n, [ \"row-mspc-8wz5_uxb8\", \"00000000-0000-0000-9E11-73B99A1B02D9\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", \"P.S. 015 ROBERTO CLEMENTE\", <mark>\"20072008\"<\/mark>, \"89.4\", null, \"261\", \"18\", \"43\", \"39\", \"36\", \"38\", \"47\", \"40\", null, null, null, null, null, null, null, \"52\", \"19.9\", \"60\", \"23\", \"20\", \"14\", \"16\", \"6.1\", \"77\", \"29.5\", \"157\", \"60.2\", \"7\", \"2.7\", \"143\", \"54.8\", \"118\", \"45.2\" ]\r\n, [ \"row-p6za~9ikt~ums7\", \"00000000-0000-0000-D2CD-5904BA5DC16E\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", \"P.S. 015 ROBERTO CLEMENTE\", <mark>\"20082009\"<\/mark>, \"89.4\", null, \"252\", \"17\", \"37\", \"44\", \"32\", \"34\", \"39\", \"49\", null, null, null, null, null, null, null, \"48\", \"19\", \"62\", \"24.6\", \"21\", \"17\", \"16\", \"6.3\", \"75\", \"29.8\", \"149\", \"59.1\", \"7\", \"2.8\", \"149\", \"59.1\", \"103\", \"40.9\" ]\r\n, [ \"row-55ss_ktcg~w7ru\", \"00000000-0000-0000-9425-35118FA9200F\", 0, 1425758466, null, 1425758466, null, \"{ }\", \"01M015\", \"P.S. 015 ROBERTO CLEMENTE\", <mark>\"20092010\"<\/mark>, \"   \", \"96.5\", \"208\", \"16\", \"40\", \"28\", \"32\", \"30\", \"24\", \"38\", null, null, null, null, null, null, null, \"40\", \"19.2\", \"46\", \"22.1\", \"14\", \"14\", \"16\", \"7.7\", \"67\", \"32.2\", \"118\", \"56.7\", \"6\", \"2.9\", \"124\", \"59.6\", \"84\", \"40.4\" ]\r\n,\r\n...\r\n<\/code><\/pre>\n<p>\u4e0a\u306e\u30dc\u30c3\u30af\u30b9\u306e\u53f3\u306b\u30b9\u30af\u30ed\u30fc\u30eb\u3057\u3066\u3001\u5b8c\u5168\u306a\u30c7\u30fc\u30bf\u30b9\u30cb\u30da\u30c3\u30c8\u3092\u8868\u793a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002\u53d6\u5f97\u3057\u305f\u5024\u306f\u30cf\u30a4\u30e9\u30a4\u30c8\u3055\u308c\u305f\u5024\u3068\u4e00\u81f4\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u5024\u306f\u3001\u30ab\u30e9\u30e0\u30ea\u30b9\u30c8\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b92\u306e\u30ab\u30e9\u30e0\u3067\u3042\u308bschoolyear\u306e\u6700\u521d\u306e5\u3064\u306e\u8981\u7d20\u3092\u8868\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u30b9\u30c6\u30c3\u30d7\u306e\u6700\u5f8c\u306b\u5230\u9054\u3059\u308b\u3068\u300138\u500b\u306e\u5217\u3059\u3079\u3066\u306e\u3059\u3079\u3066\u306e\u884c\u306e\u30c7\u30fc\u30bf\u304c\u6b63\u5e38\u306b\u53d6\u308a\u51fa\u3055\u308c\u3001\u305d\u308c\u3089\u304c\u30ea\u30b9\u30c8d\u306e38\u500b\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306b\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002\u4eca\u5ea6\u306f\u3001\u3053\u308c\u307e\u3067\u306b\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u3066\u3001\u6700\u7d42\u30b9\u30c6\u30c3\u30d7\u3067Pandas\u306eDataFrame\u3092\u4f5c\u6210\u3059\u308b\u6e96\u5099\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n<h3>\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u306e\u305f\u3081\u306e\u8f9e\u66f8\u3092\u4f5c\u6210\u3059\u308b<\/h3>\n<p>\u3053\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u306f\u300138\u5217\u306e\u305d\u308c\u305e\u308c\u306e\u540d\u524d\u3068\u5024\u3092\u62bd\u51fa\u3057\u307e\u3057\u305f\u3002\u3053\u308c\u3089\u306f\u8f9e\u66f8\u5f62\u5f0f\u306e\u30d1\u30f3\u30c0\u30b9\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u306b\u6e21\u3059\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u30ad\u30fc\u304c\u5217\u540d\uff08\u30ea\u30b9\u30c8\u300ccolumns\u300d\u304b\u3089\uff09\u3067\u3001\u5024\u304cd\u304b\u3089\u53d6\u5f97\u3057\u305f38\u500b\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306b\u306a\u308b\u8f9e\u66f8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p>\u65b0\u3057\u3044\u30bb\u30eb\u3067\u6b21\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u300cconvert_data.ipynb\u300d<\/div>\n<pre class=\"post-pre\"><code>json_dict<span class=\"token operator\">=<\/span><span class=\"token punctuation\">{<\/span><span class=\"token punctuation\">}<\/span>\r\n\r\n<span class=\"token keyword\">for<\/span> i <span class=\"token keyword\">in<\/span>  <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>columns<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\r\n\tjson_dict<span class=\"token punctuation\">.<\/span>update<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span>columns<span class=\"token punctuation\">[<\/span>i<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">:<\/span>d<span class=\"token punctuation\">[<\/span>i<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span>\r\n<\/code><\/pre>\n<p>\uff08\u4ee5\u4e0b\u306e\u6587\u3092\u65e5\u672c\u8a9e\u3067\u8868\u73fe\u3059\u308b\uff09\uff1a<br \/>\n0\u304b\u308938\u307e\u3067\u306e\u7bc4\u56f2\u3092\u30eb\u30fc\u30d7\u3057\u3001\u6700\u7d42\u7684\u306a\u8f9e\u66f8json_dict\u306b\u30ad\u30fc\u3068\u5024\u306e\u30da\u30a2\u3092\u8ffd\u52a0\u3057\u3001pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3078\u306e\u5909\u63db\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002\u4f8b\u3048\u3070\u3001i\u304c0\u306e\u5834\u5408\u3001d\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b90\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u3092\u5024\u3068\u3057\u3066\u3001\u30ad\u30fcDBN\uff08columns[0]\u3067\u8868\u3055\u308c\u308b\uff09\u306b\u5272\u308a\u5f53\u3066\u307e\u3059\u3002\u3053\u306e\u64cd\u4f5c\u306f\u3001\u6b8b\u308a\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306b\u5bfe\u3057\u3066\u3082\u540c\u69d8\u306b\u884c\u308f\u308c\u307e\u3059\u3002<\/p>\n<p>\u8f9e\u66f8\u306e\u53d6\u5f97\u3057\u305f\u30ad\u30fc\u306e\u8868\u793a\u65b9\u6cd5\u3092\u628a\u63e1\u3059\u308b\u305f\u3081\u306b\u3001json_dict\u306b\u5b58\u5728\u3059\u308b\u3059\u3079\u3066\u306e\u30ad\u30fc\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3059\u308b\u3001convert_data.ipynb\u3002<\/div>\n<pre class=\"post-pre\"><code>json_dict<span class=\"token punctuation\">.<\/span>keys<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\r\n<\/code><\/pre>\n<p>\u6700\u7d42\u7684\u306a\u8f9e\u66f8\u306e\u30ad\u30fc\u306e\u30ea\u30b9\u30c8\u304c\u753b\u9762\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002 (Saish\u016btekina jisho no k\u012b no risuto ga gamen ni hy\u014dji sa re masu.)<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>dict_keys([&#8216;DBN&#8217;, &#8216;Name&#8217;, &#8216;schoolyear&#8217;, &#8216;fl_percent&#8217;, &#8216;frl_percent&#8217;, &#8216;total_enrollment&#8217;, &#8216;prek&#8217;, &#8216;k&#8217;, &#8216;grade1&#8217;, &#8216;grade2&#8217;, &#8216;grade3&#8217;, &#8216;grade4&#8217;, &#8216;grade5&#8217;, &#8216;grade6&#8217;, &#8216;grade7&#8217;, &#8216;grade8&#8217;, &#8216;grade9&#8217;, &#8216;grade10&#8217;, &#8216;grade11&#8217;, &#8216;grade12&#8217;, &#8216;ell_num&#8217;, &#8216;ell_percent&#8217;, &#8216;sped_num&#8217;, &#8216;sped_percent&#8217;, &#8216;ctt_num&#8217;, &#8216;selfcontained_num&#8217;, &#8216;asian_num&#8217;, &#8216;asian_per&#8217;, &#8216;black_num&#8217;, &#8216;black_per&#8217;, &#8216;hispanic_num&#8217;, &#8216;hispanic_per&#8217;, &#8216;white_num&#8217;, &#8216;white_per&#8217;, &#8216;male_num&#8217;, &#8216;male_per&#8217;, &#8216;female_num&#8217;, &#8216;female_per&#8217;])<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>d\u306e38\u500b\u306e\u30b5\u30d6\u30ea\u30b9\u30c8\u306f\u3001json_dict\u5185\u306e38\u500b\u306e\u30ad\u30fc\u306b\u5272\u308a\u5f53\u3066\u3089\u308c\u307e\u3057\u305f\u3002\u3057\u305f\u304c\u3063\u3066\u3001\u5217\u540d\u304c\u30ad\u30fc\u3067\u3042\u308a\u3001\u5404\u5217\u306e\u8981\u7d20\u3092\u542b\u3080\u30ea\u30b9\u30c8\u304c\u5024\u3068\u306a\u308b\u8f9e\u66f8\u3092\u53d6\u5f97\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u4eca\u3001\u3053\u306e\u8f9e\u66f8\u3092Pandas\u306b\u6e21\u3057\u3066DataFrame\u3092\u751f\u6210\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u306eDataFrame\u306f\u3001\u4efb\u610f\u306e\u5909\u6570\u540d\u3067\u547c\u3073\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\uff08\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f&#8221;data&#8221;\u3068\u3044\u3046\u540d\u524d\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\uff09\u3002<\/p>\n<div>\u30c7\u30fc\u30bf\u306e\u5909\u63db\u3092\u884c\u3046\u305f\u3081\u306e convert_data.ipynb\u3002<\/div>\n<pre class=\"post-pre\"><code><mark>data<\/mark><span class=\"token operator\">=<\/span>pd<span class=\"token punctuation\">.<\/span>DataFrame<span class=\"token punctuation\">(<\/span>json_dict<span class=\"token punctuation\">)<\/span>\r\n<\/code><\/pre>\n<p>\u6b21\u306b\u3001\u7d50\u679c\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u306e\u4e00\u90e8\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002 (Tsugi ni, kekka no deeta fureemu no ichibu o kakunin shite kudasai.)<\/p>\n<div>\n<p>\u4ee5\u4e0b\u306e\u30d5\u30a1\u30a4\u30eb\u3001convert_data.ipynb\u3092\u65e5\u672c\u8a9e\u3067\u8a00\u3044\u63db\u3048\u307e\u3059\u3002<\/p>\n<p>\u300c\u30b3\u30f3\u30d0\u30fc\u30c8\u30c7\u30fc\u30bf.ipynb\u300d\u3068\u3044\u3046\u30d5\u30a1\u30a4\u30eb\u3092\u5909\u63db\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<\/div>\n<pre class=\"post-pre\"><code>data<span class=\"token punctuation\">.<\/span>head<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\r\n<\/code><\/pre>\n<p>\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u306e\u6700\u521d\u306e5\u884c\u304c\u753b\u9762\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>DBN Name schoolyear fl_percent frl_percent total_enrollment prek k grade1 grade2 &#8230; black_num black_per hispanic_num hispanic_per white_num white_per male_num male_per female_num female_per 0 01M015 P.S. 015 ROBERTO CLEMENTE 20052006 89.4 None 281 15 36 40 33 &#8230; 74 26.3 189 67.3 5 1.8 158 56.2 123 43.8 1 01M015 P.S. 015 ROBERTO CLEMENTE 20062007 89.4 None 243 15 29 39 38 &#8230; 68 28 153 63 4 1.6 140 57.6 103 42.4 2 01M015 P.S. 015 ROBERTO CLEMENTE 20072008 89.4 None 261 18 43 39 36 &#8230; 77 29.5 157 60.2 7 2.7 143 54.8 118 45.2 3 01M015 P.S. 015 ROBERTO CLEMENTE 20082009 89.4 None 252 17 37 44 32 &#8230; 75 29.8 149 59.1 7 2.8 149 59.1 103 40.9 4 01M015 P.S. 015 ROBERTO CLEMENTE 20092010 96.5 208 16 40 28 32 &#8230; 67 32.2 118 56.7 6 2.9 124 59.6 84 40.4<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u4e0a\u306e\u30dc\u30c3\u30af\u30b9\u3092\u53f3\u306b\u30b9\u30af\u30ed\u30fc\u30eb\u3057\u3066DataFrame\u306e\u30d8\u30c3\u30c9\u5168\u4f53\u3092\u8868\u793a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002\u62bd\u51fa\u3057\u305f\u30c7\u30fc\u30bf\u3092URL\u304b\u3089\u6e21\u3059\u3053\u3068\u3067\u3001DataFrame\u3092\u6210\u529f\u88cf\u306b\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002<\/p>\n<h2>\u7d50\u8ad6<\/h2>\n<p>\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3001\u3055\u307e\u3056\u307e\u306a\u5f62\u5f0f\u306e\u8f9e\u66f8\u3084URL\u304b\u3089pandas\u306eDataFrame\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306e\u4e00\u822c\u7684\u306a\u65b9\u6cd5\u3092\u4f7f\u3044\u307e\u3057\u305f\u3002\u307e\u305f\u3001\u5217\u3068\u305d\u308c\u306b\u5bfe\u5fdc\u3059\u308b\u5024\u304c\u76f4\u611f\u7684\u306b\u8868\u793a\u3055\u308c\u306a\u3044API\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089\u306eDataFrame\u3082\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u306f\u3001\u901a\u5e38\u306eAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3084\u8f9e\u66f8\u304b\u3089\u62bd\u51fa\u3057\u305f\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u3066\u3001\u30e6\u30cb\u30fc\u30af\u306a\u65b9\u6cd5\u3067DataFrames\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u3092\u7406\u89e3\u3059\u308b\u306e\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002pandas\u306eDataFrames\u306b\u3064\u3044\u3066\u3082\u3063\u3068\u77e5\u308a\u305f\u3044\u65b9\u306f\u3001\u5f53\u793e\u306epandas\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3092\u3054\u89a7\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8457\u8005\u306f\u3001\u66f8\u304f\u3053\u3068\u306b\u3088\u308b\u5bc4\u4ed8\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u4e00\u74b0\u3068\u3057\u3066\u3001\u300c\u30d5\u30ea\u30fc\u30fb\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u57fa\u91d1\u300d\u306b\u5bc4\u4ed8\u3059\u308b\u3053\u3068\u3092\u9078\u3073\u307e\u3057\u305f\u3002 \u306f\u3058\u3081\u306b Excel\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3084SQL\u30c6\u30fc\u30d6\u30eb\u306e\u3088\u3046\u306b\u3001pandas\u306eDataFrame\u306f\u884c\u3068\u5217\u306b\u30c7\u30fc\u30bf [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[26,61],"class_list":["post-492","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-26","tag-61"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5 - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5\u3092\u5206\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac\u3002\u5b9f\u8df5\u7684\u306a\u4f8b\u3068\u30b3\u30fc\u30c9\u3001\u6ce8\u610f\u70b9\u3092\u542b\u3081\u3066\u521d\u5fc3\u8005\u306b\u3082\u7406\u89e3\u3067\u304d\u308b\u3088\u3046\u8aac\u660e\u3057\u307e\u3059\u3002\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/ja\/blog\/\u7121\u9806\u5e8f\u306aapi\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5\" \/>\n<meta property=\"og:description\" content=\"\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5\u3092\u5206\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac\u3002\u5b9f\u8df5\u7684\u306a\u4f8b\u3068\u30b3\u30fc\u30c9\u3001\u6ce8\u610f\u70b9\u3092\u542b\u3081\u3066\u521d\u5fc3\u8005\u306b\u3082\u7406\u89e3\u3067\u304d\u308b\u3088\u3046\u8aac\u660e\u3057\u307e\u3059\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/ja\/blog\/\u7121\u9806\u5e8f\u306aapi\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-03T11:58:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-31T15:00:19+00:00\" \/>\n<meta name=\"author\" content=\"\u6d77\u6597, \u8475\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6d77\u6597, \u8475\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"61\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0\/\",\"url\":\"https:\/\/www.silicloud.com\/ja\/blog\/%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0\/\",\"name\":\"\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/#website\"},\"datePublished\":\"2023-05-03T11:58:07+00:00\",\"dateModified\":\"2025-07-31T15:00:19+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/#\/schema\/person\/20cfc053626f4d45c0fa7a4e7964b5b6\"},\"description\":\"\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5\u3092\u5206\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac\u3002\u5b9f\u8df5\u7684\u306a\u4f8b\u3068\u30b3\u30fc\u30c9\u3001\u6ce8\u610f\u70b9\u3092\u542b\u3081\u3066\u521d\u5fc3\u8005\u306b\u3082\u7406\u89e3\u3067\u304d\u308b\u3088\u3046\u8aac\u660e\u3057\u307e\u3059\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0\/#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/ja\/blog\/%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/ja\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/ja\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"ja\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/#\/schema\/person\/20cfc053626f4d45c0fa7a4e7964b5b6\",\"name\":\"\u6d77\u6597, \u8475\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/25aec9a18954b6bfb7e4f7219c2923d62c6f0c9f4d5c0171228fe41751c0ab7a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/25aec9a18954b6bfb7e4f7219c2923d62c6f0c9f4d5c0171228fe41751c0ab7a?s=96&d=mm&r=g\",\"caption\":\"\u6d77\u6597, \u8475\"},\"url\":\"https:\/\/www.silicloud.com\/ja\/blog\/author\/kaitoaoi\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5 - Blog - Silicon Cloud","description":"\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5\u3092\u5206\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac\u3002\u5b9f\u8df5\u7684\u306a\u4f8b\u3068\u30b3\u30fc\u30c9\u3001\u6ce8\u610f\u70b9\u3092\u542b\u3081\u3066\u521d\u5fc3\u8005\u306b\u3082\u7406\u89e3\u3067\u304d\u308b\u3088\u3046\u8aac\u660e\u3057\u307e\u3059\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/ja\/blog\/\u7121\u9806\u5e8f\u306aapi\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\/","og_locale":"ja_JP","og_type":"article","og_title":"\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5","og_description":"\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5\u3092\u5206\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac\u3002\u5b9f\u8df5\u7684\u306a\u4f8b\u3068\u30b3\u30fc\u30c9\u3001\u6ce8\u610f\u70b9\u3092\u542b\u3081\u3066\u521d\u5fc3\u8005\u306b\u3082\u7406\u89e3\u3067\u304d\u308b\u3088\u3046\u8aac\u660e\u3057\u307e\u3059\u3002","og_url":"https:\/\/www.silicloud.com\/ja\/blog\/\u7121\u9806\u5e8f\u306aapi\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-05-03T11:58:07+00:00","article_modified_time":"2025-07-31T15:00:19+00:00","author":"\u6d77\u6597, \u8475","twitter_card":"summary_large_image","twitter_misc":{"\u57f7\u7b46\u8005":"\u6d77\u6597, \u8475","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"61\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/ja\/blog\/%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0\/","url":"https:\/\/www.silicloud.com\/ja\/blog\/%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0\/","name":"\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/ja\/blog\/#website"},"datePublished":"2023-05-03T11:58:07+00:00","dateModified":"2025-07-31T15:00:19+00:00","author":{"@id":"https:\/\/www.silicloud.com\/ja\/blog\/#\/schema\/person\/20cfc053626f4d45c0fa7a4e7964b5b6"},"description":"\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5\u3092\u5206\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac\u3002\u5b9f\u8df5\u7684\u306a\u4f8b\u3068\u30b3\u30fc\u30c9\u3001\u6ce8\u610f\u70b9\u3092\u542b\u3081\u3066\u521d\u5fc3\u8005\u306b\u3082\u7406\u89e3\u3067\u304d\u308b\u3088\u3046\u8aac\u660e\u3057\u307e\u3059\u3002","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/ja\/blog\/%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0\/#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/ja\/blog\/%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/ja\/blog\/%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/ja\/blog\/"},{"@type":"ListItem","position":2,"name":"\u7121\u9806\u5e8f\u306aAPI\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u53d6\u5f97\u306e\u65b9\u6cd5"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/ja\/blog\/#website","url":"https:\/\/www.silicloud.com\/ja\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"ja"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/ja\/blog\/#\/schema\/person\/20cfc053626f4d45c0fa7a4e7964b5b6","name":"\u6d77\u6597, \u8475","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/www.silicloud.com\/ja\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/25aec9a18954b6bfb7e4f7219c2923d62c6f0c9f4d5c0171228fe41751c0ab7a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/25aec9a18954b6bfb7e4f7219c2923d62c6f0c9f4d5c0171228fe41751c0ab7a?s=96&d=mm&r=g","caption":"\u6d77\u6597, \u8475"},"url":"https:\/\/www.silicloud.com\/ja\/blog\/author\/kaitoaoi\/"},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/www.silicloud.com\/ja\/blog\/%e7%84%a1%e9%a0%86%e5%ba%8f%e3%81%aaapi%e3%82%a8%e3%83%b3%e3%83%89%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%81%8b%e3%82%89pandas%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%95%e3%83%ac%e3%83%bc%e3%83%a0\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/posts\/492","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/comments?post=492"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/posts\/492\/revisions"}],"predecessor-version":[{"id":325800,"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/posts\/492\/revisions\/325800"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/media?parent=492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/categories?post=492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/tags?post=492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}