QueryCraft is a free online AI based tool to generate SQL and Pandas code from natural text. This tool is specifically meant for data scientists and researchers to quickly get a code for a specific problem or solution. On numerous occasions, I have talked about AI based SQL generator but in this post, I will focus on generation Pandas code in Python using AI. Without any sign up and registration, you can generate the correct and precise code for free and use anywhere you like.
Pandas is one of the most popular libraries of Python for data processing, cleaning, and organizing. In Pandas, you basically work with datasets in different formats such as CSV, Excel, and SQL databases, and more. To do some operation on the datasets, you need to write some code and run it. But if you are stuck somewhere and do not want to go through the lengthy documentation, then you can take help of QueryCraft. Just tell it what you want to do and it will give you the corresponding code.
How to Generate SQL, Pandas Code from Natural Text using AI?
You can access QueryCraft on its main website. The interface is simple and as I mentioned earlier that you don’t need to sign up, so you can just get started with it right away. There are two tabs on the site to generate SQL and Pandas code respectively. But since here we are only taking about Pandas code generation, so just go to its tab.
So, specify in plain text what you want to do. Include as many details as you want, and then click on the Generate button. You can literally enter anything here and it will process that.
Once it has processed what you have asked it, it will generate the final output accordingly. For example, you can see the screenshot below. Here I asked it to generate the code for reading an Excel file and print top 5 maximum values for the salary column.
Remove input prompt and then give it some other problem and it will be able to fix that all as well. Keep using this tool in way and generate short and worming Pandas code that you can use in your apps or projects. Apart from Pandas, you can generate the SQL statements from text as well, the process is the same.
Final thoughts:
If you are looking for a free tool that can generate accurate Pandas code that you are at the right place. Even though the website needs a bit of polishing and testing to fix broken UI, the core functionality of the tool is working. Personally, I see it as a good helper tool for Python and SQL developers, so go give it a try and let me know what you think.
