This post is following of above post.
In this post, let's make average value data frame by country and by year.
First, I make a data frame for average value by country using group_by() function and summarize() function using R.
The, let's make a sacatter plot.
I load ggthemes and ggrepel packages to make a professional looking graph.
Let's make a economist style graph.
We see GROSSADJ & USD_CAL and NET_AGRWTH are negative correlation.
Next, let's make a data frame by year.
Let's make a scatter plot.
We see GROSSADJ & USD_CAP and NET & AGRWTH are negative correlation.
Next, let's see year vs. gr_us
We see GROSSADJ & USD_CAP has increasing trend.
How about NET & AGRWTH?
We see NET & AGRWTH has downward trend and it is more volatile than GROSSADJ & USD_CAP.
That's it. Thank you!
Next post is
to see the 1st post,