{"id":276,"date":"2022-05-07T11:57:00","date_gmt":"2022-05-07T03:57:00","guid":{"rendered":""},"modified":"2023-01-17T16:54:56","modified_gmt":"2023-01-17T08:54:56","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98%ef%bc%9apandas-%e5%b0%87dataframe-%e8%bd%89%e6%8f%9b%e6%88%90-dictionary%ef%bc%8c%e4%b8%a6%e4%be%9d%e6%a2%9d%e4%bb%b6fillna","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/276\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18\uff1aPandas \u5c07DataFrame \u8f49\u63db\u6210 Dictionary\uff0c\u4e26\u4f9d\u689d\u4ef6fillna"},"content":{"rendered":"

\u8cc7\u6599\u6a94\uff1a<\/p>\n

<\/a><\/div>\n

\u76ee\u6a19\uff1a\u5c07NaN\u4ee5\u5e73\u5747\u503c\u586b\u5165<\/p>\n

<\/a><\/div>\n

 import<\/span> <\/span>pandas<\/span> <\/span>as<\/span> <\/span>pd<\/span><\/p>\n

\n
\n
\n
\n
\n
\n
import<\/span> numpy<\/span> as<\/span> np<\/span>\n\nfile<\/span> =<\/span> '<\/span>Fish.csv'<\/span>\n\ndf<\/span> =<\/span> pd<\/span>.<\/span>read_csv<\/span>(<\/span>file<\/span>)<\/span>\nprint<\/span>(<\/span>len<\/span>(<\/span>df<\/span>))<\/span>\nprint<\/span>(<\/span>df<\/span>.<\/span>columns<\/span>)<\/span>\ndf<\/span>.<\/span>head<\/span>()<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
<\/div>\n
\n
159\nIndex(['Species', 'Weight', 'Length1', 'Length2', 'Length3', 'Height',\n       'Width'],\n      dtype='object')\n<\/pre>\n<\/div>\n<\/div>\n
\n
Out[1]:<\/div>\n
\n
\n\n\n\n\n\n\n\n\n\n
<\/th>\nSpecies<\/th>\nWeight<\/th>\nLength1<\/th>\nLength2<\/th>\nLength3<\/th>\nHeight<\/th>\nWidth<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\nBream<\/td>\n242.0<\/td>\n23.2<\/td>\n25.4<\/td>\n30.0<\/td>\n11.5200<\/td>\n4.0200<\/td>\n<\/tr>\n
1<\/th>\nBream<\/td>\n290.0<\/td>\n24.0<\/td>\n26.3<\/td>\n31.2<\/td>\n12.4800<\/td>\n4.3056<\/td>\n<\/tr>\n
2<\/th>\nBream<\/td>\n340.0<\/td>\n23.9<\/td>\n26.5<\/td>\n31.1<\/td>\n12.3778<\/td>\n4.6961<\/td>\n<\/tr>\n
3<\/th>\nBream<\/td>\n363.0<\/td>\n26.3<\/td>\n29.0<\/td>\n33.5<\/td>\n12.7300<\/td>\n4.4555<\/td>\n<\/tr>\n
4<\/th>\nBream<\/td>\n430.0<\/td>\nNaN<\/td>\n29.0<\/td>\n34.0<\/td>\n12.4440<\/td>\n5.1340<\/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>df_mean<\/span> =<\/span> df<\/span>[[<\/span>'Species'<\/span>,<\/span> 'Length1'<\/span>]]<\/span>.<\/span>groupby<\/span>(<\/span>'Species'<\/span>)<\/span>.<\/span>mean<\/span>()<\/span>#.reset_index(drop=False)<\/span>\ndf_mean<\/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\n\n
<\/th>\nLength1<\/th>\n<\/tr>\n
Species<\/th>\n<\/th>\n<\/tr>\n<\/thead>\n
Bream<\/th>\n30.417647<\/td>\n<\/tr>\n
Parkki<\/th>\n18.727273<\/td>\n<\/tr>\n
Perch<\/th>\n25.735714<\/td>\n<\/tr>\n
Pike<\/th>\n42.476471<\/td>\n<\/tr>\n
Roach<\/th>\n20.645000<\/td>\n<\/tr>\n
Smelt<\/th>\n11.257143<\/td>\n<\/tr>\n
Whitefish<\/th>\n28.800000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
In [3]:<\/div>\n
\n
\n
\n
<\/span>df_dict<\/span> =<\/span> df_mean<\/span>.<\/span>squeeze<\/span>()<\/span>.<\/span>to_dict<\/span>()<\/span>\ndf_dict<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[3]:<\/div>\n
\n
{'Bream': 30.41764705882353,\n 'Parkki': 18.727272727272727,\n 'Perch': 25.735714285714288,\n 'Pike': 42.476470588235294,\n 'Roach': 20.645,\n 'Smelt': 11.257142857142856,\n 'Whitefish': 28.8}<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
In [4]:<\/div>\n
\n
\n
\n
<\/span>for<\/span> i<\/span> in<\/span> df<\/span>[<\/span>'Species'<\/span>]:<\/span>\n    df<\/span>.<\/span>loc<\/span>[(<\/span>df<\/span>[<\/span>'Species'<\/span>]<\/span>==<\/span>i<\/span>)<\/span> &<\/span> (<\/span>df<\/span>[<\/span>'Length1'<\/span>]<\/span>.<\/span>isna<\/span>()),<\/span> 'Length1'<\/span>]<\/span> =<\/span> df_dict<\/span>[<\/span>i<\/span>]<\/span>\n\ndf<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[4]:<\/div>\n
\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
<\/th>\nSpecies<\/th>\nWeight<\/th>\nLength1<\/th>\nLength2<\/th>\nLength3<\/th>\nHeight<\/th>\nWidth<\/th>\n<\/tr>\n<\/thead>\n
0<\/th>\nBream<\/td>\n242.0<\/td>\n23.200000<\/td>\n25.4<\/td>\n30.0<\/td>\n11.5200<\/td>\n4.0200<\/td>\n<\/tr>\n
1<\/th>\nBream<\/td>\n290.0<\/td>\n24.000000<\/td>\n26.3<\/td>\n31.2<\/td>\n12.4800<\/td>\n4.3056<\/td>\n<\/tr>\n
2<\/th>\nBream<\/td>\n340.0<\/td>\n23.900000<\/td>\n26.5<\/td>\n31.1<\/td>\n12.3778<\/td>\n4.6961<\/td>\n<\/tr>\n
3<\/th>\nBream<\/td>\n363.0<\/td>\n26.300000<\/td>\n29.0<\/td>\n33.5<\/td>\n12.7300<\/td>\n4.4555<\/td>\n<\/tr>\n
4<\/th>\nBream<\/td>\n430.0<\/td>\n30.417647<\/td>\n29.0<\/td>\n34.0<\/td>\n12.4440<\/td>\n5.1340<\/td>\n<\/tr>\n
…<\/th>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n<\/tr>\n
154<\/th>\nSmelt<\/td>\n12.2<\/td>\n11.500000<\/td>\n12.2<\/td>\n13.4<\/td>\n2.0904<\/td>\n1.3936<\/td>\n<\/tr>\n
155<\/th>\nSmelt<\/td>\n13.4<\/td>\n11.700000<\/td>\n12.4<\/td>\n13.5<\/td>\n2.4300<\/td>\n1.2690<\/td>\n<\/tr>\n
156<\/th>\nSmelt<\/td>\n12.2<\/td>\n12.100000<\/td>\n13.0<\/td>\n13.8<\/td>\n2.2770<\/td>\n1.2558<\/td>\n<\/tr>\n
157<\/th>\nSmelt<\/td>\n19.7<\/td>\n13.200000<\/td>\n14.3<\/td>\n15.2<\/td>\n2.8728<\/td>\n2.0672<\/td>\n<\/tr>\n
158<\/th>\nSmelt<\/td>\n19.9<\/td>\n13.800000<\/td>\n15.0<\/td>\n16.2<\/td>\n2.9322<\/td>\n1.8792<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
159 rows \u00d7 7 columns<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
\u8cc7\u6599\u6a94\uff1a \u76ee\u6a19\uff1a\u5c07NaN\u4ee5\u5e73\u5747\u503c\u586b\u5165  import pandas as pd import num […]<\/p>\n","protected":false},"author":1,"featured_media":331,"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":[212,234,8,9],"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\/05\/E8-9E-A2-E5-B9-95-E6-93-B7-E5-8F-96-E7-95-AB-E9-9D-A2-202022-05-07-20105926-300x130.png","coauthors":[],"tax_additional":{"categories":{"linked":["Python\u5b78\u7fd2\u7b46\u8a18<\/a>"],"unlinked":["Python\u5b78\u7fd2\u7b46\u8a18<\/span>"]},"tags":{"linked":["dictionary<\/a>","fillna<\/a>","Pandas<\/a>","Python<\/a>"],"unlinked":["dictionary<\/span>","fillna<\/span>","Pandas<\/span>","Python<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 4 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2022 \u5e74 5 \u6708 7 \u65e5","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5"},"absolute_dates_time":{"created":"Posted on 2022 \u5e74 5 \u6708 7 \u65e5 \u4e0a\u5348 11:57","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5 \u4e0b\u5348 4:54"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/276"}],"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=276"}],"version-history":[{"count":2,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/276\/revisions"}],"predecessor-version":[{"id":636,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/276\/revisions\/636"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/331"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}