quietlight/FiordlandPacks - Change Q22Y36T4TRTOAYVINNLCVV6NIR3WGW6IHY7QHUTX6PITRCPLZZQQC

added .julia format, tidy up

Created by AEj8dahVWy718uSSFPe9VSRJ5qX5G8pC2zvFzJJ8yzBd on March 16, 2024

Q22Y36T4TRTOAYVINNLCVV6NIR3WGW6IHY7QHUTX6PITRCPLZZQQC

Dependencies

In channels

main

Change contents

Replacement in survey/where.png at line 1 [3.21]
B:BD[3.21] → [3.22:26000]
[3.21]
Replacement in survey/what.png at line 1 [3.26023]
B:BD[3.26023] → [3.26024:45801]
[3.26023]
Replacement in survey/most_used_size.png at line 1 [3.589706]
B:BD[3.589706] → [3.589707:616727]
[3.589706]
Replacement in survey/most_used_make.png at line 1 [3.616759]
B:BD[3.616759] → [3.616760:650003]
[3.616759]
Replacement in survey/most_important.png at line 1 [3.650035]
B:BD[3.650035] → [3.650036:716744]
[3.650035]

Replacement in survey/ingest_to_db.txt at line 39 [3.716776]

B:BD[3.717945] → [3.717945:718134]

p1 = df |> @vlplot(:bar, height=800, width=800,x={:how_often, axis={title="How often do you use a pack?"}, sort="-y"}, y={"count()", axis={title="Count"}}) |> x -> save("how_often.png", x)

[3.717945]

[3.718134]

p1 = df |> @vlplot(:bar, height=700, width=700, config={axis={
      labelFontSize=22, titleFontSize=26},scale={fontSize=22}}, x={:how_often, axis={title="How often do you use a pack?"}, sort="-y"}, y={"count()", axis={title="Count"}}) |> x -> save("how_often.png", x)

Replacement in survey/ingest_to_db.txt at line 42 [3.716776]

B:BD[3.718135] → [3.718135:718320]

p2 = df |> @vlplot(:bar, height=800, width=800,x={:where, axis={title="Where do you use your pack most?"}, sort="-y"}, y={"count()", axis={title="Count"}}) |> x -> save("where.png", x)

[3.718135]

[3.718320]

p2 = df |> @vlplot(:bar, height=700, width=700, config={axis={
      labelFontSize=22, titleFontSize=26},scale={fontSize=22}}, x={:where, axis={title="Where do you use your pack most?"}, sort="-y"}, y={"count()", axis={title="Count"}}) |> x -> save("where.png", x)

Replacement in survey/ingest_to_db.txt at line 45 [3.716776]

B:BD[3.718321] → [3.718321:718503]

p3 = df |> @vlplot(:bar, height=800, width=800,x={:what, axis={title="What kind of load do you carry?"}, sort="-y"}, y={"count()", axis={title="Count"}}) |> x -> save("what.png", x)

[3.718321]

[3.718503]

p3 = df |> @vlplot(:bar, height=700, width=700, config={axis={
      labelFontSize=22, titleFontSize=26},scale={fontSize=22}}, x={:what, axis={title="What kind of load do you carry?"}, sort="-y"}, y={"count()", axis={title="Count"}}) |> x -> save("what.png", x)

Replacement in survey/ingest_to_db.txt at line 72 [3.716776]

B:BD[3.718842] → [3.718842:719033]

p4 = @vlplot(:bar, height=800, width=800,x={make, axis={title="What is your all time most used pack?"}, sort="-y"}, y={"count()", axis={title="Count"}}) |> x -> save("most_used_make.png", x)

[3.718842]

[3.719033]

p4 = @vlplot(:bar, height=700, width=700, config={axis={
      labelFontSize=22, titleFontSize=26},scale={fontSize=22}}, x={make, axis={title="What is your all time most used pack?"}, sort="-y"}, y={"count()", axis={title="Count"}}) |> x -> save("most_used_make.png", x)

Replacement in survey/ingest_to_db.txt at line 75 [3.716776]

B:BD[3.719034] → [3.719034:719228]

p5 = @vlplot(:bar, height=800, width=800,x={size, axis={title="Size of most used pack?"}, sort="-y", bin={maxbins=6}}, y={"count()", axis={title="Count"}}) |> x -> save("most_used_size.png", x)

[3.719034]

[3.719228]

p5 = @vlplot(:bar, height=700, width=700, config={axis={
      labelFontSize=22, titleFontSize=26},scale={fontSize=22}} , x={size, axis={title="Size of most used pack?"}, sort="-y", bin={maxbins=6}}, y={"count()", axis={title="Count"}}) |> x -> save("most_used_size.png", x)

