{"id":2870,"date":"2023-07-20T07:55:51","date_gmt":"2023-07-20T07:55:51","guid":{"rendered":"https:\/\/statorials.org\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/"},"modified":"2023-07-20T07:55:51","modified_gmt":"2023-07-20T07:55:51","slug":"probujesz-polaczyc-kolumny-object-i-int64","status":"publish","type":"post","link":"https:\/\/statorials.org\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/","title":{"rendered":"Jak naprawi\u0107: pr\u00f3bujesz scali\u0107 kolumny object i int64"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">B\u0142\u0105d, kt\u00f3ry mo\u017cesz napotka\u0107 podczas korzystania z pand, to:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #ff0000;\">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<p> <span style=\"color: #000000;\">Ten b\u0142\u0105d wyst\u0119puje, gdy pr\u00f3bujesz po\u0142\u0105czy\u0107 dwie ramki danych pand, ale kolumna, kt\u00f3r\u0105 \u0142\u0105czysz, jest obiektem w jednej ramce danych i liczb\u0105 ca\u0142kowit\u0105 w drugiej ramce danych.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Poni\u017cszy przyk\u0142ad pokazuje, jak w praktyce skorygowa\u0107 ten b\u0142\u0105d.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Jak odtworzy\u0107 b\u0142\u0105d<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Za\u0142\u00f3\u017cmy, \u017ce tworzymy nast\u0119puj\u0105ce dwie ramki danych pandy:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #107d3f;\">import<\/span> pandas <span style=\"color: #107d3f;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf1 = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">year<\/span> ': [2015, 2016, 2017, 2018, 2019, 2020, 2021],\n                    ' <span style=\"color: #ff0000;\">sales<\/span> ': [500, 534, 564, 671, 700, 840, 810]})\n\ndf2 = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">year<\/span> ': ['2015', '2016', '2017', '2018', '2019', '2020', '2021'],\n                    ' <span style=\"color: #ff0000;\">refunds<\/span> ': [31, 36, 40, 40, 43, 70, 62]})\n\n<span style=\"color: #008080;\">#view DataFrames\n<\/span><span style=\"color: #008000;\">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\n<span style=\"color: #008000;\">print<\/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<p> <span style=\"color: #000000;\">Za\u0142\u00f3\u017cmy teraz, \u017ce pr\u00f3bujemy po\u0142\u0105czy\u0107 dwie ramki danych:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#attempt to merge two DataFrames\n<\/span>big_df = df1. <span style=\"color: #3366ff;\">merge<\/span> (df2, on=' <span style=\"color: #ff0000;\">year<\/span> ', how=' <span style=\"color: #ff0000;\">left<\/span> ')\n\n<span style=\"color: #ff0000;\">ValueError<\/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<p> <span style=\"color: #000000;\">Otrzymujemy b\u0142\u0105d <strong>ValueError<\/strong> , poniewa\u017c zmienna <strong>roku<\/strong> w pierwszej ramce danych jest liczb\u0105 ca\u0142kowit\u0105, ale zmienna <strong>roku<\/strong> w drugiej ramce danych jest obiektem.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Jak naprawi\u0107 b\u0142\u0105d<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Naj\u0142atwiejszym sposobem naprawienia tego b\u0142\u0119du jest po prostu przekonwertowanie zmiennej <strong>roku<\/strong> drugiej ramki danych na liczb\u0119 ca\u0142kowit\u0105, a nast\u0119pnie wykonanie scalania.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Poni\u017csza sk\u0142adnia pokazuje, jak to zrobi\u0107:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#convert year variable in df2 to integer\n<\/span>df2[' <span style=\"color: #ff0000;\">year<\/span> ']=df2[' <span style=\"color: #ff0000;\">year<\/span> ']. <span style=\"color: #3366ff;\">astype<\/span> (int)\n\n<span style=\"color: #008080;\">#merge two DataFrames\n<\/span>big_df = df1. <span style=\"color: #3366ff;\">merge<\/span> (df2, on=' <span style=\"color: #ff0000;\">year<\/span> ', how=' <span style=\"color: #ff0000;\">left<\/span> ')\n\n<span style=\"color: #008080;\">#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<p> <span style=\"color: #000000;\">Nale\u017cy pami\u0119ta\u0107, \u017ce nie otrzymali\u015bmy \u017cadnego <strong>b\u0142\u0119du ValueError<\/strong> i uda\u0142o nam si\u0119 pomy\u015blnie po\u0142\u0105czy\u0107 dwie ramki DataFrame w jedn\u0105.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Dodatkowe zasoby<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Poni\u017csze samouczki wyja\u015bniaj\u0105, jak naprawi\u0107 inne typowe b\u0142\u0119dy w Pythonie:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/pl\/kolumny-nak\u0142adaja-sie,-ale-nie-okreslono-zadnego-przyrostka\/\" target=\"_blank\" rel=\"noopener\">Jak naprawi\u0107: Kolumny nak\u0142adaj\u0105 si\u0119, ale nie okre\u015blono \u017cadnego sufiksu<\/a><br \/> <a href=\"https:\/\/statorials.org\/pl\/numpy-obiekt-ndarray-nie-ma-dodanego-atrybutu\/\" target=\"_blank\" rel=\"noopener\">Jak naprawi\u0107: Obiekt \u201enumpy.ndarray\u201d nie ma atrybutu \u201edo\u0142\u0105cz\u201d.<\/a><br \/> <a href=\"https:\/\/statorials.org\/pl\/b\u0142ad-wartosci,-jesli-uzywasz-wszystkich-wartosci-skalarnych,-musisz-przekazac-indeks\/\" target=\"_blank\" rel=\"noopener\">Jak naprawi\u0107: je\u015bli u\u017cywasz wszystkich warto\u015bci skalarnych, musisz przekaza\u0107 indeks<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>B\u0142\u0105d, kt\u00f3ry mo\u017cesz napotka\u0107 podczas korzystania z pand, to: ValueError : You are trying to merge on int64 and object columns. If you wish to proceed you should use pd.concat Ten b\u0142\u0105d wyst\u0119puje, gdy pr\u00f3bujesz po\u0142\u0105czy\u0107 dwie ramki danych pand, ale kolumna, kt\u00f3r\u0105 \u0142\u0105czysz, jest obiektem w jednej ramce danych i liczb\u0105 ca\u0142kowit\u0105 w drugiej [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2870","post","type-post","status-publish","format-standard","hentry","category-przewodnik"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Jak naprawi\u0107: Pr\u00f3bujesz scali\u0107 kolumny obiektu i int64 - Statorials<\/title>\n<meta name=\"description\" content=\"W tym samouczku wyja\u015bniono, jak naprawi\u0107 nast\u0119puj\u0105cy b\u0142\u0105d w pandach: \u201epr\u00f3bujesz scali\u0107 kolumny obiektowe i int64\u201d.\" \/>\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\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Jak naprawi\u0107: Pr\u00f3bujesz scali\u0107 kolumny obiektu i int64 - Statorials\" \/>\n<meta property=\"og:description\" content=\"W tym samouczku wyja\u015bniono, jak naprawi\u0107 nast\u0119puj\u0105cy b\u0142\u0105d w pandach: \u201epr\u00f3bujesz scali\u0107 kolumny obiektowe i int64\u201d.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T07:55:51+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin Anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin Anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/\",\"url\":\"https:\/\/statorials.org\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/\",\"name\":\"Jak naprawi\u0107: Pr\u00f3bujesz scali\u0107 kolumny obiektu i int64 - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pl\/#website\"},\"datePublished\":\"2023-07-20T07:55:51+00:00\",\"dateModified\":\"2023-07-20T07:55:51+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965\"},\"description\":\"W tym samouczku wyja\u015bniono, jak naprawi\u0107 nast\u0119puj\u0105cy b\u0142\u0105d w pandach: \u201epr\u00f3bujesz scali\u0107 kolumny obiektowe i int64\u201d.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Dom\",\"item\":\"https:\/\/statorials.org\/pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Jak naprawi\u0107: pr\u00f3bujesz scali\u0107 kolumny object i int64\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/pl\/#website\",\"url\":\"https:\/\/statorials.org\/pl\/\",\"name\":\"Statorials\",\"description\":\"Tw\u00f3j przewodnik po kompetencjach statystycznych!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/pl\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965\",\"name\":\"Benjamin Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/statorials.org\/pl\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin Anderson\"},\"description\":\"Cze\u015b\u0107, jestem Benjamin i jestem emerytowanym profesorem statystyki, kt\u00f3ry zosta\u0142 oddanym nauczycielem Statorials. Dzi\u0119ki bogatemu do\u015bwiadczeniu i wiedzy specjalistycznej w dziedzinie statystyki ch\u0119tnie dziel\u0119 si\u0119 swoj\u0105 wiedz\u0105, aby wzmocni\u0107 pozycj\u0119 uczni\u00f3w za po\u015brednictwem Statorials. Wiedzie\u0107 wi\u0119cej\",\"sameAs\":[\"https:\/\/statorials.org\/pl\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Jak naprawi\u0107: Pr\u00f3bujesz scali\u0107 kolumny obiektu i int64 - Statorials","description":"W tym samouczku wyja\u015bniono, jak naprawi\u0107 nast\u0119puj\u0105cy b\u0142\u0105d w pandach: \u201epr\u00f3bujesz scali\u0107 kolumny obiektowe i int64\u201d.","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\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/","og_locale":"pl_PL","og_type":"article","og_title":"Jak naprawi\u0107: Pr\u00f3bujesz scali\u0107 kolumny obiektu i int64 - Statorials","og_description":"W tym samouczku wyja\u015bniono, jak naprawi\u0107 nast\u0119puj\u0105cy b\u0142\u0105d w pandach: \u201epr\u00f3bujesz scali\u0107 kolumny obiektowe i int64\u201d.","og_url":"https:\/\/statorials.org\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/","og_site_name":"Statorials","article_published_time":"2023-07-20T07:55:51+00:00","author":"Benjamin Anderson","twitter_card":"summary_large_image","twitter_misc":{"Napisane przez":"Benjamin Anderson","Szacowany czas czytania":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/","url":"https:\/\/statorials.org\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/","name":"Jak naprawi\u0107: Pr\u00f3bujesz scali\u0107 kolumny obiektu i int64 - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/pl\/#website"},"datePublished":"2023-07-20T07:55:51+00:00","dateModified":"2023-07-20T07:55:51+00:00","author":{"@id":"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965"},"description":"W tym samouczku wyja\u015bniono, jak naprawi\u0107 nast\u0119puj\u0105cy b\u0142\u0105d w pandach: \u201epr\u00f3bujesz scali\u0107 kolumny obiektowe i int64\u201d.","breadcrumb":{"@id":"https:\/\/statorials.org\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pl\/probujesz-polaczyc-kolumny-object-i-int64\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Dom","item":"https:\/\/statorials.org\/pl\/"},{"@type":"ListItem","position":2,"name":"Jak naprawi\u0107: pr\u00f3bujesz scali\u0107 kolumny object i int64"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/pl\/#website","url":"https:\/\/statorials.org\/pl\/","name":"Statorials","description":"Tw\u00f3j przewodnik po kompetencjach statystycznych!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/pl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pl-PL"},{"@type":"Person","@id":"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965","name":"Benjamin Anderson","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/statorials.org\/pl\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg","caption":"Benjamin Anderson"},"description":"Cze\u015b\u0107, jestem Benjamin i jestem emerytowanym profesorem statystyki, kt\u00f3ry zosta\u0142 oddanym nauczycielem Statorials. Dzi\u0119ki bogatemu do\u015bwiadczeniu i wiedzy specjalistycznej w dziedzinie statystyki ch\u0119tnie dziel\u0119 si\u0119 swoj\u0105 wiedz\u0105, aby wzmocni\u0107 pozycj\u0119 uczni\u00f3w za po\u015brednictwem Statorials. Wiedzie\u0107 wi\u0119cej","sameAs":["https:\/\/statorials.org\/pl"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/posts\/2870","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/comments?post=2870"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/posts\/2870\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/media?parent=2870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/categories?post=2870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/tags?post=2870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}