{"id":3227,"date":"2023-07-18T14:10:40","date_gmt":"2023-07-18T14:10:40","guid":{"rendered":"https:\/\/statorials.org\/pt\/coluna-especifica-do-pandas-fillna\/"},"modified":"2023-07-18T14:10:40","modified_gmt":"2023-07-18T14:10:40","slug":"coluna-especifica-do-pandas-fillna","status":"publish","type":"post","link":"https:\/\/statorials.org\/pt\/coluna-especifica-do-pandas-fillna\/","title":{"rendered":"Pandas: como usar fillna() com colunas espec\u00edficas"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Voc\u00ea pode usar os seguintes m\u00e9todos com <strong>fillna()<\/strong> para substituir valores NaN em colunas espec\u00edficas de um DataFrame do pandas:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>M\u00e9todo 1: Use fillna() com uma coluna espec\u00edfica<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[' <span style=\"color: #008000;\">col1<\/span> '] = df[' <span style=\"color: #008000;\">col1<\/span> ']. <span style=\"color: #3366ff;\">fillna<\/span> (0)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>M\u00e9todo 2: Use fillna() com m\u00faltiplas colunas espec\u00edficas<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[[' <span style=\"color: #008000;\">col1<\/span> ', ' <span style=\"color: #008000;\">col2<\/span> ']] = df[[' <span style=\"color: #008000;\">col1<\/span> ', ' <span style=\"color: #008000;\">col2<\/span> ']]. <span style=\"color: #3366ff;\">fillna<\/span> (0)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Este tutorial explica como usar esta fun\u00e7\u00e3o com o seguinte DataFrame do pandas:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #107d3f;\">import<\/span> numpy <span style=\"color: #107d3f;\">as<\/span> np\n<span style=\"color: #107d3f;\">import<\/span> pandas <span style=\"color: #107d3f;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#create DataFrame with some NaN values<\/span>\ndf = pd. <span style=\"color: #3366ff;\">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<span style=\"color: #008080;\">\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<h3> <span style=\"color: #000000;\"><strong>Exemplo 1: Use fillna() com uma coluna espec\u00edfica<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">O c\u00f3digo a seguir mostra como usar <strong>fillna()<\/strong> para substituir valores NaN por zeros apenas na coluna \u201cnota\u201d:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#replace NaNs with zeros in 'rating' column<\/span>\ndf[' <span style=\"color: #008000;\">rating<\/span> '] = df[' <span style=\"color: #008000;\">rating<\/span> ']. <span style=\"color: #3366ff;\">fillna<\/span> (0)\n<span style=\"color: #008080;\">\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<p> <span style=\"color: #000000;\">Observe que os valores NaN foram substitu\u00eddos apenas na coluna \u201cnota\u201d e todas as outras colunas foram deixadas intactas.<\/span><\/p>\n<h3> <strong>Exemplo 2: Use fillna<\/strong> <span style=\"color: #000000;\"><strong>() com m\u00faltiplas colunas espec\u00edficas<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">O c\u00f3digo a seguir mostra como usar <strong>fillna()<\/strong> para substituir valores NaN por zeros nas colunas \u201cnota\u201d e \u201cpontos\u201d:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#replace NaNs with zeros in 'rating' and 'points' columns<\/span>\ndf[[' <span style=\"color: #008000;\">rating<\/span> ', ' <span style=\"color: #008000;\">points<\/span> ']] = df[[' <span style=\"color: #008000;\">rating<\/span> ', ' <span style=\"color: #008000;\">points<\/span> ']]. <span style=\"color: #3366ff;\">fillna<\/span> (0)\n\n<span style=\"color: #008080;\">#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<p> <span style=\"color: #000000;\">Observe que os valores NaN foram substitu\u00eddos nas colunas \u201cnota\u201d e \u201cpontos\u201d, mas as demais colunas permanecem intactas.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Nota<\/strong> : Voc\u00ea pode encontrar a documenta\u00e7\u00e3o completa da fun\u00e7\u00e3o pandas <strong>fillna()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.fillna.html\" target=\"_blank\" rel=\"noopener\">aqui<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Recursos adicionais<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Os tutoriais a seguir explicam como realizar outras opera\u00e7\u00f5es comuns em pandas:<\/span><\/p>\n<p><a href=\"https:\/\/statorials.org\/pt\/pandas-contam-valores-faltantes\/\" target=\"_blank\" rel=\"noopener\">Como contar valores faltantes em pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/solte-os-pandas\/\" target=\"_blank\" rel=\"noopener\">Como deletar linhas com valores NaN no Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/pandas-eliminam-linhas-com-valor\/\" target=\"_blank\" rel=\"noopener\">Como deletar linhas contendo um valor espec\u00edfico no Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Voc\u00ea pode usar os seguintes m\u00e9todos com fillna() para substituir valores NaN em colunas espec\u00edficas de um DataFrame do pandas: M\u00e9todo 1: Use fillna() com uma coluna espec\u00edfica df[&#8216; col1 &#8216;] = df[&#8216; col1 &#8216;]. fillna (0) M\u00e9todo 2: Use fillna() com m\u00faltiplas colunas espec\u00edficas df[[&#8216; col1 &#8216;, &#8216; col2 &#8216;]] = df[[&#8216; col1 &#8216;, [&hellip;]<\/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-3227","post","type-post","status-publish","format-standard","hentry","category-guia"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Pandas: Como usar fillna() com colunas espec\u00edficas \u2013 Estatoriais<\/title>\n<meta name=\"description\" content=\"Este tutorial explica como usar a fun\u00e7\u00e3o fillna() no pandas para substituir valores em colunas espec\u00edficas, 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\/coluna-especifica-do-pandas-fillna\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Como usar fillna() com colunas espec\u00edficas \u2013 Estatoriais\" \/>\n<meta property=\"og:description\" content=\"Este tutorial explica como usar a fun\u00e7\u00e3o fillna() no pandas para substituir valores em colunas espec\u00edficas, incluindo exemplos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pt\/coluna-especifica-do-pandas-fillna\/\" \/>\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=\"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=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/pt\/coluna-especifica-do-pandas-fillna\/\",\"url\":\"https:\/\/statorials.org\/pt\/coluna-especifica-do-pandas-fillna\/\",\"name\":\"Pandas: Como usar fillna() com colunas espec\u00edficas \u2013 Estatoriais\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pt\/#website\"},\"datePublished\":\"2023-07-18T14:10:40+00:00\",\"dateModified\":\"2023-07-18T14:10:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\"},\"description\":\"Este tutorial explica como usar a fun\u00e7\u00e3o fillna() no pandas para substituir valores em colunas espec\u00edficas, incluindo exemplos.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pt\/coluna-especifica-do-pandas-fillna\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pt\/coluna-especifica-do-pandas-fillna\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pt\/coluna-especifica-do-pandas-fillna\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/statorials.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: como usar fillna() com colunas espec\u00edficas\"}]},{\"@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":"Pandas: Como usar fillna() com colunas espec\u00edficas \u2013 Estatoriais","description":"Este tutorial explica como usar a fun\u00e7\u00e3o fillna() no pandas para substituir valores em colunas espec\u00edficas, 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\/coluna-especifica-do-pandas-fillna\/","og_locale":"pt_PT","og_type":"article","og_title":"Pandas: Como usar fillna() com colunas espec\u00edficas \u2013 Estatoriais","og_description":"Este tutorial explica como usar a fun\u00e7\u00e3o fillna() no pandas para substituir valores em colunas espec\u00edficas, incluindo exemplos.","og_url":"https:\/\/statorials.org\/pt\/coluna-especifica-do-pandas-fillna\/","og_site_name":"Statorials","article_published_time":"2023-07-18T14:10:40+00:00","author":"Dr. benjamim anderson","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dr. benjamim anderson","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/pt\/coluna-especifica-do-pandas-fillna\/","url":"https:\/\/statorials.org\/pt\/coluna-especifica-do-pandas-fillna\/","name":"Pandas: Como usar fillna() com colunas espec\u00edficas \u2013 Estatoriais","isPartOf":{"@id":"https:\/\/statorials.org\/pt\/#website"},"datePublished":"2023-07-18T14:10:40+00:00","dateModified":"2023-07-18T14:10:40+00:00","author":{"@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666"},"description":"Este tutorial explica como usar a fun\u00e7\u00e3o fillna() no pandas para substituir valores em colunas espec\u00edficas, incluindo exemplos.","breadcrumb":{"@id":"https:\/\/statorials.org\/pt\/coluna-especifica-do-pandas-fillna\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pt\/coluna-especifica-do-pandas-fillna\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pt\/coluna-especifica-do-pandas-fillna\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/statorials.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Pandas: como usar fillna() com colunas espec\u00edficas"}]},{"@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\/3227","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=3227"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/3227\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/media?parent=3227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/categories?post=3227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/tags?post=3227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}