Build dictionary for Apache concept mapper

190 Views Asked by At

I have got an Excel file with two columns "Symbols" and "Synonyms" each having more than a million entries. I would like to convert excel data to a dictionary that is supported by Apache UIMA ConceptMapper. Is there any automated tool that can do this task?

I have attached a sample of excel data and format of Apache UIMA ConceptMapper.

https://i.stack.imgur.com/QC9BU.png contains excel sample

https://i.stack.imgur.com/PMItP.png contains ConceptMapper dictionary format

1

There are 1 best solutions below

0
On

I think you would need to convert the excel document, into a dictionary file. Where the excel cells are converted to keys.

I would suggest you look at Apache POI for the excel conversion to the dictionary XML file, and for context to what I am talking about, I would look at this tutorial.