{"id":1360,"date":"2023-07-26T17:12:24","date_gmt":"2023-07-26T17:12:24","guid":{"rendered":"https:\/\/statorials.org\/pt\/fillna-pandas-multicolunas\/"},"modified":"2023-07-26T17:12:24","modified_gmt":"2023-07-26T17:12:24","slug":"fillna-pandas-multicolunas","status":"publish","type":"post","link":"https:\/\/statorials.org\/pt\/fillna-pandas-multicolunas\/","title":{"rendered":"Como preencher valores na para m\u00faltiplas colunas no pandas"},"content":{"rendered":"

<\/p>\n

\n

A fun\u00e7\u00e3o pandas fillna()<\/a> \u00e9 \u00fatil para preencher valores ausentes nas colunas de um DataFrame do pandas.<\/span><\/p>\n

Este tutorial fornece v\u00e1rios exemplos de uso desta fun\u00e7\u00e3o para preencher valores ausentes para v\u00e1rias colunas no seguinte DataFrame do pandas:<\/span><\/p>\n

 import<\/span> pandas as<\/span> pd\nimport<\/span> numpy as<\/span> np\n\n#createDataFrame\ndf = pd. DataFrame<\/span> ({'team': ['A', np. nan<\/span> , 'B', 'B', 'B', 'C', 'C', 'C'],\n                   'points': [25, np. no<\/span> , 15, np. no<\/span> , 19, 23, 25, 29],\n                   'assists': [5, 7, 7, 9, 12, 9, np. no<\/span> , 4],\n                   'rebounds': [11, 8, 10, 6, 6, 5, 9, 12]})<\/span>\n\n#view DataFrame\nprint<\/span> (df)\n\n  team points assists rebounds\n0 A 25.0 5.0 11\n1 NaN NaN 7.0 8\n2 B 15.0 7.0 10\n3 B NaN 9.0 6\n4 B 19.0 12.0 6\n5 C 23.0 9.0 5\n6 C 25.0 NaN 9\n7 C 29.0 4.0 12<\/span>\n<\/span><\/strong><\/pre>\n
 Exemplo 1: Preencha os valores ausentes de todas as colunas<\/strong><\/span><\/h3>\n
 O c\u00f3digo a seguir mostra como preencher valores ausentes com zero para todas<\/em> as colunas do DataFrame:<\/span><\/p>\n
 #replace all missing values with zero<\/span>\ndf. fillna<\/span> (value= 0<\/span> ,inplace= True<\/span> )\n\n#view DataFrame\n<\/span>print<\/span> (df) \n\n  team points assists rebounds\n0 A 25.0 5.0 11\n1 0 0.0 7.0 8\n2 B 15.0 7.0 10\n3 B 0.0 9.0 6\n4 B 19.0 12.0 6\n5 C 23.0 9.0 5\n6 C 25.0 0.0 9\n7 C 29.0 4.0 12<\/strong><\/pre>\n
 Exemplo 2: Preencha valores ausentes para m\u00faltiplas colunas<\/strong><\/span><\/h3>\n
 O c\u00f3digo a seguir mostra como preencher valores ausentes com zero apenas para as colunas de ponto e auxiliares do DataFrame:<\/span><\/p>\n
 #replace missing values in points and assists columns with zero<\/span>\ndf[['points', 'assists']] = df[['points', 'assists']]. fillna<\/span> (value= 0<\/span> )\n\n#view DataFrame\n<\/span>print<\/span> (df) \n\n  team points assists rebounds\n0 A 25.0 5.0 11\n1 NaN 0.0 7.0 8\n2 B 15.0 7.0 10\n3 B 0.0 9.0 6\n4 B 19.0 12.0 6\n5 C 23.0 9.0 5\n6 C 25.0 0.0 9\n7 C 29.0 4.0 12\n<\/strong><\/pre>\n
 Exemplo 3: Preencha valores ausentes de v\u00e1rias colunas com valores diferentes<\/strong><\/span><\/h3>\n
 O c\u00f3digo a seguir mostra como preencher valores ausentes em tr\u00eas colunas diferentes com tr\u00eas valores diferentes:<\/span><\/p>\n
 #replace missing values in three columns with three different values<\/span>\ndf. fillna<\/span> ({'team': ' Unknown<\/span> ', 'points': 0<\/span> , 'assists': ' zero<\/span> '}, inplace= True<\/span> )\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n      team points assists rebounds\n0 A 25.0 5 11\n1 Unknown 0.0 7 8\n2 B 15.0 7 10\n3 B 0.0 9 6\n4 B 19.0 12 6\n5 C 23.0 9 5\n6 C 25.0 zero 9\n7 C 29.0 4 12\n<\/strong><\/pre>\n
 Observe que cada um dos valores ausentes nas tr\u00eas colunas foi substitu\u00eddo por um valor exclusivo.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
A fun\u00e7\u00e3o pandas fillna() \u00e9 \u00fatil para preencher valores ausentes nas colunas de um DataFrame do pandas. Este tutorial fornece v\u00e1rios exemplos de uso desta fun\u00e7\u00e3o para preencher valores ausentes para v\u00e1rias colunas no seguinte DataFrame do pandas: import pandas as pd import numpy as np #createDataFrame df = pd. DataFrame ({‘team’: [‘A’, np. nan […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-1360","post","type-post","status-publish","format-standard","hentry","category-guia"],"yoast_head":"\nComo preencher valores NA para m\u00faltiplas colunas no Pandas<\/title>\n<meta name=\"description\" content=\"Este tutorial explica como preencher valores NA para m\u00faltiplas colunas em um DataFrame do pandas, incluindo exemplos.\" \/>\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\/pt\/fillna-pandas-multicolunas\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como preencher valores NA para m\u00faltiplas colunas no Pandas\" \/>\n<meta property=\"og:description\" content=\"Este tutorial explica como preencher valores NA para m\u00faltiplas colunas em um DataFrame do pandas, incluindo exemplos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pt\/fillna-pandas-multicolunas\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T17:12:24+00:00\" \/>\n<meta name=\"author\" content=\"Dr. benjamim anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr. benjamim anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/pt\/fillna-pandas-multicolunas\/\",\"url\":\"https:\/\/statorials.org\/pt\/fillna-pandas-multicolunas\/\",\"name\":\"Como preencher valores NA para m\u00faltiplas colunas no Pandas\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pt\/#website\"},\"datePublished\":\"2023-07-26T17:12:24+00:00\",\"dateModified\":\"2023-07-26T17:12:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\"},\"description\":\"Este tutorial explica como preencher valores NA para m\u00faltiplas colunas em um DataFrame do pandas, incluindo exemplos.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pt\/fillna-pandas-multicolunas\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pt\/fillna-pandas-multicolunas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pt\/fillna-pandas-multicolunas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/statorials.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como preencher valores na para m\u00faltiplas colunas no pandas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/pt\/#website\",\"url\":\"https:\/\/statorials.org\/pt\/\",\"name\":\"Statorials\",\"description\":\"O seu guia para a literacia estat\u00edstica!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/pt\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\",\"name\":\"Dr. benjamim anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr. benjamim anderson\"},\"description\":\"Ol\u00e1, sou Benjamin, um professor aposentado de estat\u00edstica que se tornou professor dedicado na Statorials. Com vasta experi\u00eancia e conhecimento na \u00e1rea de estat\u00edstica, estou empenhado em compartilhar meu conhecimento para capacitar os alunos por meio de Statorials. Saber mais\",\"sameAs\":[\"https:\/\/statorials.org\/pt\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como preencher valores NA para m\u00faltiplas colunas no Pandas","description":"Este tutorial explica como preencher valores NA para m\u00faltiplas colunas em um DataFrame do pandas, incluindo exemplos.","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\/pt\/fillna-pandas-multicolunas\/","og_locale":"pt_PT","og_type":"article","og_title":"Como preencher valores NA para m\u00faltiplas colunas no Pandas","og_description":"Este tutorial explica como preencher valores NA para m\u00faltiplas colunas em um DataFrame do pandas, incluindo exemplos.","og_url":"https:\/\/statorials.org\/pt\/fillna-pandas-multicolunas\/","og_site_name":"Statorials","article_published_time":"2023-07-26T17:12:24+00:00","author":"Dr. benjamim anderson","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dr. benjamim anderson","Tempo estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/pt\/fillna-pandas-multicolunas\/","url":"https:\/\/statorials.org\/pt\/fillna-pandas-multicolunas\/","name":"Como preencher valores NA para m\u00faltiplas colunas no Pandas","isPartOf":{"@id":"https:\/\/statorials.org\/pt\/#website"},"datePublished":"2023-07-26T17:12:24+00:00","dateModified":"2023-07-26T17:12:24+00:00","author":{"@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666"},"description":"Este tutorial explica como preencher valores NA para m\u00faltiplas colunas em um DataFrame do pandas, incluindo exemplos.","breadcrumb":{"@id":"https:\/\/statorials.org\/pt\/fillna-pandas-multicolunas\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pt\/fillna-pandas-multicolunas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pt\/fillna-pandas-multicolunas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/statorials.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como preencher valores na para m\u00faltiplas colunas no pandas"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/pt\/#website","url":"https:\/\/statorials.org\/pt\/","name":"Statorials","description":"O seu guia para a literacia estat\u00edstica!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/pt\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666","name":"Dr. benjamim anderson","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr. benjamim anderson"},"description":"Ol\u00e1, sou Benjamin, um professor aposentado de estat\u00edstica que se tornou professor dedicado na Statorials. Com vasta experi\u00eancia e conhecimento na \u00e1rea de estat\u00edstica, estou empenhado em compartilhar meu conhecimento para capacitar os alunos por meio de Statorials. Saber mais","sameAs":["https:\/\/statorials.org\/pt"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/1360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/comments?post=1360"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/1360\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/media?parent=1360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/categories?post=1360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/tags?post=1360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}