Answer to: How to visualize a dense, gappy time series with spikes in Python?

You're looking for the ruptures library. It formulates your Change Point Analysis problem as an optimization problem, minimizing a loss function, and identifies optimal timestamps to declare that the latent state variable(s) of the underlying process went through some change. Do take a little while to read the project's introductory paper, as it is quite illuminating.