{"id":3226,"date":"2023-07-18T14:10:40","date_gmt":"2023-07-18T14:10:40","guid":{"rendered":"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/"},"modified":"2023-07-18T14:10:40","modified_gmt":"2023-07-18T14:10:40","slug":"pandas-fillna-konkretna-kolumna","status":"publish","type":"post","link":"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/","title":{"rendered":"Pandy: jak u\u017cywa\u0107 fillna() z okre\u015blonymi kolumnami"},"content":{"rendered":"

<\/p>\n

\n

Mo\u017cesz u\u017cy\u0107 nast\u0119puj\u0105cych metod z fillna(),<\/strong> aby zast\u0105pi\u0107 warto\u015bci NaN w okre\u015blonych kolumnach pandy DataFrame:<\/span><\/p>\n

Metoda 1: U\u017cyj fillna() z okre\u015blon\u0105 kolumn\u0105<\/strong><\/span><\/p>\n

 df[' col1<\/span> '] = df[' col1<\/span> ']. fillna<\/span> (0)\n<\/strong><\/pre>\n
 Metoda 2: U\u017cyj fillna() z wieloma okre\u015blonymi kolumnami<\/strong><\/span><\/p>\n
 df[[' col1<\/span> ', ' col2<\/span> ']] = df[[' col1<\/span> ', ' col2<\/span> ']]. fillna<\/span> (0)<\/strong><\/pre>\n
 W tym samouczku wyja\u015bniono, jak u\u017cywa\u0107 tej funkcji z nast\u0119puj\u0105c\u0105 ramk\u0105 DataFrame pand:<\/span><\/p>\n
 import<\/span> numpy as<\/span> np\nimport<\/span> pandas as<\/span> pd\n\n#create DataFrame with some NaN values<\/span>\ndf = pd. DataFrame<\/span> ({'rating': [np.nan, 85, np.nan, 88, 94, 90, 76, 75, 87, 86],\n                   'points': [25, np.nan, 14, 16, 27, 20, 12, 15, 14, 19],\n                   'assists': [5, 7, 7, np.nan, 5, 7, 6, 9, 9, 5],\n                   'rebounds': [11, 8, 10, 6, 6, 9, 6, 10, 10, 7]})\n\n#view DataFrame<\/span>\ndf\n\n        rating points assists rebounds\n0 NaN 25.0 5.0 11\n1 85.0 NaN 7.0 8\n2 NaN 14.0 7.0 10\n3 88.0 16.0 NaN 6\n4 94.0 27.0 5.0 6\n5 90.0 20.0 7.0 9\n6 76.0 12.0 6.0 6\n7 75.0 15.0 9.0 10\n8 87.0 14.0 9.0 10\n9 86.0 19.0 5.0 7\n<\/strong><\/pre>\n
 Przyk\u0142ad 1: U\u017cyj fillna() z okre\u015blon\u0105 kolumn\u0105<\/strong><\/span><\/h3>\n
 Poni\u017cszy kod pokazuje, jak u\u017cy\u0107 fillna()<\/strong> do zamiany warto\u015bci NaN na zera tylko w kolumnie \u201euwaga\u201d:<\/span><\/p>\n
 #replace NaNs with zeros in 'rating' column<\/span>\ndf[' rating<\/span> '] = df[' rating<\/span> ']. fillna<\/span> (0)\n\n#view DataFrame<\/span>\ndf\n\n\trating points assists rebounds\n0 0.0 25.0 5.0 11\n1 85.0 NaN 7.0 8\n2 0.0 14.0 7.0 10\n3 88.0 16.0 NaN 6\n4 94.0 27.0 5.0 6\n5 90.0 20.0 7.0 9\n6 76.0 12.0 6.0 6\n7 75.0 15.0 9.0 10\n8 87.0 14.0 9.0 10\n9 86.0 19.0 5.0 7\n<\/strong><\/pre>\n
 Nale\u017cy pami\u0119ta\u0107, \u017ce warto\u015bci NaN zosta\u0142y zast\u0105pione jedynie w kolumnie \u201euwaga\u201d, a wszystkie pozosta\u0142e kolumny pozosta\u0142y nienaruszone.<\/span><\/p>\n
 Przyk\u0142ad 2: U\u017cyj fillna<\/strong> () z wieloma okre\u015blonymi kolumnami<\/strong><\/span><\/h3>\n
 Poni\u017cszy kod pokazuje, jak za pomoc\u0105 fillna()<\/strong> zast\u0105pi\u0107 warto\u015bci NaN zerami w kolumnach \u201eocena\u201d i \u201epunkty\u201d:<\/span><\/p>\n
 #replace NaNs with zeros in 'rating' and 'points' columns<\/span>\ndf[[' rating<\/span> ', ' points<\/span> ']] = df[[' rating<\/span> ', ' points<\/span> ']]. fillna<\/span> (0)\n\n#view DataFrame\n<\/span>df\n\n\trating points assists rebounds\n0 0.0 25.0 5.0 11\n1 85.0 0.0 7.0 8\n2 0.0 14.0 7.0 10\n3 88.0 16.0 NaN 6\n4 94.0 27.0 5.0 6\n5 90.0 20.0 7.0 9\n6 76.0 12.0 6.0 6\n7 75.0 15.0 9.0 10\n8 87.0 14.0 9.0 10\n9 86.0 19.0 5.0 7\n<\/strong><\/pre>\n
 Nale\u017cy pami\u0119ta\u0107, \u017ce warto\u015bci NaN zosta\u0142y zast\u0105pione w kolumnach \u201eocena\u201d i \u201epunkty\u201d, ale pozosta\u0142e kolumny pozosta\u0142y nienaruszone.<\/span><\/p>\n
 Uwaga<\/strong> : pe\u0142n\u0105 dokumentacj\u0119 funkcji pandas fillna()<\/strong> mo\u017cna znale\u017a\u0107 tutaj<\/a> .<\/span><\/p>\n
 Dodatkowe zasoby<\/strong><\/span><\/h3>\n
 Poni\u017csze samouczki wyja\u015bniaj\u0105, jak wykonywa\u0107 inne typowe operacje na pandach:<\/span><\/p>\n
 Jak policzy\u0107 brakuj\u0105ce warto\u015bci w pandach<\/a>
 Jak usun\u0105\u0107 wiersze z warto\u015bciami NaN w Pandach<\/a>
 Jak usun\u0105\u0107 wiersze zawieraj\u0105ce okre\u015blon\u0105 warto\u015b\u0107 w Pandach<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Mo\u017cesz u\u017cy\u0107 nast\u0119puj\u0105cych metod z fillna(), aby zast\u0105pi\u0107 warto\u015bci NaN w okre\u015blonych kolumnach pandy DataFrame: Metoda 1: U\u017cyj fillna() z okre\u015blon\u0105 kolumn\u0105 df[’ col1 ’] = df[’ col1 ’]. fillna (0) Metoda 2: U\u017cyj fillna() z wieloma okre\u015blonymi kolumnami df[[’ col1 ’, ’ col2 ’]] = df[[’ col1 ’, ’ col2 ’]]. fillna (0) W […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3226","post","type-post","status-publish","format-standard","hentry","category-przewodnik"],"yoast_head":"\nPandy: Jak u\u017cywa\u0107 fillna() z okre\u015blonymi kolumnami \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"W tym samouczku wyja\u015bniono, jak u\u017cywa\u0107 funkcji fillna() w pandach do zast\u0119powania warto\u015bci w okre\u015blonych kolumnach, \u0142\u0105cznie z przyk\u0142adami.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandy: Jak u\u017cywa\u0107 fillna() z okre\u015blonymi kolumnami \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"W tym samouczku wyja\u015bniono, jak u\u017cywa\u0107 funkcji fillna() w pandach do zast\u0119powania warto\u015bci w okre\u015blonych kolumnach, \u0142\u0105cznie z przyk\u0142adami.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T14:10:40+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin Anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin Anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/\",\"url\":\"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/\",\"name\":\"Pandy: Jak u\u017cywa\u0107 fillna() z okre\u015blonymi kolumnami \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pl\/#website\"},\"datePublished\":\"2023-07-18T14:10:40+00:00\",\"dateModified\":\"2023-07-18T14:10:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965\"},\"description\":\"W tym samouczku wyja\u015bniono, jak u\u017cywa\u0107 funkcji fillna() w pandach do zast\u0119powania warto\u015bci w okre\u015blonych kolumnach, \u0142\u0105cznie z przyk\u0142adami.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Dom\",\"item\":\"https:\/\/statorials.org\/pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandy: jak u\u017cywa\u0107 fillna() z okre\u015blonymi kolumnami\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/pl\/#website\",\"url\":\"https:\/\/statorials.org\/pl\/\",\"name\":\"Statorials\",\"description\":\"Tw\u00f3j przewodnik po kompetencjach statystycznych!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/pl\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965\",\"name\":\"Benjamin Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/statorials.org\/pl\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin Anderson\"},\"description\":\"Cze\u015b\u0107, jestem Benjamin i jestem emerytowanym profesorem statystyki, kt\u00f3ry zosta\u0142 oddanym nauczycielem Statorials. Dzi\u0119ki bogatemu do\u015bwiadczeniu i wiedzy specjalistycznej w dziedzinie statystyki ch\u0119tnie dziel\u0119 si\u0119 swoj\u0105 wiedz\u0105, aby wzmocni\u0107 pozycj\u0119 uczni\u00f3w za po\u015brednictwem Statorials. Wiedzie\u0107 wi\u0119cej\",\"sameAs\":[\"https:\/\/statorials.org\/pl\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pandy: Jak u\u017cywa\u0107 fillna() z okre\u015blonymi kolumnami \u2013 Statorials","description":"W tym samouczku wyja\u015bniono, jak u\u017cywa\u0107 funkcji fillna() w pandach do zast\u0119powania warto\u015bci w okre\u015blonych kolumnach, \u0142\u0105cznie z przyk\u0142adami.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/","og_locale":"pl_PL","og_type":"article","og_title":"Pandy: Jak u\u017cywa\u0107 fillna() z okre\u015blonymi kolumnami \u2013 Statorials","og_description":"W tym samouczku wyja\u015bniono, jak u\u017cywa\u0107 funkcji fillna() w pandach do zast\u0119powania warto\u015bci w okre\u015blonych kolumnach, \u0142\u0105cznie z przyk\u0142adami.","og_url":"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/","og_site_name":"Statorials","article_published_time":"2023-07-18T14:10:40+00:00","author":"Benjamin Anderson","twitter_card":"summary_large_image","twitter_misc":{"Napisane przez":"Benjamin Anderson","Szacowany czas czytania":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/","url":"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/","name":"Pandy: Jak u\u017cywa\u0107 fillna() z okre\u015blonymi kolumnami \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/pl\/#website"},"datePublished":"2023-07-18T14:10:40+00:00","dateModified":"2023-07-18T14:10:40+00:00","author":{"@id":"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965"},"description":"W tym samouczku wyja\u015bniono, jak u\u017cywa\u0107 funkcji fillna() w pandach do zast\u0119powania warto\u015bci w okre\u015blonych kolumnach, \u0142\u0105cznie z przyk\u0142adami.","breadcrumb":{"@id":"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pl\/pandas-fillna-konkretna-kolumna\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Dom","item":"https:\/\/statorials.org\/pl\/"},{"@type":"ListItem","position":2,"name":"Pandy: jak u\u017cywa\u0107 fillna() z okre\u015blonymi kolumnami"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/pl\/#website","url":"https:\/\/statorials.org\/pl\/","name":"Statorials","description":"Tw\u00f3j przewodnik po kompetencjach statystycznych!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/pl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pl-PL"},{"@type":"Person","@id":"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965","name":"Benjamin Anderson","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/statorials.org\/pl\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg","caption":"Benjamin Anderson"},"description":"Cze\u015b\u0107, jestem Benjamin i jestem emerytowanym profesorem statystyki, kt\u00f3ry zosta\u0142 oddanym nauczycielem Statorials. Dzi\u0119ki bogatemu do\u015bwiadczeniu i wiedzy specjalistycznej w dziedzinie statystyki ch\u0119tnie dziel\u0119 si\u0119 swoj\u0105 wiedz\u0105, aby wzmocni\u0107 pozycj\u0119 uczni\u00f3w za po\u015brednictwem Statorials. Wiedzie\u0107 wi\u0119cej","sameAs":["https:\/\/statorials.org\/pl"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/posts\/3226","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/comments?post=3226"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/posts\/3226\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/media?parent=3226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/categories?post=3226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/tags?post=3226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}