From the course: Data Cleaning and Manipulating with Python in Excel

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Manipulating text data

Manipulating text data

From the course: Data Cleaning and Manipulating with Python in Excel

Start my 1-month free trial Buy for my team

Manipulating text data

“

- [Instructor] One of the main issues I've ran into in my analytics career has been text data quality. Having to manipulate it to get the data I need is a common occurrence. I'm sure you've had similar experiences. In this video, we will discuss proper ways of manipulating text data. We will also learn how to manipulate text data by using Python, which will make the process more efficient and easier. Finally, we will learn some of the key details that go into the Python code to manipulate the data. We have a bit to cover right here, so let's get right into it. So let's open up the XS file for this video. We'll use the chapter three 03_04 tab. Okay, so we have some information here in our dataset. We have the customer ID, the region, and city and state. However, there's an issue with this Customer_ID column, where we need to extract some of the text within this to make sure we are showing it off in the proper fashion. What we want to do here is we're going to go over to G3. We're going…

Contents