(BlogPost: {CMSContentType=Optional[BLOG_POST], ab=false, abMaster=false, abStatus=null, abTestId=null, abVariation=false, abVariationAutomated=false, absoluteUrl=https://www.symon.ai/learning-hub/restructure-data, afterPostBody=null, allModules=2 object module(s) and 0 layout section module(s), allWidgets=[{body={hubspot_video={height=1080, player_id=89608912569, player_type=hsvideo2, width=1920}, module_id=35056501883, video_type=hubspot_video}, css={}, child_css={}, id=video, name=video, type=module, order=2, label=null, smart_type=null, styles={}, module_id=35056501883}, {body={module_id=88592615586, video_embed={height=113, max_height=113, max_width=200, oembed_response={provider_url=https://www.youtube.com/, width=200, height=113, html=<iframe width="200" height="113" src="https://www.youtube.com/embed/qyrXYsBkkq0?feature=oembed" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen title="Aggregate and Reshape Data EASILY - Symon.AI"></iframe>, thumbnail_width=480, version=1.0, title=Aggregate and Reshape Data EASILY - Symon.AI, provider_name=YouTube, type=video, thumbnail_height=360, author_url=https://www.youtube.com/channel/UCeWi9QMEie3n_V3MY94Gz7Q, thumbnail_url=https://i.ytimg.com/vi/qyrXYsBkkq0/hqdefault.jpg, author_name=Symon AI}, oembed_url=https://www.youtube.com/watch?v=qyrXYsBkkq0, size_type=auto_full_width, source_type=oembed, width=200}}, css={}, child_css={}, id=module_16661226169288, name=module_16661226169288, type=module, order=2, label=Video, smart_type=null, styles={}, module_id=88592615586, deleted_at=1675876967037}], allowedSlugConflict=false, allowedSlugConflictColumn=false, ampUrl=https://www.symon.ai/learning-hub/restructure-data?hs_amp=true, analytics=null, analyticsFieldsMap={CONTENT_GROUP_ID=long_value: 84256981056 , BLOG_AUTHOR_ID=long_value: 55821023870 , TAG_IDS=long_list_value { long_value: 88448017234 long_value: 109684312704 } , NAME=string_value: "Restructure Data" , HTML_TITLE=string_value: "Restructure Data" , PUBLISH_STATUS_ID=long_value: 2 , URL=string_value: "https://www.symon.ai/learning-hub/restructure-data" , CREATED_TIMESTAMP=long_value: 1666726429243 , PUBLISHED_TIMESTAMP=long_value: 1666726597000 , CONTENT_TYPE_CODE=long_value: 3 }, analyticsForeignIndexObjectType=Optional[BLOG_POST], analyticsPageId=89455986086, analyticsPageType=blog-post, approvalStatus=null, archived=false, archivedAt=0, archivedInDashboard=false, areCommentsAllowed=true, attachedStylesheets=[], audienceAccess=PUBLIC, author=null, authorAt=1683121981702, authorEmail=null, authorFullName=null, authorId=45399073, authorName=null, authorUserId=45399073, authorUsername=null, automated=false, automatedAbMaster=false, blogAuthor=Admin, blogAuthorId=55821023870, blogPostAuthor=Admin, blogPostScheduleTaskUid=null, blogPublishInstantEmailCampaignId=null, blogPublishInstantEmailRetryCount=null, blogPublishInstantEmailTaskUid=null, blogPublishToSocialMediaTask=DONE_NOT_SENT, blueprintTypeId=0, body=BlogPost 89455986086 Restructure Data, businessUnitId=null, campaign=null, campaignName=null, campaignUtm=null, category=BLOG_POST, categoryId=3, clonedFrom=null, commentCount=0, commentList=[], composeBody=null, compositionId=0, contentAccessRuleIds=[], contentAccessRuleTypes=[], contentGroup=84256981056, contentGroupId=84256981056, contentGroupIdForDb=84256981056, contentTypeCategory=BLOG_POST, contentTypeCategoryId=3, contentTypeId=null, cosObjectType=CONTENT, created=1666726429243, createdById=44716558, createdTime=2022-10-25T19:33:49.243Z, crmObjectId=null, css={}, cssText=, ctaClicks=null, ctaViews=null, currentState=PUBLISHED, currentlyPublished=true, deferDynamicValues=false, deletedAt=0, deletedBy=null, domain=, dynamicPageDataSourceCrmObject=false, dynamicPageDataSourceDataQuery=false, dynamicPageDataSourceHubDbTable=false, dynamicPageDataSourceId=null, dynamicPageDataSourceType=null, dynamicPageHubDbTableId=null, enableDomainStylesheets=null, enableDomainStylesheetsColumn=null, enableGoogleAmpOutput=true, enableGoogleAmpOutputOverride=false, enableLayoutStylesheets=null, enableLayoutStylesheetsColumn=null, errors=[], featuredImage=https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-11-1.jpg, featuredImageAltText=, featuredImageAltTextColumn=null, featuredImageColumn=null, featuredImageHeight=175, featuredImageLength=0, featuredImageWidth=300, flexAreas={}, folderId=null, footerHtml=null, freezeDate=1666726597000, generateJsonLdEnabled=true, generateJsonLdEnabledOverride=true, hasContentAccessRules=false, hasUserChanges=true, headHtml=null, header=null, htmlTitle=Restructure Data, htmlTitleColumn=null, id=89455986086, includeDefaultCustomCss=null, includeDefaultCustomCssColumn=null, isCaptchaRequired=true, isDraft=false, isInstanceLayoutPage=false, isInstantEmailEnabled=false, isPublished=true, isSocialPublishingEnabled=false, isStagedPage=false, jsonBody={"attached_stylesheets":[],"featured_image_height":175,"featured_image_width":300,"post_summary":"Learn how to aggregate and reshape data to restructure data for specific analysis.","has_user_changes":true,"last_edit_session_id":null,"last_edit_update_id":null,"html_title":"Restructure Data","tag_ids":[88448017234,109684312704],"topic_ids":[88448017234,109684312704],"campaign_name":null,"campaign_utm":null,"enable_google_amp_output_override":false,"featured_image":"https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-11-1.jpg","featured_image_alt_text":"","head_html":null,"link_rel_canonical_url":null,"meta_description":"Learn how to aggregate and reshape data to restructure data for specific analysis.","post_body":"Learn how to aggregate and reshape data to restructure data for specific analysis.","publish_immediately":null,"use_featured_image":true,"layout_sections":{},"published_by_id":45399073,"published_at":1683121981697,"rss_body":"Learn how to aggregate and reshape data to restructure data for specific analysis.","rss_summary":"Learn how to aggregate and reshape data to restructure data for specific analysis.","scheduled_update_date":0,"blog_publish_to_social_media_task":"DONE_NOT_SENT","blog_post_schedule_task_uid":null,"header":null}, jsonBodyAsString={"attached_stylesheets":[],"featured_image_height":175,"featured_image_width":300,"post_summary":"Learn how to aggregate and reshape data to restructure data for specific analysis.","has_user_changes":true,"last_edit_session_id":null,"last_edit_update_id":null,"html_title":"Restructure Data","tag_ids":[88448017234,109684312704],"topic_ids":[88448017234,109684312704],"campaign_name":null,"campaign_utm":null,"enable_google_amp_output_override":false,"featured_image":"https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-11-1.jpg","featured_image_alt_text":"","head_html":null,"link_rel_canonical_url":null,"meta_description":"Learn how to aggregate and reshape data to restructure data for specific analysis.","post_body":"Learn how to aggregate and reshape data to restructure data for specific analysis.","publish_immediately":null,"use_featured_image":true,"layout_sections":{},"published_by_id":45399073,"published_at":1683121981697,"rss_body":"Learn how to aggregate and reshape data to restructure data for specific analysis.","rss_summary":"Learn how to aggregate and reshape data to restructure data for specific analysis.","scheduled_update_date":0,"blog_publish_to_social_media_task":"DONE_NOT_SENT","blog_post_schedule_task_uid":null,"header":null}, jsonBodyMap={layout_sections={}, tag_ids=[88448017234, 109684312704], featured_image_alt_text=, topic_ids=[88448017234, 109684312704], featured_image_width=300, featured_image_height=175, html_title=Restructure Data, featured_image=https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-11-1.jpg, meta_description=Learn how to aggregate and reshape data to restructure data for specific analysis., has_user_changes=true, attached_stylesheets=[], enable_google_amp_output_override=false, blog_publish_to_social_media_task=DONE_NOT_SENT}, keywords=[], label=Restructure Data, language=en, languageVariant=false, layoutSections={}, legacyBlogTabid=null, legacyId=null, legacyPostGuid=null, linkRelCanonicalUrl=null, linkRelCanonicalUrlColumn=null, listTemplate=, liveDomain=www.symon.ai, mab=false, mabExperimentId=null, mabMaster=false, mabVariant=false, majorVersion=0, metaDescription=Learn how to aggregate and reshape data to restructure data for specific analysis., metaKeywords=null, migratedLegacyPost=false, name=Restructure Data, nextPostFeaturedImage=https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-5.jpg, nextPostFeaturedImageAltText=, nextPostName=Combine the Rows of Two Data Sets, nextPostSlug=learning-hub/combine-the-rows-of-two-data-sets, onlyIdSlug=false, pageExpiryDate=null, pageExpiryDateColumn=null, pageExpiryRedirectId=null, pageExpiryRedirectIdColumn=null, pageExpiryRedirectUrl=null, pageExpiryRedirectUrlColumn=null, pageRedirectedColumn=false, pageTitle=Restructure Data, parentBlog='Symon.AI Learning Hub' blog (84256981056) of hub id 6899630, password=null, passwordColumn=null, pastMabExperimentIds=[], performableGuid=null, performableVariationLetter=null, permissionedObjectType=Optional[BLOG_POST], personas=[], placementGuids=[], portableKey=null, portalId=6899630, position=null, postBody=Learn how to aggregate and reshape data to restructure data for specific analysis., postBodyRss=Learn how to aggregate and reshape data to restructure data for specific analysis., postEmailContent=Learn how to aggregate and reshape data to restructure data for specific analysis., postFeaturedImageIfEnabled=https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-11-1.jpg, postListContent=Learn how to aggregate and reshape data to restructure data for specific analysis., postListSummaryFeaturedImage=https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-11-1.jpg, postRssContent=Learn how to aggregate and reshape data to restructure data for specific analysis., postRssSummaryFeaturedImage=https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-11-1.jpg, postSummary=Learn how to aggregate and reshape data to restructure data for specific analysis., postSummaryRss=Learn how to aggregate and reshape data to restructure data for specific analysis., postTemplate=Symon/templates/Symon-Learning-Hub-Post.html, potentiallyStale=false, previewImageSrc=null, previewKey=SWRaizzQ, previousPostFeaturedImage=https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-12.jpg, previousPostFeaturedImageAltText=, previousPostName=Evaluate Regression Scores, previousPostSlug=learning-hub/evaluate-regression-scores, processingStatus=PUBLISHED, propertyForDynamicPageCanonicalUrl=null, propertyForDynamicPageFeaturedImage=null, propertyForDynamicPageMetaDescription=null, propertyForDynamicPageSlug=null, propertyForDynamicPageTitle=null, publicAccessRules=[], publicAccessRulesEnabled=false, publicAccessRulesEnabledColumn=false, publishDate=2022-10-25 19:36:37, publishDateLocalTime=2022-10-25T19:36:37Z, publishDateLocalized=com.hubspot.jinjava.objects.date.FormattedDate@3720288a, publishDateLong=1666726597000, publishDateSnakeCaseLong=1666726597000, publishImmediately=null, publishImmediatelyColumn=null, publishTimezoneOffset=null, publishedAt=1683121981697, publishedByEmail=null, publishedById=45399073, publishedByName=null, publishedUrl=https://www.symon.ai/learning-hub/restructure-data, requiresDeletion=false, resolvedDomain=www.symon.ai, resolvedLanguage=null, rssBody=Learn how to aggregate and reshape data to restructure data for specific analysis., rssSummary=Learn how to aggregate and reshape data to restructure data for specific analysis., rssSummaryFeaturedImage=https://6899630.fs1.hubspotusercontent-na1.net/hubfs/6899630/join-11-1.jpg, safeFeaturedImageAltText=Restructure Data, scheduledUpdateDate=0, screenshotPreviewTakenAt=1690293182123, screenshotPreviewUrl=https://cdn1.hubspot.net/hubshotv3/prod/e/0/2629326e-d408-4eb1-b9b0-688f6e9dffcb.png, sections={}, securityState=NONE, siteId=null, slug=learning-hub/restructure-data, stagedFrom=null, state=PUBLISHED, stateWhenDeleted=null, styleOverrideId=null, styleOverrideIdColumn=null, subcategory=normal_blog_post, subcategoryEnum=normal_blog_post, syncedWithBlogRoot=true, tagId=null, tagIds=[88448017234, 109684312704], tagList=[Clean and Prepare Data, Featured], tagNames=[Clean and Prepare Data, Featured], tagsForBuffer=[88448017234, 109684312704], targetObjectType=BLOG_POST, teamPerms=[], templatePath=, templatePathForRender=Symon/templates/Symon-Learning-Hub-Post.html, themePath=null, themeSettingsValues=null, title=Restructure Data, tmsId=null, topicId=null, topicIds=[88448017234, 109684312704], topicList=[Clean and Prepare Data, Featured], topicNames=[Clean and Prepare Data, Featured], translatedContent={}, translatedContentEnumMap={}, translatedFromId=null, translations={}, tweet=null, tweetAt=null, tweetImmediately=false, unpublishedAt=0, updated=1683121981702, updatedById=45399073, updatedDateTime=2023-05-03T13:53:01.702Z, upsizeFeaturedImage=false, url=https://www.symon.ai/learning-hub/restructure-data, useFeaturedImage=true, useFeaturedImageColumn=false, userPerms=[], usesJsRendering=false, views=0, visibleToAll=null, widgetContainers={}, widgetcontainers={}, widgets={video={body={hubspot_video={height=1080, player_id=89608912569, player_type=hsvideo2, width=1920}, module_id=35056501883, video_type=hubspot_video}, css={}, child_css={}, id=video, name=video, type=module, order=2, label=null, smart_type=null, styles={}, module_id=35056501883}, module_16661226169288={body={module_id=88592615586, video_embed={height=113, max_height=113, max_width=200, oembed_response={provider_url=https://www.youtube.com/, width=200, height=113, html=<iframe width="200" height="113" src="https://www.youtube.com/embed/qyrXYsBkkq0?feature=oembed" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen title="Aggregate and Reshape Data EASILY - Symon.AI"></iframe>, thumbnail_width=480, version=1.0, title=Aggregate and Reshape Data EASILY - Symon.AI, provider_name=YouTube, type=video, thumbnail_height=360, author_url=https://www.youtube.com/channel/UCeWi9QMEie3n_V3MY94Gz7Q, thumbnail_url=https://i.ytimg.com/vi/qyrXYsBkkq0/hqdefault.jpg, author_name=Symon AI}, oembed_url=https://www.youtube.com/watch?v=qyrXYsBkkq0, size_type=auto_full_width, source_type=oembed, width=200}}, css={}, child_css={}, id=module_16661226169288, name=module_16661226169288, type=module, order=2, label=Video, smart_type=null, styles={}, module_id=88592615586, deleted_at=1675876967037}}})

Clean and Prepare Data , Featured

Restructure Data

Learn how to aggregate and reshape data to restructure data for specific analysis.

Sign up for a Symon.AI account today

No credit card required.