Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Wordle - help needed! #216

Open
edent opened this issue Sep 23, 2019 · 2 comments
Open

Wordle - help needed! #216

edent opened this issue Sep 23, 2019 · 2 comments

Comments

@edent
Copy link
Collaborator

edent commented Sep 23, 2019

We've been asked to create a Wordle or Word Cloud based on inscription data.

BUT! They would like to included common phrases. Like "in loving memory of", "always in our hearts", "together again".

When I've previously done word clouds, it has always been done on single words. Does anyone know I can create a "phrase" wordle? Or even just get stats out about common phrases?

@edent
Copy link
Collaborator Author

edent commented Sep 23, 2019

Selecting all the inscriptions from the DB is easy. SELECTION inscription WHERE 1 etc.

The text can then be dumped in a Word Cloud site. I can find lots of software which works on individual words, but none which will automatically find phrases.

@ssddanbrown
Copy link

Just came across this and thought it would be an interesting task to attempt to find phrases.
I built out some logic here: https://github.com/ssddanbrown/openbench-phrases
A view of the current output can be seen here.

It's pretty dumb, and not currently suitable for running server-side due to high resource usage, but may be helpful as a first step depending on desired usage. It looks to the live API for data (With caching on subsequent runs) but could be easily adapted to DB usage; the fetch of the inscription list is contained to one function.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants