{"id":274,"date":"2022-06-23T11:17:00","date_gmt":"2022-06-23T03:17:00","guid":{"rendered":""},"modified":"2023-01-17T16:52:51","modified_gmt":"2023-01-17T08:52:51","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-%e6%ad%a3%e5%89%87%e8%a1%a8%e9%81%94%e5%bc%8f_regex1","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/274\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: \u6b63\u5247\u8868\u9054\u5f0f_Regex(1)"},"content":{"rendered":"
\n
\n
\n
\n
\n
\n
import<\/span> pandas<\/span> as<\/span> pd<\/span>\nfile_location<\/span> =<\/span> '0000_\u5b78\u751f\u8cc7\u6599\u7bc4\u4f8b\u6a94.xlsx'<\/span>\ndf<\/span> =<\/span> pd<\/span>.<\/span>read_excel<\/span>(<\/span>file_location<\/span>)<\/span>\n\nprint<\/span>(<\/span>len<\/span>(<\/span>df<\/span>))<\/span>\nprint<\/span>(<\/span>df<\/span>.<\/span>columns<\/span>)<\/span>\ndf<\/span>.<\/span>info<\/span>()<\/span>\ndf<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
17\nIndex(['\u5b78\u865f', '\u51fa\u751f\u5e74\u6708\u65e5', '\u6027\u5225', '\u4e2d\u6587\u59d3\u540d', '\u90e8\u5225', '\u7cfb\u6240'], dtype='object')\n<class 'pandas.core.frame.DataFrame'>\nRangeIndex: 17 entries, 0 to 16\nData columns (total 6 columns):\n #   Column  Non-Null Count  Dtype \n---  ------  --------------  ----- \n 0   \u5b78\u865f      17 non-null     object\n 1   \u51fa\u751f\u5e74\u6708\u65e5   17 non-null     int64 \n 2   \u6027\u5225      17 non-null     object\n 3   \u4e2d\u6587\u59d3\u540d    17 non-null     object\n 4   \u90e8\u5225      17 non-null     object\n 5   \u7cfb\u6240      17 non-null     object\ndtypes: int64(1), object(5)\nmemory usage: 944.0+ bytes\n<\/pre>\n<\/div>\n<\/div>\n
\n
Out[1]:<\/div>\n
\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
<\/th>\n\u5b78\u865f<\/th>\n\u51fa\u751f\u5e74\u6708\u65e5<\/th>\n\u6027\u5225<\/th>\n\u4e2d\u6587\u59d3\u540d<\/th>\n\u90e8\u5225<\/th>\n\u7cfb\u6240<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\nU1002252<\/td>\n650502<\/td>\n\u5973<\/td>\n\u9ec3\u6587\u6b23<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u6d41\u901a\u7ba1\u7406\u5b78\u7cfb<\/td>\n<\/tr>\n
1<\/th>\nU1007128<\/td>\n720525<\/td>\n\u7537<\/td>\n\u5f90\u7fe0\u6d0b<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u6d41\u901a\u7ba1\u7406\u5b78\u7cfb<\/td>\n<\/tr>\n
2<\/th>\nU1017113<\/td>\n721116<\/td>\n\u7537<\/td>\n\u6797\u6b23\u8679<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u6d41\u901a\u7ba1\u7406\u5b78\u7cfb<\/td>\n<\/tr>\n
3<\/th>\nU1017117<\/td>\n730224<\/td>\n\u7537<\/td>\n\u5433\u8a9e\u7fa4<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u6d41\u901a\u7ba1\u7406\u5b78\u7cfb<\/td>\n<\/tr>\n
4<\/th>\nU1017146<\/td>\n720923<\/td>\n\u7537<\/td>\n\u8a79\u4fca\u5b8f<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u6b77\u53f2\u5b78\u7cfb<\/td>\n<\/tr>\n
5<\/th>\nU1027140<\/td>\n690101<\/td>\n\u5973<\/td>\n\u6797\u7d20\u5143<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u6b77\u53f2\u5b78\u7cfb<\/td>\n<\/tr>\n
6<\/th>\nU1027153<\/td>\n700503<\/td>\n\u7537<\/td>\n\u6d2a\u5049\u8aa0<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u6b77\u53f2\u5b78\u7cfb<\/td>\n<\/tr>\n
7<\/th>\nU1017123<\/td>\n730318<\/td>\n\u5973<\/td>\n\u9ec3\u7389\u5ef7<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u6b77\u53f2\u5b78\u7cfb<\/td>\n<\/tr>\n
8<\/th>\nU1027130<\/td>\n740802<\/td>\n\u5973<\/td>\n\u9ec3\u74ca\u745e<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u96fb\u6a5f\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
9<\/th>\nU1027156<\/td>\n730607<\/td>\n\u7537<\/td>\n\u9673\u5955\u5b63<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u96fb\u6a5f\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
10<\/th>\nU1027119<\/td>\n720121<\/td>\n\u7537<\/td>\n\u85cd\u7acb\u7487<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u96fb\u6a5f\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
11<\/th>\nU1037130<\/td>\n690909<\/td>\n\u5973<\/td>\n\u6c5f\u59f5\u5229<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u96fb\u6a5f\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
12<\/th>\nU1037131<\/td>\n730118<\/td>\n\u5973<\/td>\n\u6797\u65b0\u4e91<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u793e\u6703\u5b78\u7cfb<\/td>\n<\/tr>\n
13<\/th>\nU1047102<\/td>\n751123<\/td>\n\u5973<\/td>\n\u8a79\u6dd1\u73b2<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u793e\u6703\u5b78\u7cfb<\/td>\n<\/tr>\n
14<\/th>\nU1047113<\/td>\n750903<\/td>\n\u7537<\/td>\n\u6797\u4e16\u5149<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u793e\u6703\u5b78\u7cfb<\/td>\n<\/tr>\n
15<\/th>\nU1047120<\/td>\n760907<\/td>\n\u5973<\/td>\n\u5433\u60e0\u8339<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u793e\u6703\u5b78\u7cfb<\/td>\n<\/tr>\n
16<\/th>\nU1047124<\/td>\n760227<\/td>\n\u7537<\/td>\n\u9673\u6bc5\u6587<\/td>\n\u5927\u5b78\u90e8<\/td>\n\u793e\u6703\u5b78\u7cfb<\/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
# \u5339\u914d\u5b78\u865f\u7b2c2-4\u78bc\u70ba101<\/span>\ndf<\/span>[<\/span>df<\/span>[<\/span>'\u5b78\u865f'<\/span>]<\/span>.<\/span>str<\/span>.<\/span>contains<\/span>(<\/span>r<\/span>'.101'<\/span>)][<\/span>'\u5b78\u865f'<\/span>]<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[2]:<\/div>\n
\n
2    U1017113\n3    U1017117\n4    U1017146\n7    U1017123\nName: \u5b78\u865f, dtype: object<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
In [3]:<\/div>\n
\n
\n
\n
# \u5339\u914d\u5b78\u865f\u7b2c5-6\u78bc\u70ba71<\/span>\ndf<\/span>[<\/span>df<\/span>[<\/span>'\u5b78\u865f'<\/span>]<\/span>.<\/span>str<\/span>.<\/span>contains<\/span>(<\/span>r<\/span>'....71'<\/span>)][<\/span>'\u5b78\u865f'<\/span>]<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[3]:<\/div>\n
\n
1     U1007128\n2     U1017113\n3     U1017117\n4     U1017146\n5     U1027140\n6     U1027153\n7     U1017123\n8     U1027130\n9     U1027156\n10    U1027119\n11    U1037130\n12    U1037131\n13    U1047102\n14    U1047113\n15    U1047120\n16    U1047124\nName: \u5b78\u865f, dtype: object<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
In [4]:<\/div>\n
\n
\n
\n
# \u5339\u914d\u5b78\u865f\u6700\u5f8c2\u78bc\u70ba30<\/span>\nprint<\/span>(<\/span>df<\/span>[<\/span>df<\/span>[<\/span>'\u5b78\u865f'<\/span>]<\/span>.<\/span>str<\/span>.<\/span>contains<\/span>(<\/span>r<\/span>'30\n<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
8     U1027130\n11    U1037130\nName: \u5b78\u865f, dtype: object\n8     U1027130\n11    U1037130\nName: \u5b78\u865f, dtype: object\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
In [5]:<\/div>\n
\n
\n
\n
# \u51fa\u751f\u5e74\u6708\u65e5\u7684\u6b04\u4f4d\u70ba\u6574\u6578\uff0c\u8981\u5148\u4ee5astype('str')\u8f49\u63db\u70ba\u5b57\u4e32<\/span>\n# \u5339\u914d\u51fa\u751f\u5e74\u6708\u65e5\u7b2c\u4e00\u78bc\u70ba7\u958b\u982d\u8cc7\u6599<\/span>\nprint<\/span>(<\/span>df<\/span>[<\/span>df<\/span>[<\/span>'\u51fa\u751f\u5e74\u6708\u65e5'<\/span>]<\/span>.<\/span>astype<\/span>(<\/span>'str'<\/span>)<\/span>.<\/span>str<\/span>.<\/span>contains<\/span>(<\/span>r<\/span>'^7'<\/span>)][<\/span>'\u51fa\u751f\u5e74\u6708\u65e5'<\/span>])<\/span>\n\n# \u4e0a\u9762\u7684\u7a0b\u5f0f\u78bc\u4e5f\u53ef\u4ee5startswith\u4f86\u505a<\/span>\nprint<\/span>(<\/span>df<\/span>[<\/span>df<\/span>[<\/span>'\u51fa\u751f\u5e74\u6708\u65e5'<\/span>]<\/span>.<\/span>astype<\/span>(<\/span>'str'<\/span>)<\/span>.<\/span>str<\/span>.<\/span>startswith<\/span>(<\/span>'7'<\/span>)][<\/span>'\u51fa\u751f\u5e74\u6708\u65e5'<\/span>])<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
1     720525\n2     721116\n3     730224\n4     720923\n6     700503\n7     730318\n8     740802\n9     730607\n10    720121\n12    730118\n13    751123\n14    750903\n15    760907\n16    760227\nName: \u51fa\u751f\u5e74\u6708\u65e5, dtype: int64\n1     720525\n2     721116\n3     730224\n4     720923\n6     700503\n7     730318\n8     740802\n9     730607\n10    720121\n12    730118\n13    751123\n14    750903\n15    760907\n16    760227\nName: \u51fa\u751f\u5e74\u6708\u65e5, dtype: int64\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
In [6]:<\/div>\n
\n
\n
\n
# \u5339\u914d\u4e2d\u6587\u59d3\u540d\u70ba\u5433\u6216\u6797\u958b\u982d<\/span>\nprint<\/span>(<\/span>df<\/span>[<\/span>df<\/span>[<\/span>'\u4e2d\u6587\u59d3\u540d'<\/span>]<\/span>.<\/span>str<\/span>.<\/span>contains<\/span>(<\/span>r<\/span>'^\u5433|^\u6797'<\/span>)][<\/span>'\u4e2d\u6587\u59d3\u540d'<\/span>])<\/span>\n\n# \u4e0a\u9762\u7684\u7a0b\u5f0f\u78bc\u4e5f\u53ef\u4ee5startswith\u4f86\u505a<\/span>\nprint<\/span>(<\/span>df<\/span>[<\/span>df<\/span>[<\/span>'\u4e2d\u6587\u59d3\u540d'<\/span>]<\/span>.<\/span>str<\/span>.<\/span>startswith<\/span>((<\/span>'\u5433'<\/span>,<\/span>'\u6797'<\/span>))][<\/span>'\u4e2d\u6587\u59d3\u540d'<\/span>])<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
2     \u6797\u6b23\u8679\n3     \u5433\u8a9e\u7fa4\n5     \u6797\u7d20\u5143\n12    \u6797\u65b0\u4e91\n14    \u6797\u4e16\u5149\n15    \u5433\u60e0\u8339\nName: \u4e2d\u6587\u59d3\u540d, dtype: object\n2     \u6797\u6b23\u8679\n3     \u5433\u8a9e\u7fa4\n5     \u6797\u7d20\u5143\n12    \u6797\u65b0\u4e91\n14    \u6797\u4e16\u5149\n15    \u5433\u60e0\u8339\nName: \u4e2d\u6587\u59d3\u540d, dtype: object\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
In [ ]:<\/div>\n
\n
\n
\n
<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
)][<\/span>‘\u5b78\u865f’<\/span>])<\/span><\/p>\n
# \u4e0a\u9762\u7684\u7a0b\u5f0f\u78bc\u4e5f\u53ef\u4ee5endswith\u4f86\u505a<\/span>
\nprint<\/span>(<\/span>df<\/span>[<\/span>df<\/span>[<\/span>‘\u5b78\u865f’<\/span>]<\/span>.<\/span>str<\/span>.<\/span>endswith<\/span>(<\/span>’30’<\/span>)][<\/span>‘\u5b78\u865f’<\/span>])<\/span><\/p>\n
\n
\n
\n
<\/div>\n
\n
<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
In [5]:<\/div>\n
\n
\n
\n
<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
In [6]:<\/div>\n
\n
\n
\n
<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
In [ ]:<\/div>\n
\n
\n
\n
<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
import pandas as pd file_location = ‘0000_\u5b78\u751f\u8cc7\u6599\u7bc4\u4f8b\u6a94.xlsx’ […]<\/p>\n","protected":false},"author":1,"featured_media":382,"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,171,172,173],"author_meta":{"display_name":"mackuo","author_link":"https:\/\/kuo.us.to\/wordpress\/author\/mackuo\/"},"featured_img":"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/07\/5unykny0mta-300x200.jpg","coauthors":[],"tax_additional":{"categories":{"linked":["Python\u5b78\u7fd2\u7b46\u8a18<\/a>"],"unlinked":["Python\u5b78\u7fd2\u7b46\u8a18<\/span>"]},"tags":{"linked":["Pandas<\/a>","Python<\/a>","Regular Expression<\/a>","\u6b63\u5247\u8868\u9054\u5f0f<\/a>","\u6b63\u898f\u8868\u9054\u5f0f<\/a>"],"unlinked":["Pandas<\/span>","Python<\/span>","Regular Expression<\/span>","\u6b63\u5247\u8868\u9054\u5f0f<\/span>","\u6b63\u898f\u8868\u9054\u5f0f<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 4 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2022 \u5e74 6 \u6708 23 \u65e5","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5"},"absolute_dates_time":{"created":"Posted on 2022 \u5e74 6 \u6708 23 \u65e5 \u4e0a\u5348 11:17","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5 \u4e0b\u5348 4:52"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/274"}],"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=274"}],"version-history":[{"count":3,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/274\/revisions"}],"predecessor-version":[{"id":634,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/274\/revisions\/634"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/382"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}