Excel Data to Venn Diagram

I don't really know if I'm posting in the right place but I hope so.

I'm writing my bachelor degree, and I collected some data about fonts and language support.

At the moment, all my data is stored in an excel spreadsheet, in the form of:

  • Column: language support (e.g. Cyrillic, Cyrillic extended, Arabic, Vietnamese, Devanagari, etc)
  • Rows: names of the fonts that supports that language, up to 890

Note that some of there fonts, even though they occur only one per columns, they may appear several times in different columns (e.g. Noto Sans will appear in Latin, Latin Extended, Cyrillic, Cyrillic Extended, Simplified Chinese and many others; while others e.g. Padauk will only appear under Myanmar since that font may not support all Latin characters).

What I would like to do is to put these data in visual form, ideally via a Venn Diagram that displays how much each language is supported (area) and how many language are supported at the same time by a given font (opacity overlapping). I don't need to process this plotting step inside excel, I just need to get the data of how many fonts per intersection are there (e.g. latin and cyrillic gives 100, latin and arabic gives 80, latin and arabic and cyrillic gives 10 ... up to latin and cyrillic and arabic and devanagari and [n] gives 0).

I thought I could have parsed these data with javascript and json but I can't get to properly convert my excel file to json in a fashion that I can really use.

Any suggestion in warmly welcomed and I really thank you in advance

Topic excel visualization data-mining

Category Data Science


If you are famialiar with R, you can use this library: VennDiagram Without glimpse of your data its hard to help more, but with this library you can build simple Diagrams like this : enter image description here

Or something insane like this: enter image description here

You can find boht examples in the library code examples.

Hope this helps!

About

Geeks Mental is a community that publishes articles and tutorials about Web, Android, Data Science, new techniques and Linux security.