# How to convert csv into a format accepted by rasa with python

**URL:** https://forum.rasa.com/t/how-to-convert-csv-into-a-format-accepted-by-rasa-with-python/46884
**Category:** Rasa Open Source
**Tags:** testing
**Created:** [August 14, 2021, 11:25am UTC](https://forum.rasa.com/t/how-to-convert-csv-into-a-format-accepted-by-rasa-with-python/46884 "2021-08-14T11:25:02Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![dan246](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/dan246/32/16550_2.png) [@dan246](https://forum.rasa.com/u/dan246)
#### Post date: [August 14, 2021, 11:25am UTC](https://forum.rasa.com/t/how-to-convert-csv-into-a-format-accepted-by-rasa-with-python/46884/1 "2021-08-14T11:25:02Z")

</div>

I found this and tried to modify the program to the format accepted by rasa.

But i don’t know what to do next

How to modify the program?

[csvtorasa-master.zip](https://forum.rasa.com/uploads/short-url/6nv5sG9BzXOSvUQPntQGHhmDMHS.zip) (3.6 KB)

---

<div class="post-metadata">

### Author: ![dan246](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/dan246/32/16550_2.png) [@dan246](https://forum.rasa.com/u/dan246)
#### Post date: [August 15, 2021, 11:38am UTC](https://forum.rasa.com/t/how-to-convert-csv-into-a-format-accepted-by-rasa-with-python/46884/2 "2021-08-15T11:38:43Z")

</div>

I solved thanks.

---

<div class="post-metadata">

### Author: ![nik202](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/nik202/32/16098_2.png) [@nik202](https://forum.rasa.com/u/nik202)
#### Post date: [August 15, 2021, 7:06pm UTC](https://forum.rasa.com/t/how-to-convert-csv-into-a-format-accepted-by-rasa-with-python/46884/3 "2021-08-15T19:06:21Z")

</div>

@dan246 great, do share some solution with us, whenever you got some time. Many thanks in advance.

---

<div class="post-metadata">

### Author: ![dan246](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/dan246/32/16550_2.png) [@dan246](https://forum.rasa.com/u/dan246)
#### Post date: [August 26, 2021, 11:23am UTC](https://forum.rasa.com/t/how-to-convert-csv-into-a-format-accepted-by-rasa-with-python/46884/4 "2021-08-26T11:23:54Z")

</div>

I split the Q&A set into questions and answers, and trained them in domain nlu and story respectively 😄

---

<div class="post-metadata">

### Author: ![nik202](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/nik202/32/16098_2.png) [@nik202](https://forum.rasa.com/u/nik202)
#### Post date: [August 26, 2021, 11:41am UTC](https://forum.rasa.com/t/how-to-convert-csv-into-a-format-accepted-by-rasa-with-python/46884/5 "2021-08-26T11:41:08Z")

</div>

@dan246 nice, and what python code did you used or manual?

---

<div class="post-metadata">

### Author: ![dan246](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/dan246/32/16550_2.png) [@dan246](https://forum.rasa.com/u/dan246)
#### Post date: [August 26, 2021, 12:15pm UTC](https://forum.rasa.com/t/how-to-convert-csv-into-a-format-accepted-by-rasa-with-python/46884/6 "2021-08-26T12:15:32Z")

</div>

[csvtorasa.py](https://forum.rasa.com/uploads/short-url/gCwjwIAjMIEsc1DNgQghmCVmzS6.py) (6.5 KB)

I modified this program

You can modify the question and answer set to this format ![擷取1](https://europe1.discourse-cdn.com/flex013/uploads/rasa/original/3X/0/7/075bd9b727498996720893225c780eb30ef43502.png)

 ![擷取](https://europe1.discourse-cdn.com/flex013/uploads/rasa/original/3X/3/e/3e6c92889532b91e17461b285c59941c56cd0bed.png)q1~q8 is intent (Free setting) The following are the corresponding questions and answers (I use google translate, sorry 😅)

---

<div class="post-metadata">

### Author: ![nik202](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/nik202/32/16098_2.png) [@nik202](https://forum.rasa.com/u/nik202)
#### Post date: [August 26, 2021, 12:35pm UTC](https://forum.rasa.com/t/how-to-convert-csv-into-a-format-accepted-by-rasa-with-python/46884/7 "2021-08-26T12:35:36Z")

</div>

@dan246 great, I will also try this method 😉 many thanks for sharing the solution.