💾 Archived View for gemlog.blue › users › cariboudatascience › 1613686927.gmi captured on 2023-07-22 at 18:16:46. Gemini links have been rewritten to link to archived content

-=-=-=-=-=-=-

Fruit Consumption Per Capita: 1960 - 2017

Five Countries with hightest Fruit Comsumption

Software required to recreate plot:

Install: R language, RTools40 and RStudio (see link below)
Packages: GGPLot2, dplyr, janitor.
Download code and data from Github.com (see link below).
Move R code and data to working directory

Walkthough (R Code)

Gemini Browser

Caribou Data Science(Capsule)

Run R Code:

library(ggplot2)
library(scales)
library(dplyr)
library(tidyr)
## Import Fruit Consumption data
rm(list=ls())
fruit <- read.csv("./DATA/1-fruit-consumption-per-capita.csv")
fruit <- fruit %>%select(-Code) 
colnames(fruit) <- c("Country","Year","Fruits")
fruits_top <- fruit %>% filter(Year =="2017") %>%  top_n(5,Fruits)
fruits_top <- as.data.frame(fruits_top)

ggplot(fruits_top) +
  geom_col(aes(x=reorder(Country,Fruits),y=Fruits)) + coord_flip() +
  labs(title="Top 5 countries by per Capita Fruit Production")

countries_five <- fruits_top %>% select(Country) %>% left_join(fruit,by="Country")
head(countries_five)
tail(countries_five)

### Plot Top % Countries by Kg cosummed per year per person.
##
ggplot(countries_five) + geom_line(aes(x=Year,y=Fruits,col=Country)) +
  labs(title = "Fruit Consumption Kg/Person/Year",subtitle = "( Top 5 countries)",
       y="Fruit Consumed per person Kg")

### Plot of US Fruit consumption 

fruit %>% filter(Country =="United States") %>%
  ggplot() + geom_line(aes(x=Year,y=Fruits)) +
  labs(title="US Fruit Consumption: Kg/Year/Person (1960-2017)",
       y="Kilograms Per Person")

Plots:

Top 5 Countries

Top 5 Countries by Year

US Fruit Comsumption by Year

Part 2: Code Continues with Two More Plots:

countries_five %>% filter(Year >="2010") %>%
  ggplot() + geom_col(aes(x=Country,y=Fruits)) + 
  facet_wrap(~Year,ncol=2) + coord_flip() +
  labs(title="Fruit Consumption by Country by Year/Kg/Person")

ggplot(countries_five) + geom_line(aes(x=Year,y=Fruits,col=Country)) +
  labs(title = "Fruit Consumption Kg/Person/Year",subtitle = "( Top 5 countries)",
       y="Fruit Consumed per person Kg") + facet_wrap(~Country,scale="free_y",ncol=2) +
  geom_smooth(aes(x=Year, y= Fruits),method="lm")

Plots:

Fruit Comsumption by Country/Year

Fruit Comsumption Per Year

Resources:

R Code, and data

R Language and Rtools40 (click and "base" and "Rtools")

Download and install RStudio

Comments, Questions, Request:

Comments, Questions, Request