{"id":3227,"date":"2023-07-18T14:10:40","date_gmt":"2023-07-18T14:10:40","guid":{"rendered":"https:\/\/statorials.org\/tr\/pandalar-belirli-bir-sutunu-doldurur\/"},"modified":"2023-07-18T14:10:40","modified_gmt":"2023-07-18T14:10:40","slug":"pandalar-belirli-bir-sutunu-doldurur","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/pandalar-belirli-bir-sutunu-doldurur\/","title":{"rendered":"Pandalar: belirli s\u00fctunlarla fillna() nas\u0131l kullan\u0131l\u0131r"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Bir pandan\u0131n DataFrame&#8217;inin belirli s\u00fctunlar\u0131ndaki NaN de\u011ferlerini de\u011fi\u015ftirmek i\u00e7in <strong>fillna()<\/strong> ile a\u015fa\u011f\u0131daki y\u00f6ntemleri kullanabilirsiniz:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Y\u00f6ntem 1: Belirli bir s\u00fctunla fillna() i\u015flevini kullan\u0131n<\/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>Y\u00f6ntem 2: Birden \u00e7ok belirli s\u00fctunla fillna() i\u015flevini kullan\u0131n<\/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;\">Bu e\u011fitimde bu i\u015flevin a\u015fa\u011f\u0131daki pandalar DataFrame ile nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r:<\/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>\u00d6rnek 1: Belirli bir s\u00fctunla fillna() i\u015flevini kullanma<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki kod, NaN de\u011ferlerini yaln\u0131zca &#8220;not&#8221; s\u00fctununda s\u0131f\u0131rlarla de\u011fi\u015ftirmek i\u00e7in <strong>fillna()<\/strong> i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/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;\">NaN de\u011ferlerinin yaln\u0131zca &#8220;not&#8221; s\u00fctununda de\u011fi\u015ftirildi\u011fini ve di\u011fer t\u00fcm s\u00fctunlar\u0131n oldu\u011fu gibi kald\u0131\u011f\u0131n\u0131 unutmay\u0131n.<\/span><\/p>\n<h3> <strong>\u00d6rnek 2:<\/strong> <span style=\"color: #000000;\"><strong>Birden \u00e7ok belirli s\u00fctunla fillna ()<\/strong><\/span> i\u015flevini kullanma<\/h3>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki kod, &#8220;grade&#8221; ve &#8220;points&#8221; s\u00fctunlar\u0131ndaki NaN de\u011ferlerini s\u0131f\u0131rlarla de\u011fi\u015ftirmek i\u00e7in <strong>fillna()<\/strong> i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/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;\">&#8220;Derece&#8221; ve &#8220;puan&#8221; s\u00fctunlar\u0131ndaki NaN de\u011ferlerinin de\u011fi\u015ftirildi\u011fini ancak di\u011fer s\u00fctunlar\u0131n de\u011fi\u015fmeden kald\u0131\u011f\u0131n\u0131 unutmay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Not<\/strong> : Pandas <strong>fillna()<\/strong> i\u015flevinin tam belgelerini <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.fillna.html\" target=\"_blank\" rel=\"noopener\">burada<\/a> bulabilirsiniz.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde pandalarda di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/tr\/pandalar-eksik-degerleri-sayar\/\" target=\"_blank\" rel=\"noopener\">Pandalarda eksik de\u011ferler nas\u0131l say\u0131l\u0131r?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/pandalari-birak\/\" target=\"_blank\" rel=\"noopener\">Pandalar&#8217;da NaN de\u011ferlerine sahip sat\u0131rlar nas\u0131l silinir<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/pandalar-degeri-olan-satirlari-birakir\/\" target=\"_blank\" rel=\"noopener\">Pandalarda belirli bir de\u011fer i\u00e7eren sat\u0131rlar nas\u0131l silinir<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bir pandan\u0131n DataFrame&#8217;inin belirli s\u00fctunlar\u0131ndaki NaN de\u011ferlerini de\u011fi\u015ftirmek i\u00e7in fillna() ile a\u015fa\u011f\u0131daki y\u00f6ntemleri kullanabilirsiniz: Y\u00f6ntem 1: Belirli bir s\u00fctunla fillna() i\u015flevini kullan\u0131n df[&#8216; col1 &#8216;] = df[&#8216; col1 &#8216;]. fillna (0) Y\u00f6ntem 2: Birden \u00e7ok belirli s\u00fctunla fillna() i\u015flevini kullan\u0131n df[[&#8216; col1 &#8216;, &#8216; col2 &#8216;]] = df[[&#8216; col1 &#8216;, &#8216; col2 &#8216;]]. fillna (0) [&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-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Pandalar: Belirli s\u00fctunlarla fillna() nas\u0131l kullan\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, \u00f6rnekler de dahil olmak \u00fczere belirli s\u00fctunlardaki de\u011ferleri de\u011fi\u015ftirmek i\u00e7in pandalarda fillna() i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\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\/tr\/pandalar-belirli-bir-sutunu-doldurur\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandalar: Belirli s\u00fctunlarla fillna() nas\u0131l kullan\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, \u00f6rnekler de dahil olmak \u00fczere belirli s\u00fctunlardaki de\u011ferleri de\u011fi\u015ftirmek i\u00e7in pandalarda fillna() i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/pandalar-belirli-bir-sutunu-doldurur\/\" \/>\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.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/pandalar-belirli-bir-sutunu-doldurur\/\",\"url\":\"https:\/\/statorials.org\/tr\/pandalar-belirli-bir-sutunu-doldurur\/\",\"name\":\"Pandalar: Belirli s\u00fctunlarla fillna() nas\u0131l kullan\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-18T14:10:40+00:00\",\"dateModified\":\"2023-07-18T14:10:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, \u00f6rnekler de dahil olmak \u00fczere belirli s\u00fctunlardaki de\u011ferleri de\u011fi\u015ftirmek i\u00e7in pandalarda fillna() i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/pandalar-belirli-bir-sutunu-doldurur\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/pandalar-belirli-bir-sutunu-doldurur\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/pandalar-belirli-bir-sutunu-doldurur\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandalar: belirli s\u00fctunlarla fillna() nas\u0131l kullan\u0131l\u0131r\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pandalar: Belirli s\u00fctunlarla fillna() nas\u0131l kullan\u0131l\u0131r?","description":"Bu e\u011fitimde, \u00f6rnekler de dahil olmak \u00fczere belirli s\u00fctunlardaki de\u011ferleri de\u011fi\u015ftirmek i\u00e7in pandalarda fillna() i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","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\/tr\/pandalar-belirli-bir-sutunu-doldurur\/","og_locale":"tr_TR","og_type":"article","og_title":"Pandalar: Belirli s\u00fctunlarla fillna() nas\u0131l kullan\u0131l\u0131r?","og_description":"Bu e\u011fitimde, \u00f6rnekler de dahil olmak \u00fczere belirli s\u00fctunlardaki de\u011ferleri de\u011fi\u015ftirmek i\u00e7in pandalarda fillna() i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/pandalar-belirli-bir-sutunu-doldurur\/","og_site_name":"Statorials","article_published_time":"2023-07-18T14:10:40+00:00","author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/pandalar-belirli-bir-sutunu-doldurur\/","url":"https:\/\/statorials.org\/tr\/pandalar-belirli-bir-sutunu-doldurur\/","name":"Pandalar: Belirli s\u00fctunlarla fillna() nas\u0131l kullan\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-18T14:10:40+00:00","dateModified":"2023-07-18T14:10:40+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, \u00f6rnekler de dahil olmak \u00fczere belirli s\u00fctunlardaki de\u011ferleri de\u011fi\u015ftirmek i\u00e7in pandalarda fillna() i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/pandalar-belirli-bir-sutunu-doldurur\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/pandalar-belirli-bir-sutunu-doldurur\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/pandalar-belirli-bir-sutunu-doldurur\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Pandalar: belirli s\u00fctunlarla fillna() nas\u0131l kullan\u0131l\u0131r"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=3227"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3227\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=3227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=3227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=3227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}