Import data from CSV file

Overview

Graphite Note’s CSV integration allows you to import your data from CSV files. This guide will walk you through the steps to import your CSV data into Graphite Note.

Steps to Import Data

1. Create a New Dataset

• Option 1: Go to the homepage and click on "Create" under Datasets.

• Option 2: From the datasets list, click on "New Dataset."

Option 1: Create Dataset using homepage

Option 2: Create Dataset from the Dataset List page

2. Select CSV file

• Choose "CSV" as your data source and click "Next".

Choose CSV file

3. Enter Dataset Information

• Name: Provide a name for the dataset.

• Description: Add a short description of the data.

• Tags: Add tags for better organization.

• Click "Next" to proceed.

Name and Description of the dataset

4. Choose Parsing Options

• Configure your parsing options to properly interpret the CSV file.

  • Delimiter: Choose the character that separates values in your CSV (e.g., comma, semicolon).

  • Header: Indicate whether your CSV file has a header row.

  • Convert Empty Values to Null: Convert 'empty string' values to null. By default, this is turned on.

  • File Encoding: Select the file character encoding. The default is Unicode (UTF-8).

  • Skip Empty Rows: Skip empty rows at the beginning or end of the file. By default, Graphite Note will ignore those lines.

• Click on "Parse file" to process the file.

Parsing options

5. Review parsed data

   Review the parsed data and make any necessary adjustments:

   • Rename Columns: Change column names if needed.

   • Change Data Types: Adjust the data types of your columns as required.

   • Click on the "Create" button to finalize and create your dataset.

CSV filesize upload limits

Graphite Note limits the file size for CSV uploads to 50 MB. This restriction ensures that the platform maintains optimal performance, prevents excessive resource consumption, and ensures fast processing times for data uploads. If users need to work with larger datasets, alternative methods such as connecting directly to a database (Postgres, MySQL, BigQuery) can be used.

Next Steps

Now that your data is imported and prepared, you can proceed to create a model without writing any code. Simply go to the Models and follow the steps to build and deploy your model using Graphite Note's intuitive interface.