Cleaning, Transforming, and Exploring Data with AI

I have 50,000 rows of data.

How long does cleaning, transforming, and exploring this information take?

1 billion people worldwide use spreadsheets. Some are fast, but most will need days to do it.

AI can do this in seconds. Here is how:

— Santiago (@svpino) June 23, 2023

I'm using @AkkioHQ.

They built one of the few no-code tools I've seen that feel like a game-changer for data manipulation.

If you want to follow along, create a free account here and upload your dataset. https://t.co/euOuAsyKVp.

Let me show you 3 tricks:

— Santiago (@svpino) June 23, 2023

I can now transform my data by writing what I want.

Here is one example:

I wanted to replace some abbreviations from the "workclass" column and replace missing values with the most frequent value in the column.

Look at this screenshot. This took seconds and 0 lines of code! pic.twitter.com/0evTO9f3Mh

— Santiago (@svpino) June 23, 2023

Let's spice it up:

I want to create a new column and set its value based on a condition involving another column.

This is fun!

I write what I want, and the tool does it for me. pic.twitter.com/ZvFzDrJGcF

— Santiago (@svpino) June 23, 2023

But it's not only about making changes to the data.

You can also explore the data and create charts by writing your queries in plain English.

Here is a chart showing the distribution of overworked employees by income. pic.twitter.com/KCyPuAF3y8

— Santiago (@svpino) June 23, 2023

It's mind-blowing everything you can do:

1. Apply complex and arbitrary transformations.
2. Scale columns.
3. Translate content.
4. Expand or summarize columns.
5. Convert between formats.

I used @AkkioHQ for the first time in January. Today it's 3x faster and more accurate.

— Santiago (@svpino) June 23, 2023