Dataset Finder powered by ChatGPT API
Zoho DataPrep helps you enrich your data by enabling you to find new datasets based on your requirement using ChatGPT API integration, a generative artificial intelligence developed by OpenAI. You can use these datasets for data enrichment purposes. To enable this feature in your DataPrep organization, go to the OpenAI Integration tab in the Settings page.
Click here
to know more about enabling OpenAI integrated features.
Here's a quick video on ChatGPT API integration with Zoho DataPrep.
Here's a quick demo on the features powered by OpenAI in Zoho DataPrep.
Data Privacy Notice
: Zoho DataPrep utilizes OpenAI's ChatGPT API, an external service based in the USA, subject to
OpenAI's Terms of Use
. Please be aware that the information sent to OpenAI depends on the access provided by you, the user. The data shared with ChatGPT is based on the features you enable. Details such as column names and/or selected cell data will be shared based on each feature. You can choose to enable or disable each feature based on the level of data you want to share. Therefore, exercise caution while using this service and ensure that the data you provide does not contain confidential or personal information.
Go to OpenAI Integration in the Settings page to learn more about configuring this integration.
Notes
:
-
The generative response are coming in from ChatGPT's training data. Accuracy, consistency, and relevance of the response are subjective to the type of prompts and the data available in its training set.
-
ChatGPT doesn't respond to prompts about personal information.
Data Enrichment powered by OpenAI ChatGPT API
1.Create a workspace or open an existing workspace.
Click here
if you're new to creating workspaces in Zoho DataPrep.
2. Choose the
Zoho Apps
category from the left pane and click
Find new dataset with ChatGPT. You can also directly search the option in the search box.
3. Provide a hint about the type of data you are looking for in the
Instruction prompt. For example, create a dataset for salesforce CRM instagram "Liked" list. You can also insert one of the prompts from the
Insert hints
section.
4. Click
Fetch data
and you will see a preview of the data generated by ChatGPT.
5. Click the
Import
button to import data and a dataset will be created.
Note: The datasets generated can be used for data enrichment purposes by blending or merging the generated data with other datasets using
append
or
join
transforms.
Here are some sample prompts for you to try out
a. Create a dataset of sales tax rates by state in the US.
b. Create a dataset for places with the highest average temperature in the US.
c. Create a dataset of average electricity prices by state.
6. You can also use the
Reload data from source
option to refresh or reload data again from ChatGPT. Click here
to know more about reloading data in your dataset.
Note: Reloading data could add new data and columns and also modify the dataset model since data is re-fetched from ChatGPT which usually gives new data.
SEE ALSO
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Dataset transforms
Dataset transform consists of combining and transforming datasets to suit your needs. You can apply the following transforms in a dataset. Deduplicate Row-wise Column-wise Join Append Pivot Unpivot Calculated columns Derive dataset Mark as personal ...Transform by Example powered by OpenAI ChatGPT API
Zoho DataPrep helps you transform columns based on example inputs using integration with ChatGPT API, a generative artificial intelligence developed by OpenAI. To enable this feature in your DataPrep organization, go to the OpenAI Integration tab in ...Derive dataset
The Derive dataset transform allows you to create a branch of your dataset from the last applied transform in your dataset. The new dataset will have the most recent state of your data with an empty ruleset. To derive dataset 1. Click the Transform ...Add formula
You can create new columns and customize them using the Formula column transform. Zoho DataPrep offers a variety of functions to suit your needs. Click here to know more about the functions. To create a formula column 1. Click on the Transform menu ...Target Matching
Target matching allows you to set a target and align the source dataset to match with your target before exporting data. You can attach a target dataset to match the column structure, formats, and the data types in the existing source dataset. This ...
New to Zoho LandingPage?
Zoho LandingPage Resources