{"id":12450,"date":"2021-05-28T20:38:41","date_gmt":"2021-05-29T01:38:41","guid":{"rendered":"httpss:\/\/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\/"},"modified":"2021-05-28T20:45:39","modified_gmt":"2021-05-29T01:45:39","slug":"%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","status":"publish","type":"docs","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","title":{"rendered":"\u6587\u5b57\u5206\u985e\u8f49\u6578\u5b57\u4ee3\u865f"},"content":{"rendered":"<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n\r\n#!\/usr\/bin\/env python\r\n# -*- coding=utf-8 -*-\r\n# pip install seaborn\r\n__author__ = &quot;\u67ef\u535a\u6587\u8001\u5e2b Powen Ko, www.powenko.com&quot;\r\n \r\nimport xlrd\r\nimport xlwt\r\n\r\nimport pandas as pd\r\n\r\n \r\n\r\n#read data\r\ndf = pd.read_csv('adult.csv')\r\n\r\nprint(df.head())\r\nprint(df.columns)\r\nprint(df.index)\r\nprint(df.columns)\r\n \r\ncolumnsName=&#x5B;'B','D','F','G','H','I','J','N','O']\r\n\r\nfor x in columnsName:\r\n    df&#x5B;x+'_Code'] = df&#x5B;x].astype(&quot;category&quot;).cat.codes\r\n\r\n#df&#x5B;'Spectral_Class_Code'] = df&#x5B;'Spectral_Class'].astype(&quot;category&quot;).cat.codes\r\n\r\nprint(df.head())\r\n\r\ndf.to_excel(&quot;adult.xlsx&quot;)\r\n\r\n\r\n\r\n\r\n<\/pre>\n","protected":false},"featured_media":0,"parent":12417,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-12450","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/docs\/12450"}],"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=12450"}],"version-history":[{"count":3,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/docs\/12450\/revisions"}],"predecessor-version":[{"id":12453,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/docs\/12450\/revisions\/12453"}],"up":[{"embeddable":true,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/docs\/12417"}],"next":[{"title":"\u5747\u4e00\u5316","link":"https:\/\/www.powenko.com\/wordpress\/?docs=python\/pandas\/%e5%9d%87%e4%b8%80%e5%8c%96","href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/docs\/12418"}],"prev":[{"title":"Pandas\u8f49numpy","link":"https:\/\/www.powenko.com\/wordpress\/?docs=python\/pandas\/pandas%e8%bd%89numpy","href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/docs\/12421"}],"wp:attachment":[{"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12450"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_tag&post=12450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}