Icon

Manipulate the Data and Visualize

Final Project - Brayden CumminsFor this final project I am going to be looking at a dataset of Data Science Salaries in 2023 and using a country codes CSV to get the countries full name. Manipulate the Data and Visualize At least 2 different Data Manipulation (join, concatenate, group by)At least 2 different visualizationsIn this workflow, I used the data cleaned from the last page to join the two datasets together andthen I use a bunch of group bys to group the data how I wanted it before I visualized it. I then used3 different charts to show the data and the differnet salaries. I HAVE NEVER HAD SUCH AN ISSUEI wanted to put each step on different pages, but for some reason the Inner Join justDOES NOT want to work on this page, and it works on the other page. So I am going to jointhem on the other page. Final Brayden CumminsMy plan for this final was to work around this data science salary dataset and try and showdiffernet visualizations based on that data that was in here. I added the countries dataset to getmore data for what countires were which.The first page is me cleaning and bringing in the two datasets.The second page was me Manipulating the data (Joining it and grouping before visulizations) andvisualizing the data with differnet charts.The last page I trained 2 models to predict the company size and salary. Overall this was a pretty interesting final, and I learned a lot with this class. I tried to explain what Iwas doing under each node to help with documentation and the outcomes. Thanks for anamazing semester! Reading cleaned salary dataReading cleaned country dataNode 4Node 5Node 6Salary per experience levelSalary by countrysalaries descendingChart showing all the average country salariessalaries per experience level averageSalary per job titletop 10 job titles by salarysalaries descendingtop 10 job by salarySalary per job titleonly full timeshowing full time employees salary per employment arrangementSalary per job titlesalaries average by company size,this one is just a test for the models CSV Reader CSV Reader Column Filter Column Filter Joiner GroupBy GroupBy Sorter Pie/Donut Chart Bar Chart GroupBy Top k Selector Sorter Bar Chart GroupBy Row Filter Scatter Plot Read and ManipulateJoined Data GroupBy Bar Chart Final Project - Brayden CumminsFor this final project I am going to be looking at a dataset of Data Science Salaries in 2023 and using a country codes CSV to get the countries full name. Manipulate the Data and Visualize At least 2 different Data Manipulation (join, concatenate, group by)At least 2 different visualizationsIn this workflow, I used the data cleaned from the last page to join the two datasets together andthen I use a bunch of group bys to group the data how I wanted it before I visualized it. I then used3 different charts to show the data and the differnet salaries. I HAVE NEVER HAD SUCH AN ISSUEI wanted to put each step on different pages, but for some reason the Inner Join justDOES NOT want to work on this page, and it works on the other page. So I am going to jointhem on the other page. Final Brayden CumminsMy plan for this final was to work around this data science salary dataset and try and showdiffernet visualizations based on that data that was in here. I added the countries dataset to getmore data for what countires were which.The first page is me cleaning and bringing in the two datasets.The second page was me Manipulating the data (Joining it and grouping before visulizations) andvisualizing the data with differnet charts.The last page I trained 2 models to predict the company size and salary. Overall this was a pretty interesting final, and I learned a lot with this class. I tried to explain what Iwas doing under each node to help with documentation and the outcomes. Thanks for anamazing semester! Reading cleaned salary dataReading cleaned country dataNode 4Node 5Node 6Salary per experience levelSalary by countrysalaries descendingChart showing all the average country salariessalaries per experience level averageSalary per job titletop 10 job titles by salarysalaries descendingtop 10 job by salarySalary per job titleonly full timeshowing full time employees salary per employment arrangementSalary per job titlesalaries average by company size,this one is just a test for the models CSV Reader CSV Reader Column Filter Column Filter Joiner GroupBy GroupBy Sorter Pie/Donut Chart Bar Chart GroupBy Top k Selector Sorter Bar Chart GroupBy Row Filter Scatter Plot Read and ManipulateJoined Data GroupBy Bar Chart

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Brayd
Created at: 2023-04-13
On NodePit since: 2023-04-14
Last update: 2024-11-21
Created with KNIME version: v4.7.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!