{"id":12418,"date":"2021-05-28T20:15:27","date_gmt":"2021-05-29T01:15:27","guid":{"rendered":"httpss:\/\/www.powenko.com\/wordpress\/docs\/python\/pandas\/%e5%9d%87%e4%b8%80%e5%8c%96\/"},"modified":"2021-05-28T20:45:39","modified_gmt":"2021-05-29T01:45:39","slug":"%e5%9d%87%e4%b8%80%e5%8c%96","status":"publish","type":"docs","link":"https:\/\/www.powenko.com\/wordpress\/?docs=python\/pandas\/%e5%9d%87%e4%b8%80%e5%8c%96","title":{"rendered":"\u5747\u4e00\u5316"},"content":{"rendered":"<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\ndf = pd.read_excel('\u6843\u5712\u5168\u5340\u5be6\u50f9\u767b\u9304\u8cc7\u6599_20190430\u4fee\u6539\u5f8c_\u8f49\u6578\u5b57_lite.xls',0)\r\n\r\n#\u5168\u90e8\u7684\u7a7a\u767d\r\ndf=df.fillna(-1)\r\n\r\nprint(df.head())\r\nprint(df.columns)\r\nprint(df.index)\r\nprint(df.columns)\r\n\r\ncolumnsName=&#x5B;'\u9109\u93ae\u5e02\u5340_Code','\u4ea4\u6613\u6a19\u7684_Code','\u571f\u5730\u5340\u6bb5\u4f4d\u7f6e\u5efa\u7269\u5340\u6bb5\u9580\u724c_Code']\r\ndfX=df&#x5B;columnsName]\r\ndfY=df&#x5B;\"\u7e3d\u50f9\u5143\"]\r\n\r\ndfX = (dfX - dfX.min()) \/ (dfX.max() - dfX.min())\r\n\r\ndfY = (dfY - dfY2.min()) \/ (dfY2.max() - dfY2.min())  # \u5747\u4e00\u5316\r\n\r\nX=dfX.to_numpy()\r\nY=dfY.to_numpy()\r\nX_train ,X_test ,Y_train ,Y_test = train_test_split(X,Y,test_size=0.01)\r\n<\/pre>\n","protected":false},"featured_media":0,"parent":12417,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-12418","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/docs\/12418"}],"collection":[{"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12418"}],"version-history":[{"count":3,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/docs\/12418\/revisions"}],"predecessor-version":[{"id":12460,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/docs\/12418\/revisions\/12460"}],"up":[{"embeddable":true,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/docs\/12417"}],"next":[{"title":"\u7e6a\u5716-\u4e2d\u6587","link":"https:\/\/www.powenko.com\/wordpress\/?docs=python\/pandas\/%e7%b9%aa%e5%9c%96-%e4%b8%ad%e6%96%87","href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/docs\/12456"}],"prev":[{"title":"\u6587\u5b57\u5206\u985e\u8f49\u6578\u5b57\u4ee3\u865f","link":"https:\/\/www.powenko.com\/wordpress\/?docs=python\/pandas\/%e6%96%87%e5%ad%97%e5%88%86%e9%a1%9e%e8%bd%89%e6%95%b8%e5%ad%97%e4%bb%a3%e8%99%9f","href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/docs\/12450"}],"wp:attachment":[{"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12418"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_tag&post=12418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}