Translate English to Code

kinosal · October 8, 2021, 4:24pm

Translate English to SQL and Pandas for data analytics based on OpenAI’s GPT-3 Codex with this app:

https://share.streamlit.io/kinosal/codex-analytics/app.py

Happy to hear your feedback, questions or ideas how to develop this further (e.g. upload actual data and run queries).

akshanshkmr · October 8, 2021, 5:24pm

That’s a great app @kinosal

Thanks for sharing🎈
Akshansh

alexsunny123 · November 4, 2021, 11:09am

thanks for the awesome information.

alexsunny123 · September 17, 2022, 9:05am

thanks my issue has been fixed.

asehmi · September 17, 2022, 4:55pm

Nice. I specified two tables (traffic, sites) and asked it to get pageviews between 10 and 100, grouped by site. Columns were specified using 'table.column (type)' notation. The SQL generation worked. Pandas not so much.

wgong27514 · October 18, 2022, 8:58pm

@kinosal @asehmi @akshanshkmr @alexsunny123 I have built a streamlit app using GPT-3, using SQLite as backend to log all the interactions with GPT-3, The SQL flavor is targeted for SQLite database, so the generated query can be validated right away.

The github link is GitHub - wgong/gpt3sql: use GPT3 to generate SQL from text
Love to hear your feedback
Thanks