So far in this series, in part 1, 2 and 3, we have built bar charts on categorical data. One aspect of top bottom analysis we have not yet covered is the case of time series data. That will be the topic of this blog.
We load the R packages for data manipulation and data plotting.
This is a busy chart with many lines and a lot of history. Keeping only the top and bottom cities is a possible way to bring clarity to the visualization. This can be achieved within a single line plot or using a first plot for top cities and a second one for bottom cities, each plot having its own Y axis.
We compute the average price by city to then keep the top and bottom cities