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
Access your files securely from anywhere
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:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
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?
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
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 ...OpenAI Integration with Zoho DataPrep
Open AI integration with Zoho DataPrep helps you enrich your data with advanced AI-based features using ChatGPT, a generative artificial intelligence developed by OpenAI. OpenAI in Zoho DataPrep works in a BYOK (Bring Your Own Key) model, in which ...Filter
The filter option allows you to filter data based on custom conditions applied over one or more columns. The filter can also be used without applying them as a rule. However, you can choose to apply them as a rule by either keeping or deleting the ...Window functions to add formula columns
A window function is used to perform calculations across a group of rows on a dataset. A set of rows is termed a window. You can use window functions to perform summations and calculations based on a rolling window of data, relative to the current ...Filter
The filter transform allows you to selectively filter data based on filter conditions applied over one or more columns. To apply advanced filters 1. You can choose an Right-click on a column and select the Filter option from the context menu. The ...
New to Zoho LandingPage?
Zoho LandingPage Resources