EasyCSV

Tech Stack

Inspiration

As developers, we often get bored by non-coding tasks like querying data for reports. These tedious tasks slow us down, especially when working with large CSV files. We wanted to simplify this process to make querying CSV files quick and easy, allowing us to focus more on coding and less on manual data retrieval.

What it does

EasyCSV lets users upload CSV files, enter a query, and receive the desired information instantly in a friendly, easy-to-use interface. It eliminates the need to manually search through data, making the whole process faster and more efficient.

How we built it

Our app is built using Python. We used Streamlit to develop the UI, which allows users to easily upload and drag-drop a CSV file. After uploading, users can enter their query in the form of a prompt. Once submitted, the prompt is sent to AnythingLLM, which generates an SQL query. This SQL query is then applied to the uploaded CSV file, and the app returns the result directly to the user, ensuring a seamless experience.

Challenges we ran into

One of the main challenges was working with Streamlit to implement the user interface. There was a learning curve to getting the UI, but the app came together smoothly once we overcame this. We also faced the challenge of the LLM being too resource-intensive, which made it difficult for some of our computers to run AnythingLLM effectively, limiting our ability to develop, debug, and implement features efficiently.

Accomplishments that we're proud of

We’re proud of creating a functional and intuitive tool that simplifies data retrieval. Seeing how efficiently our app processes queries and presents results in a user-friendly way is an accomplishment in itself. We are also proud of completing our idea and achieving what we expected.

What we learned

Throughout the project, we learned how to work with Streamlit to design user interfaces and explored the use of LLMs for processing data queries. This hackathon was a great opportunity to gain hands-on experience with these technologies.

What's next for EasyCSV

Next, we plan to enhance the app by adding a voice feature, allowing users to query data by speaking instead of typing, and introducing support for querying and joining multiple datasets in CSV format. This will allow users to perform complex operations like table joins across different datasets. These enhancements will make the tool even more powerful, accessible, and user-friendly, offering a seamless, hands-free experience for users handling large and complex data sets.