Issue with data visualization, help?

zotenfriend's Avatar

zotenfriend

07 May, 2015 10:24 PM

Hello,
I've been trying to make a dataviz but can't find a way to make it work. I am relatively new to NodeBox. I used the Metallica example with some adjustments to make my dataviz. [I just need this to work to implement it in a more complex one.] While using the original sample file [found under File>Open Examples>Topics>Data Visualization>Zipmap] (with columns "Word" and "Album") everything's fine. Basically in the column "Album" the name of the albums are written in multiple rows; in the column "Word" there is a series of words associated once with the album but found multiple times in the column for there are same words in different albums.
Now passing on to the .csv file I am using, which is about documentaries and countries represented in the documentaries. I have two columns "Title" and "Country". In the column "Country" the name of the countries are written in multiple rows; in the column "Title" there is a series of documentaries associated once with the album but found multiple times in the column for there are same documentaries representing different countries. To me this structure looks very much the same to the sample one; I intended to structure it in the same way.
Now, when I change the csv file in the import csv node with my file, and change the two lookups from "Word" to "Title" and from "Album" to "Country", the resulting visualization is wrong. There are two issues, probably related to each other. First, the titles of the documentaries are _most of the times_ connected to the wrong country, thus it looks kind of random to me. Second, the way the colors are associated to each documentary seems odd: there is an evident repetition of color1, color2, color3 instead of having a more mixed order. Although the lines of the same color do end up in the same country.
Also, the simplified version of my file includes only three countries. I did this after noticing that with the big file (49 countries) I ended up having the same "color-order" issue, plus strangely enough each country had always 3-5 documentaries attached (even though some should have only one and some up to 34 connections). There is an obvious issue here but I cannot understand what I need to do to fix it.
I am attaching six files:
1a. modified version of the Metallica zipmap example
1b. csv for 1a (sample data)
2a. same file as 1b but with my data imported
2b. csv for 2a (my data)
3a. version of the Metallica zipmap example with my large file (the one with 49 countries) imported
3b. csv for 3a
(The original Metallica zipmap file is to be found inside the software so I'm not uploading it.)

I apologize for the long text but I tried to be as clear as possible.
I hope that someone will please help me understanding what is needed to be fixed. I'm available for further explanation if needed!
Thanks to whoever will reply, I'm a little desperate!

  1. Support Staff 1 Posted by lucasnijs on 11 May, 2015 08:50 AM

    lucasnijs's Avatar

    Hi,

    please look closely at the file I'm joining. The only difference with your file is the way I use your zipmap nodes. You connect the lookup after your zipmap with the distinct values. The way to use it is to connect your original lookup list, which is a long list, with the zipmap, which is a distinct list, so the values it encounters get connected with the colors, points, text, ... whatever you want.

    best regards,

    Lucas

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • 1a_modified_sample_zipmap.ndbx 6.91 KB
  • 1b_modified_sample_zipmap.csv 6.51 KB
  • 2a_sample_zipmap_my_data.ndbx 6.94 KB
  • 2b_sample_zipmap_my_data.csv 2.21 KB
  • 3a_zipmap_sample_large_data.ndbx 7.34 KB
  • 3b_zipmap_sample_large_data.csv 9.76 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

29 May, 2024 05:47 AM
29 May, 2024 05:15 AM
29 May, 2024 05:12 AM
28 May, 2024 07:37 PM
25 May, 2024 11:52 AM

 

24 May, 2024 07:39 AM
16 May, 2024 02:11 AM
14 May, 2024 01:29 AM
12 May, 2024 07:46 PM
05 May, 2024 04:38 PM
03 May, 2024 06:50 AM