Documentation

How to Extract Selected Rows from Large Datasets with DataOlllo

When working with large datasets in formats like .csv, .xlsx, .parquet, .json, or other dataset formats, you may only need specific rows for analysis. Opening and filtering such datasets can be difficult with tools like traditional spreadsheets due to file size and performance limitations. DataOlllo — Handle Large Datasets Locally, Without Limits is designed to handle such tasks quickly and efficiently.

In this article, we’ll guide you through the simple process of extracting specific rows from any large dataset using DataOlllo in just two steps.

Scenario: Extracting Selected Rows from Large Datasets

Imagine you have a massive dataset in .csv, .parquet, .xlsx, .json, or other formats, and you're only interested in analyzing certain rows based on specific conditions or values. DataOlllo makes it easy to filter and extract only the rows you need, even if the dataset is too large for traditional tools.

Step 1: Open the Dataset in DataOlllo

  1. Launch DataOlllo on your computer.
  2. Click the Open File button and select the dataset. DataOlllo supports various formats like .csv, .xlsx, .json, .parquet, and more.
  3. Once the file is loaded, DataOlllo will display the entire dataset, even if it contains millions of rows and columns, with no performance issues.

Step 2: Select and Extract the Desired Rows

  1. After loading the dataset, use the Extract Rows feature located in the toolbar to filter the dataset by specific conditions (e.g., by a date range, value match, or unique identifier).
  2. Define the conditions for the rows you want to extract, such as filtering by list of values or using custom conditions with ':'.
  3. Once you’ve applied the filters, click Extract Rows to export the filtered rows into a new file. You can save the extracted rows in formats such as .csv, .json, .parquet, or .xlsx.

With DataOlllo, extracting rows from large datasets is fast and simple. The intuitive row filtering and extraction tools allow you to focus on analyzing the data that matters, without the hassle of handling massive files in other programs.

Try DataOlllo today and optimize your data extraction workflow!