{"rsdb":{"rid":"372620","subhead":"","postdate":"0","aid":"261545","fid":"57","uid":"1","topic":"1","content":"<div id=\"cnblogs_post_body\" class=\"blogpost-body \"> \n <h1 class=\"md-end-block md-heading md-focus\"><span class=\"md-plain md-expand\">\u5229\u7528 pandas\u5e93\u8bfb\u53d6excel\u8868\u683c\u6570\u636e<\/span><\/h1> \n <h4 class=\"md-end-block md-heading\"><span class=\"md-plain md-expand\">\u521d\u5165IT\u884c\u4e1a\uff0c\u613f\u4e0e\u5927\u5bb6\u4e00\u8d77\u5b66\u4e60\uff0c\u5171\u540c\u8fdb\u6b65\uff0c\u6709\u95ee\u9898\u8bf7\u6307\u51fa\uff01\uff01<\/span><\/h4> \n <p><span class=\"md-plain md-expand\">\u8fd8\u5728\u4e3a\u6570\u636e\u8bfb\u53d6\u800c\u5934\u75bc\u5462\uff0c\u8bf7\u770b\u4e0b\u65b9\u7b80\u6d01\u4ecb\u7ecd\uff1a<\/span><\/p> \n <p class=\"md-end-block md-p\"><span class=\"md-plain\">\u6570\u636e\u6765\u6e90\u4e3a\u56fd\u5bb6\u7edf\u8ba1\u5c40\u7f51\u7ad9\u4e0b\u8f7d\uff1a<\/span><\/p> \n <p class=\"md-end-block md-p\"><img src=\"https:\/\/img2018.cnblogs.com\/blog\/1690387\/201909\/1690387-20190919005353862-2127402914.png\" alt=\"\" \/><\/p> \n <p class=\"md-end-block md-p\"><span class=\"md-plain\">\u5177\u4f53\u65b9\u6cd5 \u4ee3\u7801\uff1a<\/span><\/p> \n <pre class=\"md-fences md-end-block ty-contain-cm modeLoaded\"><span><span class=\"cm-keyword\">import <span class=\"cm-variable\">pandas <span class=\"cm-keyword\">as <span class=\"cm-variable\">pd<br \/><span><span>?<br \/><span><span class=\"cm-variable\">df = <span class=\"cm-variable\">pd.<span class=\"cm-property\">read_excel(<span class=\"cm-string\">'quanguojingji10nian.xls')<span class=\"cm-comment\">#\u73b0\u5728Excel\u8868\u683c\u4e0epy\u4ee3\u7801\u653e\u5728\u4e00\u4e2a\u6587\u4ef6\u5939\u91cc<br \/><span><span>?<br \/><span><span class=\"cm-variable\">x=<span class=\"cm-variable\">df[<span class=\"cm-string\">'\u6307\u6807']<span class=\"cm-comment\">#\u8bfb\u53d6\u7b2c\u4e00\u5217\u6570\u636e<br \/><span><span class=\"cm-builtin\">print(<span class=\"cm-variable\">x);<span class=\"cm-comment\">#\u628a'\u6307\u6807\u6362\u6210\u5176\u4ed6\u5217\u5730\u5217\u540d\uff0c\u5c31\u80fd\u8bfb\u5176\u4ed6\u5217'<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/pre> \n <p class=\"md-end-block md-p\"><span class=\"md-plain\"> \u7ed3\u679c\uff1a<\/span><\/p> \n <p class=\"md-end-block md-p\"><img src=\"https:\/\/img2018.cnblogs.com\/blog\/1690387\/201909\/1690387-20190919005631431-1782984136.png\" alt=\"\" \/><\/p> \n <p class=\"md-end-block md-p\"><span class=\"md-plain\">\u8bfb\u51fax\u5217\u7684\u7ed3\u679c\u53ef\u4ee5\u7528matplotlib.pyplot\u5e93\u7ed8\u5236\u76f4\u7ebf\u56fe\u3001\u997c\u56fe\u3001\u6298\u7ebf\u56fe<\/span><\/p> \n <p><span class=\"md-plain\">&nbsp;<\/span><\/p> \n<\/div>","orderid":"0","title":"\u5229\u7528 pandas\u5e93\u8bfb\u53d6excel\u8868\u683c\u6570\u636e","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"60","pages":"1","comments":"0","posttime":"2019-09-19 11:12:01","list":"1568862721","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"<A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%C0%FB%D3%C3' target=_blank>\u5229\u7528<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=pandas' target=_blank>pandas<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%B6%C1%C8%A1' target=_blank>\u8bfb\u53d6<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=excel' target=_blank>excel<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%B1%ED%B8%F1' target=_blank>\u8868\u683c<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%CA%FD%BE%DD' target=_blank>\u6570\u636e<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"14.17.22.32","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"\u5229\u7528 pandas\u5e93\u8bfb\u53d6excel\u8868\u683c\u6570\u636e","lastview":"1712928786","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}