{"id":2034,"date":"2023-07-24T00:14:06","date_gmt":"2023-07-24T00:14:06","guid":{"rendered":"https:\/\/statorials.org\/tr\/pandalarin-anahtar-hatasi\/"},"modified":"2023-07-24T00:14:06","modified_gmt":"2023-07-24T00:14:06","slug":"pandalarin-anahtar-hatasi","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/pandalarin-anahtar-hatasi\/","title":{"rendered":"Pandas'ta keyerror nas\u0131l d\u00fczeltilir (\u00f6rnekle)"},"content":{"rendered":"

<\/p>\n

\n

Pandalar\u0131 kullan\u0131rken kar\u015f\u0131la\u015fabilece\u011finiz bir hata:<\/span><\/p>\n

 KeyError<\/span> : 'column_name'\n<\/strong><\/pre>\n
 Bu hata, mevcut olmayan bir panda DataFrame s\u00fctununa eri\u015fmeye \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda ortaya \u00e7\u0131kar.<\/span><\/p>\n
 Genellikle bu hata, bir s\u00fctun ad\u0131n\u0131 yanl\u0131\u015f yazd\u0131\u011f\u0131n\u0131zda veya s\u00fctun ad\u0131n\u0131n \u00f6n\u00fcne veya arkas\u0131na yanl\u0131\u015fl\u0131kla bo\u015fluk ekledi\u011finizde ortaya \u00e7\u0131kar.<\/span><\/p>\n
 A\u015fa\u011f\u0131daki \u00f6rnekte bu hatan\u0131n pratikte nas\u0131l d\u00fczeltilece\u011fi g\u00f6sterilmektedir.<\/span><\/p>\n
 Hata nas\u0131l yeniden olu\u015fturulur?<\/strong><\/span><\/h3>\n
 A\u015fa\u011f\u0131daki pandalar\u0131 DataFrame olu\u015fturdu\u011fumuzu varsayal\u0131m:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\n<\/span>df = pd. DataFrame<\/span> ({' points<\/span> ': [25, 12, 15, 14, 19, 23, 25, 29],\n                   ' assists<\/span> ': [5, 7, 7, 9, 12, 9, 9, 4],\n                   ' rebounds<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12]})\n\n#view DataFrame\n<\/span>df\n\npoints assists rebounds\n0 25 5 11\n1 12 7 8\n2 15 7 10\n3 14 9 6\n4 19 12 6\n5 23 9 5\n6 25 9 9\n7 29 4 12<\/strong><\/pre>\n
 Daha sonra, de\u011ferleri “nokta” ad\u0131 verilen bir s\u00fctuna yazd\u0131rmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131m\u0131z\u0131 varsayal\u0131m:<\/span><\/p>\n
 #attempt to print values in 'point' column\n<\/span>print<\/span> (df[' point<\/span> '])\n\nKeyError<\/span> Traceback (most recent call last)\n\/srv\/conda\/envs\/notebook\/lib\/python3.7\/site-packages\/pandas\/core\/indexes\/base.py in get_loc(self, key, method, tolerance)\n   3360 try:\n-> 3361 return self._engine.get_loc(casted_key)\n   3362 except KeyError as err:\n\n\/srv\/conda\/envs\/notebook\/lib\/python3.7\/site-packages\/pandas\/_libs\/index.pyx in pandas._libs.index.IndexEngine.get_loc()\n\n\/srv\/conda\/envs\/notebook\/lib\/python3.7\/site-packages\/pandas\/_libs\/index.pyx in pandas._libs.index.IndexEngine.get_loc()\n\npandas\/_libs\/hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()\n\npandas\/_libs\/hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()\n\nKeyError<\/span> : 'dot'\n<\/strong><\/pre>\n
 DataFrame’imizde “nokta” s\u00fctunu olmad\u0131\u011f\u0131ndan KeyError<\/strong> al\u0131yoruz.<\/span><\/p>\n
 Hata nas\u0131l d\u00fczeltilir?<\/strong><\/span><\/h3>\n
 Bu hatay\u0131 d\u00fczeltmenin yolu s\u00fctun ad\u0131n\u0131 do\u011fru yazd\u0131\u011f\u0131m\u0131zdan emin olmakt\u0131r.<\/span><\/p>\n
 DataFrame’deki t\u00fcm s\u00fctun adlar\u0131ndan emin de\u011filsek, her s\u00fctun ad\u0131n\u0131 yazd\u0131rmak i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabiliriz:<\/span><\/p>\n
 #display all column names of DataFrame\n<\/span>print<\/span> ( df.columns.tolist<\/span> () )<\/span>\n\n['points', 'assists', 'rebounds']\n<\/strong><\/pre>\n
 “points” diye bir s\u00fctunun oldu\u011funu g\u00f6r\u00fcyoruz, dolay\u0131s\u0131yla s\u00fctun ad\u0131n\u0131 do\u011fru yazarak hatam\u0131z\u0131 d\u00fczeltebiliriz:<\/span><\/p>\n
 #print values in 'points' column\n<\/span>print<\/span> (df[' points<\/span> '])\n\n0 25\n1 12\n2 15\n3 14\n4 19\n5 23\n6 25\n7 29\nName: points, dtype: int64\n<\/strong><\/pre>\n
 S\u00fctun ad\u0131n\u0131 do\u011fru yazd\u0131\u011f\u0131m\u0131z i\u00e7in hatadan ka\u00e7\u0131n\u0131yoruz.<\/span><\/span><\/p>\n
 Ek kaynaklar<\/strong><\/span><\/h3>\n
 A\u015fa\u011f\u0131daki e\u011fitimlerde Python’daki di\u011fer yayg\u0131n hatalar\u0131n nas\u0131l d\u00fczeltilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n
 Nas\u0131l d\u00fczeltilir? S\u00fctunlar \u00e7ak\u0131\u015f\u0131yor ancak son ek belirtilmemi\u015f<\/a>
 Nas\u0131l d\u00fczeltilir: ‘numpy.ndarray’ nesnesinin ‘append’ \u00f6zelli\u011fi yok<\/a>
 Nas\u0131l d\u00fczeltilir? T\u00fcm skaler de\u011ferleri kullan\u0131yorsan\u0131z bir dizin iletmeniz gerekir<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Pandalar\u0131 kullan\u0131rken kar\u015f\u0131la\u015fabilece\u011finiz bir hata: KeyError : ‘column_name’ Bu hata, mevcut olmayan bir panda DataFrame s\u00fctununa eri\u015fmeye \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda ortaya \u00e7\u0131kar. Genellikle bu hata, bir s\u00fctun ad\u0131n\u0131 yanl\u0131\u015f yazd\u0131\u011f\u0131n\u0131zda veya s\u00fctun ad\u0131n\u0131n \u00f6n\u00fcne veya arkas\u0131na yanl\u0131\u015fl\u0131kla bo\u015fluk ekledi\u011finizde ortaya \u00e7\u0131kar. A\u015fa\u011f\u0131daki \u00f6rnekte bu hatan\u0131n pratikte nas\u0131l d\u00fczeltilece\u011fi g\u00f6sterilmektedir. Hata nas\u0131l yeniden olu\u015fturulur? A\u015fa\u011f\u0131daki pandalar\u0131 DataFrame olu\u015fturdu\u011fumuzu […]<\/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-2034","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\nPandalarda KeyError Nas\u0131l D\u00fczeltilir (\u00d6rnek ile) \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde pandalarda KeyError sorununun nas\u0131l d\u00fczeltilece\u011fi birka\u00e7 \u00f6rnekle 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\/pandalarin-anahtar-hatasi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandalarda KeyError Nas\u0131l D\u00fczeltilir (\u00d6rnek ile) \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde pandalarda KeyError sorununun nas\u0131l d\u00fczeltilece\u011fi birka\u00e7 \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/pandalarin-anahtar-hatasi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T00:14:06+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\/pandalarin-anahtar-hatasi\/\",\"url\":\"https:\/\/statorials.org\/tr\/pandalarin-anahtar-hatasi\/\",\"name\":\"Pandalarda KeyError Nas\u0131l D\u00fczeltilir (\u00d6rnek ile) \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-24T00:14:06+00:00\",\"dateModified\":\"2023-07-24T00:14:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde pandalarda KeyError sorununun nas\u0131l d\u00fczeltilece\u011fi birka\u00e7 \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/pandalarin-anahtar-hatasi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/pandalarin-anahtar-hatasi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/pandalarin-anahtar-hatasi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas'ta keyerror nas\u0131l d\u00fczeltilir (\u00f6rnekle)\"}]},{\"@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":"Pandalarda KeyError Nas\u0131l D\u00fczeltilir (\u00d6rnek ile) \u2013 Statorials","description":"Bu e\u011fitimde pandalarda KeyError sorununun nas\u0131l d\u00fczeltilece\u011fi birka\u00e7 \u00f6rnekle 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\/pandalarin-anahtar-hatasi\/","og_locale":"tr_TR","og_type":"article","og_title":"Pandalarda KeyError Nas\u0131l D\u00fczeltilir (\u00d6rnek ile) \u2013 Statorials","og_description":"Bu e\u011fitimde pandalarda KeyError sorununun nas\u0131l d\u00fczeltilece\u011fi birka\u00e7 \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/pandalarin-anahtar-hatasi\/","og_site_name":"Statorials","article_published_time":"2023-07-24T00:14:06+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\/pandalarin-anahtar-hatasi\/","url":"https:\/\/statorials.org\/tr\/pandalarin-anahtar-hatasi\/","name":"Pandalarda KeyError Nas\u0131l D\u00fczeltilir (\u00d6rnek ile) \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-24T00:14:06+00:00","dateModified":"2023-07-24T00:14:06+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde pandalarda KeyError sorununun nas\u0131l d\u00fczeltilece\u011fi birka\u00e7 \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/pandalarin-anahtar-hatasi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/pandalarin-anahtar-hatasi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/pandalarin-anahtar-hatasi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Pandas'ta keyerror nas\u0131l d\u00fczeltilir (\u00f6rnekle)"}]},{"@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\/2034","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=2034"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/2034\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=2034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=2034"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=2034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}