RStudio Workspace & Data Workflow Setup

Заказчик: AI | Опубликовано: 19.01.2026

I need a hands-on RStudio expert to overhaul the way I organise, share, and analyse data. The immediate priority is proper RStudio workspace management: cleaning up existing folders and scripts, setting up clear project structures, and enabling smooth collaboration through RStudio Server. All of this must work seamlessly with two data sources—local CSV files and a live MySQL database. Beyond housekeeping, I also rely on MySQL Server and MySQL Workbench for querying and data prep, so the workspace you create should include robust connection scripts, test queries, and repeatable procedures for moving data in and out of R. Finally, many of my exploratory steps take place in JupyterLab / Jupyter Notebook, so the workflow you design has to let me flip between RStudio and Python notebooks without friction. Deliverables: • Reorganised RStudio workspace with tidy file hierarchy and reusable project templates • RStudio Server setup that lets multiple users collaborate safely on the same codebase • Connection scripts and example queries that link RStudio to both local CSVs and the MySQL database (via MySQL Workbench) • Two sample Jupyter notebooks that demonstrate the full data flow—import, clean, analyse, and visualise—mirroring the R workflow • A brief README or screencast walking through the system so I can maintain it on my own