{"id":283,"date":"2021-12-13T14:03:00","date_gmt":"2021-12-13T06:03:00","guid":{"rendered":""},"modified":"2023-01-17T17:07:15","modified_gmt":"2023-01-17T09:07:15","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%ba%8c_%e5%8f%a6%e8%a7%a3","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/283\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18\uff1a\u5be6\u9a57\u8a2d\u8a08\u7d44\u5408(\u4e8c)_\u53e6\u89e3"},"content":{"rendered":"

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

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

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

110\/12\/13 \u53e6\u4e00\u7a2e\u5beb\u6cd5\uff1a<\/p>\n

\n
\n
\n
\n
\n
\n
import<\/span> pandas<\/span> as<\/span> pd<\/span>\nimport<\/span> numpy<\/span> as<\/span> np<\/span>\n\ndf<\/span> =<\/span> pd<\/span>.<\/span>DataFrame<\/span>(<\/span>\n    {<\/span>\n      'GROUP'<\/span>:<\/span>   [<\/span>'R'<\/span>,<\/span>'W'<\/span>,<\/span>'W'<\/span>,<\/span>'R'<\/span>,<\/span>'R'<\/span>,<\/span>'W'<\/span>],<\/span>\n      'GOAT'<\/span>:<\/span>    [<\/span>'15\/10'<\/span>,<\/span>'10\/7\/11'<\/span>,<\/span>'9'<\/span>,<\/span>'12'<\/span>,<\/span>'8\/13'<\/span>,<\/span>'10'<\/span>],<\/span>\n      'TYPE'<\/span>:<\/span>    [<\/span>'A\/B'<\/span>,<\/span>'A\/B\/B'<\/span>,<\/span>'A'<\/span>,<\/span>'B'<\/span>,<\/span>'B\/A'<\/span>,<\/span>'B'<\/span>],<\/span>\n      'TIME'<\/span>:<\/span> [<\/span>2<\/span>,<\/span>3<\/span>,<\/span>2<\/span>,<\/span>2<\/span>,<\/span>3<\/span>,<\/span>2<\/span>]<\/span>\n    }<\/span>\n)<\/span>\n\ndf<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[1]:<\/div>\n
\n
\n\n\n\n\n\n\n\n\n\n\n
<\/th>\nGROUP<\/th>\nGOAT<\/th>\nTYPE<\/th>\nTIME<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\nR<\/td>\n15\/10<\/td>\nA\/B<\/td>\n2<\/td>\n<\/tr>\n
1<\/th>\nW<\/td>\n10\/7\/11<\/td>\nA\/B\/B<\/td>\n3<\/td>\n<\/tr>\n
2<\/th>\nW<\/td>\n9<\/td>\nA<\/td>\n2<\/td>\n<\/tr>\n
3<\/th>\nR<\/td>\n12<\/td>\nB<\/td>\n2<\/td>\n<\/tr>\n
4<\/th>\nR<\/td>\n8\/13<\/td>\nB\/A<\/td>\n3<\/td>\n<\/tr>\n
5<\/th>\nW<\/td>\n10<\/td>\nB<\/td>\n2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
In [2]:<\/div>\n
\n
\n
\n
<\/span>go<\/span> =<\/span> df<\/span>[<\/span>'GOAT'<\/span>]<\/span>.<\/span>str<\/span>.<\/span>split<\/span>(<\/span>'\/'<\/span>)<\/span>\nty<\/span> =<\/span> df<\/span>[<\/span>'TYPE'<\/span>]<\/span>.<\/span>str<\/span>.<\/span>split<\/span>(<\/span>'\/'<\/span>)<\/span>\nco<\/span> =<\/span> range<\/span>(<\/span>len<\/span>(<\/span>df<\/span>))<\/span>\nresult<\/span> =<\/span> []<\/span>\nfor<\/span> a<\/span>,<\/span> b<\/span>,<\/span> c<\/span> in<\/span> zip<\/span>(<\/span>go<\/span>,<\/span> ty<\/span>,<\/span> co<\/span>):<\/span>\n    re<\/span> =<\/span> []<\/span>\n    for<\/span> i<\/span> in<\/span> range<\/span>(<\/span>len<\/span>(<\/span>b<\/span>)):<\/span>\n        gr<\/span> =<\/span> df<\/span>[<\/span>'GROUP'<\/span>][<\/span>c<\/span>]<\/span>\n        ti<\/span> =<\/span> df<\/span>[<\/span>'TIME'<\/span>][<\/span>c<\/span>]<\/span>\n        if<\/span> ((<\/span>gr<\/span> ==<\/span> 'R'<\/span>)<\/span> &<\/span> (<\/span>b<\/span>[<\/span>i<\/span>]<\/span> ==<\/span> 'A'<\/span>)):<\/span>\n            r<\/span> =<\/span> int<\/span>(<\/span>a<\/span>[<\/span>i<\/span>])<\/span>*<\/span>int<\/span>(<\/span>ti<\/span>)<\/span>*<\/span>0.3<\/span>\n        elif<\/span> ((<\/span>gr<\/span> ==<\/span> 'R'<\/span>)<\/span> &<\/span> (<\/span>b<\/span>[<\/span>i<\/span>]<\/span> ==<\/span> 'B'<\/span>)):<\/span>\n            r<\/span> =<\/span> int<\/span>(<\/span>a<\/span>[<\/span>i<\/span>])<\/span>*<\/span>int<\/span>(<\/span>ti<\/span>)<\/span>*<\/span>0.5<\/span>\n        elif<\/span> ((<\/span>gr<\/span> ==<\/span> 'W'<\/span>)<\/span> &<\/span> (<\/span>b<\/span>[<\/span>i<\/span>]<\/span> ==<\/span> 'A'<\/span>)):<\/span>\n            r<\/span> =<\/span> int<\/span>(<\/span>a<\/span>[<\/span>i<\/span>])<\/span>*<\/span>int<\/span>(<\/span>ti<\/span>)<\/span>*<\/span>0.4<\/span>\n        elif<\/span> ((<\/span>gr<\/span> ==<\/span> 'W'<\/span>)<\/span> &<\/span> (<\/span>b<\/span>[<\/span>i<\/span>]<\/span> ==<\/span> 'B'<\/span>)):<\/span>\n            r<\/span> =<\/span> int<\/span>(<\/span>a<\/span>[<\/span>i<\/span>])<\/span>*<\/span>int<\/span>(<\/span>ti<\/span>)<\/span>*<\/span>0.3<\/span>\n\n        li<\/span> =<\/span> str<\/span>(<\/span>r<\/span>)<\/span>\n        re<\/span>.<\/span>append<\/span>(<\/span>li<\/span>)<\/span>\n        #print(a[i], b[i], gr, ti, r)<\/span>\n    #print('\/'.join(re))<\/span>\n    result<\/span>.<\/span>append<\/span>(<\/span>'\/'<\/span>.<\/span>join<\/span>(<\/span>re<\/span>))<\/span>\n    \ndf<\/span>[<\/span>'RESULT'<\/span>]<\/span> =<\/span> result<\/span>\ndf<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[2]:<\/div>\n
\n
\n\n\n\n\n\n\n\n\n\n\n
<\/th>\nGROUP<\/th>\nGOAT<\/th>\nTYPE<\/th>\nTIME<\/th>\nRESULT<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\nR<\/td>\n15\/10<\/td>\nA\/B<\/td>\n2<\/td>\n9.0\/10.0<\/td>\n<\/tr>\n
1<\/th>\nW<\/td>\n10\/7\/11<\/td>\nA\/B\/B<\/td>\n3<\/td>\n12.0\/6.3\/9.9<\/td>\n<\/tr>\n
2<\/th>\nW<\/td>\n9<\/td>\nA<\/td>\n2<\/td>\n7.2<\/td>\n<\/tr>\n
3<\/th>\nR<\/td>\n12<\/td>\nB<\/td>\n2<\/td>\n12.0<\/td>\n<\/tr>\n
4<\/th>\nR<\/td>\n8\/13<\/td>\nB\/A<\/td>\n3<\/td>\n12.0\/11.7<\/td>\n<\/tr>\n
5<\/th>\nW<\/td>\n10<\/td>\nB<\/td>\n2<\/td>\n6.0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
In [ ]:<\/div>\n
\n
\n
\n
<\/span><\/pre>\n<\/div>\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\u8acb\u6559 \u7a0b\u5f0f\u78bc\u662f\u6211\u81ea\u5df2\u5beb\u7684\u3002 110 […]<\/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":[8,9],"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":["Pandas<\/a>","Python<\/a>"],"unlinked":["Pandas<\/span>","Python<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 4 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2021 \u5e74 12 \u6708 13 \u65e5","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5"},"absolute_dates_time":{"created":"Posted on 2021 \u5e74 12 \u6708 13 \u65e5 \u4e0b\u5348 2:03","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5 \u4e0b\u5348 5:07"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/283"}],"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=283"}],"version-history":[{"count":2,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/283\/revisions"}],"predecessor-version":[{"id":647,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/283\/revisions\/647"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}