Simple Information Remodel progress | Profitable Software program

I’ve been regularly enhancing my knowledge wrangling software, Simple Information Remodel, placing out 70 public releases since 2019. Whereas the product’s emphasis is on ease of use, fairly than pure efficiency, I’ve been attempting to make it quick as effectively, so it will possibly address the multi-million row datasets clients wish to throw at it. To see how I used to be doing, I did a easy benchmark of the latest model of Simple Information Remodel (v1.37.0) towards a number of different desktop knowledge wrangling instruments. The benchmark did a learn, kind, be part of and write of a 1 million row CSV file. I did the benchmarking on my Home windows improvement PC and my Mac M1 laptop computer.

Easy Data Transform screenshot

Right here is an outline of the outcomes:

Time by process (seconds), on Home windows with out Energy Question (smaller is best):

data wrangling/ETL benchmark Windows

I’ve left Excel Energy Question off this graph, as it’s so gradual you possibly can hardly see the opposite bars when it’s included!

Time by process (seconds) on Mac (smaller is best):

data wrangling/ETL benchmark M1 Mac

Reminiscence utilization (MB), Home windows vs Mac (smaller is best):

data wrangling/ETL benchmark memory Windows vs Mac

So Simple Information Remodel is almost as quick because it’s nearest competitor, Knime, on Home windows and a good bit quicker on an M1 Mac. It is usually makes use of quite a bit much less reminiscence than Knime. Nevertheless we’ve got bought some technique to go to meet up with the Pandas library for Python and the info.desk bundle for R, on the subject of uncooked efficiency. Hopefully I can get nearer to their efficiency in time. I used to be forbidden from together with benchmarks for Tableau Prep and Alteryx by their licensing phrases, which appears unnecessarily restrictive.

simply the Simple Information Remodel outcomes, it’s fascinating to note {that a} newish Macbook Air M1 laptop computer is considerably quicker than a desktop AMD Ryzen 7 desktop PC from a couple of years in the past.

Windows vs Mac M1 benchmark

See the total comparability:

Comparability of information wrangling/ETL instruments : R, Pandas, Knime, Energy Question, Tableau Prep, Alteryx and Simple Information Remodel, with benchmarks

Acquired some knowledge to scrub, merge, reshape or analyze? Why not obtain a free trial of Simple Information Remodel ? No enroll required.


Leave a Reply

Your email address will not be published. Required fields are marked *