📊 Data2Boxplot – Generate Boxplots + ANOVA + Tukey HSD from CSV/Excel (No Code Required)

Show the Community!
, , , , , ,
1

:bar_chart: Data2Boxplot – Generate Boxplots + ANOVA + Tukey HSD from CSV/Excel (No Code Required)

Hi everyone! :waving_hand:

I wanted to share a tool I recently built called Data2Boxplot — a lightweight Streamlit app that lets you upload CSV or Excel files and instantly:

  • Generate clean boxplots
  • Run ANOVA group comparisons across multiple CSV and Excel files across multiple columns
  • Automatically apply Tukey HSD post hoc analysis if the ANOVA is significant
    demoboxplot

:light_bulb: Why I built it

While working on lab reports and experimental data, I realized how painful it was to:

  • Manually generate boxplots in Excel (especially with large datasets)
  • Run ANOVA and post hoc tests without writing R or Python code
  • Quickly explore group differences without setting up a Jupyter notebook

So I built this tool to streamline the process and make stats + plots more accessible — especially for students and researchers without programming experience.

:rocket: Key Features

  • :file_folder: Supports both CSV and Excel (.xlsx, .xls) — even large files with thousands of rows
  • :test_tube: Auto-runs ANOVA and Tukey HSD if p < 0.05
  • :compass: Interactive UI to select categorical and numerical columns
  • :bar_chart: Clean Plotly boxplots with group overlays
  • :brain: Built with: pandas, statsmodels, scipy, plotly, and streamlit

:link: Links