The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Identifying trends and data from original excel sheet using exported wordlist
thecatalyst17
Member Posts: 1 
Learner III
Hi guys. First off, I want to apologize because I am very new to data mining and am just starting with working through this. I have watched some tutorials and have some basics down and have managed to derive a word list from an excel sheet. However, now I am a bit stuck. I am looking for a couple things.
1. Is there a way to filter out single words from a word list? I see you can set a max n-grams, but not a minimum. The only method I can see is to set your minimum number of tokens.
2. How do I compare a word list that I extracted from an excel file to the excel file I got it from? A little background. I pulled data from a ticketing system which has free-text fields as well as some set fields. Now that I have some key phrases, I would like to go back and compare them with location and date to see if I can identify trends.
Any help would be greatly appreciated.
1. Is there a way to filter out single words from a word list? I see you can set a max n-grams, but not a minimum. The only method I can see is to set your minimum number of tokens.
2. How do I compare a word list that I extracted from an excel file to the excel file I got it from? A little background. I pulled data from a ticketing system which has free-text fields as well as some set fields. Now that I have some key phrases, I would like to go back and compare them with location and date to see if I can identify trends.
Any help would be greatly appreciated.
Tagged:
0
