Smart Inventory System for Expiry Date Tracking
Volume-7 | Issue-2

Classification of Remote Sensing Image Scenes Using Double Feature Extraction Hybrid Deep Learning Approach
Volume-3 | Issue-2

Light Weight CNN based Robust Image Watermarking Scheme for Security
Volume-3 | Issue-2

Survey: Unconventional Categories of Chatbots that make use of Machine Learning Techniques
Volume-5 | Issue-3

AI based Identification of Students Dress Code in Schools and Universities
Volume-6 | Issue-1

Principle of 6G Wireless Networks: Vision, Challenges and Applications
Volume-3 | Issue-4

PROGRESS AND PRECLUSION OF KNEE OSTEOARTHRITIS: A STUDY
Volume-3 | Issue-3

Getis-Ord (Gi*) based Farmer Suicide Hotspot Detection
Volume-4 | Issue-2

Ground-breaking Theory of Knowledge Representation Practices for Information Sharing in IT Organization
Volume-4 | Issue-3

Is Internet becoming a Major Contributor for Global warming - The Online Carbon Footprint
Volume-2 | Issue-4

AUTOMATION USING IOT IN GREENHOUSE ENVIRONMENT
Volume-1 | Issue-1

Principle of 6G Wireless Networks: Vision, Challenges and Applications
Volume-3 | Issue-4

Classification of Remote Sensing Image Scenes Using Double Feature Extraction Hybrid Deep Learning Approach
Volume-3 | Issue-2

Light Weight CNN based Robust Image Watermarking Scheme for Security
Volume-3 | Issue-2

VIRTUAL REALITY GAMING TECHNOLOGY FOR MENTAL STIMULATION AND THERAPY
Volume-1 | Issue-1

Design of Digital Image Watermarking Technique with Two Stage Vector Extraction in Transform Domain
Volume-3 | Issue-3

Analysis of Natural Language Processing in the FinTech Models of Mid-21st Century
Volume-4 | Issue-3

PROGRESS AND PRECLUSION OF KNEE OSTEOARTHRITIS: A STUDY
Volume-3 | Issue-3

Image Augmentation based on GAN deep learning approach with Textual Content Descriptors
Volume-3 | Issue-3

Comparative Analysis for Personality Prediction by Digital Footprints in Social Media
Volume-3 | Issue-2

Home / Archives / Volume-7 / Issue-1 / Article-1

Volume - 7 | Issue - 1 | march 2025

AI-Powered Data Interaction: A Natural Language Chatbot for CSV, Excel, and SQL Files Open Access
Dhanya K.R.  , Venkatesh S.  304
Pages: 1-11
Cite this article
K.R., Dhanya, and Venkatesh S.. "AI-Powered Data Interaction: A Natural Language Chatbot for CSV, Excel, and SQL Files." Journal of Information Technology and Digital World 7, no. 1 (2025): 1-11
Published
18 March, 2025
Abstract

Artificial Intelligence (AI) is revolutionizing data interaction by making it more efficient, accessible, and user-friendly. Traditionally, extracting insights from structured data stored in CSV files, Excel spreadsheets, and databases required manual processing through SQL queries and mathematical formulas. These conventional methods were not only time-consuming and prone to human error but also demanded significant technical expertise and also limiting accessibility for the non-technical users. To overcome these challenges, an AI-powered Data Agent has been developed to automate data interaction through natural language queries. By utilizing advanced Large Language Models (LLMs) such as Google Gemini 1.5 Pro, in combination with frameworks like Streamlit, LangChain, and Pandas, the system processes the structured data and retrieves relevant insights. Unlike traditional methods that return raw database records, this system generates responses in a conversational Q&A format, making complex data more comprehensible and actionable. This approach significantly reduces the manual effort involved in data extraction, minimizes the risk of errors, and enhances decision-making efficiency. Business analysts, researchers, students, and organizations can benefit from this solution. Moreover, the integration of Google Gemini provides a cost-effective alternative to expensive data analysis tools, enabling seamless automation and democratizing access to data-driven insights. By bridging the gap between raw data and meaningful conclusions, this AI-based solution enhances productivity and enables informed decision-making across various domains.

Keywords

Artificial Intelligence Data Interaction Natural Language Queries Large Language Models Google Gemini Streamlit LangChain Automation Conversational AI

×

Currently, subscription is the only source of revenue. The subscription resource covers the operating expenses such as web presence, online version, pre-press preparations, and staff wages.

To access the full PDF, please complete the payment process.

Subscription Details

Category Fee
Article Access Charge
15 USD
Open Access Fee Nil
Annual Subscription Fee
200 USD
After payment,
please send an email to irojournals.contact@gmail.com / journals@iroglobal.com requesting article access.
Subscription form: click here