{"id":30129,"date":"2023-01-13T10:23:48","date_gmt":"2023-01-13T04:53:48","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/"},"modified":"2023-01-13T10:23:48","modified_gmt":"2023-01-13T04:53:48","slug":"solved-is-there-any-pandas-function-to-merge-3-rows","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/","title":{"rendered":"[Solved] Is there any pandas function to merge 3 rows?"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-59200644\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"59200644\" data-parentid=\"59196166\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>Let&#8217;s take the following sample DataFrame, containing 2 groups<br \/>\nof 3 adjacent rows:<\/p>\n<pre><code>      C1   C2   C3   C4   C5   C6\nABC  NaN  NaN  NaN  NaN   PK   KJ\nPQR  NaN  NaN   RR   SS  NaN  NaN\nMNO   PO   UI  NaN  NaN  NaN  NaN\nXXX   AA  NaN  NaN  NaN   EE  NaN\nXX1  NaN   BB  NaN   DD  NaN  FF1\nXX2  NaN  NaN   CC  NaN  NaN  FF2\n<\/code><\/pre>\n<p>Then proceed as follows:<\/p>\n<ol>\n<li>\n<p>Define a function &#8220;cumulating&#8221; the content from a group<br \/>\nof rows:<\/p>\n<pre><code>def getFirstValue(grp):\n    return grp.reset_index().bfill(axis=0).iloc[0]\n<\/code><\/pre>\n<\/li>\n<li>\n<p>Then apply it:<\/p>\n<pre><code>df2 = df.groupby(np.arange(len(df.index)) \/\/ 3).apply(getFirstValue)\n<\/code><\/pre>\n<\/li>\n<li>\n<p>And a couple of &#8220;finishing&#8221; operations:<\/p>\n<pre><code>df2.set_index('index', inplace=True)\ndf2.index.name = None\ndf2.columns.name = None\n<\/code><\/pre>\n<\/li>\n<\/ol>\n<p>The result is:<\/p>\n<pre><code>     C1  C2  C3  C4  C5   C6\nABC  PO  UI  RR  SS  PK   KJ\nXXX  AA  BB  CC  DD  EE  FF1\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Is there any pandas function to merge 3 rows? <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Let&#8217;s take the following sample DataFrame, containing 2 groups of 3 adjacent rows: C1 C2 C3 C4 C5 C6 ABC NaN NaN NaN NaN PK KJ PQR NaN NaN RR SS NaN NaN MNO PO UI NaN NaN NaN NaN XXX AA NaN NaN NaN EE NaN XX1 NaN BB NaN DD NaN FF1 &#8230; <a title=\"[Solved] Is there any pandas function to merge 3 rows?\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/\" aria-label=\"More on [Solved] Is there any pandas function to merge 3 rows?\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[461,415,349],"class_list":["post-30129","post","type-post","status-publish","format-standard","hentry","category-solved","tag-dataframe","tag-pandas","tag-python"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Is there any pandas function to merge 3 rows? - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Is there any pandas function to merge 3 rows? - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Let&#8217;s take the following sample DataFrame, containing 2 groups of 3 adjacent rows: C1 C2 C3 C4 C5 C6 ABC NaN NaN NaN NaN PK KJ PQR NaN NaN RR SS NaN NaN MNO PO UI NaN NaN NaN NaN XXX AA NaN NaN NaN EE NaN XX1 NaN BB NaN DD NaN FF1 ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-13T04:53:48+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Is there any pandas function to merge 3 rows?\",\"datePublished\":\"2023-01-13T04:53:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/\"},\"wordCount\":59,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"dataframe\",\"pandas\",\"python\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/\",\"name\":\"[Solved] Is there any pandas function to merge 3 rows? - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-01-13T04:53:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Is there any pandas function to merge 3 rows?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Is there any pandas function to merge 3 rows? - JassWeb","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:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Is there any pandas function to merge 3 rows? - JassWeb","og_description":"[ad_1] Let&#8217;s take the following sample DataFrame, containing 2 groups of 3 adjacent rows: C1 C2 C3 C4 C5 C6 ABC NaN NaN NaN NaN PK KJ PQR NaN NaN RR SS NaN NaN MNO PO UI NaN NaN NaN NaN XXX AA NaN NaN NaN EE NaN XX1 NaN BB NaN DD NaN FF1 ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/","og_site_name":"JassWeb","article_published_time":"2023-01-13T04:53:48+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Is there any pandas function to merge 3 rows?","datePublished":"2023-01-13T04:53:48+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/"},"wordCount":59,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["dataframe","pandas","python"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/","url":"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/","name":"[Solved] Is there any pandas function to merge 3 rows? - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-01-13T04:53:48+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-is-there-any-pandas-function-to-merge-3-rows\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Is there any pandas function to merge 3 rows?"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/30129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=30129"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/30129\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=30129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=30129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=30129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}