{"id":3206,"date":"2023-07-18T16:51:56","date_gmt":"2023-07-18T16:51:56","guid":{"rendered":"https:\/\/statorials.org\/pt\/pandas-fillna-com-moda\/"},"modified":"2023-07-18T16:51:56","modified_gmt":"2023-07-18T16:51:56","slug":"pandas-fillna-com-moda","status":"publish","type":"post","link":"https:\/\/statorials.org\/pt\/pandas-fillna-com-moda\/","title":{"rendered":"Pandas: como preencher valores nan com modo"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Voc\u00ea pode usar a seguinte sintaxe para substituir valores NaN em uma coluna de um DataFrame do pandas pelo valor do modo da coluna:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[' <span style=\"color: #ff0000;\">col1<\/span> '] = df[' <span style=\"color: #ff0000;\">col1<\/span> ']. <span style=\"color: #3366ff;\">fillna<\/span> (df[' <span style=\"color: #ff0000;\">col1<\/span> ']. <span style=\"color: #3366ff;\">mode<\/span> ()[0])<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">O exemplo a seguir mostra como usar essa sintaxe na pr\u00e1tica.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Exemplo: Substitua valores ausentes por Modo no Pandas<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Vamos supor que temos o seguinte DataFrame do pandas com alguns valores ausentes:<\/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> ({' <span style=\"color: #ff0000;\">rating<\/span> ': [np.nan, 85, np.nan, 88, 94, 90, 75, 75, 87, 86],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [25, np.nan, 14, 16, 27, 20, 12, 15, 14, 19],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [5, 7, 7, np.nan, 5, 7, 6, 9, 9, 7],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [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 75.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 7.0 7\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Podemos usar a fun\u00e7\u00e3o <strong>fillna()<\/strong> para preencher os valores NaN na coluna <strong>de classifica\u00e7\u00e3o<\/strong> com o valor da moda da coluna <strong>de classifica\u00e7\u00e3o<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#fill NaNs with column mode in 'rating' column<\/span>\n<span style=\"color: #008080;\"><span style=\"color: #000000;\">df[' <span style=\"color: #ff0000;\">rating<\/span> '] = df[' <span style=\"color: #ff0000;\">rating<\/span> ']. <span style=\"color: #3366ff;\">fillna<\/span> (df[' <span style=\"color: #ff0000;\">rating<\/span> ']. <span style=\"color: #3366ff;\">mode<\/span> ()[0])\n\n<\/span>#view updated DataFrame<\/span>\ndf\n\n\trating points assists rebounds\n0 75.0 25.0 5.0 11\n1 85.0 NaN 7.0 8\n2 75.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 75.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 7.0 7\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">O valor da moda na coluna <strong>de classifica\u00e7\u00e3o<\/strong> era <b>75<\/b> , portanto, cada um dos valores NaN na coluna <strong>de classifica\u00e7\u00e3o<\/strong> foi preenchido com esse valor.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Nota<\/strong> : Voc\u00ea pode encontrar a documenta\u00e7\u00e3o online completa para a fun\u00e7\u00e3o <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 a seguinte sintaxe para substituir valores NaN em uma coluna de um DataFrame do pandas pelo valor do modo da coluna: df[&#8216; col1 &#8216;] = df[&#8216; col1 &#8216;]. fillna (df[&#8216; col1 &#8216;]. mode ()[0]) O exemplo a seguir mostra como usar essa sintaxe na pr\u00e1tica. Exemplo: Substitua valores ausentes por Modo no [&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-3206","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 preencher valores NaN com modo - Estatoriais<\/title>\n<meta name=\"description\" content=\"Este tutorial explica como usar a fun\u00e7\u00e3o fillna() em pandas para preencher valores ausentes com modo, 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\/pandas-fillna-com-moda\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Como preencher valores NaN com modo - Estatoriais\" \/>\n<meta property=\"og:description\" content=\"Este tutorial explica como usar a fun\u00e7\u00e3o fillna() em pandas para preencher valores ausentes com modo, incluindo exemplos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pt\/pandas-fillna-com-moda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T16:51:56+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\/pandas-fillna-com-moda\/\",\"url\":\"https:\/\/statorials.org\/pt\/pandas-fillna-com-moda\/\",\"name\":\"Pandas: Como preencher valores NaN com modo - Estatoriais\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pt\/#website\"},\"datePublished\":\"2023-07-18T16:51:56+00:00\",\"dateModified\":\"2023-07-18T16:51:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\"},\"description\":\"Este tutorial explica como usar a fun\u00e7\u00e3o fillna() em pandas para preencher valores ausentes com modo, incluindo exemplos.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pt\/pandas-fillna-com-moda\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pt\/pandas-fillna-com-moda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pt\/pandas-fillna-com-moda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/statorials.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: como preencher valores nan com modo\"}]},{\"@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 preencher valores NaN com modo - Estatoriais","description":"Este tutorial explica como usar a fun\u00e7\u00e3o fillna() em pandas para preencher valores ausentes com modo, 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\/pandas-fillna-com-moda\/","og_locale":"pt_PT","og_type":"article","og_title":"Pandas: Como preencher valores NaN com modo - Estatoriais","og_description":"Este tutorial explica como usar a fun\u00e7\u00e3o fillna() em pandas para preencher valores ausentes com modo, incluindo exemplos.","og_url":"https:\/\/statorials.org\/pt\/pandas-fillna-com-moda\/","og_site_name":"Statorials","article_published_time":"2023-07-18T16:51:56+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\/pandas-fillna-com-moda\/","url":"https:\/\/statorials.org\/pt\/pandas-fillna-com-moda\/","name":"Pandas: Como preencher valores NaN com modo - Estatoriais","isPartOf":{"@id":"https:\/\/statorials.org\/pt\/#website"},"datePublished":"2023-07-18T16:51:56+00:00","dateModified":"2023-07-18T16:51:56+00:00","author":{"@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666"},"description":"Este tutorial explica como usar a fun\u00e7\u00e3o fillna() em pandas para preencher valores ausentes com modo, incluindo exemplos.","breadcrumb":{"@id":"https:\/\/statorials.org\/pt\/pandas-fillna-com-moda\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pt\/pandas-fillna-com-moda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pt\/pandas-fillna-com-moda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/statorials.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Pandas: como preencher valores nan com modo"}]},{"@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\/3206","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=3206"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/3206\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/media?parent=3206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/categories?post=3206"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/tags?post=3206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}