Comparison-Julia1

compjl1.jl

# Load required packages 
using CSV 
using DataFrames 
using Plots 
using Pipe 
using Dates

# Read csv 
commodities = CSV.read("../../../Datasets/imf-commodities.csv", DataFrame);

# Data-wrangling 
commodities = @pipe commodities |> 
    _[4:end, [:Commodity, :PALLFNF]] |> 
    dropmissing(_) |> 
    transform(_, :Commodity => (x -> replace.(x, ("M" => "-"))) => :date) |> 
    transform(_, :date => (x -> Date.(x, "y-m")) => :date) |>
    transform(_, :PALLFNF => (x -> parse.(Float32, x)) => :comm);

first(commodities, 6)