using CSV, DataFrames, StatsPlots

spotify_filepath = "data//archive//museum_visitors.csv";

museum_data = CSV.read(spotify_filepath, DataFrame);

last(museum_data, 5)

# How many visitors did the Chinese American Museum 
# receive in July 2018? 
ca_museum_jul18 = 2620

2620

19280-4622

14658

# In October 2018, how many more visitors did Avila 
# Adobe receive than the Firehouse Museum?
avila_oct18 = 14658

14658

#gr(size=(1000,700))

@df museum_data plot(museum_data.Date, cols(2:5), xlabel="Date", title="Monthly Visitors to Los Angeles City Museums")

propertynames(museum_data)

5-element Vector{Symbol}:
 :Date
 Symbol("Avila Adobe")
 Symbol("Firehouse Museum")
 Symbol("Chinese American Museum")
 Symbol("America Tropical Interpretive Center")

p = @df museum_data plot(museum_data.Date, cols(2), title="Monthly Visitors to Avila Adobe", xlabel="Date",ylabel="Avila Adobe", legend=false, grid=false)

To run this tutorial locally, download [this file](/tutorials/museum03x02.jl) and open it with Pluto.jl._