The Altair Community and the RapidMiner community is on read-only mode until further notice. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.
Options
Text mining in rapidminer: loop on seperate sentences in every row of SQL table
![ghasempoor_m](https://us.v-cdn.net/6030995/uploads/defaultavatar/nCCNNSPK1YM69.jpg)
![](https://s3.amazonaws.com/rapidminer.community/vanilla-rank-images/contributor-16x16.png )
I have a table in sql server that have 2 field: id,text. In the text field i have some sentences. my sentences are stemed and cleaned from stop words and so on.
1.I like to get 5 most frequent words in every row with the row id and the count of word's frequent.
for example in the first row with id=2303 i have a text such this:
this is a test for test and this is test for rapidminer text mining of sentence. second test for test book and sentence.
I need to have :
2303 test 5
2303 this 2
2303 sentence 2
2303 rapidminer 1
2303 second 1
2. I need to have 2words that are in a same sentence like:
1 this test
2 this this
3 this rapidminer
4 this text
.
.
.
10 text mining
but not having:
15 mining book
because they are not in a same sentence.
can you help me??
thanks
1.I like to get 5 most frequent words in every row with the row id and the count of word's frequent.
for example in the first row with id=2303 i have a text such this:
this is a test for test and this is test for rapidminer text mining of sentence. second test for test book and sentence.
I need to have :
2303 test 5
2303 this 2
2303 sentence 2
2303 rapidminer 1
2303 second 1
2. I need to have 2words that are in a same sentence like:
1 this test
2 this this
3 this rapidminer
4 this text
.
.
.
10 text mining
but not having:
15 mining book
because they are not in a same sentence.
can you help me??
thanks
![:) :)](https://community.rapidminer.com/resources/emoji/smile.png)
Tagged:
0