{"id":4089,"date":"2023-07-13T16:22:42","date_gmt":"2023-07-13T16:22:42","guid":{"rendered":"https:\/\/statorials.org\/pl\/pandy-czytaja-scalone-komorki-programu-excel\/"},"modified":"2023-07-13T16:22:42","modified_gmt":"2023-07-13T16:22:42","slug":"pandy-czytaja-scalone-komorki-programu-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/pl\/pandy-czytaja-scalone-komorki-programu-excel\/","title":{"rendered":"Pandy: jak odczyta\u0107 plik excel ze scalonymi kom\u00f3rkami"},"content":{"rendered":"

<\/p>\n

\n

Kiedy wczytujesz plik Excel ze scalonymi kom\u00f3rkami do ramki DataFrame pandy, scalone kom\u00f3rki zostan\u0105 automatycznie wype\u0142nione warto\u015bciami NaN.<\/span><\/p>\n

Naj\u0142atwiejszym sposobem wype\u0142nienia tych warto\u015bci NaN po zaimportowaniu pliku jest u\u017cycie funkcji pandas fillna()<\/strong> w nast\u0119puj\u0105cy spos\u00f3b:<\/span><\/p>\n

 df = df. fillna<\/span> (method=' ffill<\/span> ', axis= 0<\/span> )<\/strong><\/pre>\n
 Poni\u017cszy przyk\u0142ad pokazuje, jak zastosowa\u0107 t\u0119 sk\u0142adni\u0119 w praktyce.<\/span><\/p>\n
 Przyk\u0142ad: Przeczytaj plik Excel ze scalonymi kom\u00f3rkami w Pandach<\/strong><\/span><\/h2>\n
 Za\u0142\u00f3\u017cmy, \u017ce mamy nast\u0119puj\u0105cy plik Excel o nazwie merged_data.xlsx<\/strong> , kt\u00f3ry zawiera informacje o r\u00f3\u017cnych koszykarzach:<\/span> <\/p>\n
\"\"<\/p>\n
 Zauwa\u017c, \u017ce warto\u015bci w kolumnie Zesp\u00f3\u0142<\/strong> zosta\u0142y scalone.<\/span><\/p>\n
 Gracze od A do D nale\u017c\u0105 do Mavericks, a gracze od E do H do Rockets.<\/span><\/p>\n
 Za\u0142\u00f3\u017cmy, \u017ce u\u017cywamy funkcji read_excel()<\/strong> do wczytania pliku Excel do ramki DataFrame pandy:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#import Excel fie\n<\/span>df = pd. read_excel<\/span> (' merged_data.xlsx<\/span> ' )<\/strong>\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n        Team Player Points Assists\n0 Mavericks A 22 4\n1 NaN B 29 4\n2 NaN C 45 3\n3 NaN D 30 7\n4 Rockets E 29 8\n5 NaN F 16 6\n6 NaN G 25 9\n7 NaN H 20 12\n<\/b><\/pre>\n
 Domy\u015blnie pandy wype\u0142niaj\u0105 scalone kom\u00f3rki warto\u015bciami NaN.<\/span><\/span><\/p>\n
 Aby wype\u0142ni\u0107 ka\u017cd\u0105 z tych warto\u015bci NaN nazwami zespo\u0142\u00f3w, mo\u017cemy u\u017cy\u0107 funkcji fillna()<\/strong> w nast\u0119puj\u0105cy spos\u00f3b:<\/span><\/p>\n
 #fill in NaN values with team names\n<\/span>df = df. fillna<\/span> (method=' ffill<\/span> ', axis= 0<\/span> )\n\n#view updated DataFrame\n<\/span>print<\/span> (df)\n\n        Team Player Points Assists\n0 Mavericks A 22 4\n1 Mavericks B 29 4\n2 Mavericks C 45 3\n3 Mavericks D 30 7\n4 Rockets E 29 8\n5 Rockets F 16 6\n6 Rockets G 25 9\n7 Rockets M 20 12<\/b><\/pre>\n
 Nale\u017cy pami\u0119ta\u0107, \u017ce ka\u017cda z warto\u015bci NaN zosta\u0142a wype\u0142niona odpowiedni\u0105 nazw\u0105 zespo\u0142u.<\/span><\/p>\n
 Zauwa\u017c, \u017ce argument o\u015b=0<\/strong> m\u00f3wi pandom, aby wype\u0142ni\u0142y warto\u015bci NaN w pionie.<\/span><\/p>\n
 Aby wype\u0142ni\u0107 warto\u015bci NaN w kolumnach poziomo, mo\u017cesz okre\u015bli\u0107 o\u015b=1<\/strong> .<\/span><\/p>\n
 Uwaga<\/strong> : pe\u0142n\u0105 dokumentacj\u0119 funkcji pandas fillna()<\/strong> mo\u017cna znale\u017a\u0107 tutaj<\/a> .<\/span><\/p>\n
 Dodatkowe zasoby<\/strong><\/span><\/h2>\n
 Poni\u017csze samouczki wyja\u015bniaj\u0105, jak wykonywa\u0107 inne typowe zadania w pandach:<\/span><\/p>\n
 Pandy: Jak pomin\u0105\u0107 linie podczas czytania pliku Excel<\/a>
 Pandy: Jak okre\u015bli\u0107 typy podczas importowania pliku Excel<\/a>
 Pandy: Jak po\u0142\u0105czy\u0107 wiele arkuszy Excela<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Kiedy wczytujesz plik Excel ze scalonymi kom\u00f3rkami do ramki DataFrame pandy, scalone kom\u00f3rki zostan\u0105 automatycznie wype\u0142nione warto\u015bciami NaN. Naj\u0142atwiejszym sposobem wype\u0142nienia tych warto\u015bci NaN po zaimportowaniu pliku jest u\u017cycie funkcji pandas fillna() w nast\u0119puj\u0105cy spos\u00f3b: df = df. fillna (method=’ ffill ’, axis= 0 ) Poni\u017cszy przyk\u0142ad pokazuje, jak zastosowa\u0107 t\u0119 sk\u0142adni\u0119 w praktyce. Przyk\u0142ad: […]<\/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-4089","post","type-post","status-publish","format-standard","hentry","category-przewodnik"],"yoast_head":"\nPandy: Jak czyta\u0107 plik Excel z po\u0142\u0105czonymi kom\u00f3rkami - Statorials<\/title>\n<meta name=\"description\" content=\"W tym samouczku wyja\u015bniono, jak na przyk\u0142adzie odczyta\u0107 plik Excel ze scalonymi kom\u00f3rkami w ramce DataFrame pandy.\" \/>\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\/pandy-czytaja-scalone-komorki-programu-excel\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandy: Jak czyta\u0107 plik Excel z po\u0142\u0105czonymi kom\u00f3rkami - Statorials\" \/>\n<meta property=\"og:description\" content=\"W tym samouczku wyja\u015bniono, jak na przyk\u0142adzie odczyta\u0107 plik Excel ze scalonymi kom\u00f3rkami w ramce DataFrame pandy.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pl\/pandy-czytaja-scalone-komorki-programu-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T16:22:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nan1.png\" \/>\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\/pandy-czytaja-scalone-komorki-programu-excel\/\",\"url\":\"https:\/\/statorials.org\/pl\/pandy-czytaja-scalone-komorki-programu-excel\/\",\"name\":\"Pandy: Jak czyta\u0107 plik Excel z po\u0142\u0105czonymi kom\u00f3rkami - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pl\/#website\"},\"datePublished\":\"2023-07-13T16:22:42+00:00\",\"dateModified\":\"2023-07-13T16:22:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965\"},\"description\":\"W tym samouczku wyja\u015bniono, jak na przyk\u0142adzie odczyta\u0107 plik Excel ze scalonymi kom\u00f3rkami w ramce DataFrame pandy.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pl\/pandy-czytaja-scalone-komorki-programu-excel\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pl\/pandy-czytaja-scalone-komorki-programu-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pl\/pandy-czytaja-scalone-komorki-programu-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Dom\",\"item\":\"https:\/\/statorials.org\/pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandy: jak odczyta\u0107 plik excel ze scalonymi kom\u00f3rkami\"}]},{\"@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":"Pandy: Jak czyta\u0107 plik Excel z po\u0142\u0105czonymi kom\u00f3rkami - Statorials","description":"W tym samouczku wyja\u015bniono, jak na przyk\u0142adzie odczyta\u0107 plik Excel ze scalonymi kom\u00f3rkami w ramce DataFrame pandy.","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\/pandy-czytaja-scalone-komorki-programu-excel\/","og_locale":"pl_PL","og_type":"article","og_title":"Pandy: Jak czyta\u0107 plik Excel z po\u0142\u0105czonymi kom\u00f3rkami - Statorials","og_description":"W tym samouczku wyja\u015bniono, jak na przyk\u0142adzie odczyta\u0107 plik Excel ze scalonymi kom\u00f3rkami w ramce DataFrame pandy.","og_url":"https:\/\/statorials.org\/pl\/pandy-czytaja-scalone-komorki-programu-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-13T16:22:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nan1.png"}],"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\/pandy-czytaja-scalone-komorki-programu-excel\/","url":"https:\/\/statorials.org\/pl\/pandy-czytaja-scalone-komorki-programu-excel\/","name":"Pandy: Jak czyta\u0107 plik Excel z po\u0142\u0105czonymi kom\u00f3rkami - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/pl\/#website"},"datePublished":"2023-07-13T16:22:42+00:00","dateModified":"2023-07-13T16:22:42+00:00","author":{"@id":"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965"},"description":"W tym samouczku wyja\u015bniono, jak na przyk\u0142adzie odczyta\u0107 plik Excel ze scalonymi kom\u00f3rkami w ramce DataFrame pandy.","breadcrumb":{"@id":"https:\/\/statorials.org\/pl\/pandy-czytaja-scalone-komorki-programu-excel\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pl\/pandy-czytaja-scalone-komorki-programu-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pl\/pandy-czytaja-scalone-komorki-programu-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Dom","item":"https:\/\/statorials.org\/pl\/"},{"@type":"ListItem","position":2,"name":"Pandy: jak odczyta\u0107 plik excel ze scalonymi kom\u00f3rkami"}]},{"@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\/4089","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=4089"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/posts\/4089\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/media?parent=4089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/categories?post=4089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/tags?post=4089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}