{"id":291,"date":"2020-10-15T10:20:00","date_gmt":"2020-10-15T02:20:00","guid":{"rendered":""},"modified":"2023-01-17T17:26:40","modified_gmt":"2023-01-17T09:26:40","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-google-colab%e8%ae%80%e5%8f%96%e6%9c%ac%e6%a9%9fexcel%e3%80%81csv%e6%aa%94%e6%a1%88","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/291\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18-Google Colab\u8b80\u53d6\u672c\u6a5fexcel\u3001csv\u6a94\u6848"},"content":{"rendered":"
\n
\n
\n

Google Colab\u8b80\u53d6\u672c\u6a5fexcel\u3001csv\u6a94\u6848<\/a><\/h1>\n

Google Colab\u53ef\u4ee5\u5f88\u65b9\u4fbf\u5728\u7dda\u4e0a\u7de8\u8b6fPython\u7a0b\u5f0f\uff0c \u4f46\u5f88\u591a\u6642\u5019\uff0c\u7a0b\u5f0f\u8981\u5f9e\u672c\u6a5f\u547c\u53eb\u6a94\u6848\uff0c \u9019\u6642\u5019\u5c31\u6709\u9ede\u9ebb\u7169\u4e86\u3002<\/p>\n

\u4ee5\u4e0b\u662fgoogle\u5230\u7684\u65b9\u5f0f\uff0c\u53ef\u4ee5\u5f88\u65b9\u4fbf\u7684\u547c\u53eb\u672c\u6a5f\u7684excel\u6216csv\u6a94\u6848\u3002<\/p>\n

\u5099\u8a3b\uff1acsv\u6a94\u6848\u8a18\u5f97\u8981\u5c07\u7de8\u78bc\u6539\u70ba\u300cutf-8\u300d\u5b58\u6a94\uff0c\u514d\u5f97\u57f7\u884c\u6642\u51fa\u932f\u3002<\/p>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
In [1]:<\/div>\n
\n
\n
\n
<\/span>from<\/span> google.colab<\/span> import<\/span> files<\/span>\n# \u4e0a\u50b3csv\u6a94\u6848<\/span>\nuploaded<\/span> =<\/span> files<\/span>.<\/span>upload<\/span>()<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
Upload widget is only available when the cell has been executed in the current browser session. Please rerun this cell to enable.<\/output><\/div>\n<\/div>\n
\n
<\/div>\n
\n
Saving 1091015_108\u5e74\u5404\u8077\u985e\u5225\u521d\u4efb\u4eba\u54e1\u6bcf\u4eba\u6bcf\u6708\u7d93\u5e38\u6027\u85aa\u8cc7\uff0d\u6309\u884c\u696d\u5225\u5206.csv to 1091015_108\u5e74\u5404\u8077\u985e\u5225\u521d\u4efb\u4eba\u54e1\u6bcf\u4eba\u6bcf\u6708\u7d93\u5e38\u6027\u85aa\u8cc7\uff0d\u6309\u884c\u696d\u5225\u5206.csv\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [2]:<\/div>\n
\n
\n
\n
<\/span>import<\/span> io<\/span>\nimport<\/span> pandas<\/span> as<\/span> pd<\/span>\ndf1<\/span> =<\/span> pd<\/span>.<\/span>read_csv<\/span>(<\/span>io<\/span>.<\/span>BytesIO<\/span>(<\/span>uploaded<\/span>[<\/span>'1091015_108\u5e74\u5404\u8077\u985e\u5225\u521d\u4efb\u4eba\u54e1\u6bcf\u4eba\u6bcf\u6708\u7d93\u5e38\u6027\u85aa\u8cc7\uff0d\u6309\u884c\u696d\u5225\u5206.csv'<\/span>]))<\/span>\nprint<\/span>(<\/span>len<\/span>(<\/span>df1<\/span>))<\/span>\ndf1<\/span>.<\/span>head<\/span>()<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
110\n<\/pre>\n<\/div>\n<\/div>\n
\n
Out[2]:<\/div>\n
\n
\n\n\n\n\n\n\n\n\n\n
<\/th>\n\u5e74\u5ea6<\/th>\n\u884c\u696d\u5225<\/th>\n\u7d93\u5e38\u6027\u85aa\u8cc7-\u85aa\u8cc7<\/th>\n\u7d93\u5e38\u6027\u85aa\u8cc7-\u5973\/\u7537<\/th>\n\u5c08\u696d\u4eba\u54e1-\u85aa\u8cc7<\/th>\n\u5c08\u696d\u4eba\u54e1-\u5973\/\u7537<\/th>\n\u6280\u8853\u54e1\u53ca\u52a9\u7406\u5c08\u696d\u4eba\u54e1-\u85aa\u8cc7<\/th>\n\u6280\u8853\u54e1\u53ca\u52a9\u7406\u5c08\u696d\u4eba\u54e1-\u5973\/\u7537<\/th>\n\u4e8b\u52d9\u652f\u63f4\u4eba\u54e1-\u85aa\u8cc7<\/th>\n\u4e8b\u52d9\u652f\u63f4\u4eba\u54e1-\u5973\/\u7537<\/th>\n\u670d\u52d9\u53ca\u92b7\u552e\u5de5\u4f5c\u4eba\u54e1-\u85aa\u8cc7<\/th>\n\u670d\u52d9\u53ca\u92b7\u552e\u5de5\u4f5c\u4eba\u54e1-\u5973\/\u7537<\/th>\n\u6280\u85dd_\u6a5f\u68b0\u8a2d\u5099\u64cd\u4f5c\u53ca\u7d44\u88dd\u4eba\u54e1-\u85aa\u8cc7<\/th>\n\u6280\u85dd_\u6a5f\u68b0\u8a2d\u5099\u64cd\u4f5c\u53ca\u7d44\u88dd\u4eba\u54e1-\u5973\/\u7537<\/th>\n\u57fa\u5c64\u6280\u8853\u5de5\u53ca\u52de\u529b\u5de5-\u85aa\u8cc7<\/th>\n\u57fa\u5c64\u6280\u8853\u5de5\u53ca\u52de\u529b\u5de5-\u5973\/\u7537<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\n2019<\/td>\n\u5de5\u696d\u53ca\u670d\u52d9\u696d<\/td>\n28231<\/td>\n99.21<\/td>\n35065<\/td>\n99.21<\/td>\n29812<\/td>\n99.21<\/td>\n27170<\/td>\n99.48<\/td>\n26428<\/td>\n99.49<\/td>\n26794<\/td>\n98.6<\/td>\n24372<\/td>\n99.29<\/td>\n<\/tr>\n
1<\/th>\n2019<\/td>\n\u5de5\u696d<\/td>\n28177<\/td>\n99.00<\/td>\n35234<\/td>\n99<\/td>\n29593<\/td>\n98.89<\/td>\n27179<\/td>\n99.33<\/td>\n26962<\/td>\n99.36<\/td>\n26379<\/td>\n98.5<\/td>\n24230<\/td>\n99.25<\/td>\n<\/tr>\n
2<\/th>\n2019<\/td>\n\u7926\u696d\u53ca\u571f\u77f3\u63a1\u53d6\u696d<\/td>\n27040<\/td>\n97.29<\/td>\n35763<\/td>\n98.81<\/td>\n29105<\/td>\n97.55<\/td>\n25337<\/td>\n100.18<\/td>\n25047<\/td>\n99.64<\/td>\n28911<\/td>\n93.91<\/td>\n23614<\/td>\n97.95<\/td>\n<\/tr>\n
3<\/th>\n2019<\/td>\n\u77f3\u6cb9\u53ca\u5929\u7136\u6c23\u7926\u696d<\/td>\n29542<\/td>\n100.00<\/td>\n38423<\/td>\n100<\/td>\n27944<\/td>\n100<\/td>\n27944<\/td>\n100<\/td>\n\u2026<\/td>\n\u2026<\/td>\n27944<\/td>\n100<\/td>\n\u2014<\/td>\n\u2014<\/td>\n<\/tr>\n
4<\/th>\n2019<\/td>\n\u7802\u3001\u77f3\u63a1\u53d6\u53ca\u5176\u4ed6\u7926\u696d<\/td>\n26206<\/td>\n95.87<\/td>\n30444<\/td>\n99.67<\/td>\n30267<\/td>\n96.26<\/td>\n24726<\/td>\n100.47<\/td>\n24589<\/td>\n99.97<\/td>\n29269<\/td>\n92.19<\/td>\n23614<\/td>\n97.95<\/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># \u4e0a\u50b3excel\u6a94\u6848<\/span>\nuploaded<\/span> =<\/span> files<\/span>.<\/span>upload<\/span>()<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
Upload widget is only available when the cell has been executed in the current browser session. Please rerun this cell to enable.<\/output><\/div>\n<\/div>\n
\n
<\/div>\n
\n
Saving 1091015_108\u5e74\u5404\u8077\u985e\u5225\u521d\u4efb\u4eba\u54e1\u6bcf\u4eba\u6bcf\u6708\u7d93\u5e38\u6027\u85aa\u8cc7\uff0d\u6309\u884c\u696d\u5225\u5206.xlsx to 1091015_108\u5e74\u5404\u8077\u985e\u5225\u521d\u4efb\u4eba\u54e1\u6bcf\u4eba\u6bcf\u6708\u7d93\u5e38\u6027\u85aa\u8cc7\uff0d\u6309\u884c\u696d\u5225\u5206.xlsx\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In [4]:<\/div>\n
\n
\n
\n
<\/span>df2<\/span> =<\/span> pd<\/span>.<\/span>read_excel<\/span>(<\/span>io<\/span>.<\/span>BytesIO<\/span>(<\/span>uploaded<\/span>[<\/span>'1091015_108\u5e74\u5404\u8077\u985e\u5225\u521d\u4efb\u4eba\u54e1\u6bcf\u4eba\u6bcf\u6708\u7d93\u5e38\u6027\u85aa\u8cc7\uff0d\u6309\u884c\u696d\u5225\u5206.xlsx'<\/span>]))<\/span>\nprint<\/span>(<\/span>len<\/span>(<\/span>df2<\/span>))<\/span>\ndf2<\/span>.<\/span>head<\/span>()<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
110\n<\/pre>\n<\/div>\n<\/div>\n
\n
Out[4]:<\/div>\n
\n
\n\n\n\n\n\n\n\n\n\n
<\/th>\n\u5e74\u5ea6<\/th>\n\u884c\u696d\u5225<\/th>\n\u7d93\u5e38\u6027\u85aa\u8cc7-\u85aa\u8cc7<\/th>\n\u7d93\u5e38\u6027\u85aa\u8cc7-\u5973\/\u7537<\/th>\n\u5c08\u696d\u4eba\u54e1-\u85aa\u8cc7<\/th>\n\u5c08\u696d\u4eba\u54e1-\u5973\/\u7537<\/th>\n\u6280\u8853\u54e1\u53ca\u52a9\u7406\u5c08\u696d\u4eba\u54e1-\u85aa\u8cc7<\/th>\n\u6280\u8853\u54e1\u53ca\u52a9\u7406\u5c08\u696d\u4eba\u54e1-\u5973\/\u7537<\/th>\n\u4e8b\u52d9\u652f\u63f4\u4eba\u54e1-\u85aa\u8cc7<\/th>\n\u4e8b\u52d9\u652f\u63f4\u4eba\u54e1-\u5973\/\u7537<\/th>\n\u670d\u52d9\u53ca\u92b7\u552e\u5de5\u4f5c\u4eba\u54e1-\u85aa\u8cc7<\/th>\n\u670d\u52d9\u53ca\u92b7\u552e\u5de5\u4f5c\u4eba\u54e1-\u5973\/\u7537<\/th>\n\u6280\u85dd_\u6a5f\u68b0\u8a2d\u5099\u64cd\u4f5c\u53ca\u7d44\u88dd\u4eba\u54e1-\u85aa\u8cc7<\/th>\n\u6280\u85dd_\u6a5f\u68b0\u8a2d\u5099\u64cd\u4f5c\u53ca\u7d44\u88dd\u4eba\u54e1-\u5973\/\u7537<\/th>\n\u57fa\u5c64\u6280\u8853\u5de5\u53ca\u52de\u529b\u5de5-\u85aa\u8cc7<\/th>\n\u57fa\u5c64\u6280\u8853\u5de5\u53ca\u52de\u529b\u5de5-\u5973\/\u7537<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\n2019<\/td>\n\u5de5\u696d\u53ca\u670d\u52d9\u696d<\/td>\n28231<\/td>\n99.21<\/td>\n35065<\/td>\n99.21<\/td>\n29812<\/td>\n99.21<\/td>\n27170<\/td>\n99.48<\/td>\n26428<\/td>\n99.49<\/td>\n26794<\/td>\n98.6<\/td>\n24372<\/td>\n99.29<\/td>\n<\/tr>\n
1<\/th>\n2019<\/td>\n\u5de5\u696d<\/td>\n28177<\/td>\n99.00<\/td>\n35234<\/td>\n99<\/td>\n29593<\/td>\n98.89<\/td>\n27179<\/td>\n99.33<\/td>\n26962<\/td>\n99.36<\/td>\n26379<\/td>\n98.5<\/td>\n24230<\/td>\n99.25<\/td>\n<\/tr>\n
2<\/th>\n2019<\/td>\n\u7926\u696d\u53ca\u571f\u77f3\u63a1\u53d6\u696d<\/td>\n27040<\/td>\n97.29<\/td>\n35763<\/td>\n98.81<\/td>\n29105<\/td>\n97.55<\/td>\n25337<\/td>\n100.18<\/td>\n25047<\/td>\n99.64<\/td>\n28911<\/td>\n93.91<\/td>\n23614<\/td>\n97.95<\/td>\n<\/tr>\n
3<\/th>\n2019<\/td>\n\u77f3\u6cb9\u53ca\u5929\u7136\u6c23\u7926\u696d<\/td>\n29542<\/td>\n100.00<\/td>\n38423<\/td>\n100<\/td>\n27944<\/td>\n100<\/td>\n27944<\/td>\n100<\/td>\n\u2026<\/td>\n\u2026<\/td>\n27944<\/td>\n100<\/td>\n\u2014<\/td>\n\u2014<\/td>\n<\/tr>\n
4<\/th>\n2019<\/td>\n\u7802\u3001\u77f3\u63a1\u53d6\u53ca\u5176\u4ed6\u7926\u696d<\/td>\n26206<\/td>\n95.87<\/td>\n30444<\/td>\n99.67<\/td>\n30267<\/td>\n96.26<\/td>\n24726<\/td>\n100.47<\/td>\n24589<\/td>\n99.97<\/td>\n29269<\/td>\n92.19<\/td>\n23614<\/td>\n97.95<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Google Colab\u8b80\u53d6\u672c\u6a5fexcel\u3001csv\u6a94\u6848 Google Colab\u53ef\u4ee5\u5f88\u65b9\u4fbf\u5728\u7dda\u4e0a\u7de8\u8b6fPytho […]<\/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":[267,201,177,268,8,9,269],"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":["colab<\/a>","csv<\/a>","excel<\/a>","google colab<\/a>","Pandas<\/a>","Python<\/a>","\u672c\u6a5f\u6a94\u6848<\/a>"],"unlinked":["colab<\/span>","csv<\/span>","excel<\/span>","google colab<\/span>","Pandas<\/span>","Python<\/span>","\u672c\u6a5f\u6a94\u6848<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 5 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2020 \u5e74 10 \u6708 15 \u65e5","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5"},"absolute_dates_time":{"created":"Posted on 2020 \u5e74 10 \u6708 15 \u65e5 \u4e0a\u5348 10:20","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5 \u4e0b\u5348 5:26"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/291"}],"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=291"}],"version-history":[{"count":2,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/291\/revisions"}],"predecessor-version":[{"id":658,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/291\/revisions\/658"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}