<\/p>\n
Pandalar\u0131 kullan\u0131rken kar\u015f\u0131la\u015fabilece\u011finiz bir hata:<\/span><\/p>\n Bu hata, iki panda DataFrame’i birle\u015ftirmeye \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda ancak birle\u015ftirdi\u011finiz s\u00fctun bir DataFrame’de bir nesne ve di\u011fer DataFrame’de bir tam say\u0131 oldu\u011funda 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 Diyelim ki a\u015fa\u011f\u0131daki iki panda DataFrame’i olu\u015fturduk:<\/span><\/p>\n \u015eimdi iki DataFrame’i birle\u015ftirmeye \u00e7al\u0131\u015ft\u0131\u011f\u0131m\u0131z\u0131 varsayal\u0131m:<\/span><\/p>\n \u0130lk DataFrame’deki y\u0131l<\/strong> de\u011fi\u015fkeni bir tamsay\u0131, ikinci DataFrame’deki y\u0131l<\/strong> de\u011fi\u015fkeni ise bir nesne oldu\u011fundan ValueError<\/strong> al\u0131yoruz.<\/span><\/p>\n Bu hatay\u0131 d\u00fczeltmenin en kolay yolu, ikinci DataFrame’in y\u0131l<\/strong> de\u011fi\u015fkenini bir tam say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrmek ve ard\u0131ndan birle\u015ftirme i\u015flemini ger\u00e7ekle\u015ftirmektir.<\/span><\/p>\n A\u015fa\u011f\u0131daki s\u00f6zdizimi bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n Herhangi bir ValueError<\/strong> almad\u0131\u011f\u0131m\u0131z\u0131 ve iki DataFrame’i ba\u015far\u0131l\u0131 bir \u015fekilde tek bir DataFrame’de birle\u015ftirmeyi ba\u015fard\u0131\u011f\u0131m\u0131z\u0131 unutmay\u0131n.<\/span><\/p>\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> Pandalar\u0131 kullan\u0131rken kar\u015f\u0131la\u015fabilece\u011finiz bir hata: ValueError : You are trying to merge on int64 and object columns. If you wish to proceed you should use pd.concat Bu hata, iki panda DataFrame’i birle\u015ftirmeye \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda ancak birle\u015ftirdi\u011finiz s\u00fctun bir DataFrame’de bir nesne ve di\u011fer DataFrame’de bir tam say\u0131 oldu\u011funda ortaya \u00e7\u0131kar. A\u015fa\u011f\u0131daki \u00f6rnekte bu hatan\u0131n pratikte nas\u0131l […]<\/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-2872","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n ValueError<\/span> : You are trying to merge on int64 and object columns.\n If you wish to proceed you should use pd.concat\n<\/strong><\/pre>\n Hata nas\u0131l yeniden olu\u015fturulur?<\/strong><\/span><\/h3>\n
import<\/span> pandas as<\/span> pd\n\n#createDataFrame<\/span>\ndf1 = pd. DataFrame<\/span> ({' year<\/span> ': [2015, 2016, 2017, 2018, 2019, 2020, 2021],\n ' sales<\/span> ': [500, 534, 564, 671, 700, 840, 810]})\n\ndf2 = pd. DataFrame<\/span> ({' year<\/span> ': ['2015', '2016', '2017', '2018', '2019', '2020', '2021'],\n ' refunds<\/span> ': [31, 36, 40, 40, 43, 70, 62]})\n\n#view DataFrames\n<\/span>print<\/span> (df1)\n\n year sales\n0 2015 500\n1 2016 534\n2 2017 564\n3 2018 671\n4 2019 700\n5,2020 840\n6 2021 810\n\nprint<\/span> (df2)\n\n year refunds\n0 2015 31\n1 2016 36\n2 2017 40\n3 2018 40\n4 2019 43\n5 2020 70\n6 2021 62<\/strong><\/pre>\n #attempt to merge two DataFrames\n<\/span>big_df = df1. merge<\/span> (df2, on=' year<\/span> ', how=' left<\/span> ')\n\nValueError<\/span> : You are trying to merge on int64 and object columns.\n If you wish to proceed you should use pd.concat\n<\/span><\/span><\/strong><\/pre>\n Hata nas\u0131l d\u00fczeltilir?<\/strong><\/span><\/h3>\n
#convert year variable in df2 to integer\n<\/span>df2[' year<\/span> ']=df2[' year<\/span> ']. astype<\/span> (int)\n\n#merge two DataFrames\n<\/span>big_df = df1. merge<\/span> (df2, on=' year<\/span> ', how=' left<\/span> ')\n\n#view merged DataFrame\n<\/span>big_df\n\n\tyear sales refunds\n0 2015 500 31\n1 2016 534 36\n2 2017 564 40\n3 2018 671 40\n4 2019 700 43\n5 2020 840 70\n6 2021 810 62<\/span><\/span><\/strong><\/pre>\n Ek kaynaklar<\/strong><\/span><\/h3>\n
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":"