Conditional Count

In this example we use VerbaGPT to get a conditional count of the target variable from the famous abalone dataset¹.

Video:

Coming soon…

User question: For the Abalone dataset, give me the count of Rings > 10.

VerbaGPT response:

Cost of query: $0.00

Count of Rings > 10: 1447

VerbaGPT answers the question correctly and gives us exactly what we asked for.

VerbaGPT is a powerful way to communicate with the data. A user can ask any kind of similar question in free-form natural language. Check out the full VerbaGPT read-out by click on below.

import pyodbc

query = "SELECT COUNT(*) FROM d_Abalone WHERE Rings > 10"
cursor.execute(query)
result = cursor.fetchone()[0]
print(f"Count of Rings > 10: {result}")

1. Abalone dataset