From the course: Practical Python for Time Series Analysis

Unlock this course with a free trial

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

Inner join vs. outer join

Inner join vs. outer join - Python Tutorial

From the course: Practical Python for Time Series Analysis

Start my 1-month free trial Buy for my team

Inner join vs. outer join

“

- [Instructor] To visualize multiple time series with different frequencies, we must learn the differences between inner join and outer join. Taking the code from the previous video, we observe almost 3,500 rows. This is because there is a parameter called join that it's using the default outer. However, if we use the other one, which results in having multiple data that you see at the end with missing values, because the frequencies are different. And not all the data points from the first column coincide with the ones in the second column. However, if we put join = inner, we are making sure that the only data points to shown are the ones that they coincide. And now, by the time we plot the data, we can observe the full continuation of the line. However, this doesn't make any sense because the index doesn't follow a regular frequency for the day times. For example, between the first two rows, there is a difference…

Contents