{"id":239733,"date":"2026-06-12T18:56:04","date_gmt":"2026-06-12T18:56:04","guid":{"rendered":"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/"},"modified":"2026-06-12T18:56:04","modified_gmt":"2026-06-12T18:56:04","slug":"learn-pandas-in-python-8-working-with-text-data","status":"publish","type":"post","link":"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/","title":{"rendered":"Learn Pandas in Python #8 \u2014 Working with Text Data"},"content":{"rendered":"<div class=\"youtubomatic-video-container\"><iframe loading=\"lazy\" width=\"580\" height=\"380\" src=\"https:\/\/www.youtube.com\/embed\/Pbjr_5FxKbM?autoplay=1&#038;controls=1&#038;hl=en\" frameborder=\"0\" allowfullscreen><\/iframe><\/div>\n<p>Learn Pandas in Python #8 \u2014 Working with Text Data<\/p>\n<p>In this video we learn how to clean and manipulate text data in pandas \u2014 one of the messiest parts of real data work. We work with a dataset full of inconsistent casing, extra spaces, and messy entries, and we clean it all up step by step.<\/p>\n<p>Here is what we cover:<\/p>\n<p>The .str accessor and why it is the key to all text operations in pandas<br \/>\nFixing inconsistent casing with upper, lower, title, and capitalize<br \/>\nRemoving extra spaces with strip, lstrip, and rstrip<br \/>\nChaining multiple .str methods together in one line<br \/>\nSearching inside text with contains, startswith, and endswith<br \/>\nUsing text conditions as filters<br \/>\nReplacing and cleaning text with replace, including a first look at regex<br \/>\nSplitting strings into parts with split and expand<br \/>\nMeasuring string length with len and counting patterns with count<\/p>\n<p>\ud83d\udccc Full series playlist<br \/>\n<a href=\"https:\/\/www.youtube.com\/watch?v=RFhzuGfY8b0&#038;list=PLtZX5L5tty4xvzS4DPuRY5JoOVgQQ4lKz\" target=\"_blank\">https:\/\/www.youtube.com\/watch?v=RFhzuGfY8b0&#038;list=PLtZX5L5tty4xvzS4DPuRY5JoOVgQQ4lKz<\/a><\/p>\n<p>No prior data experience needed. All code runs directly in Google Colab \u2014 just open your browser and follow along.<\/p>\n<p>#pandas #python #dataanalysis #pythonforbeginners #googlecolab<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn Pandas in Python #8 \u2014 Working with Text Data In this video we learn how to clean and manipulate text data in pandas \u2014 one of the messiest parts of real data work. We work with a dataset full of inconsistent casing, extra spaces, and messy entries, and we clean it all up step by step. Here is what we cover: The .str accessor and why it is the&#8230;<\/p>\n","protected":false},"author":1,"featured_media":239734,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"","tve_custom_css":"","tve_user_custom_css":"","tve_globals":{},"tcb2_ready":0,"tcb_editor_enabled":0,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[1],"tags":[],"class_list":["post-239733","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Learn Pandas in Python #8 \u2014 Working with Text Data - UshopWell.com<\/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:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learn Pandas in Python #8 \u2014 Working with Text Data - UshopWell.com\" \/>\n<meta property=\"og:description\" content=\"Learn Pandas in Python #8 \u2014 Working with Text Data In this video we learn how to clean and manipulate text data in pandas \u2014 one of the messiest parts of real data work. We work with a dataset full of inconsistent casing, extra spaces, and messy entries, and we clean it all up step by step. Here is what we cover: The .str accessor and why it is the...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/\" \/>\n<meta property=\"og:site_name\" content=\"UshopWell.com\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-12T18:56:04+00:00\" \/>\n<meta name=\"author\" content=\"UShopWell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"UShopWell\" \/>\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:\\\/\\\/ushopwell.com\\\/ublog\\\/learn-pandas-in-python-8-working-with-text-data\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/learn-pandas-in-python-8-working-with-text-data\\\/\"},\"author\":{\"name\":\"UShopWell\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/person\\\/6fd1f9e0ff932e534c86c70d5acff0fc\"},\"headline\":\"Learn Pandas in Python #8 \u2014 Working with Text Data\",\"datePublished\":\"2026-06-12T18:56:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/learn-pandas-in-python-8-working-with-text-data\\\/\"},\"wordCount\":193,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/learn-pandas-in-python-8-working-with-text-data\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/239733\\\/learn-pandas-in-python-8-working-with-text-data.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/learn-pandas-in-python-8-working-with-text-data\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/learn-pandas-in-python-8-working-with-text-data\\\/\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/learn-pandas-in-python-8-working-with-text-data\\\/\",\"name\":\"Learn Pandas in Python #8 \u2014 Working with Text Data - UshopWell.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/learn-pandas-in-python-8-working-with-text-data\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/learn-pandas-in-python-8-working-with-text-data\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/239733\\\/learn-pandas-in-python-8-working-with-text-data.jpg\",\"datePublished\":\"2026-06-12T18:56:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/learn-pandas-in-python-8-working-with-text-data\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/learn-pandas-in-python-8-working-with-text-data\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/learn-pandas-in-python-8-working-with-text-data\\\/#primaryimage\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/239733\\\/learn-pandas-in-python-8-working-with-text-data.jpg\",\"contentUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/239733\\\/learn-pandas-in-python-8-working-with-text-data.jpg\",\"width\":480,\"height\":360,\"caption\":\"Learn Pandas in Python #8 \u2014 Working with Text Data\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/learn-pandas-in-python-8-working-with-text-data\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learn Pandas in Python #8 \u2014 Working with Text Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#website\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\",\"name\":\"UshopWell.com\",\"description\":\"The Premiere Online Marketplace\",\"publisher\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\",\"name\":\"UshopWell\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/pandaSwea.png\",\"contentUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/pandaSwea.png\",\"width\":365,\"height\":359,\"caption\":\"UshopWell\"},\"image\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/person\\\/6fd1f9e0ff932e534c86c70d5acff0fc\",\"name\":\"UShopWell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"caption\":\"UShopWell\"},\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/author\\\/kburnettu\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Learn Pandas in Python #8 \u2014 Working with Text Data - UshopWell.com","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:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/","og_locale":"en_US","og_type":"article","og_title":"Learn Pandas in Python #8 \u2014 Working with Text Data - UshopWell.com","og_description":"Learn Pandas in Python #8 \u2014 Working with Text Data In this video we learn how to clean and manipulate text data in pandas \u2014 one of the messiest parts of real data work. We work with a dataset full of inconsistent casing, extra spaces, and messy entries, and we clean it all up step by step. Here is what we cover: The .str accessor and why it is the...","og_url":"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/","og_site_name":"UshopWell.com","article_published_time":"2026-06-12T18:56:04+00:00","author":"UShopWell","twitter_card":"summary_large_image","twitter_misc":{"Written by":"UShopWell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/#article","isPartOf":{"@id":"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/"},"author":{"name":"UShopWell","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/person\/6fd1f9e0ff932e534c86c70d5acff0fc"},"headline":"Learn Pandas in Python #8 \u2014 Working with Text Data","datePublished":"2026-06-12T18:56:04+00:00","mainEntityOfPage":{"@id":"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/"},"wordCount":193,"commentCount":0,"publisher":{"@id":"https:\/\/ushopwell.com\/ublog\/#organization"},"image":{"@id":"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/#primaryimage"},"thumbnailUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2026\/06\/239733\/learn-pandas-in-python-8-working-with-text-data.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/","url":"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/","name":"Learn Pandas in Python #8 \u2014 Working with Text Data - UshopWell.com","isPartOf":{"@id":"https:\/\/ushopwell.com\/ublog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/#primaryimage"},"image":{"@id":"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/#primaryimage"},"thumbnailUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2026\/06\/239733\/learn-pandas-in-python-8-working-with-text-data.jpg","datePublished":"2026-06-12T18:56:04+00:00","breadcrumb":{"@id":"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/#primaryimage","url":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2026\/06\/239733\/learn-pandas-in-python-8-working-with-text-data.jpg","contentUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2026\/06\/239733\/learn-pandas-in-python-8-working-with-text-data.jpg","width":480,"height":360,"caption":"Learn Pandas in Python #8 \u2014 Working with Text Data"},{"@type":"BreadcrumbList","@id":"https:\/\/ushopwell.com\/ublog\/learn-pandas-in-python-8-working-with-text-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ushopwell.com\/ublog\/"},{"@type":"ListItem","position":2,"name":"Learn Pandas in Python #8 \u2014 Working with Text Data"}]},{"@type":"WebSite","@id":"https:\/\/ushopwell.com\/ublog\/#website","url":"https:\/\/ushopwell.com\/ublog\/","name":"UshopWell.com","description":"The Premiere Online Marketplace","publisher":{"@id":"https:\/\/ushopwell.com\/ublog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ushopwell.com\/ublog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ushopwell.com\/ublog\/#organization","name":"UshopWell","url":"https:\/\/ushopwell.com\/ublog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/logo\/image\/","url":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2018\/01\/pandaSwea.png","contentUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2018\/01\/pandaSwea.png","width":365,"height":359,"caption":"UshopWell"},"image":{"@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/person\/6fd1f9e0ff932e534c86c70d5acff0fc","name":"UShopWell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","caption":"UShopWell"},"url":"https:\/\/ushopwell.com\/ublog\/author\/kburnettu\/"}]}},"_links":{"self":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts\/239733","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/comments?post=239733"}],"version-history":[{"count":0,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts\/239733\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/media\/239734"}],"wp:attachment":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/media?parent=239733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/categories?post=239733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/tags?post=239733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}