Another Wednesday, another Just KNIME It! challenge! This time we will explore KNIME’s network mining capabilities: did you know that you could also explore them the low-code way with our platform?
Diplomacy and international relations are inherently complex, with each country maintaining its own unique network of relationships with others. For non-Europeans planning a trip to Europe, obtaining a Visitor Visa may be required—and acceptance rates can vary significantly depending on the applicant’s nationality. Let’s explore which pairs of countries show higher acceptance or refusal rates for Visitor Visa applications across Europe.
Here is the challenge. Let’s use this thread to post our solutions to it, which should be uploaded to your public KNIME Hub spaces with tag JKISeason4-26 .
Need help with tags? To add tag JKISeason4-26 to your workflow, go to the description panel in KNIME Analytics Platform, click the pencil to edit it, and you will see the option for adding tags right there. Let us know if you have any problems!
Find herewith my Submission : Comparative Top and Bottom acceptance rates taken into count while dataset throws the requirement of understand the nomenclature of visa and its consideration. For the challenge requirement the selection of specific EU countries TOP and Bottom K non EU applyign countries has been taken for network comparative. JKISeason4-26 – KNIME Community Hub
Thanks @jproudfoot111 to have an example about Networks creation and config, that helped me. Especially about features etc.
For that challenge I proceed as follow:
Read the file
Handle missing values, especially for the Shengen State
Get unique pairs of countries - at least one is in Europe anyway as it is a list for Shengen countries
Using an expression to get the acceptance rate, the pair key (not mandatory) and to round the rates in % with 2 digits after comma
Get the list of countries and give the choice to the use to select one of the country
Get top 5 acceptance and refused country and assign colors and size (for the nodes of the network)
Create the network with and add features, such as node color, node size (based on acceptance) and main node (Shengen state) size.
Visualize
I noticed in the data that some visitors have visas issued from the country they want to visit. For example, Denmark has Uniform visas from Denmark. Should be issued electronically maybe? Or not sure how it works.
Anyway, I love this kind of visus as it is easy to understand.
And with these types of data, so many things can be represented and explored.
Another Wednesday, another Just KNIME It! challenge! This time we will explore KNIME’s network mining capabilities: did you know that you could also explore them the low-code way with our platform? 
Diplomacy and international relations are inherently complex, with each country maintaining its own unique network of relationships with others. For non-Europeans planning a trip to Europe, obtaining a Visitor Visa may be required—and acceptance rates can vary significantly depending on the applicant’s nationality. Let’s explore which pairs of countries show higher acceptance or refusal rates for Visitor Visa applications across Europe. 
Need help with tags? To add tag JKISeason4-26 to your workflow, go to the description panel in KNIME Analytics Platform, click the pencil to edit it, and you will see the option for adding tags right there. 
Let us know if you have any problems!
