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
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."
Select CSV file
Choose "CSV" as your data source and click "Next".
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.
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.
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.
Last updated