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

Hi, Yes, the one I above sent will work, I understood that you have set entities and intents in your files. so I modified the actions.py according to it… The one you have attached right now. [image] dispatcher.utter_message(text=row[1]) is not inside the for loop that’s why it did not print the user input values you expected. You can use the above one or the fix this actions.py by adjusting the dispatcher.utter_message(text=row[1]) inside the for loop. and change the import to import _csv and _csv.reader. Sometimes csv imports cannot be recognized on the py libraries. If you have issues on csv.

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

Fetching data from csv file

Rasa Open Source

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

okay, sure

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

Fetching data from csv file

Related topics