I am developing a RASA chatbot, and I want to have a table (csv file) with fields like : book, year, points, author. How can I extract the data from that CSV file into my RASA chatbot? For example if I ask the chatbot: In what year Percy Jackson and The Lightning Thief was published? Answer: 2006 (answer provided from the CSV file) or Who’s the author of the Intelligent Investor book? Answer: Benjamin Graham (also from my CSV file) or How many points does [that book] have? Answer: 100 points (from CSV) How can I implement something like this ?

Hello @Razvan and welcome to the forum! Try implementing this using a form and a custom action. The form allows you to fill all the necessary slots (book, year, points, and author) inveractively with the user, and the custom action allow you to load and query the csv file using the filled slots. Custom actions are implemented using python, so you can use pandas to load the csv as a dataframe and query it. Here are some references: Forms: docs and video tutorial Custom actions: docs and video tutorial I hope this helps. Aciel

@Razvan Heya! Are you able to solve this?

How can I extract data from a CSV file into my RASA chatbot?

Rasa Open Source

mpriya-sv (mpriya) August 30, 2021, 2:46pm 5

Hi, Can you please help me with how you defined the custom action to read & extract data from the CSV?

Topic		Replies	Views
Extract data from csv in RASA Rasa Open Source	16	3035	November 16, 2021
Can we make a bot response from a csv file in custom action? Rasa Open Source	7	771	November 22, 2020
Handle csv file Rasa Open Source	0	616	April 8, 2019
How to read CSV file in rasa chatbot?. it is reading the file but not responding to any questions Feedback on Rasa Open Source	0	471	July 12, 2022
Custom Actions - Create Excel File with Data from Rasa Rasa Open Source	8	3494	July 22, 2021

How can I extract data from a CSV file into my RASA chatbot?

Related topics