Great demo. While following along, I noticed the issue with your initial question about the NBA data was an issue with capitalization. Typing 'Lebron' was causing no results to be returned. The season info in the prompt looked like it was actually doing the right thing. For anyone following along, these additions to the prompt seemed to help: "If you are asked about something having to do with a year, treat years as starting in October and ending in June." "Look up player names in a case insensitive manner." Also, in that initial question, the query was summing distance because there is no concept of points in the database. Adding a points column helped with this: connection.query('alter table nba_short add column points int'); connection.query(''' UPDATE nba_short SET points = CASE WHEN made = true AND shot_type = '2-pointer' THEN 2 WHEN made = true AND shot_type = '3-pointer' THEN 3 ELSE 0 END; ''') And to the prompt: "The column name points with the data type INTEGER contains the following information: The number of points the shot was worth"
Great demo. While following along, I noticed the issue with your initial question about the NBA data was an issue with capitalization. Typing 'Lebron' was causing no results to be returned. The season info in the prompt looked like it was actually doing the right thing. For anyone following along, these additions to the prompt seemed to help:
"If you are asked about something having to do with a year, treat years as starting in October and ending in June."
"Look up player names in a case insensitive manner."
Also, in that initial question, the query was summing distance because there is no concept of points in the database. Adding a points column helped with this:
connection.query('alter table nba_short add column points int');
connection.query('''
UPDATE nba_short
SET points = CASE
WHEN made = true AND shot_type = '2-pointer' THEN 2
WHEN made = true AND shot_type = '3-pointer' THEN 3
ELSE 0
END;
''')
And to the prompt:
"The column name points with the data type INTEGER contains the following information: The number of points the shot was worth"
Yes good call I want to do more on this topic and still figuring out the best way to structure the prompts.
Cool demo, thanks a lot for sharing.
Thanks!
Can you please share the Jupyter notebook?
Link should be there I believe
Thanks nice demos!
Thanks!
How you learn GIS can any way of learning tools... Is it worth it??
Depends on your career goals but there are tons of great free resources to get started. I have other videos on that topic.
Thank you very much, impressive
Thanks!