From the course: Data Cleaning and Manipulating with Python in Excel
Join today to access over 24,900 courses taught by industry experts.
Time data
From the course: Data Cleaning and Manipulating with Python in Excel
Time data
- [Instructor] I don't know about you, but working with time data can be incredibly tricky: making sure the time is appropriately formatted, using the correct format itself and so on. Excel's a fantastic tool for analyzing time data, but using Python within Excel makes it even better. In this video, we'll learn how Python can enhance our time data cleaning processes. We'll also learn how to extract time from data within Excel. Finally, we'll learn how to find the difference of time data using Python. Okay, we got a bit to cover here, so let's dive right in. So let's open up the exercise file for this video. We'll use the Chapter 2, 02_02 tab. Okay, so looking at this data here, we have the Start_Time, End_Time and the Meeting_ID. So it looks like there's a few meetings here that we know when it started and when it ended. And over here to the right, we have a few different variables we're going to be looking at. And the first one here is going to be the hour. So if I click into F3, I…
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.