{"id":902,"date":"2023-03-05T17:23:47","date_gmt":"2023-04-04T12:47:23","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/index.php\/2023\/11\/30\/%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe\/"},"modified":"2025-08-03T17:11:32","modified_gmt":"2025-08-03T09:11:32","slug":"%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe\/","title":{"rendered":"Python\u6570\u636e\u5904\u7406\uff1a\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6pandas DataFrame\u7684\u5b8c\u6574\u6307\u5357"},"content":{"rendered":"<p>\u4f5c\u8005\u9009\u62e9\u5c06\u81ea\u7531\u5f00\u6e90\u57fa\u91d1\u4f5c\u4e3a&#8221;\u4e3a\u6350\u6b3e\u800c\u5199&#8221;\u8ba1\u5212\u7684\u4e00\u90e8\u5206\u6536\u5230\u7684\u6350\u6b3e\u4e4b\u4e00\u3002<\/p>\n<h3>\u5f15\u8a00<\/h3>\n<p>\u4e0eExcel\u7535\u5b50\u8868\u683c\u6216SQL\u8868\u7c7b\u4f3c\uff0cpandas DataFrame\u662f\u4e00\u4e2a\u4e8c\u7ef4\u6570\u636e\u7ed3\u6784\uff0c\u6570\u636e\u4ee5\u884c\u548c\u5217\u7684\u5f62\u5f0f\u5448\u73b0\u3002DataFrame\u4e3b\u8981\u7528\u4e8e\u6570\u636e\u5bc6\u96c6\u578b\u9886\u57df\uff0c\u5982\u79d1\u5b66\u5b66\u4e60\u3001\u6570\u636e\u79d1\u5b66\u3001\u673a\u5668\u5b66\u4e60\u548c\u6570\u636e\u5206\u6790\u3002<\/p>\n<p>\u4f7f\u7528Python\uff0c\u60a8\u53ef\u4ee5\u5c06\u6765\u81eaCSV\u3001Excel\u6216API\u7aef\u70b9\u7684\u6570\u636e\u8f6c\u6362\u4e3apandas DataFrame\uff0c\u7136\u540e\u5bf9\u83b7\u5f97\u7684DataFrame\u8fdb\u884c\u64cd\u4f5c\u3002\u867d\u7136\u5c06Excel\u548cCSV\u6587\u4ef6\u8f6c\u6362\u6210DataFrame\u5f80\u5f80\u5f88\u7b80\u5355\uff0c\u4f46\u662fAPI\u7aef\u70b9\u53ef\u80fd\u5404\u4e0d\u76f8\u540c\uff0c\u56e0\u6b64\u4ece\u8fd9\u4e9b\u4fe1\u606f\u4e2d\u521b\u5efaDataFrame\u53ef\u80fd\u5177\u6709\u6311\u6218\u6027\u3002<\/p>\n<p>\u6709\u4e9bAPI\u7aef\u70b9\u4ee5\u8bfb\u8005\u53cb\u597d\u7684\u5b57\u5178\u683c\u5f0f\u5b58\u5728\uff0c\u5176\u4e2d\u952e\u8868\u793a\u5217\u540d\uff0c\u503c\u8868\u793a\u5c5e\u4e8e\u8fd9\u4e9b\u5217\u7684\u5143\u7d20\u3002\u7136\u800c\uff0c\u6709\u4e9bAPI\u7aef\u70b9\u6ca1\u6709\u4ee5\u6e05\u6670\u7684\u4e0a\u4e0b\u6587\u8868\u793a\u5217\u540d\u548c\u5b83\u4eec\u7684\u503c\uff0c\u5c06\u65e0\u5e8f\u7684API\u7aef\u70b9\u8f6c\u6362\u4e3aDataFrame\u53ef\u80fd\u4f1a\u5177\u6709\u6311\u6218\u6027\u3002<\/p>\n<p>\u5728\u8fd9\u4e2a\u6559\u7a0b\u4e2d\uff0c\u60a8\u5c06\u4ece\u4e00\u4e2a\u65e0\u5e8f\u7684\u7aef\u70b9\u83b7\u53d6\u6570\u636e\uff0c\u5e76\u4ee5\u9002\u5f53\u7684\u683c\u5f0f\u5448\u73b0\u7ed9pandas DataFrame\u3002\u9996\u5148\uff0c\u60a8\u5c06\u4ece\u4e00\u4e9b\u4f20\u7edf\u7684API\u683c\u5f0f\u4e2d\u63d0\u53d6\u6570\u636e\uff0c\u4ee5\u4fbf\u5c06\u6709\u5e8f\u7684API\u6570\u636e\u8f6c\u5316\u4e3aDataFrame\u3002\u7136\u540e\uff0c\u60a8\u5c06\u4f7f\u7528\u4e00\u4e2a\u65e0\u5e8f\u7684API\u7aef\u70b9\u3002\u60a8\u5c06\u63d0\u53d6\u5217\u540d\u53ca\u5176\u76f8\u5e94\u7684\u5143\u7d20\uff0c\u521b\u5efa\u4e00\u4e2a\u5b57\u5178\u3002\u6700\u540e\uff0c\u60a8\u5c06\u8fd9\u4e2a\u5b57\u5178\u4f20\u5165pandas DataFrame\uff0c\u4ee5\u4fbf\u8fdb\u884c\u6570\u636e\u5206\u6790\u3002<\/p>\n<h2>\u5148\u51b3\u6761\u4ef6<\/h2>\n<p>\u8981\u8ddf\u968f\u8fd9\u4e2a\u6559\u7a0b\uff0c\u60a8\u9700\u8981\uff1a<\/p>\n<ul class=\"post-ul\">\n<li>\u5728\u60a8\u7684\u673a\u5668\u4e0a\u5b89\u88c5Python 3\u3001pip\u548cPython venv\u6a21\u5757\u3002\u5bf9\u4e8eUbuntu\u548c\u5176\u4ed6Linux\u53d1\u884c\u7248\uff0c\u8bf7\u6309\u7167\u6211\u4eec\u6559\u7a0b\u4e2d\u300a\u5982\u4f55\u5b89\u88c5Python 3\u548c\u8bbe\u7f6e\u7f16\u7a0b\u73af\u5883\u300b\u7684\u6b65\u9aa41\u548c2\u64cd\u4f5c\u3002\u5bf9\u4e8emacOS\uff0c\u8bf7\u6309\u7167\u6211\u4eec\u6559\u7a0b\u4e2d\u300a\u5982\u4f55\u5728macOS\u4e0a\u5b89\u88c5Python 3\u548c\u8bbe\u7f6e\u672c\u5730\u7f16\u7a0b\u73af\u5883\u300b\u7684\u6b65\u9aa41-5\u64cd\u4f5c\u3002<\/li>\n<li>\u5728\u60a8\u7684\u673a\u5668\u4e0a\u5b89\u88c5\u5e76\u8fd0\u884cJupyter notebook\u3002\u5bf9\u4e8e\u8fd0\u884cUbuntu\/Debian\u7684\u8fdc\u7a0b\u670d\u52a1\u5668\uff0c\u8bf7\u9075\u5faa\u300a\u5982\u4f55\u5728\u8fdc\u7a0b\u670d\u52a1\u5668\u4e0a\u5b89\u88c5\u3001\u8fd0\u884c\u548c\u8fde\u63a5Jupyter Notebook\u300b\u3002\u5bf9\u4e8e\u5176\u4ed6\u64cd\u4f5c\u7cfb\u7edf\uff0c\u8bf7\u67e5\u770b\u5b89\u88c5Jupyter\u7684\u5b98\u65b9\u6587\u6863\u3002<\/li>\n<li>\u4e00\u4e2a\u7528\u4e8e\u8bbf\u95eeJupyter Notebook\u7684\u73b0\u4ee3\u7f51\u9875\u6d4f\u89c8\u5668\u3002<\/li>\n<li>\u719f\u6089Python\u57fa\u7840\u77e5\u8bc6\uff0c\u5982for\u5faa\u73af\u3001\u51fd\u6570\u548c\u6570\u636e\u7ed3\u6784\uff08\u7279\u522b\u662f\u5217\u8868\u548c\u5b57\u5178\uff09\u3002<\/li>\n<li>\u5177\u6709\u4f7f\u7528Python pandas\u6a21\u5757\u8fdb\u884c\u6570\u636e\u64cd\u4f5c\u548c\u5206\u6790\u7684\u7ecf\u9a8c\u3002<\/li>\n<\/ul>\n<h2>\u7b2c\u4e00\u6b65 &#8211; \u51c6\u5907\u60a8\u7684Jupyter Notebook\u73af\u5883<\/h2>\n<p>\u5728\u672c\u6559\u7a0b\u4e2d\uff0c\u60a8\u5c06\u4f7f\u7528Jupyter Notebook\u6765\u5904\u7406\u6570\u636e\u3002Jupyter Notebook\u5bf9\u4e8e\u8fed\u4ee3\u5f0f\u7f16\u7801\u975e\u5e38\u6709\u5e2e\u52a9\uff0c\u56e0\u4e3a\u5b83\u5141\u8bb8\u60a8\u7f16\u5199\u4e00\u5c0f\u6bb5\u4ee3\u7801\uff0c\u8fd0\u884c\u5b83\uff0c\u5e76\u8fd4\u56de\u7ed3\u679c\u3002<\/p>\n<p>\u8981\u5728\u60a8\u7684Jupyter Notebook\u4e2d\u8ddf\u968f\u672c\u6559\u7a0b\uff0c\u60a8\u9700\u8981\u6253\u5f00\u4e00\u4e2a\u65b0\u7684\u7b14\u8bb0\u672c\u5e76\u5b89\u88c5\u6240\u9700\u7684\u4f9d\u8d56\u9879\uff0c\u5728\u672c\u6b65\u9aa4\u4e2d\u5c06\u8fdb\u884c\u6b64\u64cd\u4f5c\u3002<\/p>\n<p>\u5728\u5148\u51b3\u6761\u4ef6\u4e2d\uff0c\u60a8\u5728\u670d\u52a1\u5668\u4e0a\u8bbe\u7f6e\u4e86\u4e00\u4e2aJupyter Notebook\u73af\u5883\u3002\u4e00\u65e6\u60a8\u767b\u5f55\u670d\u52a1\u5668\uff0c\u6fc0\u6d3b\u865a\u62df\u73af\u5883\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>\u7136\u540e\u8fd0\u884cJupyter Notebook\u5e94\u7528\u7a0b\u5e8f\u6765\u542f\u52a8\u5e94\u7528\u7a0b\u5e8f\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<div class=\"post-conf-note\">\n<p class=\"post-conf-desc\">\u6ce8\u610f\uff1a\u5982\u679c\u60a8\u5728\u8fdc\u7a0b\u670d\u52a1\u5668\u4e0a\u4f7f\u7528\u672c\u6559\u7a0b\uff0c\u60a8\u53ef\u4ee5\u4f7f\u7528\u7aef\u53e3\u8f6c\u53d1\u6765\u8bbf\u95ee\u672c\u5730\u8ba1\u7b97\u673a\u6d4f\u89c8\u5668\u4e2d\u7684Jupyter Notebook\u3002<\/p>\n<p>\u6253\u5f00\u4e00\u4e2a\u65b0\u7684\u7ec8\u7aef\u5e76\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4\uff1a<\/p>\n<p>ssh -L 8888:localhost:8888 your_non_root_user@your_server_ip<\/p>\n<p>\u8fde\u63a5\u670d\u52a1\u5668\u540e\uff0c\u5bfc\u822a\u5230\u8f93\u51fa\u63d0\u4f9b\u7684\u94fe\u63a5\u4ee5\u8bbf\u95ee\u60a8\u7684Jupyter Notebook\u3002\u5728\u672c\u6559\u7a0b\u7684\u5269\u4f59\u90e8\u5206\u4fdd\u6301\u6b64\u7ec8\u7aef\u5f00\u653e\u3002\u8fd0\u884c\u5e76\u8fde\u63a5\u5230\u5b83\u540e\uff0c\u60a8\u5c06\u8bbf\u95ee\u57fa\u4e8e\u6d4f\u89c8\u5668\u7684\u7528\u6237\u754c\u9762\u3002\u4ece&#8221;\u65b0\u5efa&#8221;\u4e0b\u62c9\u83dc\u5355\u4e2d\uff0c\u9009\u62e9Python3(ipykernel)\u9009\u9879\uff0c\u5c06\u4f1a\u6253\u5f00\u4e00\u4e2a\u65b0\u6807\u7b7e\u9875\uff0c\u5176\u4e2d\u5305\u542b\u4e00\u4e2a\u672a\u547d\u540d\u7684Python\u7b14\u8bb0\u672c\u3002\u7ed9\u60a8\u7684\u6587\u4ef6\u53d6\u4e00\u4e2a\u540d\u79f0\uff1b\u5728\u672c\u6559\u7a0b\u4e2d\uff0c\u6587\u4ef6\u540d\u4e3aconvert_data.ipynb\u3002<\/p>\n<\/div>\n<p>\u7136\u540e\uff0c\u5728\u6d4f\u89c8\u5668\u7684Jupyter\u7b14\u8bb0\u672c\u7684\u7b2c\u4e00\u4e2a\u5355\u5143\u683c\u4e2d\uff0c\u4f7f\u7528pip\u5b89\u88c5\u5fc5\u8981\u7684\u4f9d\u8d56\u9879\u3002<\/p>\n<div>\u8f6c\u6362\u6570\u636e.ipynb<\/div>\n<pre class=\"post-pre\"><code>pip install pandas\r\npip install requests\r\n<\/code><\/pre>\n<p>DataFrame\u6570\u636e\u7ed3\u6784\u53ea\u80fd\u901a\u8fc7pandas\u6a21\u5757\u6765\u8bbf\u95ee\u3002requests\u6a21\u5757\u5e2e\u52a9\u60a8\u83b7\u53d6URL\u8bbf\u95ee\u6743\u9650\u3002<\/p>\n<p>\u5728\u5c06\u547d\u4ee4\u6dfb\u52a0\u5230\u60a8\u7684Jupyter Notebook\u4e4b\u540e\uff0c\u6309\u4e0b\u8fd0\u884c\u6309\u94ae\u6765\u6267\u884c\u5b83\u4eec\u3002<\/p>\n<p>\u4f60\u7684Jupyter\u7b14\u8bb0\u672c\u5c06\u4f1a\u63d0\u4f9b\u4e00\u4e2a\u8fd0\u884c\u8f93\u51fa\u6765\u6307\u793a\u4f9d\u8d56\u9879\u6b63\u5728\u4e0b\u8f7d\u3002\u5728\u6b64\u8f93\u51fa\u4e0b\u65b9\u5c06\u4f1a\u6709\u4e00\u4e2a\u65b0\u7684\u8f93\u5165\u5355\u5143\u683c\uff0c\u4f60\u5c06\u5728\u6b64\u8fd0\u884c\u4e0b\u4e00\u884c\u4ee3\u7801\u3002<\/p>\n<p>\u63a5\u4e0b\u6765\uff0c\u901a\u8fc7\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\u5bfc\u5165\u521a\u521a\u5b89\u88c5\u7684\u6a21\u5757\u3002<\/p>\n<div>\u8f6c\u5316\u6570\u636e.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\u5c06\u4e3a\u60a8\u63d0\u4f9b\u8c03\u7528pandas\u6a21\u5757\u7684\u5feb\u6377\u65b9\u5f0f\u3002\u60a8\u53ea\u9700\u8981\u5199\u4e0bpd\u5373\u53ef\u8c03\u7528pandas\u6a21\u5757\u3002<\/p>\n<p>\u5728\u8fd9\u4e00\u6b65\u9aa4\u4e2d\uff0c\u60a8\u5df2\u7ecf\u51c6\u5907\u597d\u4e86\u60a8\u7684Jupyter Notebook\u73af\u5883\u3002\u63a5\u4e0b\u6765\uff0c\u60a8\u5c06\u6267\u884c\u4e00\u4e9b\u57fa\u672c\u7684\u8f6c\u6362\uff0c\u4ece\u5b57\u5178\u521b\u5efa\u6570\u636e\u5e27\u3002<\/p>\n<h2>\u7b2c\u4e8c\u6b65 \u2014 \u5c06\u6709\u5e8f\u7684API\u6570\u636e\u8f6c\u6362\u4e3apandas DataFrame<\/h2>\n<p>\u5728\u4ece\u65e0\u5e8f\u7684API\u7aef\u70b9\u83b7\u53d6\u6570\u636e\u4e4b\u524d\uff0c\u60a8\u5c06\u9996\u5148\u4ece\u4e0d\u540c\u683c\u5f0f\u7684\u5b57\u5178\u548cURL\u4e0a\u7ec4\u7ec7\u7684API\u6570\u636e\u521b\u5efa\u6570\u636e\u6846\u67b6\u3002<\/p>\n<p>\u5728\u8bb8\u591aAPI\u7aef\u70b9\u4e2d\uff0c\u952e\u901a\u5e38\u8868\u793a\u5217\u540d\uff0c\u800c\u8fd9\u4e9b\u952e\u7684\u503c\u8868\u793a\u5c5e\u4e8e\u76f8\u5e94\u5217\u7684\u5143\u7d20\u3002\u7136\u800c\uff0c\u6709\u4e9bAPI\u7aef\u70b9\u4e0d\u662f\u4ee5\u8fd9\u79cd\u683c\u5f0f\u5448\u73b0\uff0c\u8fd9\u610f\u5473\u7740\u60a8\u9700\u8981\u4e00\u79cd\u65b9\u6cd5\u6765\u63d0\u53d6\u5217\u540d\u53ca\u5176\u76f8\u5e94\u7684\u6570\u636e\uff0c\u4ee5\u521b\u5efa\u4e00\u4e2a\u53ef\u8bfb\u7684\u5b57\u5178\uff0c\u4ece\u5b57\u5178\u4e2d\u53ef\u4ee5\u521b\u5efa\u4e00\u4e2apandas DataFrame\u3002\u56de\u987e\u4e00\u4e9b\u5c06\u4f20\u7edfAPI\u7aef\u70b9\u8f6c\u6362\u4e3apandas DataFrame\u7684\u5e38\u89c1\u65b9\u6cd5\u5c06\u6709\u52a9\u4e8e\u60a8\u5b8c\u6210\u6b64\u4efb\u52a1\u3002<\/p>\n<p>\u5728\u8fd9\u4e00\u6b65\u9aa4\u4e2d\uff0c\u60a8\u5c06\u4f7f\u7528\u4e00\u4e9b\u5e38\u89c1\u7684\u65b9\u6cd5\u4ece\u4e0d\u540c\u683c\u5f0f\u7684\u5b57\u5178\u521b\u5efa\u6570\u636e\u5e27\u3002<\/p>\n<h3>\u65b9\u6cd51 &#8211; \u4ece\u5b57\u5178\u5217\u8868\u521b\u5efa\u6570\u636e\u6846<\/h3>\n<p>\u5728\u8fd9\u79cd\u65b9\u6cd5\u4e2d\uff0c\u5217\u8868\u4e2d\u7684\u6bcf\u4e2a\u5b57\u5178\u90fd\u4ee3\u8868\u6700\u7ec8DataFrame\u4e2d\u7684\u4e00\u884c\u6570\u636e\u3002DataFrame\u7684\u7ed3\u6784\u5c06\u5305\u542b\u4ee3\u8868\u5217\u540d\u7684\u952e\uff0c\u4ee5\u53ca\u5c5e\u4e8e\u8be5\u5217\u7684\u5143\u7d20\u7684\u503c\u3002<\/p>\n<p>\u4f7f\u7528\u8fd9\u79cd\u65b9\u6cd5\uff0c\u60a8\u5c06\u521b\u5efa\u4e00\u4e2a\u5177\u6709\u5e74\u9f84\u3001ID\u548c\u59d3\u540d\u5217\u4ee5\u53ca\u4e09\u4e2a\u4eba\u7684\u4fe1\u606f\u7684DataFrame\u3002<\/p>\n<p>\u5728\u4e00\u4e2a\u65b0\u7684\u5355\u5143\u683c\u4e2d\uff0c\u8fd0\u884c\u4ee5\u4e0b\u4ee3\u7801\u6765\u683c\u5f0f\u5316\u5206\u914d\u7ed9\u53d8\u91cfdict1\u7684\u5b57\u5178\u5217\u8868\uff08\u53ef\u4ee5\u968f\u610f\u7528\u60a8\u81ea\u5df1\u7684\u540d\u79f0\u66ff\u6362\uff09\u3002<\/p>\n<div>\u8f6c\u6362\u6570\u636e.ipynb<\/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>\u60a8\u5c06\u4e00\u4e2a\u5b57\u5178\u5217\u8868\u5206\u914d\u7ed9dict1\u53d8\u91cf\u3002\u5217\u8868\u4e2d\u7684\u6bcf\u4e2a\u5b57\u5178\u8868\u793a\u7ed3\u679cDataFrame\u7684\u4e00\u884c\u3002\u952eAge\u3001ID\u548cName\u4ee3\u8868\u5217\u540d\u3002\u5206\u914d\u7ed9\u6bcf\u4e2a\u952e\u7684\u503c\u8868\u793a\u8be5\u884c\u4e2d\u8be5\u5217\u7684\u503c\u3002\u7136\u540e\uff0c\u60a8\u5c06\u8be5\u5b57\u5178\u4f20\u9012\u7ed9pandas\u6a21\u5757\u4ee5\u521b\u5efaDataFrame\u3002<\/p>\n<p>\u4ee5\u4e0bDataFrame\u5c06\u88ab\u6253\u5370\u51fa\u6765\uff1a<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"\u8f93\u51fa\">\u8f93\u51fa<\/p>\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<\/div>\n<p>\u8fd9\u4e2aDataFrame\u662f\u4ece\u5b57\u5178\u5217\u8868\u521b\u5efa\u7684\u3002dict1\u5217\u8868\u4e2d\u6bcf\u4e2a\u5b57\u5178\u4e2d\u5b9a\u4e49\u7684\u952e\u662f\u6240\u83b7\u5f97\u7684DataFrame\u4e2d\u7684\u5217\u540d\uff0c\u800c\u8fd9\u4e9b\u5b57\u5178\u4e2d\u7684\u503c\u8868\u793a\u9010\u884c\u7684\u6570\u636e\u3002<\/p>\n<h3>\u65b9\u6cd52\u2014\u2014\u4ece\u5355\u4e2a\u5b57\u5178\u521b\u5efa\u6570\u636e\u6846<\/h3>\n<p>\u5728\u4e4b\u524d\u7684\u65b9\u6cd5\u4e2d\uff0c\u60a8\u662f\u6839\u636e\u884c\u5b9a\u4e49\u6570\u636e\uff0c\u8fd9\u4f1a\u5bfc\u81f4\u5728\u4e00\u4e2a\u5217\u8868\u4e2d\u8f93\u5165\u591a\u4e2a\u5b57\u5178\u3002\u6bcf\u4e2a\u5b57\u5178\u8868\u793a\u6309\u884c\u6392\u5217\u7684\u6570\u636e\uff0c\u5176\u4e2d\u952e\u662f\u5217\u540d\uff0c\u503c\u662f\u5c5e\u4e8e\u8be5\u5217\u7684\u5143\u7d20\u3002<\/p>\n<p>\u73b0\u5728\uff0c\u60a8\u5c06\u4ee5\u6309\u5217\u7684\u65b9\u5f0f\u5b9a\u4e49\u6570\u636e\u3002\u8fd9\u4e00\u6b21\uff0c\u60a8\u5c06\u4f7f\u7528\u4e00\u4e2a\u5b57\u5178\uff0c\u5176\u4e2d\u952e\u8868\u793a\u5217\u540d\uff0c\u503c\u662f\u4ee3\u8868\u8be5\u5217\u5782\u76f4\u6570\u636e\u7684\u5217\u8868\u3002<\/p>\n<p>\u4f7f\u7528\u8fd9\u79cd\u65b9\u6cd5\uff0c\u60a8\u53ef\u4ee5\u4f7f\u7528\u5728\u524d\u9762\u90e8\u5206\u4e2d\u4f7f\u7528\u8fc7\u7684\u76f8\u540c\u6570\u636e\u3002\u5728\u4e00\u4e2a\u65b0\u7684\u5355\u5143\u683c\u4e2d\u8fd0\u884c\u4ee5\u4e0b\u884c\uff1a<\/p>\n<p>\u5c06convert_data.ipynb\u8f6c\u6362\u4e3a\u6570\u636e\u3002<\/p>\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>\u5728\u8fd9\u91cc\uff0c\u60a8\u4f7f\u7528\u4e00\u4e2a\u5b57\u5178\u6765\u5b9a\u4e49\u9010\u5217\u7684\u6570\u636e\u3002dict2\u5b57\u5178\u7684\u952e\u662f\u5217\u540d\uff1aAge\u3001ID\u548cName\u3002\u6bcf\u4e2a\u952e\u7684\u503c\u662f\u4e00\u4e2a\u5217\u8868\uff0c\u8868\u793a\u6bcf\u5217\u7684\u6570\u636e\u3002<\/p>\n<p>\u4e0b\u9762\u7684DataFrame\u5c06\u4f1a\u6253\u5370\u5230\u5c4f\u5e55\u4e0a\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"\u8f93\u51fa\">\u8f93\u51fa<\/p>\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<\/div>\n<p>dict2\u5b57\u5178\u7684\u952e\u4ee3\u8868\u5217\u540d\uff08Age\u3001ID\u548cName\uff09\uff0c\u6bcf\u5217\u90fd\u586b\u5145\u4e86\u60a8\u5b9a\u4e49\u7684\u5217\u8868\u4f5c\u4e3a\u8be5\u952e\u7684\u503c\u3002\u4f8b\u5982\uff0cAge\u5217\u7684\u503c\u662f41\u300124\u548c26\u3002<\/p>\n<p>\u679c\u4e0d\u5176\u7136\uff0c\u4e24\u79cd\u65b9\u6cd5\u4ea7\u751f\u4e86\u76f8\u540c\u7684\u7ed3\u679c\u3002\u867d\u7136\u524d\u4e24\u79cd\u65b9\u6cd5\u7684\u8f93\u51fa\u76f8\u540c\uff0c\u4f46\u60a8\u53ef\u4ee5\u540c\u65f6\u4f7f\u7528\u6309\u884c\u548c\u6309\u5217\u7684\u65b9\u6cd5\u6765\u521b\u5efa\u4e00\u4e2aDataFrame\u3002<\/p>\n<h3>\u65b9\u6cd53 \u2014 \u901a\u8fc7URL\u521b\u5efa\u5305\u542bAPI\u6570\u636e\u7684DataFrame<\/h3>\n<h2>\u7b2c\u4e09\u90e8\u5206 \u2014 \u4eceAPI\u7aef\u70b9\u83b7\u53d6\u6570\u636e\u5e76\u521b\u5efaDataFrame<\/h2>\n<p>\u5728\u8fd9\u79cd\u65b9\u6cd5\u4e2d\uff0c\u60a8\u5c06\u4f7f\u7528\u4eceURL\u63d0\u53d6\u7684API\u6570\u636e\u521b\u5efa\u4e00\u4e2aDataFrame\u3002\u5728\u4e0eAPI\u76f8\u5173\u7684URL\u4e2d\uff0c\u6570\u636e\u901a\u5e38\u4ee5\u5b57\u5178\u5217\u8868\u7684\u5f62\u5f0f\u5448\u73b0\uff0c\u7c7b\u4f3c\u4e8e\u65b9\u6cd5\u4e00\u4e2d\u4f7f\u7528\u7684\u6570\u636e\u3002\u4f46\u662f\uff0c\u60a8\u4e0d\u4f1a\u786c\u7f16\u7801\u6570\u636e\uff0c\u800c\u662f\u4f7f\u7528requests\u6a21\u5757\u8bbf\u95eeURL\u4e0a\u7684API\u6570\u636e\uff0c\u8be5\u6a21\u5757\u53ef\u4ee5\u5e2e\u52a9\u60a8\u8bbf\u95eeURL\u3002<\/p>\n<p>\u5bf9\u4e8e\u8fd9\u79cd\u65b9\u6cd5\uff0c\u4f60\u5c06\u4f7f\u7528\u4e00\u4e2aJSON API\u7684URL\uff1a<strong>\u56fd\u5bb6\u4e0e\u9996\u90fd\u5217\u8868<\/strong>\uff0c\u5b83\u4ee5API\u683c\u5f0f\u5c55\u793a\u4e86\u4e00\u4e2a\u56fd\u5bb6\u548c\u5176\u9996\u90fd\u7684\u5217\u8868\u3002\u8981\u67e5\u770b\u8fd9\u4e2aAPI\uff0c\u8bf7\u5728\u6d4f\u89c8\u5668\u4e2d\u8bbf\u95ee\u4ee5\u4e0bURL\u3002<\/p>\n<pre class=\"post-pre\"><code>https:\/\/raw.githubusercontent.com\/dariusk\/corpora\/master\/data\/geography\/countries_with_capitals.json<\/code><\/pre>\n<p>\u8fd9\u91cc\u662f\u7531URL\u63d0\u4f9b\u7684API\u6570\u636e\u7684\u8d77\u59cb\u90e8\u5206\u3002<\/p>\n<div class=\"code-block\">\n<p class=\"code-title\">\u56fd\u5bb6\u4e0e\u9996\u90fd\u5217\u8868\uff08\u4ece\u56fd\u5bb6\u4e0e\u9996\u90fdURL\u7684API\u6570\u636e\uff09<\/p>\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<\/div>\n<p>API\u4ee5\u4e00\u79cd\u53ef\u8bc6\u522b\u7684\u683c\u5f0f\u8fdb\u884c\u5c55\u793a\uff1a\u5916\u90e8\u5b57\u5178\u4e2d\u7684\u56fd\u5bb6\u952e\u5305\u542b\u4e00\u4e2a\u5b57\u5178\u5217\u8868\uff0cname\u548ccapital\u662f\u5217\u540d\uff0c\u5b83\u4eec\u7684\u5bf9\u5e94\u503c\u662f\u6309\u884c\u6392\u5217\u7684\u6570\u636e\u3002<\/p>\n<p>\u8981\u4ece\u6b64URL\u521b\u5efa\u4e00\u4e2apandas DataFrame\uff0c\u8bf7\u5728\u65b0\u5355\u5143\u683c\u4e2d\u8fd0\u884c\u4ee5\u4e0b\u4ee3\u7801\u3002<\/p>\n<div class=\"code-block\">\n<p class=\"code-title\">\u8f6c\u6362\u6570\u636e.ipynb<\/p>\n<pre class=\"post-pre\"><code>response = requests.get('https:\/\/raw.githubusercontent.com\/dariusk\/corpora\/master\/data\/geography\/countries_with_capitals.json').json()\r\n\r\ndf1 = pd.DataFrame(response['countries'])\r\n\r\ndf1.head()<\/code><\/pre>\n<\/div>\n<p>requests\u6a21\u5757\u5141\u8bb8\u60a8\u8bbf\u95eeURL\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u60a8\u5c06URL\u8bfb\u53d6\u4e3aJSON\u6587\u4ef6\uff0c\u5e76\u5c06\u8bfb\u53d6\u7684\u6570\u636e\u8d4b\u7ed9\u53d8\u91cfresponse\u3002\u63a5\u4e0b\u6765\uff0c\u60a8\u5c06\u8fd9\u4e2a\u5b57\u5178\u5217\u8868\uff08\u4f5c\u4e3acountries\u952e\u7684\u503c\u63d0\u4f9b\uff09\u5448\u73b0\u7ed9pandas\uff0cpandas\u518d\u63d0\u4f9b\u4e00\u4e2aDataFrame\u3002\u6210\u529f\u4ece\u7ed9\u5b9aAPI\u7aef\u70b9\u63d0\u53d6\u6570\u636e\u540e\uff0cdf1\u5c06\u662f\u6240\u83b7\u5f97\u7684DataFrame\u3002<\/p>\n<p>\u8fd0\u884c\u4e0a\u8ff0\u4ee3\u7801\u540e\uff0c\u4f60\u5c06\u4f1a\u5f97\u5230\u4ee5\u4e0b\u7684DataFrame\uff1a<\/p>\n<div class=\"code-block\">\n<p class=\"code-title\">\u8f93\u51fa\u7ed3\u679c<\/p>\n<pre class=\"post-pre\"><code>        name                capital\r\n0  Afghanistan                 Kabul\r\n1      Albania                Tirana\r\n2      Algeria               Algiers\r\n3      Andorra      Andorra la Vella\r\n4       Angola                Luanda<\/code><\/pre>\n<\/div>\n<p>\u8fd9\u662f\u5728\u5c06\u56fd\u5bb6\u548c\u9996\u90fd\u5217\u8868\u4f20\u9012\u7ed9pandas DataFrame\u540e\u83b7\u5f97\u7684\u6570\u636e\u8868\u3002\u5f53\u4f60\u8fd0\u884c\u8fd9\u6bb5\u4ee3\u7801\u65f6\uff0c\u4f60\u5c06\u5b57\u5178\u5217\u8868\uff08\u4f5c\u4e3a\u56fd\u5bb6\u952e\u7684\u503c\uff09\u4f20\u9012\u7ed9\u4e86pandas DataFrame\u6a21\u5757\u3002\u5217\u540d\u4e3aname\u548ccapital\uff0c\u56e0\u4e3a\u5b83\u4eec\u5728\u5217\u8868\u4e2d\u7684\u6bcf\u4e2a\u5b57\u5178\u4e2d\u90fd\u4f5c\u4e3a\u952e\u5b58\u5728\uff0c\u5b83\u4eec\u7684\u503c\u4ee3\u8868\u9010\u884c\u7684\u6570\u636e\uff08\u56e0\u4e3a\u6bcf\u4e2a\u5b57\u5178\u4ee3\u8868\u4e00\u884c\uff09\u3002<\/p>\n<p>\u5230\u76ee\u524d\u4e3a\u6b62\uff0c\u60a8\u5df2\u7ecf\u4ece\u57fa\u672c\u5b57\u5178\u548c\u7ed3\u6784\u5316API\u7aef\u70b9\u521b\u5efa\u4e86DataFrame\u3002\u5f53\u5904\u7406\u5305\u542b\u7ed3\u6784\u5316API\u7684URL\u65f6\uff0c\u6570\u636e\u901a\u5e38\u4ee5\u65b9\u6cd51\u4e2d\u4f7f\u7528\u7684\u683c\u5f0f\u5448\u73b0\uff1a\u4f5c\u4e3a\u4e00\u4e2a\u5b57\u5178\u7684\u5217\u8868\uff0c\u5176\u4e2d\u6bcf\u4e2a\u5b57\u5178\u8868\u793a\u9010\u884c\u7684\u6570\u636e\u3002\u5728API\u6570\u636e\u662f\u975e\u7ed3\u6784\u5316\u7684\u60c5\u51b5\u4e0b\uff0c\u60a8\u53ef\u4ee5\u4f7f\u7528\u7b2c1\u6216\u7b2c2\u79cd\u65b9\u6cd5\u7684\u683c\u5f0f\u6309\u884c\u6216\u6309\u5217\u63d0\u53d6\u5217\u540d\u548c\u5b83\u4eec\u7684\u6570\u636e\u3002\u5728\u4e0b\u4e00\u6b65\u4e2d\uff0c\u60a8\u5c06\u7ed3\u5408\u6765\u81ea\u6b64\u6b65\u9aa4\u7684\u4e00\u4e9b\u7b56\u7565\uff0c\u4ece\u975e\u7ed3\u6784\u5316\u7684API\u7aef\u70b9\u83b7\u53d6\u6570\u636e\u3002<\/p>\n<h2>\u7b2c\u4e09\u6b65 \u2014 \u5c06\u65e0\u5e8f\u7684API\u6570\u636e\u8f6c\u6362\u4e3apandas DataFrame<\/h2>\n<p>\u76f4\u5230\u73b0\u5728\uff0c\u60a8\u5df2\u7ecf\u4f7f\u7528\u591a\u79cd\u65b9\u6cd5\u5c06\u6709\u5e8f\u6570\u636e\u8f6c\u6362\u4e3apandas Dataframe\u3002\u73b0\u5728\uff0c\u60a8\u5c06\u4f7f\u7528\u4e0d\u540c\u683c\u5f0f\u7684\u6570\u636e\u8fdb\u884c\u5904\u7406\u3002\u8fd9\u4e2a\u65b0URL\u4e2d\u7684API\u6570\u636e\u4e0d\u662f\u5e38\u89c4\u683c\u5f0f\uff0c\u56e0\u6b64\u5f88\u96be\u786e\u5b9a\u5217\u540d\u548c\u5b83\u4eec\u7684\u6570\u636e\u3002<\/p>\n<p>\u60a8\u9700\u8981\u91c7\u53d6\u989d\u5916\u7684\u6b65\u9aa4\u6765\u4ece\u65e0\u5e8f\u6570\u636e\u4e2d\u521b\u5efaDataFrame\u3002\u9996\u5148\uff0c\u60a8\u9700\u63d0\u53d6\u5217\u540d\u548c\u6240\u6709\u5217\u7684\u503c\uff0c\u7136\u540e\u5c06\u5217\u540d\u5b9a\u4e49\u4e3a\u5b57\u5178\u4e2d\u7684\u952e\uff0c\u5c06\u5217\u5143\u7d20\uff08\u4ee5\u5217\u8868\u5f62\u5f0f\uff09\u5b9a\u4e49\u4e3a\u5b57\u5178\u4e2d\u7684\u503c\u3002\u6700\u7ec8\uff0c\u60a8\u5c06\u83b7\u5f97\u4e00\u4e2a\u53ef\u5c55\u793a\u7684\u5b57\u5178\uff0c\u7c7b\u4f3c\u4e8e\u65b9\u6cd52\u6240\u4f7f\u7528\u7684\u683c\u5f0f\uff0c\u5e76\u5c06\u5176\u63d0\u4ea4\u7ed9pandas\u4ee5\u8f6c\u6362\u4e3aDataFrame\u3002<\/p>\n<p>\u8fd9\u4e2a\u6b65\u9aa4\u4f7f\u7528\u6765\u81ea\u7ebd\u7ea6\u5b66\u6821\u4eba\u53e3\u7edf\u8ba1\u548c\u95ee\u8d23\u5feb\u7167\u7684\u6570\u636e\u3002<\/p>\n<h3>\u8ffd\u8e2aAPI\u7aef\u70b9\u4e2d\u7684\u5217\u540d<\/h3>\n<p>\u5728\u672c\u8282\u4e2d\uff0c\u60a8\u5c06\u8ddf\u8e2a\u4e0eAPI\u7aef\u70b9\u4e2d\u5305\u542b\u7684\u6570\u636e\u5217\u76f8\u5173\u7684\u4fe1\u606f\u3002<\/p>\n<p>\u8981\u8bbf\u95ee\u6837\u672c\u6570\u636e\uff0c\u8bf7\u4f7f\u7528\u60a8\u9009\u62e9\u7684\u7f51\u7edc\u6d4f\u89c8\u5668\u6253\u5f00\u6b64\u7f51\u5740\u3002<\/p>\n<pre class=\"post-pre\"><code>https:\/\/data.cityofnewyork.us\/api\/views\/ihfw-zy9j\/rows.json<\/code><\/pre>\n<p>\u8fd9\u4e2aURL\u4e2d\u7684\u6570\u636e\u6bd4\u4f60\u5728\u7b2c\u4e8c\u6b65\u4e2d\u5904\u7406\u7684\u6570\u636e\u66f4\u4e0d\u6613\u5c55\u793a\u3002\u7ebd\u7ea6\u5feb\u7167\u6570\u636e\u5448\u73b0\u4e86\u5404\u79cd\u5f62\u5f0f\u7684\u5b57\u5178\uff0c\u4f46\u5b83\u4eec\u5e76\u4e0d\u662f\u4ee5\u952e\u4ee3\u8868\u5217\u540d\uff0c\u503c\u4ee3\u8868\u5217\u5143\u7d20\u7684\u5b57\u5178\u3002\u4f3c\u4e4e\u6ca1\u6709\u4ee5\u884c\u6216\u5217\u65b9\u5f0f\u5448\u73b0\u6570\u636e\u7684\u7b80\u5355\u5b57\u5178\u3002<\/p>\n<p>\u60a8\u5c06\u901a\u8fc7\u67e5\u627e\u4e0eDataFrame\u76f8\u5173\u7684\u5217\u4fe1\u606f\u6765\u5f00\u59cb\u3002\u5728\u6d4f\u89c8\u5668\u4e2d\u8bbf\u95eeAPI\u7f51\u5740\u65f6\uff0c\u6309\u4e0bCTRL+F\u5e76\u641c\u7d22&#8221;columns:&#8221;\u3002<\/p>\n<div class=\"code-block\">\n<p class=\"code-title\">\u680f\u76ee\u677f\u5757\uff08\u6765\u81ea\u7ebd\u7ea6\u5b66\u6821\u5feb\u7167\u7f51\u5740\u7684API\u6570\u636e\uff09<\/p>\n<pre class=\"post-pre\"><code>...\r\n\"columns\" : [ {\r\n        \"id\" : -1,\r\n        \"name\" : \"sid\",\r\n        \"dataTypeName\" : \"meta_data\",\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        \"dataTypeName\" : \"meta_data\",\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        \"dataTypeName\" : \"meta_data\",\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<\/div>\n<p>\u5728\u5217\u952e\u7684\u503c\u5217\u8868\u4e2d\u6709\u51e0\u4e2a\u5b57\u5178\u3002\u5728\u6bcf\u4e2a\u5b57\u5178\u4e2d\uff0c\u6ce8\u610fdataTypeName\u952e\u7684\u503c\u3002\u5bf9\u4e8e\u524d\u516b\u4e2a\u5b57\u5178\uff0cdataTypeName\u952e\u7684\u503c\u662f\u5143\u6570\u636e\u3002\u5143\u6570\u636e\u662f\u63cf\u8ff0\u6570\u636e\u7684\u6570\u636e\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u5143\u6570\u636e\u4e0d\u662f\u8868\u683c\u5185\u5305\u542b\u7684\u6570\u636e\uff0c\u800c\u662f\u63cf\u8ff0\u6574\u4e2a\u8868\u683c\u7684\u6570\u636e\u3002\u56e0\u6b64\uff0c\u5177\u6709dataTypeName\u952e\u503c\u4e3a\u5143\u6570\u636e\u7684\u8fd9\u516b\u4e2a\u5b57\u5178\u4e0d\u4ee3\u8868\u8868\u683c\u4e2d\u5b58\u5728\u7684\u5217\u7684\u4fe1\u606f\u3002<\/p>\n<p>\u7136\u800c\uff0c\u5f53\u60a8\u7ee7\u7eed\u9605\u8bfb\u6b64\u5217\u8868\u65f6\uff0c\u8bf7\u6ce8\u610f\u7b2c\u4e00\u4e2adataTypeName\u952e\u7684\u51fa\u73b0\uff0c\u5176\u503c\u4e0d\u662fmeta_data\u3002<\/p>\n<div class=\"code-block\">\n<p class=\"code-title\">\u680f\u76ee\u90e8\u5206\uff08\u6765\u81ea\u7ebd\u7ea6\u5b66\u6821\u5feb\u7167 URL \u7684 API \u6570\u636e\uff09<\/p>\n<\/div>\n<pre class=\"post-pre\"><code>...\\n}, {\\n       \"id\" : -1,\\n       \"name\" : \"meta\",\\n       <mark>\"dataTypeName\" : \"meta_data\",<\/mark>\\n       \"fieldName\" : \":meta\",\\n       \"position\" : 0,\\n       \"renderTypeName\" : \"meta_data\",\\n       \"format\" : { },\\n       \"flags\" : [ \"hidden\" ]\\n     }, {\\n       <mark>\"id\" : 45985351,<\/mark>\\n       <mark>\"name\" : \"DBN\",<\/mark>\\n       <mark>\"dataTypeName\" : \"text\",<\/mark>\\n       \"fieldName\" : \"dbn\",\\n       \"position\" : 1,\\n       \"renderTypeName\" : \"text\",\\n       \"tableColumnId\" : 8032537,\\n       \"cachedContents\" : {\\n         \"non_null\" : \"10075\",\\n...\\n<\/code><\/pre>\n<p>\\n<\/p>\n<p>id\u503c\u4e3a45985351\u7684\u5b57\u5178\u662f\u7b2c\u4e00\u4e2a\u4e0d\u5c06&#8221;meta_data&#8221;\u4f5c\u4e3a&#8221;dataTypeName&#8221;\u952e\u7684\u503c\u7684\u5b57\u5178\u3002\u76f8\u53cd\uff0c\u5176\u503c\u4e3a&#8221;text&#8221;\u3002\u8be5\u5b57\u5178\u63cf\u8ff0\u4e86\u60a8\u6700\u7ec8\u6570\u636e\u96c6\u7684\u7b2c\u4e00\u5217\u4fe1\u606f\u3002\u8be5\u5217\u7684\u5143\u7d20\u4ee5\u6587\u672c\u683c\u5f0f\uff08\u4e5f\u5c31\u662f\u5b57\u7b26\u4e32\uff09\u5448\u73b0\u3002\u8be5\u7b2c\u4e00\u4e2a\u5b57\u5178\u7684&#8221;name&#8221;\u952e\u5177\u6709&#8221;DBN&#8221;\u503c\uff0c\u8868\u793a&#8221;DBN&#8221;\u662f\u60a8\u7684\u7b2c\u4e00\u5217\u7684\u540d\u79f0\u3002\u5728\u6b64\u5b57\u5178\u4e4b\u540e\u7684\u6240\u6709\u5b57\u5178\uff08\u5728&#8221;columns&#8221;\u952e\u4e2d\uff09\u90fd\u4e0d\u4f1a\u5c06&#8221;meta_data&#8221;\u4f5c\u4e3a\u4ed6\u4eec\u7684&#8221;dataTypeName&#8221;\u952e\u7684\u503c\uff0c\u8868\u660e\u6240\u6709\u8fd9\u4e9b\u5b57\u5178\u90fd\u4ee3\u8868DataFrame\u7684\u4e0b\u4e00\u5217\u7684\u4fe1\u606f\u3002<\/p>\n<p>\\n\\n<\/p>\n<p>\u73b0\u5728\u4f60\u5df2\u7ecf\u5bf9\u4e8e\u5728\u54ea\u91cc\u627e\u5230\u6709\u5173\u8868\u683c\u5217\u7684\u4fe1\u606f\u6709\u4e86\u57fa\u672c\u7684\u4e86\u89e3\uff0c\u63a5\u4e0b\u6765\u4f60\u5c06\u4f1a\u83b7\u53d6\u8fd9\u4e9b\u5217\u7684\u540d\u79f0\u3002<\/p>\n<p>\\n\\n<\/p>\n<h3>\u627e\u5230\u5217\u540d<\/h3>\n<p>\\n<\/p>\n<p>\u5728\u8fd9\u4e2a\u90e8\u5206\uff0c\u4f60\u5c06\u628aAPI\u7aef\u70b9\u4e2d\u6240\u6709\u5217\u7684\u540d\u79f0\u6dfb\u52a0\u5230\u4e00\u4e2a\u540d\u4e3a&#8221;columns&#8221;\u7684\u5217\u8868\u4e2d\u3002\u5c06\u4ee5\u4e0b\u4ee3\u7801\u884c\u6dfb\u52a0\u5230Jupyter Notebook\u7684\u65b0\u5355\u5143\u683c\u4e2d\uff0c\u7136\u540e\u8fd0\u884c\u8be5\u5355\u5143\u683c\u3002<\/p>\n<p>\\n<\/p>\n<div>\u8f6c\u6362\u6570\u636e.ipynb<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\\n<\/p>\n<ol>\\n\\t<\/p>\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<p>\\n\\t<\/p>\n<li data-prefix=\"2\"><\/li>\n<p>\\n\\t<\/p>\n<li data-prefix=\"3\">columns<span class=\"token operator\">=<\/span><span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><\/li>\n<p>\\n\\t<\/p>\n<li data-prefix=\"4\"><\/li>\n<p>\\n\\t<\/p>\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<p>\\n\\t<\/p>\n<li data-prefix=\"6\"><\/li>\n<p>\\n\\t<\/p>\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<p>\\n\\t<\/p>\n<li data-prefix=\"8\"><\/li>\n<p>\\n\\t<\/p>\n<li data-prefix=\"9\"><span class=\"token keyword\">continue<\/span><\/li>\n<p>\\n\\t<\/p>\n<li data-prefix=\"10\"><span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span><\/li>\n<p>\\n\\t<\/p>\n<li data-prefix=\"11\"><\/li>\n<p>\\n\\t<\/p>\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<p>\\n<\/ol>\n<p>\\n<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\\n&nbsp;\\n<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\\n<\/p>\n<p>\u4e0e\u60a8\u5728\u7b2c2\u6b65\u4e2d\u7684\u65b9\u6cd53\u7c7b\u4f3c\uff0c\u60a8\u5c06\u901a\u8fc7\u8bf7\u6c42\u6a21\u5757\u8bfb\u53d6\u6b64URL\u4e2d\u7684\u6570\u636e\uff0c\u5e76\u5c06\u5176\u8d4b\u503c\u7ed9\u4e00\u4e2a\u540d\u4e3aresponse\u7684\u53d8\u91cf\u3002<\/p>\n<p>\\n\\n<\/p>\n<p>\u5728\u7b2c\u4e09\u884c\uff0c\u4f60\u5b9a\u4e49\u4e86\u5217\u5217\u8868\u3002\u5728\u7b2c\u4e94\u884c\uff0c\u4f60\u5b9a\u4e49\u4e86\u89c6\u56fe\u952e\u503c\u4e2d\u7684\u5217\u952e\uff0c\u800c\u8fd9\u4e2a\u89c6\u56fe\u952e\u662f\u5728\u5143\u952e\u7684\u503c\u4e2d\u5b9a\u4e49\u7684\u3002<\/p>\n<p>\\n\\n<\/p>\n<p>for\u5faa\u73af\u904d\u5386\u4e0e&#8221;columns&#8221;\u952e\u76f8\u5173\u8054\u7684\u5217\u8868\u4e2d\u7684\u6bcf\u4e2a\u5b57\u5178\uff0c\u5e76\u68c0\u67e5\u8fd9\u4e9b\u5b57\u5178\u7684&#8221;dataTypeName&#8221;\u952e\u7684\u503c\u3002\u5982\u679c\u5f53\u524d\u5b57\u5178\u7684&#8221;dataTypeName&#8221;\u952e\u7684\u503c\u7b49\u4e8e&#8221;meta_data&#8221;\uff0c\u90a3\u4e48\u4f60\u8df3\u8fc7\u4e0b\u4e00\u4e2a\u5b57\u5178\u3002\u5982\u679c\u4e0d\u662f\uff0c\u5219\u5c06&#8221;name&#8221;\u952e\u7684\u503c\u9644\u52a0\u5230columns\u5217\u8868\u4e2d\u3002<\/p>\n<p>\\n\\n<\/p>\n<p>\u63a5\u4e0b\u6765\uff0c\u68c0\u67e5\u5217\u5217\u8868\u7684\u5185\u5bb9\u3002\u5728\u65b0\u7684\u5355\u5143\u683c\u4e2d\u8fd0\u884c\u4ee5\u4e0b\u4ee3\u7801\u884c\uff1a<\/p>\n<p>\\n<\/p>\n<div>\u5c06\u6570\u636e\u8f6c\u6362\u4e3a.ipynb\u683c\u5f0f<\/p>\n<pre class=\"post-pre\"><code>columns\\n<\/code><\/pre>\n<p>\\n<\/p>\n<p>\u5217\u540d\u5c06\u88ab\u6253\u5370\u5230\u5c4f\u5e55\u4e0a\u3002<\/p>\n<p>\\n<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\\n<\/p>\n<div class=\"secondary-code-label\" title=\"Output\">\u8f93\u51fa<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\\n[&#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_num&#8217;]\\n<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\\n<\/p>\n<p>\u8f93\u51fa\u7ed3\u679c\u786e\u8ba4\uff0c\u4efb\u4f55\u6570\u636e\u7c7b\u578b\u540d\u79f0\u975e\u5143\u6570\u636e\u7684\u5217\u90fd\u5df2\u6dfb\u52a0\u5230\u5217\u5217\u8868\u4e2d\u3002<\/p>\n<p>\\n\\n<\/p>\n<p>\u5728\u8fd9\u4e00\u90e8\u5206\u4e2d\uff0c\u60a8\u83b7\u5f97\u4e86\u65e0\u5e8fAPI\u7aef\u70b9\u4e2d\u5217\u540d\u7684\u5217\u8868\uff0c\u60a8\u9700\u8981\u7528\u5b83\u4eec\u6765\u521b\u5efa\u6700\u7ec8\u7684DataFrame\u3002\u63a5\u4e0b\u6765\uff0c\u60a8\u5c06\u63d0\u53d6\u5c5e\u4e8e\u5217\u5217\u8868\u4e2d\u5b9a\u4e49\u7684\u5217\u7684\u6570\u636e\u3002<\/p>\n<p>\\n\\n<\/p>\n<h3>\u5b9a\u4e49\u4e00\u4e2a\u5305\u542bn\u4e2a\u5b50\u5217\u8868\u7684\u5217\u8868<\/h3>\n<p>\\n<\/p>\n<p>\u5728\u8fd9\u4e00\u90e8\u5206\uff0c\u4f60\u5c06\u786e\u5b9aAPI\u4e2d\u7684\u5217\u6570\uff0c\u5e76\u4e3a\u8be5\u6570\u91cf\u5b9a\u4e49\u4e00\u4e2a\u76f8\u5e94\u7684\u5b50\u5217\u8868\u3002<\/p>\n<p>\\n\\n<\/p>\n<p>\u6700\u7ec8\uff0c\u60a8\u5728\u7b2c\u4e8c\u6b65\u4e2d\u4f7f\u7528\u65b9\u6cd52\uff0c\u4ece\u4e00\u4e2a\u5b57\u5178\u4e2d\u83b7\u53d6pandas DataFrame\u3002\u5b57\u5178\u7684\u952e\u8868\u793a\u5217\u540d\uff0c\u800c\u8fd9\u4e9b\u952e\u7684\u503c\u662f\u4ee3\u8868\u5404\u5217\u5143\u7d20\u7684\u5217\u8868\u3002\u5728\u786e\u5b9aAPI\u4e2d\u7684\u5217\u6570\u540e\uff0c\u60a8\u5c06\u5b9a\u4e49\u4e00\u4e2a\u5305\u542b\u76f8\u540c\u5217\u6570\u7684\u5b50\u5217\u8868\u7684\u5217\u8868\uff0c\u6bcf\u4e2a\u5b50\u5217\u8868\u5305\u542b\u76f8\u5e94\u5217\u7684\u6570\u636e\u3002<\/p>\n<p>\\n\\n<\/p>\n<p>\u4e00\u65e6\u4f7f\u7528\u8fd9\u4e2a\u64cd\u4f5c\u5b9a\u4e49\u4e86\u4e00\u4e2a\u5b57\u5178\uff0c\u4f60\u5c31\u53ef\u4ee5\u901a\u8fc7\u5faa\u73af\u904d\u5386\u5217\u5217\u8868\u548c\u5b50\u5217\u8868\u7684\u65b9\u5f0f\u52a8\u6001\u5730\u5411\u5b57\u5178\u4e2d\u6dfb\u52a0\u5185\u5bb9\u3002\u4f8b\u5982\uff0c\u7d22\u5f15\u4e3a0\u7684\u5b50\u5217\u8868\u5c06\u4f5c\u4e3a\u5217\u540d\u5217\u8868\u4e2d\u7d22\u5f15\u4e3a0\u7684\u5217\u540d\u7684\u5143\u7d20\u5217\u8868\u3002\u540c\u6837\u5730\uff0c\u7d22\u5f15\u4e3a1\u7684\u5b50\u5217\u8868\u5c06\u4f5c\u4e3a\u5217\u540d\u5217\u8868\u4e2d\u7d22\u5f15\u4e3a1\u7684\u5217\u540d\u7684\u5143\u7d20\u5217\u8868\u3002<\/p>\n<p>\\n\\n<\/p>\n<p>\u5728\u4e4b\u524d\u7684\u6b65\u9aa4\u4e2d\uff0c\u4f60\u83b7\u5f97\u4e86\u4e00\u4e2a\u5217\u540d\u7684\u5217\u8868\u3002\u73b0\u5728\uff0c\u4f60\u5c06\u901a\u8fc7\u5728\u65b0\u5355\u5143\u683c\u4e2d\u8fd0\u884c\u6b64\u884c\u6765\u68c0\u67e5\u8fd9\u4e2a\u5217\u8868\u7684\u957f\u5ea6\u3002<\/p>\n<p>\\n<\/p>\n<div>\u5c06 convert_data.ipynb \u8f6c\u6362\u6210\u4e2d\u6587<\/p>\n<pre class=\"post-pre\"><code><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>columns<span class=\"token punctuation\">)<\/span>\\n<\/code><\/pre>\n<p>\\n<\/p>\n<p>len(columns)\u8fd4\u56decolumns\u5217\u8868\u4e2d\u7684\u9879\u76ee\u6570\u91cf\u3002<\/p>\n<p>\\n\\n<\/p>\n<p>API\u4e2d\u663e\u793a\u7684\u5217\u6570\u4f1a\u6253\u5370\u5230\u5c4f\u5e55\u4e0a\u3002<\/p>\n<p>\\n<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\\n<\/p>\n<div class=\"secondary-code-label\" title=\"Output\">\u8f93\u51fa<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>38<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u65e2\u7136\u4f60\u670938\u5217\uff0c\u4f60\u5c06\u5b9a\u4e49\u4e00\u4e2a\u5305\u542b38\u4e2a\u5b50\u5217\u8868\u7684\u5217\u8868\uff0c\u5176\u4e2d\u6bcf\u4e2a\u5b50\u5217\u8868\u90fd\u5c06\u5305\u542b\u5bf9\u5e94\u5217\u7684\u6570\u636e\u3002<\/p>\n<p>\u5728\u65b0\u7684\u5355\u5143\u683c\u4e2d\u8fd0\u884c\u4ee5\u4e0b\u4ee3\u7801\uff0c\u521b\u5efa\u4e00\u4e2a\u5305\u542b38\u4e2a\u5b50\u5217\u8868\u7684\u5217\u8868\uff08\u547d\u540d\u4e3ad\uff09\u3002<\/p>\n<div>\u5c06convert_data.ipynb\u8f6c\u6362\u4e3a\u6570\u636e<\/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>\u521b\u5efa\u5217\u8868\u65f6\uff0c\u8bf7\u9996\u5148\u547d\u540d\u5b83\uff08\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u547d\u540d\u4e3ad\uff09\u3002\u6570\u636e\u96c6\u4e2d\u7684\u6bcf\u4e2a\u6570\u7ec4\uff08[]\uff09\u5c06\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u5b50\u5217\u8868\uff0c\u5176\u4e2d\u5305\u542b\u521a\u521a\u627e\u5230\u7684\u5217\u8303\u56f4\u5185\u7684\u6570\u636e\u3002<\/p>\n<p>\u4e0b\u9762\u7684\u8f93\u51fa\u663e\u793a\u4e8638\u4e2a\u5b50\u5217\u8868\u7684\u6e05\u5355\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"\u8f93\u51fa\">\u8f93\u51fa<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>[[], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], [], []]<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u8fd9\u4e9b\u5b50\u5217\u8868\u6700\u521d\u4e3a\u7a7a\uff0c\u56e0\u4e3a\u60a8\u5c1a\u672a\u5411\u5176\u6dfb\u52a0\u4efb\u4f55\u5143\u7d20\u3002<\/p>\n<p>\u4f60\u73b0\u5728\u5df2\u7ecf\u5728\u5217\u8868d\u4e2d\u521b\u5efa\u4e8638\u4e2a\u5b50\u5217\u8868\u3002\u8fd938\u4e2a\u5b50\u5217\u8868\u7684\u5185\u5bb9\u5c06\u4ee3\u886838\u5217\u7684\u9010\u5217\u6570\u636e\u3002\u63a5\u4e0b\u6765\uff0c\u4f60\u5c06\u6dfb\u52a0\u8fd9\u4e9b\u5185\u5bb9\u3002<\/p>\n<h3>\u83b7\u53d6\u5217\u7684\u503c<\/h3>\n<p>\u5728\u8fd9\u4e00\u90e8\u5206\u4e2d\uff0c\u60a8\u5c06\u4eceAPI\u7aef\u70b9\u63d0\u53d6\u6309\u5217\u6392\u5217\u7684\u6570\u636e\uff0c\u5e76\u5c06\u8fd9\u4e9b\u6570\u636e\u8ffd\u52a0\u5230\u60a8\u5728\u4e0a\u4e00\u6b65\u9aa4\u4e2d\u521b\u5efa\u768438\u4e2a\u5b50\u5217\u8868\u4e2d\u3002\u4e3a\u4e86\u5b8c\u6210\u8fd9\u4e2a\u4efb\u52a1\uff0c\u60a8\u9996\u5148\u9700\u8981\u627e\u5230\u6574\u4e2aAPI\u4e2d\u6570\u636e\u952e\u7684\u4f4d\u7f6e\u3002\u6570\u636e\u952e\u7684\u503c\u5c06\u4ee3\u8868\u8868\u683c\u7684\u5185\u5bb9\u3002<\/p>\n<p>\u5f53\u5728\u6d4f\u89c8\u5668\u4e2d\u8bbf\u95eeAPI URL\u65f6\uff0c\u8bf7\u952e\u5165CTRL+F\u5e76\u641c\u7d22\u6570\u636e\u3002\u5927\u7ea6\u4f1a\u670973\u4e2a\u51fa\u73b0\u7684\u5730\u65b9\u3002\u627e\u5230\u6700\u540e\u4e00\u4e2a\u51fa\u73b0\u7684\u5730\u65b9\uff0c\u5728\u90a3\u91cc\u4f60\u4f1a\u627e\u5230\u4ee5\u4e0b\u5185\u5bb9\uff1a<\/p>\n<div>\u663e\u793a\u5b50\u5217\u8868\u7684\u6570\u636e\u90e8\u5206\uff08\u6765\u81ea\u7ebd\u7ea6\u5b66\u6821\u5feb\u7167\u7f51\u5740\u7684API\u6570\u636e\uff09<\/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>\u5728\u5206\u914d\u7ed9\u6570\u636e\u952e\u7684\u5217\u8868\u4e2d\uff0c\u6bcf\u4e2a\u5b50\u5217\u8868\u8868\u793a\u60a8\u6f5c\u5728DataFrame\u7684\u4e00\u884c\u7684\u503c\u3002\u8981\u786e\u5b9a\u5b9e\u9645\u884c\u6570\u636e\u5f00\u59cb\u7684\u4f4d\u7f6e\uff0c\u60a8\u9700\u8981\u5c06\u5217\u6570\u4e0e\u6570\u636e\u90e8\u5206\u7684\u5355\u4e2a\u5b50\u5217\u8868\u4e2d\u5143\u7d20\u7684\u6570\u91cf\u8fdb\u884c\u6bd4\u8f83\u3002<\/p>\n<p>\u5728\u65b0\u7684\u5355\u5143\u683c\u4e2d\u8fd0\u884c\u4ee5\u4e0b\u884c\u4ee3\u7801\u6765\u786e\u8ba4\u5217\u6570\u3002<\/p>\n<div>\u5c06\u6570\u636e\u8f6c\u6362\u4e3a.ipynb\u6587\u4ef6\u3002<\/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\u8f93\u51fa\u5c06\u6253\u5370\u5217\u6570\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"\u8f93\u51fa\">\u8f93\u51fa<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>38<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u63a5\u4e0b\u6765\uff0c\u68c0\u67e5\u6570\u636e\u4e2d\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\u7684\u957f\u5ea6\uff0c\u5373\u7b2c\u4e00\u884c\u7684\u503c\u7684\u6570\u91cf\u3002<\/p>\n<div>\u8f6c\u6362\u6570\u636e.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>\u4f60\u53ef\u4ee5\u4f7f\u7528ID\u53f7\u4e3a0\u6765\u6307\u5b9a\u6570\u636e\u4e2d\u7684\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\u3002<\/p>\n<p>\u4ee5\u4e0b\u8f93\u51fa\u5c06\u6253\u5370\u51fadata\u4e2d\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\u4e2d\u7684\u5143\u7d20\u6570\u91cf\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>46<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u4f60\u53ef\u80fd\u8ba4\u4e3a\u7531\u4e8e\u6570\u636e\u662f\u6309\u884c\u6392\u5217\u7684\uff0c\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\uff0846\u4e2a\u5143\u7d20\uff09\u7684\u6570\u91cf\u5e94\u8be5\u7b49\u4e8e\u5217\u6570\uff0838\uff09\u3002\u7136\u800c\uff0c\u6bcf\u4e2a\u5b50\u5217\u8868\u7684\u957f\u5ea6\u90fd\u662f46\uff0c\u6bd438\u591a8\u4e2a\u3002\u56de\u60f3\u4e00\u4e0b\uff0c\u5728\u5217\u952e\u4e2d\uff0c\u4f60\u627e\u5230\u4e868\u4e2a\u5b57\u5178\u7684dataTypeName\u952e\u7684\u503c\u4e3ameta_data\u3002\u56e0\u6b64\uff0c\u4f60\u5728\u8fd9\u4e9b\u5b50\u5217\u8868\u5f00\u5934\u770b\u5230\u7684\u989d\u5916\u76848\u4e2a\u503c\u8868\u793a\u5143\u6570\u636e\u503c\uff0c\u800c\u4e0d\u4ee3\u8868\u4f60\u7684\u8868\u683c\u5185\u5bb9\u3002<\/p>\n<p>\u7531\u4e8e\u5217\u8868\u4e2d\u7684\u7d22\u5f15\u4ece0\u5f00\u59cb\uff0c\u4f60\u73b0\u5728\u77e5\u9053\u5728\u8303\u56f40\u81f37\uff08\u5305\u62ec\uff09\u7684\u5b50\u5217\u8868\u7684\u503c\u4e0d\u4ee3\u8868DataFrame\u7684\u5185\u5bb9\uff0c\u800c\u662f\u8868\u793a\u5143\u6570\u636e\u503c\u3002\u56e0\u6b64\uff0c\u9010\u884c\u6570\u636e\u7684\u5185\u5bb9\u4ece\u7d22\u5f158\u5f00\u59cb\u3002<\/p>\n<p>\u4f60\u5c06\u4f7f\u7528\u5faa\u73af\u4ece\u7d22\u5f1546-38\uff088\uff09\u5f00\u59cb\u7684\u6570\u636e\u5b50\u5217\u8868\u4e2d\u6dfb\u52a0\u5143\u7d20\uff0c\u76f4\u5230\u7d22\u5f1546\u3002\u4e3a\u4e86\u6d4b\u8bd5\u8fd9\u4e2a\u529f\u80fd\uff0c\u4f60\u5c06\u4ec5\u4ece\u7b2c\u4e00\u884c\u4e2d\u63d0\u53d6\u6570\u636e\uff08\u800c\u4e0d\u662f\u4ece\u6240\u6709\u5b50\u5217\u8868\u4e2d\u63d0\u53d6\u6240\u6709\u6570\u636e\uff09\u3002\u5728\u4e00\u4e2a\u65b0\u7684\u5355\u5143\u683c\u4e2d\u8fd0\u884c\u4ee5\u4e0b\u4ee3\u7801\u884c\uff1a<\/p>\n<div>\u5c06data\u8f6c\u6362\u4e3a.ipynb\u683c\u5f0f\u7684\u6587\u4ef6\u3002<\/p>\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>\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u53d8\u91cfcount\u5e2e\u52a9\u5c06\u7b2c\u4e00\u884c\u7684\u5217\u6570\u636e\u8ffd\u52a0\u5230d\u7684\u7b2cn\u4e2a\u5b50\u5217\u8868\u4e0a\u3002<\/p>\n<p>\u7136\u540e\u4ee3\u7801\u904d\u5386\u6570\u636e\u4e2d\u7684\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\uff0c\u4ece\u7d22\u5f158\u5f00\u59cb\u83b7\u53d6\u5143\u7d20\uff0c\u76f4\u5230\u7d22\u5f1545\u7ed3\u675f\uff08\u7ed3\u679c\u4e3a38\u4e2a\u5143\u7d20\uff09\u3002<\/p>\n<p>response[&#8216;data&#8217;][0]\u7684\u957f\u5ea6\u8868\u793a\u6570\u636e\u952e\u4e2d\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\u7684\u957f\u5ea6\uff0c\u800clen(columns)\u662f\u5217\u8868columns\u7684\u957f\u5ea6\uff0c\u8868\u793a\u6700\u540eDataFrame\u7684\u5217\u6570\u3002<\/p>\n<p>\u8fd9\u662f\u524d\u51e0\u6b21\u8fed\u4ee3\u4e2d\u53d1\u751f\u7684\u60c5\u51b5\u6982\u8ff0\u3002\u8ba1\u6570\u6700\u521d\u4e3a0\u3002\u5f53\u60a8\u8fdb\u5165for\u5faa\u73af\u65f6\uff0ci\u662fresponse[&#8216;data&#8217;][0][8]\uff0c\u5373\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\u4e2d\u7b2c\u4e00\u4e2a\u975e\u5143\u6570\u636e\u503c\u3002\u7136\u540e\uff0c\u60a8\u5c06\u6b64i\u503c\u9644\u52a0\u5230d[0]\u4e0a\uff1b\u65b9\u62ec\u53f7\u4e2d\u76840\u662f\u5f53\u524d\u8ba1\u6570\u503c\u3002\u56e0\u6b64\uff0c\u60a8\u5c06\u6b64\u503c\u9644\u52a0\u5230\u5217\u8868d\u4e2d\u7684\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\u4e2d\u3002<\/p>\n<p>\u8ba1\u6570\u589e\u52a01\u3002 \u5f53i\u7b49\u4e8eresponse[&#8216;data&#8217;][0][9]\uff08\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\u4e2d\u7b2c\u4e8c\u4e2a\u975e\u5143\u6570\u636e\u503c\uff09\u65f6\uff0c\u5c06i\u7684\u503c\u6dfb\u52a0\u5230d[1]\u4e2d\uff08\u56e0\u4e3a\u5728\u524d\u4e00\u6b21\u8fed\u4ee3\u4e2d\uff0c\u8ba1\u6570\u589e\u52a0\u4e861\uff0c\u6240\u4ee50\u73b0\u5728\u662f1\uff09\u3002 \u7ed3\u679c\uff0c\u8be5\u503c\u88ab\u8ffd\u52a0\u5230\u5217\u8868d\u7684\u7b2c\u4e8c\u4e2a\u5b50\u5217\u8868\u4e2d\u3002 \u8fd9\u4e2a\u8fc7\u7a0b\u4e00\u76f4\u6301\u7eed\u5230\u8fbe\u7d22\u5f1545\u3002\u4e0a\u8ff0\u4ee3\u7801\u7684\u6700\u540e\u4e00\u884c\u5c06\u663e\u793a\u66f4\u65b0\u540e\u7684d\u5b50\u5217\u8868\u3002<\/p>\n<p>\u8f93\u51fa\u663e\u793a\u7b2c\u4e00\u884c\u6570\u636e\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/p>\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>\u4e3a\u4e86\u68c0\u67e5\u7b2c\u4e00\u884c\u662f\u5426\u5305\u542b\u6b63\u786e\u7684\u6570\u636e\uff0c\u5c06\u5176\u4e0e\u4f5c\u4e3aAPI URL\u4e2ddata key\u7684\u503c\u7684\u5217\u8868\u4e2d\u7684\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\u8fdb\u884c\u6bd4\u8f83\u3002<\/p>\n<div>\u6765\u81eaNY School Snapshot\u7f51\u5740\u7684API\u6570\u636e\u7684\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\u5143\u7d20\u3002<\/p>\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>\u60a8\u53ef\u80fd\u9700\u8981\u5411\u53f3\u6ed1\u52a8\u4e0a\u65b9\u7684\u6846\u4ee5\u67e5\u770b\u5b8c\u6574\u7684\u6570\u636e\u7247\u6bb5\u3002<\/p>\n<p>\u524d\u51e0\u4e2a\u503c\uff08\u4ece\u7d22\u5f150\u52307\uff09\u4ee3\u8868\u4e0e\u5143\u6570\u636e\u5217\u76f8\u5173\u7684\u4fe1\u606f\u3002\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\uff08\u4ece\u7d22\u5f158\u523045\uff09\u4e2d\u7684\u9ad8\u4eae\u503c\u662f\u7b2c\u4e00\u884c\u7684\u503c\uff0c\u4f60\u5df2\u6210\u529f\u63d0\u53d6\u51fa\u6765\u3002<\/p>\n<p>\u8981\u4e3a\u6240\u6709\u884c\u6267\u884c\u76f8\u540c\u7684\u4efb\u52a1\uff0c\u60a8\u9700\u8981\u66f4\u65b0\u5148\u524d\u7684\u4ee3\u7801\u3002\u9996\u5148\uff0c\u5728\u65b0\u7684\u5355\u5143\u683c\u4e2d\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\u91cd\u65b0\u5b9a\u4e49\u5305\u542b38\u4e2a\u5b50\u5217\u8868\u7684d\u5217\u8868:<\/p>\n<div>\u8f6c\u6362\u6570\u636e.ipynb<\/p>\n<p>\u8fd9\u662f\u6587\u7ae0\u300a\u5982\u4f55\u4ece\u65e0\u5e8f\u7684API\u7aef\u70b9\u83b7\u53d6pandas DataFrame\u300b\u7684\u7b2c7\u90e8\u5206\uff08\u517111\u90e8\u5206\uff09\u3002<\/p>\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>\u7531\u4e8e\u5b50\u5217\u8868d\u5f53\u524d\u5305\u542b\u6240\u6709\u7b2c\u4e00\u884c\u7684\u5143\u7d20\uff0c\u60a8\u6b63\u5728\u91cd\u65b0\u5b9a\u4e49d\u5217\u8868\u3002\u73b0\u5728\uff0c\u60a8\u7684\u76ee\u6807\u662f\u5bf9\u6240\u6709\u5269\u4f59\u884c\uff08\u5305\u62ec\u7b2c\u4e00\u884c\uff09\u6267\u884c\u76f8\u540c\u7684\u64cd\u4f5c\u3002<\/p>\n<p>\u65e2\u7136\u4f60\u5df2\u7ecf\u521b\u5efa\u4e86\u4e00\u4e2a\u5305\u542b38\u4e2a\u5b50\u5217\u8868\u7684\u65b0\u5217\u8868\uff0c\u8bf7\u5728\u4e00\u4e2a\u65b0\u7684\u5355\u5143\u683c\u4e2d\u8fd0\u884c\u4ee5\u4e0b\u4ee3\u7801\u884c\uff0c\u5b83\u4f1a\u5bf9\u6f5c\u5728\u7684\u6570\u636e\u6846\u7684\u6240\u6709\u884c\u8fdb\u884c\u6570\u636e\u63d0\u53d6\u3002<\/p>\n<div>\u8f6c\u6362\u6570\u636e.ipynb<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<\/div>\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>\u5728\u7b2c\u4e00\u884c\u4e2d\uff0c\u5bf9\u4e8eresponse[&#8216;data&#8217;]\u4e2d\u7684\u6bcf\u4e00\u4e2a\u5b50\u5217\u8868\uff0ci\u90fd\u88ab\u9010\u4e00\u8d4b\u503c\u3002<\/p>\n<p>\u8fd9\u91cc\u6709\u51e0\u4e2a\u8fed\u4ee3\u7684\u6982\u8ff0\u3002\u4f60\u4ecei\u5f00\u59cb\uff0c\u5c06\u5217\u8868\u4e2d\u7684\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\u5206\u914d\u7ed9data\u952e\u3002\u8ba1\u6570\u4e3a0\u3002<\/p>\n<p>\u7b2c3\u884c\u5141\u8bb8\u60a8\u5728\u5b50\u5217\u8868\u7684\u7d22\u5f158\u523046\u4e4b\u95f4\u904d\u5386\u5143\u7d20\u3002\u5728Python\u4e2d\uff0cfor\u5faa\u73af\u7684\u4e0a\u9650\u662f\u6392\u4ed6\u6027\u7684\uff0c\u6240\u4ee5\u60a8\u5c06\u83b7\u5f97\u4ece\u7d22\u5f158\u523045\u7684\u5143\u7d20\u3002<\/p>\n<p>&#8220;d[count].append(i[j])&#8221;\u7684\u610f\u601d\u662fd[0].append(i[8])\uff0c\u610f\u601d\u662f\u5c06\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\uff08\u5f53\u524d\u88ab\u8d4b\u503c\u7ed9i\uff09\u7684\u7d22\u5f15\u4e3a8\u7684\u5143\u7d20\u6dfb\u52a0\u5230\u5217\u8868d\u7684\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\u4e2d\u3002count\u589e\u52a01\u3002\u60a8\u7ee7\u7eed\u5728\u5185\u90e8\u5faa\u73af\u4e2d\u3002\u73b0\u5728j\u4e3a9\u3002<\/p>\n<p>\u7b2c4\u884c\u73b0\u5728\u662fd[1].append(i[9])\uff0c\u610f\u5473\u7740\u5728\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\uff08\u4ecd\u7136\u6839\u636e\u5916\u5faa\u73af\u5206\u914d\u7ed9i\uff09\u4e2d\u7684\u7d22\u5f15\u4e3a9\u7684\u5143\u7d20\u88ab\u6dfb\u52a0\u5230\u5217\u8868d\u7684\u7b2c\u4e8c\u4e2a\u5b50\u5217\u8868\u4e2d\u3002\u8ba1\u6570\u88ab\u9012\u589e\u3002\u5185\u5faa\u73af\u4f1a\u7ee7\u7eed\u76f4\u5230\u5c06\u4e00\u884c\u7684\u6240\u6709\u503c\u90fd\u6dfb\u52a0\u5230\u5217\u8868d\u7684\u6240\u6709\u5b50\u5217\u8868\u4e2d\u4e3a\u6b62\u3002<\/p>\n<p>\u5728\u5185\u5faa\u73af\u7ed3\u675f\u65f6\uff0c\u5c06\u7b2c\u4e00\u884c\u7684\u6700\u540e\u4e00\u4e2a\u503c\u8ffd\u52a0\u5230\u5217\u8868d\u7684\u64cd\u4f5c\u5c06\u5982\u4e0b\u6240\u793a\uff1ad[37].append(i[45])\u3002\u5728i\u7684\u7b2c\u4e00\u6b21\u8fed\u4ee3\u7ed3\u675f\u65f6\uff0c\u5217\u8868d\u7684\u72b6\u6001\u4e0e\u5148\u524d\u7684\u8f93\u51fa\u76f8\u540c\uff08\u6240\u6709\u5b50\u5217\u8868\u4e2d\u4ec5\u6709\u4e00\u4e2a\u5143\u7d20\uff09\u3002<\/p>\n<p>\u5f53\u4f60\u8df3\u51fa\u5185\u5faa\u73af\u65f6\uff0c\u4f60\u4f1a\u8fdb\u5165\u5916\u5faa\u73af\u3002\u6b64\u65f6\uff0ci\u5c06\u88ab\u8d4b\u503c\u4e3a\u6570\u636e\u952e\u4e2d\u88ab\u5206\u914d\u7684\u5217\u8868\u5185\u7684\u4e0b\u4e00\u4e2a\u5b50\u5217\u8868\uff08\u7b2c\u4e8c\u4e2a\u5b50\u5217\u8868\uff09\u3002\u8ba1\u6570\u503c\u73b0\u5728\u91cd\u65b0\u8bbe\u4e3a0\u3002<\/p>\n<p>\u5f53\u60a8\u5728\u7b2c\u4e8c\u6b21\u5bf9i\u8fdb\u884c\u8fed\u4ee3\u65f6\uff0c\u5f53\u60a8\u8df3\u51fa\u5185\u90e8\u5faa\u73af\u65f6\uff0cd\u7684\u6240\u6709\u5b50\u5217\u8868\u5c06\u4f1a\u6709\u4e24\u4e2a\u503c\u3002\u6bcf\u4e2a\u5b50\u5217\u8868\u7684\u7b2c\u4e8c\u4e2a\u503c\u4ee3\u8868\u7740\u5c5e\u4e8e\u7b2c\u4e8c\u884c\u7684\u6570\u636e\u3002\u8fd9\u79cd\u60c5\u51b5\u4f1a\u9002\u7528\u4e8e\u6570\u636e\u952e\u6240\u5206\u914d\u7684\u6240\u6709\u5b50\u5217\u8868\u3002<\/p>\n<p>\u4e3a\u4e86\u8ba9\u60a8\u4e86\u89e3d\u7684\u5b50\u5217\u8868\u4e2d\u6240\u83b7\u53d6\u6570\u636e\u7684\u6837\u5f0f\uff0c\u60a8\u5c06\u68c0\u7d22d\u7684\u524d\u4e09\u4e2a\u5b50\u5217\u8868\u4e2d\u7684\u524d\u4e94\u4e2a\u5143\u7d20\u3002\u5728\u751f\u6210\u7684\u6570\u636e\u6846\u4e2d\uff0c\u8fd9\u4e9b\u503c\u5c06\u662f\u524d\u4e09\u5217\u7684\u524d\u4e94\u4e2a\u5143\u7d20\u3002<\/p>\n<p>\u4eced\u7684\u7d22\u5f150\u5f00\u59cb\uff0c\u5148\u56de\u987e\u5b50\u5217\u8868\u7684\u524d\u4e94\u4e2a\u5143\u7d20\u3002<\/p>\n<div>\u5c06\u6570\u636e\u8f6c\u6362.ipynb<\/p>\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<\/div>\n<p>\u8f93\u51fa\u5c06\u4f1a\u663e\u793a\u4ee5\u4e0b\u5185\u5bb9\uff1a<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"\u8f93\u51fa\">\u8f93\u51fa<\/p>\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<\/div>\n<p>\u5f53\u60a8\u5728\u6d4f\u89c8\u5668\u4e2d\u67e5\u770bAPI\u7684\u6570\u636e\u90e8\u5206\u65f6\uff0c\u60a8\u53ef\u4ee5\u901a\u8fc7\u4e0e\u8f93\u51fa\u8fdb\u884c\u6bd4\u8f83\u6765\u9a8c\u8bc1\u5176\u51c6\u786e\u6027\u3002<\/p>\n<div>\u7b2c\u4e00\u4e2a\u5b50\u5217\u8868\u7684\u5143\u7d20\uff08\u6765\u81eaNY School Snapshot URL\u7684API\u6570\u636e\uff09\u3002<\/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 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279\", \"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 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279\", \"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 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279\", \"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 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279\", \"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 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279\", \"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>\u4f60\u53ef\u80fd\u9700\u8981\u5411\u4e0a\u6eda\u52a8\u5230\u4e0a\u9762\u7684\u6846\u4e2d\u7684\u53f3\u4fa7\u624d\u80fd\u67e5\u770b\u5b8c\u6574\u7684\u6570\u636e\u7247\u6bb5\u3002<\/p>\n<p>\u60a8\u83b7\u53d6\u7684\u6570\u503c\u4e0e\u7a81\u51fa\u663e\u793a\u7684\u6570\u503c\u76f8\u5339\u914d\uff0c\u8fd9\u4e9b\u6570\u503c\u4f4d\u4e8e\u6bcf\u4e2a\u5b50\u5217\u8868\u7684\u7d22\u5f158\u5904\u3002\u8fd9\u4e9b\u5b50\u5217\u8868\u4e2d\u7d22\u5f15\u8303\u56f40-7\uff08\u5305\u62ec\uff09\u7684\u5143\u7d20\u8868\u793a\u5143\u6570\u636e\u503c\uff0c\u800c\u4e0d\u662f\u6f5c\u5728\u7684pandas DataFrame\u6570\u503c\u3002\u6700\u7ec8\uff0c\u8fd9\u4e9b\u6570\u503c\u5c06\u4ee3\u8868\u7d22\u5f150\u7684\u5217\u7684\u524d\u4e94\u4e2a\u5143\u7d20\u3002<\/p>\n<p>\u63a5\u4e0b\u6765\uff0c\u4f60\u53ef\u4ee5\u56de\u987e\u4e00\u4e0b\u53d8\u91cfd\u4e2d\u7d22\u5f15\u4e3a1\u7684\u5b50\u5217\u8868\u7684\u524d\u4e94\u4e2a\u5143\u7d20\u3002<\/p>\n<div>\n<p>\u5c06\u6570\u636e\u8f6c\u6362\u4e3a.ipynb\u6587\u4ef6<\/p>\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<\/div>\n<p>\u7b2c\u4e8c\u4e2a\u5b50\u5217\u8868\u7684\u524d\u4e94\u4e2a\u5143\u7d20\u4f1a\u6253\u5370\u5728\u5c4f\u5e55\u4e0a\u3002<\/p>\n<div class=\"secondary-code-label\" title=\"Output\">\n<p>\u8f93\u51fa<\/p>\n<pre class=\"post-pre\"><code>['P.S. 015 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279', 'P.S. 015 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279', 'P.S. 015 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279', 'P.S. 015 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279', 'P.S. 015 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279']\r\n<\/code><\/pre>\n<\/div>\n<p>\u8fd9\u4e9b\u503c\u8868\u793a\u5217\u7d22\u5f151\u7684\u5217\u5217\u8868\u4e2d\u7684\u524d\u4e94\u4e2a\u5143\u7d20\uff1a\u540d\u79f0\u3002\u4f7f\u7528API URL\u7684\u6570\u636e\u90e8\u5206\u9a8c\u8bc1\u8f93\u51fa\u3002<\/p>\n<div>\n<p>\u7ebd\u7ea6\u5b66\u6821\u5feb\u7167\u7f51\u5740\u7684API\u6570\u636e\u7684\u7b2c\u4e8c\u4e2a\u5b50\u5217\u8868\u7684\u5143\u7d20<\/p>\n<\/div>\n<p>\u8fd9\u662f\u6587\u7ae0\u300a\u5982\u4f55\u4ece\u65e0\u5e8f\u7684API\u7aef\u70b9\u83b7\u53d6pandas DataFrame\u300b\u7684\u7b2c9\u90e8\u5206\uff08\u517111\u90e8\u5206\uff09\u3002<\/p>\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 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279\u5b66\u6821\"<\/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 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279\u5b66\u6821\"<\/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 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279\u5b66\u6821\"<\/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 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279\u5b66\u6821\"<\/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 \u7f57\u4f2f\u6258\u00b7\u514b\u83b1\u95e8\u7279\u5b66\u6821\"<\/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>\u60a8\u53ef\u80fd\u9700\u8981\u5411\u53f3\u6eda\u52a8\u4e0a\u65b9\u6846\u4f53\u4ee5\u67e5\u770b\u5b8c\u6574\u7684\u6570\u636e\u7247\u6bb5\u3002\u60a8\u83b7\u53d6\u7684\u503c\u5e94\u4e0e\u7a81\u51fa\u663e\u793a\u7684\u503c\u76f8\u7b26\u3002<\/p>\n<p>\u6700\u540e\uff0c\u8ba9\u6211\u4eec\u56de\u987e\u4e00\u4e0bd\u4e2d\u7d22\u5f152\u5904\u5b50\u5217\u8868\u7684\u524d\u4e94\u4e2a\u5143\u7d20\u3002<\/p>\n<div>\u6570\u636e\u8f6c\u6362.ipynb<\/p>\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\u8f93\u51fa\u5c06\u5728\u5c4f\u5e55\u4e0a\u6253\u5370\uff1a<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"\u8f93\u51fa\">\u8f93\u51fa<\/p>\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>\u901a\u8fc7API URL\u7684\u6570\u636e\u90e8\u5206\u9a8c\u8bc1\u8f93\u51fa\u3002<\/p>\n<div>\u7ebd\u7ea6\u5b66\u6821\u5feb\u7167URL\u4e2dAPI\u6570\u636e\u7684\u7b2c\u4e8c\u4e2a\u5b50\u5217\u8868\u7684\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>\u60a8\u53ef\u80fd\u9700\u8981\u5411\u53f3\u6eda\u52a8\u4e0a\u65b9\u7684\u6846\u624d\u80fd\u67e5\u770b\u5b8c\u6574\u7684\u6570\u636e\u7247\u6bb5\u3002\u60a8\u83b7\u5f97\u7684\u503c\u4e0e\u9ad8\u4eae\u663e\u793a\u7684\u503c\u5339\u914d\u3002\u8fd9\u4e9b\u503c\u6700\u7ec8\u8868\u793a\u5217\u7d22\u5f152\u5904\u5217\uff08schoolyear\uff09\u7684\u524d\u4e94\u4e2a\u5143\u7d20\u3002<\/p>\n<p>\u5f53\u4f60\u5b8c\u6210\u8fd9\u4e00\u6b65\u9aa4\u65f6\uff0c\u4f60\u5df2\u6210\u529f\u63d0\u53d6\u4e86\u6240\u670938\u5217\u4e2d\u7684\u6240\u6709\u884c\u7684\u6570\u636e\uff0c\u5e76\u5c06\u5b83\u4eec\u6dfb\u52a0\u5230\u5217\u8868d\u768438\u4e2a\u5b50\u5217\u8868\u4e2d\u3002\u73b0\u5728\uff0c\u4f60\u5df2\u7ecf\u51c6\u5907\u597d\u8fdb\u884c\u6700\u540e\u4e00\u6b65\uff0c\u4ece\u8fc4\u4eca\u4e3a\u6b62\u83b7\u5f97\u7684\u6570\u636e\u521b\u5efa\u4e00\u4e2apandas DataFrame\u3002<\/p>\n<h3>\u4e3a\u6570\u636e\u5e27\u521b\u5efa\u4e00\u4e2a\u5b57\u5178<\/h3>\n<p>\u76ee\u524d\u4e3a\u6b62\uff0c\u60a8\u5df2\u7ecf\u63d0\u53d6\u4e8638\u5217\u4e2d\u6bcf\u4e00\u5217\u7684\u540d\u79f0\u548c\u503c\uff0c\u5e76\u5c06\u5176\u4ee5\u5b57\u5178\u683c\u5f0f\u4f20\u9012\u7ed9pandas DataFrame\u3002\u5728\u672c\u8282\u4e2d\uff0c\u60a8\u5c06\u521b\u5efa\u4e00\u4e2a\u5b57\u5178\uff0c\u952e\u662f\u4ece\u5217\u5217\u8868\u4e2d\u83b7\u53d6\u7684\u5217\u540d\uff0c\u5176\u503c\u5c06\u662f\u4eced\u4e2d\u83b7\u53d6\u768438\u4e2a\u5b50\u5217\u8868\u3002<\/p>\n<p>\u5728\u65b0\u7684\u5355\u5143\u683c\u4e2d\u8fd0\u884c\u4e0b\u9762\u7684\u4ee3\u7801\u3002<\/p>\n<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<\/div>\n<p>\u4f60\u5faa\u73af\u904d\u5386\u4ece0\u5230\uff08\u4f46\u4e0d\u5305\u62ec\uff0938\u7684\u8303\u56f4\uff0c\u5e76\u5c06\u952e\u503c\u5bf9\u8ffd\u52a0\u5230\u6700\u7ec8\u7684\u5b57\u5178json_dict\u4e2d\uff0c\u7136\u540e\u5c06\u5176\u4f20\u9012\u7ed9pandas DataFrame\u7528\u4e8e\u8f6c\u6362\u3002\u6240\u4ee5\uff0c\u4f8b\u5982\uff0c\u5f53i\u4e3a0\u65f6\uff0c\u4f60\u5c06d\u4e2d\u7d22\u5f15\u4e3a0\u7684\u5b50\u5217\u8868\u5206\u914d\u4e3a\u952eDBN\u7684\u503c\uff0c\u8be5\u952e\u7531columns[0]\u8868\u793a\uff0c\u5e76\u5bf9\u4e8e\u5176\u4f59\u7684\u7d22\u5f15\u4e5f\u9002\u7528\u3002<\/p>\n<p>\u4e3a\u4e86\u4e86\u89e3\u5b57\u5178\u4e2d\u83b7\u5f97\u7684\u952e\u7684\u6837\u5b50\uff0c\u8bf7\u67e5\u770bjson_dict\u4e2d\u5b58\u5728\u7684\u6240\u6709\u952e\u3002<\/p>\n<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<\/div>\n<p>\u6700\u540e\u5b57\u5178\u7684\u952e\u5217\u8868\u5c06\u4f1a\u663e\u793a\u5728\u5c4f\u5e55\u4e0a\u3002<\/p>\n<div class=\"secondary-code-label\" title=\"\u8f93\u51fa\">\n<pre class=\"post-pre\"><code>dict_keys(['DBN', 'Name', 'schoolyear', 'fl_percent', 'frl_percent', 'total_enrollment', 'prek', 'k', 'grade1', 'grade2', 'grade3', 'grade4', 'grade5', 'grade6', 'grade7', 'grade8', 'grade9', 'grade10', 'grade11', 'grade12', 'ell_num', 'ell_percent', 'sped_num', 'sped_percent', 'ctt_num', 'selfcontained_num', 'asian_num', 'asian_per', 'black_num', 'black_per', 'hispanic_num', 'hispanic_per', 'white_num', 'white_per', 'male_num', 'male_per', 'female_num', 'female_per'])\r\n<\/code><\/pre>\n<\/div>\n<p>38\u5217\u5b50\u5217\u8868d\u5df2\u7ecf\u88ab\u5206\u914d\u7ed9\u4e0a\u8ff0\u768438\u4e2a\u952e\u5728json_dict\u4e2d\u3002\u56e0\u6b64\uff0c\u60a8\u5f97\u5230\u4e86\u4e00\u4e2a\u5b57\u5178\uff0c\u5176\u4e2d\u952e\u662f\u5217\u540d\uff0c\u503c\u662f\u5305\u542b\u6bcf\u4e2a\u5217\u5143\u7d20\u7684\u5217\u8868\u3002<\/p>\n<p>\u73b0\u5728\u5c06\u8fd9\u4e2a\u5b57\u5178\u4f20\u9012\u7ed9pandas\u6765\u751f\u6210\u4e00\u4e2aDataFrame\u3002\u8fd9\u4e2aDataFrame\u53ef\u4ee5\u4f7f\u7528\u60a8\u9009\u62e9\u7684\u53d8\u91cf\u540d\u8fdb\u884c\u8c03\u7528\uff08\u672c\u6559\u7a0b\u4f7f\u7528\u7684\u662fdata\uff09\u3002<\/p>\n<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<\/div>\n<p>\u63a5\u4e0b\u6765\uff0c\u56de\u987e\u4e00\u90e8\u5206\u7ed3\u679c\u6570\u636e\u6846\u3002<\/p>\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>DataFrame\u7684\u524d\u4e94\u884c\u5c06\u4f1a\u6253\u5370\u5230\u5c4f\u5e55\u4e0a\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"\u8f93\u51fa\">\u8f93\u51fa<\/div>\n<pre class=\"post-pre\"><code>DBN \u540d\u79f0 \u5b66\u5e74 \u514d\u8d39\u5348\u9910\u6bd4\u4f8b \u514d\u8d39\u5348\u9910\u6bd4\u4f8b\u53d8\u5316 \u603b\u5165\u5b66\u4eba\u6570 \u5e7c\u513f\u73ed \u5e7c\u513f\u56ed \u4e00\u5e74\u7ea7 \u4e8c\u5e74\u7ea7 ... \u9ed1\u4eba\u5b66\u751f\u6570\u91cf \u9ed1\u4eba\u5b66\u751f\u6bd4\u4f8b \u897f\u73ed\u7259\u88d4\u5b66\u751f\u6570\u91cf \u897f\u73ed\u7259\u88d4\u5b66\u751f\u6bd4\u4f8b \u767d\u4eba\u5b66\u751f\u6570\u91cf \u767d\u4eba\u5b66\u751f\u6bd4\u4f8b \u7537\u751f\u6570\u91cf \u7537\u751f\u6bd4\u4f8b \u5973\u751f\u6570\u91cf \u5973\u751f\u6bd4\u4f8b \r\n0 01M015 P.S. 015 ROBERTO CLEMENTE 20052006 89.4 None 281 15 36 40 33 ... 74 26.3 189 67.3 5 1.8 158 56.2 123 43.8 \r\n1 01M015 P.S. 015 ROBERTO CLEMENTE 20062007 89.4 None 243 15 29 39 38 ... 68 28 153 63 4 1.6 140 57.6 103 42.4 \r\n2 01M015 P.S. 015 ROBERTO CLEMENTE 20072008 89.4 None 261 18 43 39 36 ... 77 29.5 157 60.2 7 2.7 143 54.8 118 45.2 \r\n3 01M015 P.S. 015 ROBERTO CLEMENTE 20082009 89.4 None 252 17 37 44 32 ... 75 29.8 149 59.1 7 2.8 149 59.1 103 40.9 \r\n4 01M015 P.S. 015 ROBERTO CLEMENTE 20092010 96.5 208 16 40 28 32 ... 67 32.2 118 56.7 6 2.9 124 59.6 84 40.4<\/code><\/pre>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u4f60\u53ef\u80fd\u9700\u8981\u5411\u53f3\u6eda\u52a8\u4ee5\u67e5\u770b\u4e0a\u65b9\u6846\u4e2d\u5b8c\u6574\u7684\u6570\u636e\u6846\u5934\u90e8\u3002\u901a\u8fc7\u63d0\u53d6\u7684\u6570\u636e\u521b\u5efa\u6570\u636e\u6846\u5df2\u7ecf\u6210\u529f\u5b8c\u6210\u3002<\/p>\n<h2>\u603b\u7ed3<\/h2>\n<p>\u5728\u672c\u6559\u7a0b\u4e2d\uff0c\u60a8\u4f7f\u7528\u4e86\u4e00\u4e9b\u5e38\u89c1\u7684\u65b9\u6cd5\uff0c\u4ece\u4e0d\u540c\u683c\u5f0f\u7684\u5b57\u5178\u548cURL\u521b\u5efa\u4e86\u4e00\u4e2apandas DataFrame\u3002\u60a8\u8fd8\u521b\u5efa\u4e86\u4e00\u4e2a\u6765\u81eaAPI\u7aef\u70b9\u7684DataFrame\uff0c\u5176\u4e2d\u5217\u548c\u5b83\u4eec\u5bf9\u5e94\u7684\u503c\u4e0d\u662f\u4ee5\u76f4\u89c2\u7684\u65b9\u5f0f\u663e\u793a\u3002<\/p>\n<p>\u8fd9\u4e2a\u6559\u7a0b\u5e94\u8be5\u5e2e\u52a9\u4f60\u7406\u89e3\u5982\u4f55\u4f7f\u7528\u72ec\u7279\u7684\u65b9\u6cd5\u4ece\u975e\u5e38\u89c4\u7684API\u7aef\u70b9\u6216\u5b57\u5178\u4e2d\u63d0\u53d6\u6570\u636e\u6765\u521b\u5efa\u6570\u636e\u6846\u3002\u5982\u679c\u60f3\u4e86\u89e3\u66f4\u591a\u5173\u4e8epandas\u6570\u636e\u6846\u7684\u5185\u5bb9\uff0c\u8bf7\u67e5\u770b\u6211\u4eec\u7684pandas\u6559\u7a0b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4f5c\u8005\u9009\u62e9\u5c06\u81ea\u7531\u5f00\u6e90\u57fa\u91d1\u4f5c\u4e3a&#8221;\u4e3a\u6350\u6b3e\u800c\u5199&#8221;\u8ba1\u5212\u7684\u4e00\u90e8\u5206\u6536\u5230\u7684\u6350\u6b3e\u4e4b\u4e00\u3002 \u5f15\u8a00 \u4e0eExce [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[2320,273,1477],"class_list":["post-902","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-api","tag-pandas","tag-python"],"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>Python\u6570\u636e\u5904\u7406\uff1a\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6pandas DataFrame\u7684\u5b8c\u6574\u6307\u5357 - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528Python\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6\u6570\u636e\u5e76\u8f6c\u6362\u4e3apandas DataFrame\u3002\u901a\u8fc7\u5b9e\u9645\u6848\u4f8b\uff0c\u5b66\u4e60\u5904\u7406\u4e0d\u89c4\u5219API\u54cd\u5e94\u3001\u6570\u636e\u6e05\u6d17\u548c\u7ed3\u6784\u5316\u7684\u6280\u5de7\uff0c\u63d0\u9ad8\u6570\u636e\u5206\u6790\u6548\u7387\u3002\u9002\u5408\u6570\u636e\u5206\u6790\u5e08\u548cPython\u5f00\u53d1\u8005\u53c2\u8003\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\/zh\/blog\/\u5982\u4f55\u4ece\u65e0\u5e8f\u7684api\u7aef\u70b9\u83b7\u53d6pandas-dataframe\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python\u6570\u636e\u5904\u7406\uff1a\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6pandas DataFrame\u7684\u5b8c\u6574\u6307\u5357\" \/>\n<meta property=\"og:description\" content=\"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528Python\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6\u6570\u636e\u5e76\u8f6c\u6362\u4e3apandas DataFrame\u3002\u901a\u8fc7\u5b9e\u9645\u6848\u4f8b\uff0c\u5b66\u4e60\u5904\u7406\u4e0d\u89c4\u5219API\u54cd\u5e94\u3001\u6570\u636e\u6e05\u6d17\u548c\u7ed3\u6784\u5316\u7684\u6280\u5de7\uff0c\u63d0\u9ad8\u6570\u636e\u5206\u6790\u6548\u7387\u3002\u9002\u5408\u6570\u636e\u5206\u6790\u5e08\u548cPython\u5f00\u53d1\u8005\u53c2\u8003\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5982\u4f55\u4ece\u65e0\u5e8f\u7684api\u7aef\u70b9\u83b7\u53d6pandas-dataframe\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-04T12:47:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-03T09:11:32+00:00\" \/>\n<meta name=\"author\" content=\"\u79d1, \u9896\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u79d1, \u9896\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe\/\",\"name\":\"Python\u6570\u636e\u5904\u7406\uff1a\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6pandas DataFrame\u7684\u5b8c\u6574\u6307\u5357 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-04-04T12:47:23+00:00\",\"dateModified\":\"2025-08-03T09:11:32+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e\"},\"description\":\"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528Python\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6\u6570\u636e\u5e76\u8f6c\u6362\u4e3apandas DataFrame\u3002\u901a\u8fc7\u5b9e\u9645\u6848\u4f8b\uff0c\u5b66\u4e60\u5904\u7406\u4e0d\u89c4\u5219API\u54cd\u5e94\u3001\u6570\u636e\u6e05\u6d17\u548c\u7ed3\u6784\u5316\u7684\u6280\u5de7\uff0c\u63d0\u9ad8\u6570\u636e\u5206\u6790\u6548\u7387\u3002\u9002\u5408\u6570\u636e\u5206\u6790\u5e08\u548cPython\u5f00\u53d1\u8005\u53c2\u8003\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python\u6570\u636e\u5904\u7406\uff1a\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6pandas DataFrame\u7684\u5b8c\u6574\u6307\u5357\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e\",\"name\":\"\u79d1, \u9896\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g\",\"caption\":\"\u79d1, \u9896\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/keying\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Python\u6570\u636e\u5904\u7406\uff1a\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6pandas DataFrame\u7684\u5b8c\u6574\u6307\u5357 - Blog - Silicon Cloud","description":"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528Python\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6\u6570\u636e\u5e76\u8f6c\u6362\u4e3apandas DataFrame\u3002\u901a\u8fc7\u5b9e\u9645\u6848\u4f8b\uff0c\u5b66\u4e60\u5904\u7406\u4e0d\u89c4\u5219API\u54cd\u5e94\u3001\u6570\u636e\u6e05\u6d17\u548c\u7ed3\u6784\u5316\u7684\u6280\u5de7\uff0c\u63d0\u9ad8\u6570\u636e\u5206\u6790\u6548\u7387\u3002\u9002\u5408\u6570\u636e\u5206\u6790\u5e08\u548cPython\u5f00\u53d1\u8005\u53c2\u8003\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\/zh\/blog\/\u5982\u4f55\u4ece\u65e0\u5e8f\u7684api\u7aef\u70b9\u83b7\u53d6pandas-dataframe\/","og_locale":"zh_CN","og_type":"article","og_title":"Python\u6570\u636e\u5904\u7406\uff1a\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6pandas DataFrame\u7684\u5b8c\u6574\u6307\u5357","og_description":"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528Python\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6\u6570\u636e\u5e76\u8f6c\u6362\u4e3apandas DataFrame\u3002\u901a\u8fc7\u5b9e\u9645\u6848\u4f8b\uff0c\u5b66\u4e60\u5904\u7406\u4e0d\u89c4\u5219API\u54cd\u5e94\u3001\u6570\u636e\u6e05\u6d17\u548c\u7ed3\u6784\u5316\u7684\u6280\u5de7\uff0c\u63d0\u9ad8\u6570\u636e\u5206\u6790\u6548\u7387\u3002\u9002\u5408\u6570\u636e\u5206\u6790\u5e08\u548cPython\u5f00\u53d1\u8005\u53c2\u8003\u3002","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5982\u4f55\u4ece\u65e0\u5e8f\u7684api\u7aef\u70b9\u83b7\u53d6pandas-dataframe\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-04-04T12:47:23+00:00","article_modified_time":"2025-08-03T09:11:32+00:00","author":"\u79d1, \u9896","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u79d1, \u9896","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"4 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe\/","name":"Python\u6570\u636e\u5904\u7406\uff1a\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6pandas DataFrame\u7684\u5b8c\u6574\u6307\u5357 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-04-04T12:47:23+00:00","dateModified":"2025-08-03T09:11:32+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e"},"description":"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u4f7f\u7528Python\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6\u6570\u636e\u5e76\u8f6c\u6362\u4e3apandas DataFrame\u3002\u901a\u8fc7\u5b9e\u9645\u6848\u4f8b\uff0c\u5b66\u4e60\u5904\u7406\u4e0d\u89c4\u5219API\u54cd\u5e94\u3001\u6570\u636e\u6e05\u6d17\u548c\u7ed3\u6784\u5316\u7684\u6280\u5de7\uff0c\u63d0\u9ad8\u6570\u636e\u5206\u6790\u6548\u7387\u3002\u9002\u5408\u6570\u636e\u5206\u6790\u5e08\u548cPython\u5f00\u53d1\u8005\u53c2\u8003\u3002","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"Python\u6570\u636e\u5904\u7406\uff1a\u4ece\u65e0\u5e8fAPI\u7aef\u70b9\u83b7\u53d6pandas DataFrame\u7684\u5b8c\u6574\u6307\u5357"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e","name":"\u79d1, \u9896","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g","caption":"\u79d1, \u9896"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/keying\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%a6%82%e4%bd%95%e4%bb%8e%e6%97%a0%e5%ba%8f%e7%9a%84api%e7%ab%af%e7%82%b9%e8%8e%b7%e5%8f%96pandas-dataframe\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/902","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=902"}],"version-history":[{"count":4,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/902\/revisions"}],"predecessor-version":[{"id":110891,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/902\/revisions\/110891"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}