{"id":287,"date":"2021-03-30T09:21:00","date_gmt":"2021-03-30T01:21:00","guid":{"rendered":""},"modified":"2023-01-17T17:20:08","modified_gmt":"2023-01-17T09:20:08","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98%ef%bc%9a%e5%af%a6%e9%a9%97%e8%a8%ad%e8%a8%88%e7%b5%84%e5%90%88%e4%b8%80","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/287\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18\uff1a\u5be6\u9a57\u8a2d\u8a08\u7d44\u5408(\u4e00)"},"content":{"rendered":"

 \u672c\u6587\u7684\u8d77\u6e90\u4f86\u81ea\u65bciThelp\u4e2d\u7db2\u53cb\u7684\u63d0\u554f\uff1a<\/p>\n

python \u8cc7\u6599\u8655\u7406<\/a><\/p>\n

\u7a0b\u5f0f\u78bc\u662f\u6211\u81ea\u5df2\u5beb\u7684\u3002<\/p>\n

\n
\n
\n
\n
\n
import<\/span> pandas<\/span> as<\/span> pd<\/span>\nimport<\/span> numpy<\/span> as<\/span> np<\/span>\ndf1<\/span> =<\/span> pd<\/span>.<\/span>read_excel<\/span>(<\/span>'\u5be6\u9a57\u8a2d\u8a08\u8a66\u89e3.xlsx'<\/span>,<\/span> sheet_name<\/span> =<\/span> '\u5be6\u9a57\u8a2d\u8a08'<\/span>)<\/span>\ndf2<\/span> =<\/span> pd<\/span>.<\/span>read_excel<\/span>(<\/span>'\u5be6\u9a57\u8a2d\u8a08\u8a66\u89e3.xlsx'<\/span>,<\/span> sheet_name<\/span> =<\/span> '\u6c34\u6e96\u8868'<\/span>)<\/span>\n\ndf<\/span> =<\/span> pd<\/span>.<\/span>DataFrame<\/span>(<\/span>np<\/span>.<\/span>full<\/span>((<\/span>6<\/span>,<\/span> 7<\/span>),<\/span> np<\/span>.<\/span>nan<\/span>))<\/span>\ndf<\/span>.<\/span>columns<\/span> =<\/span> list<\/span>(<\/span>df1<\/span>.<\/span>columns<\/span>)<\/span>\n\nprint<\/span>(<\/span>'\u5be6\u9a57\u8a2d\u8a08\u7d44\u5408\uff1a'<\/span>)<\/span>\ndf1<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
\u5be6\u9a57\u8a2d\u8a08\u7d44\u5408\uff1a\n<\/pre>\n<\/div>\n<\/div>\n
\n
Out[1]:<\/div>\n
\n
\n\n\n\n\n\n\n\n\n\n\n
<\/th>\na<\/th>\nb<\/th>\nc<\/th>\nd<\/th>\ne<\/th>\nf<\/th>\ng<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\n0<\/td>\n2<\/td>\n1<\/td>\n0<\/td>\n1<\/td>\n2<\/td>\n2<\/td>\n<\/tr>\n
1<\/th>\n1<\/td>\n1<\/td>\n2<\/td>\n1<\/td>\n0<\/td>\n1<\/td>\n0<\/td>\n<\/tr>\n
2<\/th>\n2<\/td>\n0<\/td>\n0<\/td>\n2<\/td>\n2<\/td>\n0<\/td>\n1<\/td>\n<\/tr>\n
3<\/th>\n0<\/td>\n2<\/td>\n1<\/td>\n2<\/td>\n0<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
4<\/th>\n1<\/td>\n1<\/td>\n2<\/td>\n0<\/td>\n2<\/td>\n0<\/td>\n1<\/td>\n<\/tr>\n
5<\/th>\n2<\/td>\n0<\/td>\n0<\/td>\n1<\/td>\n1<\/td>\n2<\/td>\n0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [2]:<\/div>\n
\n
\n
\n
<\/span>print<\/span>(<\/span>'\u6c34\u6e96\u8868\uff1a'<\/span>)<\/span>\ndf2<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
\u6c34\u6e96\u8868\uff1a\n<\/pre>\n<\/div>\n<\/div>\n
\n
Out[2]:<\/div>\n
\n
\n\n\n\n\n\n\n\n
<\/th>\n\u6c34\u6e96<\/th>\na<\/th>\nb<\/th>\nc<\/th>\nd<\/th>\ne<\/th>\nf<\/th>\ng<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\n0<\/td>\n24<\/td>\n1<\/td>\n32<\/td>\nSigmoid<\/td>\nSGD<\/td>\n64<\/td>\n0.01<\/td>\n<\/tr>\n
1<\/th>\n1<\/td>\n72<\/td>\n3<\/td>\n64<\/td>\nTanh<\/td>\nRMSprop<\/td>\n128<\/td>\n0.05<\/td>\n<\/tr>\n
2<\/th>\n2<\/td>\n144<\/td>\n6<\/td>\n128<\/td>\nReLU<\/td>\nAdam<\/td>\n256<\/td>\n0.10<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [3]:<\/div>\n
\n
\n
\n
<\/span>print<\/span>(<\/span>'\u9810\u671f\u7d50\u679c\uff1a'<\/span>)<\/span>\ndf<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
\u9810\u671f\u7d50\u679c\uff1a\n<\/pre>\n<\/div>\n<\/div>\n
\n
Out[3]:<\/div>\n
\n
\n\n\n\n\n\n\n\n\n\n\n
<\/th>\na<\/th>\nb<\/th>\nc<\/th>\nd<\/th>\ne<\/th>\nf<\/th>\ng<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\n<\/tr>\n
1<\/th>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\n<\/tr>\n
2<\/th>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\n<\/tr>\n
3<\/th>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\n<\/tr>\n
4<\/th>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\n<\/tr>\n
5<\/th>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\nNaN<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [4]:<\/div>\n
\n
\n
\n
<\/span>print<\/span>(<\/span>'\u9019\u7a2e\u5beb\u6cd5\u6703\u6709\u8a9e\u6cd5\u4e0a\u7684\u554f\u984c\uff1a'<\/span>)<\/span>\nfor<\/span> i<\/span> in<\/span> df<\/span>.<\/span>columns<\/span>:<\/span>\n    for<\/span> j<\/span> in<\/span> df<\/span>.<\/span>index<\/span>:<\/span>\n        df<\/span>[<\/span>i<\/span>][<\/span>j<\/span>]<\/span> =<\/span> df2<\/span>[<\/span>i<\/span>][<\/span>df1<\/span>[<\/span>i<\/span>][<\/span>j<\/span>]]<\/span>\ndf<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
\u9019\u7a2e\u5beb\u6cd5\u6703\u6709\u8a9e\u6cd5\u4e0a\u7684\u554f\u984c\uff1a\n<\/pre>\n<\/div>\n<\/div>\n
\n
<\/div>\n
\n
c:userssuperuserminiconda3libsite-packagesipykernel_launcher.py:4: SettingWithCopyWarning: \nA value is trying to be set on a copy of a slice from a DataFrame\n\nSee the caveats in the documentation: http:\/\/pandas.pydata.org\/pandas-docs\/stable\/user_guide\/indexing.html#returning-a-view-versus-a-copy\n  after removing the cwd from sys.path.\nc:userssuperuserminiconda3libsite-packagespandascoreindexing.py:205: SettingWithCopyWarning: \nA value is trying to be set on a copy of a slice from a DataFrame\n\nSee the caveats in the documentation: http:\/\/pandas.pydata.org\/pandas-docs\/stable\/user_guide\/indexing.html#returning-a-view-versus-a-copy\n  self._setitem_with_indexer(indexer, value)\n<\/pre>\n<\/div>\n<\/div>\n
\n
Out[4]:<\/div>\n
\n
\n\n\n\n\n\n\n\n\n\n\n
<\/th>\na<\/th>\nb<\/th>\nc<\/th>\nd<\/th>\ne<\/th>\nf<\/th>\ng<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\n24.0<\/td>\n6.0<\/td>\n64.0<\/td>\nSigmoid<\/td>\nRMSprop<\/td>\n256.0<\/td>\n0.10<\/td>\n<\/tr>\n
1<\/th>\n72.0<\/td>\n3.0<\/td>\n128.0<\/td>\nTanh<\/td>\nSGD<\/td>\n128.0<\/td>\n0.01<\/td>\n<\/tr>\n
2<\/th>\n144.0<\/td>\n1.0<\/td>\n32.0<\/td>\nReLU<\/td>\nAdam<\/td>\n64.0<\/td>\n0.05<\/td>\n<\/tr>\n
3<\/th>\n24.0<\/td>\n6.0<\/td>\n64.0<\/td>\nReLU<\/td>\nSGD<\/td>\n128.0<\/td>\n0.10<\/td>\n<\/tr>\n
4<\/th>\n72.0<\/td>\n3.0<\/td>\n128.0<\/td>\nSigmoid<\/td>\nAdam<\/td>\n64.0<\/td>\n0.05<\/td>\n<\/tr>\n
5<\/th>\n144.0<\/td>\n1.0<\/td>\n32.0<\/td>\nTanh<\/td>\nRMSprop<\/td>\n256.0<\/td>\n0.01<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [5]:<\/div>\n
\n
\n
\n
<\/span>print<\/span>(<\/span>'\u53e6\u4e00\u7a2e\u66f4\u6709\u6548\u7387\u7684\u5beb\u6cd5\uff1a'<\/span>)<\/span>\ndf<\/span> =<\/span> pd<\/span>.<\/span>DataFrame<\/span>(<\/span>np<\/span>.<\/span>full<\/span>((<\/span>6<\/span>,<\/span> 7<\/span>),<\/span> np<\/span>.<\/span>nan<\/span>))<\/span>\ndf<\/span>.<\/span>columns<\/span> =<\/span> list<\/span>(<\/span>df1<\/span>.<\/span>columns<\/span>)<\/span>\n\nfor<\/span> x<\/span> in<\/span> df<\/span>.<\/span>columns<\/span>:<\/span>\n  for<\/span> y<\/span> in<\/span> df2<\/span>.<\/span>index<\/span>:<\/span>\n    df<\/span>[<\/span>x<\/span>]<\/span> =<\/span> np<\/span>.<\/span>where<\/span>(<\/span>df1<\/span>[<\/span>x<\/span>]<\/span> ==<\/span> y<\/span>,<\/span> df2<\/span>[<\/span>x<\/span>][<\/span>y<\/span>],<\/span> df<\/span>[<\/span>x<\/span>])<\/span>\ndf<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
\u53e6\u4e00\u7a2e\u66f4\u6709\u6548\u7387\u7684\u5beb\u6cd5\uff1a\n<\/pre>\n<\/div>\n<\/div>\n
\n
Out[5]:<\/div>\n
\n
\n\n\n\n\n\n\n\n\n\n\n
<\/th>\na<\/th>\nb<\/th>\nc<\/th>\nd<\/th>\ne<\/th>\nf<\/th>\ng<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\n24.0<\/td>\n6.0<\/td>\n64.0<\/td>\nSigmoid<\/td>\nRMSprop<\/td>\n256.0<\/td>\n0.10<\/td>\n<\/tr>\n
1<\/th>\n72.0<\/td>\n3.0<\/td>\n128.0<\/td>\nTanh<\/td>\nSGD<\/td>\n128.0<\/td>\n0.01<\/td>\n<\/tr>\n
2<\/th>\n144.0<\/td>\n1.0<\/td>\n32.0<\/td>\nReLU<\/td>\nAdam<\/td>\n64.0<\/td>\n0.05<\/td>\n<\/tr>\n
3<\/th>\n24.0<\/td>\n6.0<\/td>\n64.0<\/td>\nReLU<\/td>\nSGD<\/td>\n128.0<\/td>\n0.10<\/td>\n<\/tr>\n
4<\/th>\n72.0<\/td>\n3.0<\/td>\n128.0<\/td>\nSigmoid<\/td>\nAdam<\/td>\n64.0<\/td>\n0.05<\/td>\n<\/tr>\n
5<\/th>\n144.0<\/td>\n1.0<\/td>\n32.0<\/td>\nTanh<\/td>\nRMSprop<\/td>\n256.0<\/td>\n0.01<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [6]:<\/div>\n
\n
\n
\n
<\/span>print<\/span>(<\/span>'\u6539\u826f\u81ea\u7b2c\u4e00\u7a2e\uff0c\u4fee\u6b63\u8a9e\u6cd5\uff1a'<\/span>)<\/span>\ndf<\/span> =<\/span> df1<\/span>\n\nfor<\/span> x<\/span> in<\/span> df<\/span>.<\/span>columns<\/span>:<\/span>\n  for<\/span> y<\/span> in<\/span> df2<\/span>.<\/span>index<\/span>:<\/span>\n    df<\/span>.<\/span>loc<\/span>[<\/span>df<\/span>[<\/span>x<\/span>]<\/span> ==<\/span> y<\/span>,<\/span> x<\/span>]<\/span> =<\/span> df2<\/span>[<\/span>x<\/span>][<\/span>y<\/span>]<\/span>\ndf<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
\u6539\u826f\u81ea\u7b2c\u4e00\u7a2e\uff0c\u4fee\u6b63\u8a9e\u6cd5\uff1a\n<\/pre>\n<\/div>\n<\/div>\n
\n
Out[6]:<\/div>\n
\n
\n\n\n\n\n\n\n\n\n\n\n
<\/th>\na<\/th>\nb<\/th>\nc<\/th>\nd<\/th>\ne<\/th>\nf<\/th>\ng<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\n24<\/td>\n6<\/td>\n64<\/td>\nSigmoid<\/td>\nRMSprop<\/td>\n256<\/td>\n0.10<\/td>\n<\/tr>\n
1<\/th>\n72<\/td>\n3<\/td>\n128<\/td>\nTanh<\/td>\nSGD<\/td>\n128<\/td>\n0.01<\/td>\n<\/tr>\n
2<\/th>\n144<\/td>\n3<\/td>\n32<\/td>\nReLU<\/td>\nAdam<\/td>\n64<\/td>\n0.05<\/td>\n<\/tr>\n
3<\/th>\n24<\/td>\n6<\/td>\n64<\/td>\nReLU<\/td>\nSGD<\/td>\n128<\/td>\n0.10<\/td>\n<\/tr>\n
4<\/th>\n72<\/td>\n3<\/td>\n128<\/td>\nSigmoid<\/td>\nAdam<\/td>\n64<\/td>\n0.05<\/td>\n<\/tr>\n
5<\/th>\n144<\/td>\n3<\/td>\n32<\/td>\nTanh<\/td>\nRMSprop<\/td>\n256<\/td>\n0.01<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
 \u672c\u6587\u7684\u8d77\u6e90\u4f86\u81ea\u65bciThelp\u4e2d\u7db2\u53cb\u7684\u63d0\u554f\uff1a python \u8cc7\u6599\u8655\u7406 \u7a0b\u5f0f\u78bc\u662f\u6211\u81ea\u5df2\u5beb\u7684\u3002 impo […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}}},"categories":[4],"tags":[262,263,9,254],"author_meta":{"display_name":"mackuo","author_link":"https:\/\/kuo.us.to\/wordpress\/author\/mackuo\/"},"featured_img":null,"coauthors":[],"tax_additional":{"categories":{"linked":["Python\u5b78\u7fd2\u7b46\u8a18<\/a>"],"unlinked":["Python\u5b78\u7fd2\u7b46\u8a18<\/span>"]},"tags":{"linked":["np.where<\/a>","numpy<\/a>","Python<\/a>","\u5be6\u9a57\u8a2d\u8a08<\/a>"],"unlinked":["np.where<\/span>","numpy<\/span>","Python<\/span>","\u5be6\u9a57\u8a2d\u8a08<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 5 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2021 \u5e74 3 \u6708 30 \u65e5","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5"},"absolute_dates_time":{"created":"Posted on 2021 \u5e74 3 \u6708 30 \u65e5 \u4e0a\u5348 9:21","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5 \u4e0b\u5348 5:20"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/287"}],"collection":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/comments?post=287"}],"version-history":[{"count":2,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/287\/revisions"}],"predecessor-version":[{"id":652,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/287\/revisions\/652"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}