Package: sideview 0.3.0

Yee How Lau

sideview: Explore and Join Many Tables on a Zoomable Canvas

Lays out many data frames side by side as cards on a pan-and-zoom canvas, either as a 'shiny' gadget for 'RStudio' or as an 'htmlwidgets' widget for 'R Markdown' and 'Quarto' pages. Drawing a line between two columns writes the 'dplyr' join and checks it first: match rates, unmatched keys and the key relationship. Sorts, filters and other steps build up a readable pipeline of R code, and a column inspector exports a data dictionary. An optional large language model (LLM) assistant, using 'Ollama' or an 'OpenAI'-compatible service, suggests 'tidyverse' code from the table schema only, never the data rows.

Authors:Yee How Lau [aut, cre, cph]

sideview_0.3.0.tar.gz
sideview_0.3.0.zip(r-4.7-any)sideview_0.3.0.zip(r-4.6-any)
sideview_0.3.0.tar.gz(r-4.7-any)sideview_0.3.0.tar.gz(r-4.6-any)
sideview_0.3.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
sideview/json (API)

# Install 'sideview' in R:
install.packages('sideview', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/lauyeehow1986-hub/sideview/issues

Pkgdown/docs site:https://lauyeehow1986-hub.github.io

On CRAN:

Conda:

1.70 score 41 exports 52 dependencies

Last updated from:3fe90c5390. Checks:6 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-develOK159
source / vignettesOK226
linux-releaseOK173
windows-develOK78
windows-releaseOK109
wasm-releaseOK122

Exports:new_sideview_staterenderSideviewsave_sideviewsideviewsideview_addinsideview_serversideview_uisideview_widgetsideviewOutputsv_auto_clean_rulessv_build_chat_promptsv_build_promptsv_build_schema_contextsv_call_llmsv_code_arrangesv_code_auto_cleansv_code_filtersv_code_group_summarizesv_code_joinsv_code_mutatesv_code_pivot_longersv_code_pivot_widersv_code_recodesv_code_renamesv_code_selectsv_codebooksv_column_profilesv_detect_discrepanciessv_escape_identsv_extract_codesv_find_tablessv_insert_codesv_is_rstudio_availablesv_join_diagnosticssv_llm_modelssv_load_statesv_normalizesv_save_statesv_send_to_consolesv_suggest_mappingssv_theme

Dependencies:askpassbase64encbslibcachemclicommonmarkcurldigestdplyrevaluatefastmapfontawesomefsgenericsgluehighrhtmltoolshtmlwidgetshttpuvhttr2jquerylibjsonliteknitrlaterlifecyclemagrittrmemoisemimeopensslotelpillarpkgconfigpromisesR6rappdirsRcpprlangrmarkdownrstudioapisassshinysourcetoolssystibbletidyselecttinytexutf8vctrswithrxfunxtableyaml

Readme and manuals

Help Manual

Help pageTopics
Create a New Sideview Canvas State Objectnew_sideview_state
Print Method for Sideview State Objectsprint.sideview_state
Shiny Render Function for Sideview WidgetrenderSideview
Save Sideview Widget to a Standalone HTML Filesave_sideview
Multi-Table 2D Infinite Canvas Interactive Gadgetsideview
RStudio Addin for Sideviewsideview_addin
Sideview Server Logicsideview_server
Sideview User Interfacesideview_ui
Create a Standalone Sideview HTMLWidgetsideview_widget
Shiny Output Container for Sideview WidgetsideviewOutput
Generate tidyverse Code for Automatic Discrepancy Cleaning and Crosswalkssv_auto_clean_rules sv_code_auto_clean
Build Structured Multi-Turn Prompt for Conversational Copilotsv_build_chat_prompt
Build Structured Prompt for Tidyverse LLM Code Generationsv_build_prompt
Build a Privacy-Safe Schema Context from Sideview Cardssv_build_schema_context
Call Local Ollama or OpenAI-Compatible LLM Endpointsv_call_llm
Generate tidyverse Code for Arranging (Sorting) Rowssv_code_arrange
Generate tidyverse Code for Filtering Rowssv_code_filter
Generate tidyverse Code for Grouping and Aggregating Datasv_code_group_summarize
Generate tidyverse Code for Relational Table Joinssv_code_join
Generate tidyverse Code for Column Mutationsv_code_mutate
Generate tidyverse Code for Reshaping Data from Wide to Longsv_code_pivot_longer
Generate tidyverse Code for Reshaping Data from Long to Widesv_code_pivot_wider
Generate tidyverse Code for Categorical Recoding and Discrepancy Crosswalkssv_code_recode
Generate tidyverse Code for Column Renamingsv_code_rename
Generate tidyverse Code for Selecting Columnssv_code_select
Codebook (Data Dictionary)sv_codebook
Column Profilesv_column_profile
Detect Exact Matches, Discrepancies, and Fuzzy Near-Matchessv_detect_discrepancies
Escape R Identifiers with Backticks If Non-Syntacticsv_escape_ident
Extract Executable R Code from LLM Response Textsv_extract_code
Find Tabular Data Objects in an Environmentsv_find_tables
Insert Generated Code into the Active RStudio Editorsv_insert_code
Check if RStudio API is Availablesv_is_rstudio_available
Join Diagnosticssv_join_diagnostics
List the models available from an LLM backendsv_llm_models
Load Canvas State from Filesv_load_state
Universal Normalization Engine for Sideview Cardssv_normalize
Save Canvas State to Filesv_save_state
Send Generated Code to the RStudio Consolesv_send_to_console
Suggest Foreign Key Mappings Across Canvas Cardssv_suggest_mappings
Canvas Themesv_theme