Replacement in survey/ingest_to_db.txt at line 88 [3.716776]

B:BD[3.719412] → [3.719412:719464]

l=levels(x) |> sort! #check categories and simplify

[3.719412]

[3.719464]

l=levels(most_important) |> sort! #check categories and simplify

Replacement in survey/ingest_to_db.txt at line 90 [3.716776]

B:BD[3.719465] → [3.719465:719662]

p6 = @vlplot(:bar, height=800, width=800,x={most_important, axis={title="What is most important in a pack?"}, sort="-y"}, y={"count()", axis={title="Count"}}) |> x -> save("most_important.png", x)

[3.719465]

p6 = @vlplot(:bar, height=700, width=700, config={axis={
      labelFontSize=22, titleFontSize=26},scale={fontSize=22}}, x={most_important, axis={title="What is most important in a pack?"}, sort="-y"}, y={"count()", axis={title="Count"}}) |> x -> save("most_important.png", x)

Replacement in survey/how_often.png at line 1 [3.719705]
B:BD[3.719705] → [3.719706:741889]
[3.719705]

Replacement in src/FiordlandPacks.jl at line 5 [4.176]

B:BD[4.230] → [4.230:332]

using Airtable, CSV, DataFrames, Dates, HTTP, Indicators, JSON3, PrettyTables, UnicodePlots, VegaLite

[4.230]

[4.332]

using Airtable,
    CSV, DataFrames, Dates, HTTP, Indicators, JSON3, PrettyTables, UnicodePlots, VegaLite

Insertion in src/FiordlandPacks.jl at line 9 [4.176]
[4.337]
[4.337]
```
    metrics(date::String, invoices::Int)
```

Insertion in src/FiordlandPacks.jl at line 11 [4.176]

[4.338]

Takes a date string and number of invoices and returns a bunch of metrics for the 7 previous days (not including the date given).

Replacement in src/FiordlandPacks.jl at line 17 [4.176]
B:BD[4.487] → [4.487:529]
```
    @show airtable_sales_for_period(date)
```
[4.487]
[4.529]
```
    #@show airtable_sales_for_period(date)
```
Insertion in src/FiordlandPacks.jl at line 22 [4.176]
[4.670]
[4.670]
```
"""
   metrics_plot()
```

Insertion in src/FiordlandPacks.jl at line 25 [4.176]

[4.671]

