Hello Everyone, I’m working on a chatbot project. I’m trying to fetch data from a csv file.My csv file consists of number of people and locations. Suppose the user asks for 10 people then the bot will answer about the location for 10 people. I have tried using this code. class ActionHelloWorld(Action): def name(self) -> Text: return "action_hello_world" def run(self, dispatcher: CollectingDispatcher, tracker: Tracker, domain: Dict[Text, Any]) -> List[Dict[Text, Any]]: dispatcher.utter_message(text="Welcome to JRB Interlocutor!") return [] This is not giving me the required result. Any help would be highly appreciated? Thanks

Hi @Rocky Welcome to Rasa Community! import csv class ActionHelloWorld(Action): def name(self) -> Text: return "action_hello_world" def run(self, dispatcher: CollectingDispatcher, tracker: Tracker, domain: Dict[Text, Any]) -> List[Dict[Text, Any]]: #Get Input from user limit = tracker.latest_message['text']. with open('location for your csv //Test.csv', 'r') as file: reader = list(csv.reader(file)) for row in reader[:limit]: print("In Row") dispatcher.utter_message(text=row[1]) return [] Sample CSV [Annotation 2020-05-27 153638] [image] Hope it helps

Okay Thank you so much Sir. One more thing I have sent you a connection request through LinkedIn My name is Mushahid Abbasi. Could you please add me into your connection. Regards

Hi Sir, Hope you are doing well. Sorry for the late reply. I was also trying by myself. Actually, whatever I’m giving as user input its returning each and every value of the location as response. Could you please help. The response image file is attached with this message. Please check and reply if possible. Thanks & Regards, [mass]

Hi @Rocky, [image] Rocky: returning each and every value of the location as response. It looks like you have only 6 cell of data in your .csv and you are asking for 10 cells, It will print everything. Try adding more data into your csv and see.

@MuraliChandran14…hello this is exactly what am also looking…my scenario is I have a csv file that contains drug name and its description…so when a user asks for a drug description by providing a drug name then I want the bot to take the drug name and finds the description from csv file then display it to the user…how can we query that??

Hey @faiza_conte I did a quick method, I hope you can build from this! import csv def excelcheck(): csvfile = open("Test.csv") reader = csv.reader(csvfile) # Get from user input drug name: drugno = "Liam" for row in reader: # Check for the user input if drugno in row[0]: print(row[0]+"\t"+row[1]); Sample Output: [1] [2]

@MuraliChandran14 thank you so much

@MuraliChandran14 Here I want to add the else part incase if it is not found in the csv file then to say * sorry not found*…after the if condition I put else and tries like this else: dispatcher.utter_message(template=“utter_notfound”) But it prints both the if and else part when I make a conversation with the bot…can you correct me …

Fetching data from csv file

Rasa Open Source

Rocky (Noor Abbasi) June 8, 2020, 4:29pm 21

Thanks

Topic		Replies	Views
Rasa chatbot using csv dataset Rasa Open Source	2	1410	October 15, 2021
Extract data from csv in RASA Rasa Open Source	16	3080	November 16, 2021
Can we make a bot response from a csv file in custom action? Rasa Open Source	7	792	November 22, 2020
RASA Custom actions , csv fetching and one hot encoding Rasa Open Source	0	216	February 23, 2024
Fetching data from csv [Deprecated] Feedback on Rasa X	7	966	July 7, 2022

Fetching data from csv file

Related topics