{"id":2028,"date":"2023-07-24T00:47:19","date_gmt":"2023-07-24T00:47:19","guid":{"rendered":"https:\/\/statorials.org\/nl\/pandas-vullen\/"},"modified":"2023-07-24T00:47:19","modified_gmt":"2023-07-24T00:47:19","slug":"pandas-vullen","status":"publish","type":"post","link":"https:\/\/statorials.org\/nl\/pandas-vullen\/","title":{"rendered":"Hoe pandas fillna() te gebruiken om nan-waarden te vervangen"},"content":{"rendered":"

<\/p>\n

\n

U kunt de functie fillna()<\/strong> gebruiken om NaN-waarden in een pandas DataFrame te vervangen.<\/span><\/p>\n

Deze functie gebruikt de volgende basissyntaxis:<\/span><\/p>\n

 #replace NaN values in one column<\/span>\ndf[' col1<\/span> '] = df[' col1<\/span> ']. fillna<\/span> (0)\n\n#replace NaN values in multiple columns\n<\/span>df[[' col1<\/span> ', ' col2<\/span> ']] = df[[' col1<\/span> ', ' col2<\/span> ']]. fillna<\/span> (0) \n\n#replace NaN values in all columns<\/span>\ndf = df. fillna<\/span> (0)<\/strong><\/pre>\n
 In deze tutorial wordt uitgelegd hoe u deze functie kunt gebruiken met de volgende panda’s DataFrame:<\/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({'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
 Voorbeeld 1: Vervang NaN-waarden in een kolom<\/strong><\/span><\/h3>\n
 De volgende code laat zien hoe u NaN-waarden vervangt door nullen in de kolom „opmerking“:<\/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
 Voorbeeld 2: Vervang NaN-waarden in meerdere kolommen<\/strong><\/h3>\n
 De volgende code laat zien hoe u NaN-waarden vervangt door nullen in de kolommen „cijfer“ en „punten“:<\/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
 Voorbeeld 3: Vervang NaN-waarden in alle kolommen<\/strong><\/h3>\n
 De volgende code laat zien hoe je de NaN-waarden in elke kolom vervangt door nullen:<\/span><\/p>\n
 #replace NaNs with zeros in all columns<\/span> \ndf = df. fillna<\/span> (0)\n\n#view DataFrame\n<\/span>df\n\n        rating 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 0.0 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
 U kunt hier<\/a> de volledige online documentatie voor de functie fillna()<\/strong> vinden.<\/span><\/p>\n
 Aanvullende bronnen<\/strong><\/span><\/h3>\n
 In de volgende tutorials wordt uitgelegd hoe u andere veelvoorkomende bewerkingen in panda’s kunt uitvoeren:<\/span><\/p>\n
 Hoe ontbrekende waarden bij panda’s te tellen<\/a>
 Hoe rijen met NaN-waarden in Panda’s te verwijderen<\/a>
 Hoe rijen met een specifieke waarde in Pandas te verwijderen<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
U kunt de functie fillna() gebruiken om NaN-waarden in een pandas DataFrame te vervangen. Deze functie gebruikt de volgende basissyntaxis: #replace NaN values in one column df[‚ col1 ‚] = df[‚ col1 ‚]. fillna (0) #replace NaN values in multiple columns df[[‚ col1 ‚, ‚ col2 ‚]] = df[[‚ col1 ‚, ‚ col2 ‚]]. fillna […]<\/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-2028","post","type-post","status-publish","format-standard","hentry","category-gids"],"yoast_head":"\nHoe Pandas fillna() te gebruiken om NaN-waarden te vervangen \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"In deze tutorial wordt met voorbeelden uitgelegd hoe u de functie pandas fillna() gebruikt om NaN-waarden in een DataFrame te vervangen.\" \/>\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\/nl\/pandas-vullen\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe Pandas fillna() te gebruiken om NaN-waarden te vervangen \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"In deze tutorial wordt met voorbeelden uitgelegd hoe u de functie pandas fillna() gebruikt om NaN-waarden in een DataFrame te vervangen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/nl\/pandas-vullen\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T00:47:19+00:00\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/nl\/pandas-vullen\/\",\"url\":\"https:\/\/statorials.org\/nl\/pandas-vullen\/\",\"name\":\"Hoe Pandas fillna() te gebruiken om NaN-waarden te vervangen \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/nl\/#website\"},\"datePublished\":\"2023-07-24T00:47:19+00:00\",\"dateModified\":\"2023-07-24T00:47:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/nl\/#\/schema\/person\/d4b8842173cca1bb62cdec41860e4219\"},\"description\":\"In deze tutorial wordt met voorbeelden uitgelegd hoe u de functie pandas fillna() gebruikt om NaN-waarden in een DataFrame te vervangen.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/nl\/pandas-vullen\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/nl\/pandas-vullen\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/nl\/pandas-vullen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/statorials.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe pandas fillna() te gebruiken om nan-waarden te vervangen\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/nl\/#website\",\"url\":\"https:\/\/statorials.org\/nl\/\",\"name\":\"Statorials\",\"description\":\"Uw gids voor statistische competentie\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/nl\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/nl\/#\/schema\/person\/d4b8842173cca1bb62cdec41860e4219\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/statorials.org\/nl\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/nl\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/nl\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Ik ben Benjamin, een gepensioneerde hoogleraar statistiek die nu een toegewijde Statorials-lesgever is. Ik heb uitgebreide ervaring en expertise op het gebied van statistiek en ik ben vastbesloten om mijn kennis te delen met studenten via Statorials. Lees verder\",\"sameAs\":[\"http:\/\/statorials.org\/nl\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hoe Pandas fillna() te gebruiken om NaN-waarden te vervangen \u2013 Statorials","description":"In deze tutorial wordt met voorbeelden uitgelegd hoe u de functie pandas fillna() gebruikt om NaN-waarden in een DataFrame te vervangen.","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\/nl\/pandas-vullen\/","og_locale":"de_DE","og_type":"article","og_title":"Hoe Pandas fillna() te gebruiken om NaN-waarden te vervangen \u2013 Statorials","og_description":"In deze tutorial wordt met voorbeelden uitgelegd hoe u de functie pandas fillna() gebruikt om NaN-waarden in een DataFrame te vervangen.","og_url":"https:\/\/statorials.org\/nl\/pandas-vullen\/","og_site_name":"Statorials","article_published_time":"2023-07-24T00:47:19+00:00","author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"Dr.benjamin anderson","Gesch\u00e4tzte Lesezeit":"2\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/nl\/pandas-vullen\/","url":"https:\/\/statorials.org\/nl\/pandas-vullen\/","name":"Hoe Pandas fillna() te gebruiken om NaN-waarden te vervangen \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/nl\/#website"},"datePublished":"2023-07-24T00:47:19+00:00","dateModified":"2023-07-24T00:47:19+00:00","author":{"@id":"https:\/\/statorials.org\/nl\/#\/schema\/person\/d4b8842173cca1bb62cdec41860e4219"},"description":"In deze tutorial wordt met voorbeelden uitgelegd hoe u de functie pandas fillna() gebruikt om NaN-waarden in een DataFrame te vervangen.","breadcrumb":{"@id":"https:\/\/statorials.org\/nl\/pandas-vullen\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/nl\/pandas-vullen\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/nl\/pandas-vullen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/statorials.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe pandas fillna() te gebruiken om nan-waarden te vervangen"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/nl\/#website","url":"https:\/\/statorials.org\/nl\/","name":"Statorials","description":"Uw gids voor statistische competentie","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/nl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de"},{"@type":"Person","@id":"https:\/\/statorials.org\/nl\/#\/schema\/person\/d4b8842173cca1bb62cdec41860e4219","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/statorials.org\/nl\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/nl\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/nl\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Ik ben Benjamin, een gepensioneerde hoogleraar statistiek die nu een toegewijde Statorials-lesgever is. Ik heb uitgebreide ervaring en expertise op het gebied van statistiek en ik ben vastbesloten om mijn kennis te delen met studenten via Statorials. Lees verder","sameAs":["http:\/\/statorials.org\/nl"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/posts\/2028","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/comments?post=2028"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/posts\/2028\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/media?parent=2028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/categories?post=2028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/tags?post=2028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}