Prerequisites for using DataFrames?

Transcript

So we have a couple of questions on the fundamentals of DataFrames, when to use them. What prerequisites are there? One from Sam, one from Tom. DataFrames are officially available from version nine two, although there are a few methods that were added in nine three that makes them significantly nicer to use.

So I would suggest to use nine three if you can. And the typical use case for DataFrame is when you're dealing with large amounts of data. So like hundreds or thousands of records because the performance gain is, is very significant. And the the more records you have, the, the larger the the gain will be.

So generally, whenever you think that the bottleneck in your solution is in SQL because you're creating a lot of records or the query is a bit slow, and try swapping in DataFrames and for data tables and see and chances are things will improve. So also in new projects whenever you're reaching for data table, unless you have a compelling reason to stick with data tables, try and set to use DataFrame because you will likely get performance gain upfront and you become more familiar with the interface going forward. Another great use case is that in the latest API version. So from nine three going forward.

It's very, very easy to slice DataFrames. So for things like pagination of large record set or other situations where you want to retrieve a large data set and then slice it according to your prerequisites, then DataFrames might feel more natural and might feel easier to use than than the old school data tables.