From the course: Data Analysis with Python and Pandas
Unlock this course with a free trial
Join today to access over 24,900 courses taught by industry experts.
Key takeaways
From the course: Data Analysis with Python and Pandas
Key takeaways
- [Instructor] All right, so that concludes our journey through time series data. As you probably learned, time series data and dates and times in Python and Pandas are deceptively complicated, and so, there's a lot more to learn here, but what we really need to know to be effective is that the datetime64 data type lets us work with time series in Pandas. As we saw, the conversion can be deceptively complicated, so use the .to_datetime method to manage errors or explicitly state the datetime format for Pandas to interpret it correctly. I generally suggest trying the typical as type method, but if you do run into problems, that's when we want to use .to_datetime. Use our datetime codes and accessors to format date, and extract date components. There are dozens of options for these, but we really only need to memorize the common parts and formats for most business analysis scenarios. We want to be able to extract our month, our day of week, our year. And we can always reference a…
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.
Contents
-
-
-
-
-
-
-
-
-
(Locked)
Times in Python and pandas3m 8s
-
(Locked)
Converting to datetimes6m 16s
-
(Locked)
Formatting dates5m 20s
-
(Locked)
Date and time parts3m 4s
-
(Locked)
Challenge: pandas datetime basics1m 23s
-
(Locked)
Solution: pandas datetime basics2m 10s
-
(Locked)
Time deltas and arithmetic6m 54s
-
(Locked)
Challenge: Time deltas1m 10s
-
(Locked)
Solution: Time deltas1m 29s
-
(Locked)
Time series indices3m 58s
-
(Locked)
Missing time series data4m 45s
-
(Locked)
Challenge: Missing time series data1m 44s
-
(Locked)
Solution: Missing time series data2m 13s
-
(Locked)
Shifting time series3m 16s
-
(Locked)
Pro tip: diff()2m 54s
-
(Locked)
Challenge: shift() and diff()1m 39s
-
(Locked)
Solution: shift() and diff()2m 47s
-
(Locked)
Aggregation and resampling4m 6s
-
(Locked)
Challenge: Resampling41s
-
(Locked)
Solution: Resampling1m 53s
-
(Locked)
Rolling aggregations4m 35s
-
(Locked)
Challenge: Rolling aggregations45s
-
(Locked)
Solution: Rolling aggregations55s
-
(Locked)
Key takeaways1m 37s
-
(Locked)
-
-
-