From the course: Data Cleaning and Manipulating with Python in Excel
Join today to access over 24,900 courses taught by industry experts.
Manipulating columns
From the course: Data Cleaning and Manipulating with Python in Excel
Manipulating columns
- [Instructor] If you're a frequent Excel user, then you can understand the frustrations that bad data can give you. You're finally ready to get started on your project or ad hoc requests, to then realize that data is all combined into a bunch of cells and whatnot. Whether you're working with messy data or simply trying to organize your dataset more efficiently, understanding how to manipulate columns can be a game-changer. In this video, you'll be learning why manipulating columns can enhance your data analysis. You will also learn how Python can help make the process more efficient. And lastly, you will learn how to implement these processes using Python code. Sound good? Awesome, let's get right into it. So, let's open up the Exercise File for this video. We'll use the Chapter 2, 02_04 tab. Okay, so let's take a look at what we got here. We have a handful of columns, Customer ID, the Region, City, and their Name. Now, there's a few things we got to do here from a manipulation…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.