{"id":739,"date":"2023-03-07T14:39:54","date_gmt":"2023-03-07T06:39:54","guid":{"rendered":"https:\/\/kuo.us.to\/wordpress\/?p=739"},"modified":"2023-03-07T14:41:26","modified_gmt":"2023-03-07T06:41:26","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-pandas%e5%bf%ab%e9%80%9f%e8%a3%bd%e4%bd%9c%e5%90%abnan%e7%9a%84dataframe","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/739\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: Pandas\u5feb\u901f\u88fd\u4f5c\u542bNaN\u7684DataFrame"},"content":{"rendered":"<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\nimport numpy as np\nimport pandas as pd\n\n# \u7522\u751f8\u52176\u6b04\u4ecb\u65bc0-100\u7684DataFrame\ndf = pd.DataFrame(np.random.randint(0,100,size=(8, 6)), columns=list('ABCDEF'))\n\nfor col in df.columns:\n    # \u6bcf\u6b04\u96a8\u6a5f\u7522\u751f\u6a5f\u73870.5\u7684NaN\n    df&#x5B;col] = df&#x5B;col].sample(frac=0.5)\n\ndf\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"317\" height=\"330\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-07-141501.jpg\" alt=\"\" class=\"wp-image-740\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-07-141501.jpg 317w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-07-141501-288x300.jpg 288w\" sizes=\"(max-width: 317px) 100vw, 317px\" \/><\/figure>\n\n\n\n<p>\u63a5\u4e0b\u4f86\u64cd\u4f5c\u4e00\u4e0b\uff0c\u628a\u6bcf\u5217\u4e2d\u8d85\u904e3\u500bNaN\u7684\u5217\u522a\u9664\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\ndf = df.dropna(thresh=3)\ndf\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"307\" height=\"248\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-07-141522.jpg\" alt=\"\" class=\"wp-image-741\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-07-141522.jpg 307w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-07-141522-300x242.jpg 300w\" sizes=\"(max-width: 307px) 100vw, 307px\" \/><\/figure>\n\n\n\n<p>\u9806\u4fbf\u8a18\u9304\u4e00\u4e0b\u5982\u4f55\u5c07\u5b57\u4e32\u5207\u5272\u6210list\uff08\u6e90\u81eastacksoverflow\uff09\uff0c\u8f49\u70ba\u6b04\u4f4d\u540d\u7a31\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u7b2c\u4e00\u7a2e\u65b9\u5f0f\nexam_string = '\u570b\u6587\u82f1\u8a9e\u6578\u5b78\u81ea\u7136\u793e\u6703\u516c\u6c11'\nn = 2\nexams = &#x5B;exam_string&#x5B;i:i+n] for i in range(0, len(exam_string), n)]\ndf.columns = exams\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u7b2c\u4e8c\u7a2e\u65b9\u5f0f\nfrom textwrap import wrap\n\nexam_string = '\u570b\u6587\u82f1\u8a9e\u6578\u5b78\u81ea\u7136\u793e\u6703\u516c\u6c11'\nexams = wrap(exam_string, 2)\ndf.columns = exams\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u7b2c\u4e09\u7a2e\u65b9\u5f0f\nexam_string = '\u570b\u6587\u82f1\u8a9e\u6578\u5b78\u81ea\u7136\u793e\u6703\u516c\u6c11'\nexams = &#x5B;]\nwhile exam_string:\n    exams.append(exam_string&#x5B;:2])\n    exam_string = exam_string&#x5B;2:]\n\ndf.columns = exams\ndf\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"307\" height=\"261\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-07-142556.jpg\" alt=\"\" class=\"wp-image-742\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-07-142556.jpg 307w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-07-142556-300x255.jpg 300w\" sizes=\"(max-width: 307px) 100vw, 307px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u63a5\u4e0b\u4f86\u64cd\u4f5c\u4e00\u4e0b\uff0c\u628a\u6bcf\u5217\u4e2d\u8d85\u904e3\u500bNaN\u7684\u5217\u522a\u9664\u3002 \u9806\u4fbf\u8a18\u9304\u4e00\u4e0b\u5982\u4f55\u5c07\u5b57\u4e32\u5207\u5272\u6210list\uff08\u6e90\u81eastacksove [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":743,"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":"default","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":"default","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":[381,8,9,382,383,384,380],"author_meta":{"display_name":"mackuo","author_link":"https:\/\/kuo.us.to\/wordpress\/author\/mackuo\/"},"featured_img":"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/5yn5rgi5iuw-300x200.jpg","coauthors":[],"tax_additional":{"categories":{"linked":["<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">Python\u5b78\u7fd2\u7b46\u8a18<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">Python\u5b78\u7fd2\u7b46\u8a18<\/span>"]},"tags":{"linked":["<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">dropna<\/a>","<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">Pandas<\/a>","<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">Python<\/a>","<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">thresh<\/a>","<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">wrap<\/a>","<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">\u5b57\u4e32\u8f49list<\/a>","<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">\u6210\u7e3e<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">dropna<\/span>","<span class=\"advgb-post-tax-term\">Pandas<\/span>","<span class=\"advgb-post-tax-term\">Python<\/span>","<span class=\"advgb-post-tax-term\">thresh<\/span>","<span class=\"advgb-post-tax-term\">wrap<\/span>","<span class=\"advgb-post-tax-term\">\u5b57\u4e32\u8f49list<\/span>","<span class=\"advgb-post-tax-term\">\u6210\u7e3e<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 3 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2023 \u5e74 3 \u6708 7 \u65e5","modified":"Updated on 2023 \u5e74 3 \u6708 7 \u65e5"},"absolute_dates_time":{"created":"Posted on 2023 \u5e74 3 \u6708 7 \u65e5 \u4e0b\u5348 2:39","modified":"Updated on 2023 \u5e74 3 \u6708 7 \u65e5 \u4e0b\u5348 2:41"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/739"}],"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=739"}],"version-history":[{"count":3,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/739\/revisions"}],"predecessor-version":[{"id":746,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/739\/revisions\/746"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/743"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=739"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=739"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}