How to Analyze a CSV File Without Writing a Single Line of Code

You have a CSV file. Maybe it's grade data your department chair exported from the LMS. Maybe it's a survey you ran on Google Forms. Maybe it's 10,000 rows of attendance records that someone emailed you with the subject line "can you take a look at this when you get a chance?"

You open it in Excel. You stare at it. You scroll down. You scroll back up. You try to make a pivot table. You accidentally freeze the wrong row. You close the laptop.

We've all been there.

The problem isn't you

The tools most people use for data analysis were built for people who already know how to do data analysis. Excel is powerful if you know what you're doing, but "powerful if you know what you're doing" is just a polite way of saying "hostile to beginners."

And the alternatives aren't much better. Python requires you to learn Python. R requires you to learn R. Jupyter notebooks require you to understand what a kernel is, and honestly, do you want to learn what a kernel is right now? Probably not. You just want to know which students scored below 70 on the last exam.

What if you could just ask?

That's the idea behind RBase. You upload your CSV, and then you just type what you want to know in plain English.

"What's the average score by section?"

"Show me a histogram of final grades."

"Which students have missed more than 5 classes?"

RBase takes your question, writes R code to answer it, runs that code in your browser, and shows you the result. A table, a chart, a number, whatever makes sense. You can see the code it wrote if you're curious, or you can completely ignore it. Up to you.

But wait, it runs in my browser?

Yeah. Your data never leaves your machine. There's no upload to some server in Virginia. The R environment runs locally using WebR and DuckDB, which are basically magic browser technologies that let you run real data analysis without installing anything.

This matters a lot if you're working with student data, medical records, or anything you probably shouldn't be emailing around in spreadsheet attachments (which, let's be honest, everyone does anyway).

A real example

A teacher I worked with had reading assessment data for 150 students. Each student had a "lessons completed per week" number and a "reading growth score." She wanted to know if the reading program was actually working or if they were wasting everyone's time.

In Excel, this would involve: looking up how to do a correlation, figuring out the CORREL function, maybe trying to make a scatter plot, definitely fighting with axis labels for 20 minutes.

In RBase, she typed: "Is there a correlation between lessons per week and reading growth? Show me a scatter plot with a trend line."

She got a ggplot2 chart with a regression line, the correlation coefficient, and a p-value. Took about 10 seconds.

The program wasn't working, by the way. The correlation was basically zero. She now has the data to back that up when she talks to her department head about it.

Who is this for?

If you write code for a living, you probably don't need this. You already have your Jupyter setup and your favorite pandas aliases and your opinions about matplotlib vs seaborn.

This is for everyone else. Teachers, researchers, small business owners, students, anyone who has data and questions but doesn't want to learn a programming language just to get answers.

Try it out. It's free, takes about 30 seconds to get going, and you don't need to install anything.