Takes an up to date FiordlandPacks.csv and produces some metrics.
"""

Replacement in src/FiordlandPacks.jl at line 34 [4.176]

B:BD[4.938] → [5.4:289]

B:BD[5.289] → [3.87159395:87159452]

∅:D[3.87159452] → [5.336:480]

B:BD[5.336] → [5.336:480]

    transform!(df, [:Shopify_Sales, :Invoice_Sales] => (a, b) -> a .+ b)  
    select!(df, :Week, :Contact_Submit, :Pack_Builder_Clicks, :Checkouts_Created, :Customer_Actions, 
        :Shopify_Sales, :Invoice_Sales, :Shopify_Sales_Invoice_Sales_function => "Sales", :Google_Spend)   
    table = pretty_table(last(df, 12); title="Metrics", 
        header=["Week", "Contact", "Builder", "Checkout", "ACTIONS", "Shopify", "Invoice", "Sales", "Google"], 
        display_size=(30, 300))

[4.938]

[4.1107]

    transform!(df, [:Shopify_Sales, :Invoice_Sales] => (a, b) -> a .+ b)
    select!(
        df,
        :Week,
        :Contact_Submit,
        :Pack_Builder_Clicks,
        :Checkouts_Created,
        :Customer_Actions,
        :Shopify_Sales,
        :Invoice_Sales,
        :Shopify_Sales_Invoice_Sales_function => "Sales",
        :Google_Spend,
    )
    table = pretty_table(
        last(df, 12);
        title="Metrics",
        header=[
            "Week",
            "Contact",
            "Builder",
            "Checkout",
            "ACTIONS",
            "Shopify",
            "Invoice",
            "Sales",
            "Google",
        ],
        display_size=(30, 300),
    )

Deletion in src/FiordlandPacks.jl at line 67 [4.176]

B:BD[4.1333] → [4.1333:1520]

    df2 |>
    @vlplot(
        :line,
        x = :Week,
        y = :Number,
        color = :Metric,
        title = "Metrics Plot",
        width = 400,
        height = 400
    ) |>

Replacement in src/FiordlandPacks.jl at line 68 [4.176]

B:BD[4.1541] → [6.93:189]

        save("/Users/david/julia/FiordlandPacks/images_and_tables/metrics_fiordland_packs.png")

[4.1541]

[4.1632]

        save(
            "/Users/david/julia/FiordlandPacks/images_and_tables/metrics_fiordland_packs.png",
        )

Replacement in src/FiordlandPacks.jl at line 72 [4.176]

B:BD[4.1641] → [4.1641:1744]

        save("/media/david/SSD1/FiordlandPacks/images_and_tables/metrics_fiordland_packs.png")
    end

[4.1641]

[4.1744]

        save(
            "/media/david/SSD1/FiordlandPacks/images_and_tables/metrics_fiordland_packs.png"
        )
    end(
        @vlplot(
            :line,
            x = :Week,
            y = :Number,
            color = :Metric,
            title = "Metrics Plot",
            width = 400,
            height = 400
        )(
            df2
        ),
    )

Replacement in src/FiordlandPacks.jl at line 101 [4.176]

B:BD[4.2064] → [4.2064:2166]

function get_traffic(end_date::Dates.Date, days::Int, SITE_ID::String="fiordlandpacks.nz")::DataFrame

[4.2064]

[4.2166]

function get_traffic(
    end_date::Dates.Date, days::Int, SITE_ID::String="fiordlandpacks.nz"
)::DataFrame

Replacement in src/FiordlandPacks.jl at line 116 [4.176]

B:BD[4.2511] → [4.2511:2581]

Returns a unicode plot of unique site visits, compared to 1 year ago.

[4.2511]

[4.2581]

Returns a unicode plot and a png of unique site visits, compared to 1 year ago.

Replacement in src/FiordlandPacks.jl at line 125 [4.176]

B:BD[4.2777] → [4.2777:3023]

    c = get_traffic(current, days)[!, 2] |> x -> Indicators.sma(x, n=7) |> x -> last(x, days) |> x -> round.(x, digits=1)
    p = get_traffic(last_year, days)[!, 2] |> x -> Indicators.sma(x, n=7) |> x -> last(x, days) |> x -> round.(x, digits=1)

[4.2777]

[4.3023]

    c = (x -> (x -> (x -> round.(x, digits=1))(last(x, days)))(Indicators.sma(x; n=7)))(
        get_traffic(current, days)[!, 2]
    )
    p = (x -> (x -> (x -> round.(x, digits=1))(last(x, days)))(Indicators.sma(x; n=7)))(
        get_traffic(last_year, days)[!, 2]
    )

Replacement in src/FiordlandPacks.jl at line 132 [4.176]

B:BD[4.3024] → [4.3024:3244]

    plt = lineplot(collect(-days:-1), [c p], color=[:blue :yellow], title="Unique Visitors: 7 day moving average", name=["Last $days Days", "Last Year"], xlabel="Day", ylabel="Visitors", canvas=DotCanvas, border=:ascii)

[4.3024]

[4.3244]

    plt = lineplot(
        collect((-days):-1),
        [c p];
        color=[:blue :yellow],
        title="Unique Visitors: 7 day moving average",
        name=["Last $days Days", "Last Year"],
        xlabel="Day",
        ylabel="Visitors",
        canvas=DotCanvas,
        border=:ascii,
    )

Deletion in src/FiordlandPacks.jl at line 144 [4.176]

B:BD[4.3245] → [4.3245:3628]

    vcat(DataFrame("Days" => collect(-days:-1), "Visits" => c, "Period" => "Last $days Days"), DataFrame("Days" => collect(-days:-1), "Visits" => p, "Period" => "Previous Year")) |>
    @vlplot(
        :line,
        x = :Days,
        y = :Visits,
        color = :Period,
        title = "Unique Visitors: 7 Day Moving Average",
        width = 400,
        height = 400
    ) |>

Replacement in src/FiordlandPacks.jl at line 145 [4.176]

B:BD[4.3649] → [6.190:285]

        save("/Users/david/julia/FiordlandPacks/images_and_tables/visits_fiordland_packs.png")

[4.3649]

[4.3739]

        save(
            "/Users/david/julia/FiordlandPacks/images_and_tables/visits_fiordland_packs.png"
        )

Replacement in src/FiordlandPacks.jl at line 149 [4.176]

B:BD[4.3748] → [4.3748:3850]

        save("/media/david/SSD1/FiordlandPacks/images_and_tables/visits_fiordland_packs.png")
    end

[4.3748]

[4.3850]

        save(
            "/media/david/SSD1/FiordlandPacks/images_and_tables/visits_fiordland_packs.png"
        )
    end(
        @vlplot(
            :line,
            x = :Days,
            y = :Visits,
            color = :Period,
            title = "Unique Visitors: 7 Day Moving Average",
            width = 400,
            height = 400
        )(
            vcat(
                DataFrame(
                    "Days" => collect((-days):-1),
                    "Visits" => c,
                    "Period" => "Last $days Days",
                ),
                DataFrame(
                    "Days" => collect((-days):-1),
                    "Visits" => p,
                    "Period" => "Previous Year",
                ),
            ),
        ),
    )

Replacement in src/FiordlandPacks.jl at line 189 [4.176]

B:BD[4.4100] → [4.4100:4204]

function get_page_rank(end_date::Dates.Date, days::Int, SITE_ID::String="fiordlandpacks.nz")::DataFrame

[4.4100]

[4.4204]

# gets page rank for previous 7 days
function get_page_rank(
    end_date::Dates.Date, days::Int, SITE_ID::String="fiordlandpacks.nz"
)::DataFrame

Deletion in src/FiordlandPacks.jl at line 200 [4.176]
B:BD[4.4537] → [4.4537:4578]
```
"""
build_page_rank_table(date::String)
```

Replacement in src/FiordlandPacks.jl at line 201 [4.176]

B:BD[4.4579] → [4.4579:4718]

Takes a date in string form yy-mm-dd.
Returns a pretty table of top 10 pages for 7, 30, 365 days.
Make sure repl window is wide enough
"""

[4.4579]

[4.4718]

# Takes a date in string form yy-mm-dd.
# Returns a pretty table of top 10 pages for 7, 30, 365 days.

Replacement in src/FiordlandPacks.jl at line 217 [4.176]

B:BD[4.5166] → [4.5166:5323]

function get_custom_events(end_date::Dates.Date, event::String, days::Int=7, SITE_ID::String="fiordlandpacks.nz")::@NamedTuple{Event::String, Number::Int64}

[4.5166]

[4.5323]

function get_custom_events(
    end_date::Dates.Date, event::String, days::Int=7, SITE_ID::String="fiordlandpacks.nz"
)::@NamedTuple{Event::String, Number::Int64}

Replacement in src/FiordlandPacks.jl at line 223 [4.176]

B:BD[4.5595] → [4.5595:5746]

    e = replace(event, "+" => " ") |> x -> titlecase(x)
    isempty(df) ? (return (Event=e, Number=0)) : (return (Event=e, Number=first(df.visitors)))

[4.5595]

[4.5746]

    e = (x -> titlecase(x))(replace(event, "+" => " "))
    if isempty(df)
        (return (Event=e, Number=0))
    else
        (return (Event=e, Number=first(df.visitors)))
    end

Replacement in src/FiordlandPacks.jl at line 232 [4.176]

B:BD[4.5778] → [4.5778:5937]

function get_pageview_events(end_date::Dates.Date, event::String, days::Int=7, SITE_ID::String="fiordlandpacks.nz")::@NamedTuple{Event::String, Number::Int64}

[4.5778]

[4.5937]

function get_pageview_events(
    end_date::Dates.Date, event::String, days::Int=7, SITE_ID::String="fiordlandpacks.nz"
)::@NamedTuple{Event::String, Number::Int64}

Replacement in src/FiordlandPacks.jl at line 238 [4.176]

B:BD[4.6210] → [4.6210:6361]

    e = replace(event, "_" => " ") |> x -> titlecase(x)
    isempty(df) ? (return (Event=e, Number=0)) : (return (Event=e, Number=first(df.visitors)))

[4.6210]

[4.6361]

    e = (x -> titlecase(x))(replace(event, "_" => " "))
    if isempty(df)
        (return (Event=e, Number=0))
    else
        (return (Event=e, Number=first(df.visitors)))
    end

Replacement in src/FiordlandPacks.jl at line 254 [4.176]

B:BD[4.6746] → [4.6746:6846]

    return pretty_table(df; title="North Star Metric", header=["Event", "Number"], body_hlines=[3])

[4.6746]

[4.6846]

    return pretty_table(
        df; title="North Star Metric", header=["Event", "Number"], body_hlines=[3]
    )

Insertion in src/FiordlandPacks.jl at line 269 [4.176]
[4.7225]
[4.7225]
```
#=
```
Deletion in src/FiordlandPacks.jl at line 283 [4.176]
B:BD[4.7715] → [4.7715:7717]
Deletion in src/FiordlandPacks.jl at line 329 [4.176]
B:BD[4.9693] → [4.9693:9696]
```
#=
```
Deletion in src/FiordlandPacks.jl at line 386 [4.176]
B:BD[4.12208] → [4.12208:12210]
Replacement in images_and_tables/visits_fiordland_packs.png at line 1 [4.361487]
B:BD[4.361487] → [2.21:32605]
[4.361487]
Replacement in images_and_tables/metrics_fiordland_packs.png at line 1 [4.394888]
B:BD[4.394888] → [2.32607:80698]
[4.394888]

Replacement in images_and_tables/FiordlandPacks.csv at line 26 [4.454278]

B:BD[2.80731] → [2.80731:80761]

2024-02-12,1,15,0,16,0,1,22.91

[2.80731]

2024-02-12,1,15,0,16,0,1,22.91
2024-02-19,2,14,0,16,0,1,23.19
2024-02-26,1,14,1,16,1,1,21.33
2024-03-04,0,10,1,11,1,1,19.62
2024-03-11,3,15,1,19,0,4,22.64

Insertion in Project.toml at line 8 [4.649040]
[4.649216]
[4.649216]
```
Aqua = "4c88cf16-eb10-579e-8560-4a9242c79595"
```
Insertion in Project.toml at line 15 [4.649040]
[4.649505]
[4.649505]
```
JuliaFormatter = "98e50ef6-434e-11e9-1051-2b60c6c9e899"
```

added .julia format, tidy up

Dependencies

In channels

Change contents

Replacement in survey/where.png at line 1 [3.21]

Replacement in survey/what.png at line 1 [3.26023]

Replacement in survey/most_used_size.png at line 1 [3.589706]

Replacement in survey/most_used_make.png at line 1 [3.616759]

Replacement in survey/most_important.png at line 1 [3.650035]

Replacement in survey/ingest_to_db.txt at line 39 [3.716776]

Replacement in survey/ingest_to_db.txt at line 42 [3.716776]

Replacement in survey/ingest_to_db.txt at line 45 [3.716776]

Replacement in survey/ingest_to_db.txt at line 72 [3.716776]

Replacement in survey/ingest_to_db.txt at line 75 [3.716776]

Replacement in survey/ingest_to_db.txt at line 88 [3.716776]

Replacement in survey/ingest_to_db.txt at line 90 [3.716776]

Replacement in survey/how_often.png at line 1 [3.719705]

Replacement in src/FiordlandPacks.jl at line 5 [4.176]

Insertion in src/FiordlandPacks.jl at line 9 [4.176]

Insertion in src/FiordlandPacks.jl at line 11 [4.176]

Replacement in src/FiordlandPacks.jl at line 17 [4.176]

Insertion in src/FiordlandPacks.jl at line 22 [4.176]

Insertion in src/FiordlandPacks.jl at line 25 [4.176]

Replacement in src/FiordlandPacks.jl at line 34 [4.176]

Deletion in src/FiordlandPacks.jl at line 67 [4.176]

Replacement in src/FiordlandPacks.jl at line 68 [4.176]

Replacement in src/FiordlandPacks.jl at line 72 [4.176]

Replacement in src/FiordlandPacks.jl at line 101 [4.176]

Replacement in src/FiordlandPacks.jl at line 116 [4.176]

Replacement in src/FiordlandPacks.jl at line 125 [4.176]

Replacement in src/FiordlandPacks.jl at line 132 [4.176]

Deletion in src/FiordlandPacks.jl at line 144 [4.176]

Replacement in src/FiordlandPacks.jl at line 145 [4.176]

Replacement in src/FiordlandPacks.jl at line 149 [4.176]

Replacement in src/FiordlandPacks.jl at line 189 [4.176]

Deletion in src/FiordlandPacks.jl at line 200 [4.176]

Replacement in src/FiordlandPacks.jl at line 201 [4.176]

Replacement in src/FiordlandPacks.jl at line 217 [4.176]

Replacement in src/FiordlandPacks.jl at line 223 [4.176]

Replacement in src/FiordlandPacks.jl at line 232 [4.176]

Replacement in src/FiordlandPacks.jl at line 238 [4.176]

Replacement in src/FiordlandPacks.jl at line 254 [4.176]

Insertion in src/FiordlandPacks.jl at line 269 [4.176]

Deletion in src/FiordlandPacks.jl at line 283 [4.176]

Deletion in src/FiordlandPacks.jl at line 329 [4.176]

Deletion in src/FiordlandPacks.jl at line 386 [4.176]

Replacement in images_and_tables/visits_fiordland_packs.png at line 1 [4.361487]

Replacement in images_and_tables/metrics_fiordland_packs.png at line 1 [4.394888]

Replacement in images_and_tables/FiordlandPacks.csv at line 26 [4.454278]

Insertion in Project.toml at line 8 [4.649040]

Insertion in Project.toml at line 15 [4.649040]