Quadratic Docs
Ask or search…
Comment on page

Manipulate data

Perform novel analysis on your data.
Manipulating data in Quadratic is easier than ever as you can view your changes in the sheet in real-time. Here is a non-exhaustive list of ways to manipulate your data in Quadratic:

1. Find correlations

Get your correlation and show that value in the sheet.
// correlation between two columns
data['col1'].corr(data['col2'], method='pearson')
// possible methods: pearson, kendall, spearman

2. Basic stats - max, min, mean, selections, etc.

// max from column
// min from column
// mean from column
// median from column
// skew for all columns
// count values in the column
// summary of column

3. DataFrame math

Do math on data in the DataFrame. Alternatively, use formulas in the sheet on the values in the sheet.
// add, subtract, multiply, etc. - will work on all values in column
df['col1'] + 1
df['col1'] * 2
df['col1'] / 2
// do any arbitrary math column-wise with the above or just do DataFrame-wise via
df + 1

4. Data selections

Alternatively, cut/copy/paste specific values in the sheet.
// get a column
// get multiple columns
df[['col1', 'col2']]
// filtering

5. Prep for visualizations

Visualizations are in active development.

6. POST your data to external APIs

This is a feature in active development for better CORS requests.