TableSkill

TableSkill.tableskill — Method

tableskill(
    ;
    dataframe_dict::Dict{String, DataFrame} = Dict("dataframe_name" => DataFrame()),
    sub_folder_in_export::String = "",
    root_folder::String = normpath(
        homedir() * "/" * ENV["JULIA_USER_SURNAME"] *"/temp/tableskill/" * Dates.format(Dates.today(), "yyyymmdd")
    )
)

Export a dictionary of (str => DataFrame) for visualization in TableSKILL.

Examples:

julia> tableskill(
    dataframe_dict = Dict(
        "1 security" => security_df,
        "2 portfolio" => portfolio_df,
    ),
    sub_folder_in_export = "portfolio",
)

source

Example:

using TableSkill, DataFrames, RDatasets, Chain

movies_df = RDatasets.dataset("ggplot2", "movies")

curated_movies_df = @chain movies_df begin
    # Select only some variables
    curated_movies_df1 = select(
        :Title, :Rating, :Votes,
        :Action, :Animation, :Comedy, :Short
    )

    # Select only some rows
    curated_movies_df2 = subset(
        [:Votes] => ByRow(>=(1000)),
        [:Action, :Animation, :Comedy] => ByRow((a,b,c) -> a+b+c >= 1)
    )

    # Sort
    curated_movies_df3 = sort(
        [
            order(:Rating, rev = true),
            order(:Votes, rev = true),
        ]
    )
end

withenv("JULIA_USER_SURNAME"=>"levy") do
    tableskill(
        dataframe_dict = Dict(
            "1 movies_df" => movies_df,
            "2a curated_movies_df1" => curated_movies_df1,
            "2b curated_movies_df2" => curated_movies_df2,
            "2c curated_movies_df3" => curated_movies_df3,
            "3 curated_movies_df" => curated_movies_df
        ),
        sub_folder_in_export = "tableskill_example",
    )
end