
We sometimes obtain phone numbers as customer information, but there are cases where country data is missing, and we want to determine country from the phone number.
However, when attempting to determine country from phone numbers, the following problems arise:
These challenges can hinder the utilization of customer data and lead to lost business opportunities.
“AI Functions,” newly introduced in Exploratory v14, solve these challenges and enable anyone to create functions using AI. Without any programming knowledge, you can easily create custom AI functions by simply writing instructions (prompts) in your own words.
This feature leverages state-of-the-art AI in the backend, allowing users to enjoy its powerful analytical capabilities without the hassle of complex configurations or model building.
Since the AI makes individual judgments for each data row and returns the results as a new column, it’s easy to determine country from phone numbers.
Let’s look at a specific example of how to determine country from phone number data.
In the following case, international phone numbers may contain delimiters such as parentheses, hyphens, and spaces, making it necessary to identify which part corresponds to the international phone number.
You can download the data to use from here.

Select “AI Function” from the column header menu.

This will display the AI Function dialog.

Execute with the following prompt:
Determine country (e.g. United States) from phone number information

When this prompt is executed, the AI analyzes the international code and format of the phone number and determines which country the phone number belongs to.

For example, a phone number like “+1-XXX-XXX-XXXX” will return “United States” as the country.
This allows you to understand the customer’s country of residence and proceed with analysis using country as a key dimension.
Exploratory v14’s “AI Functions” revolutionize data analysis, enabling anyone to perform advanced processing using AI.
Exploratory v14’s “AI Functions” is a feature that can elevate your data utilization to the next level. We encourage you to experience it for yourself.
Try Exploratory’s latest features, including AI Functions, with a 30-day free trial.