Icon

Import and clean data

Read and Clean the Data At least 3 different Data Cleansing techniques (filters, missing values, replace values, etc.)For this part, I renamed a bunch of abbreviations to make the dataset look more clean. Then I gotrid of unneeded columns. I wrote the finished data to new CSVs so I could use them later on. 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. 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 salary dataReplace experience level columnx2x3x3FT to Full-Timeto string100 to remote0 to in-person50 to Hybridchanging company size to full namex2x3remove unneeded columnsnew CSV to use in next pagesReading country dataremove unneeded columnsRename Columnsnew CSV to use in next pagesInner Join on this page since KNIME wants to be a pain in the buttJoined Data to CSVCT to ContactFL to freelancePT to Part-Timelooking for missing numberssort by job title CSV Reader String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation Number To String String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation Column Filter CSV Writer CSV Reader Column Filter Column Rename CSV Writer Joiner CSV Writer String Manipulation String Manipulation String Manipulation Missing Value Sorter Read and Clean the Data At least 3 different Data Cleansing techniques (filters, missing values, replace values, etc.)For this part, I renamed a bunch of abbreviations to make the dataset look more clean. Then I gotrid of unneeded columns. I wrote the finished data to new CSVs so I could use them later on. 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. 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 salary dataReplace experience level columnx2x3x3FT to Full-Timeto string100 to remote0 to in-person50 to Hybridchanging company size to full namex2x3remove unneeded columnsnew CSV to use in next pagesReading country dataremove unneeded columnsRename Columnsnew CSV to use in next pagesInner Join on this page since KNIME wants to be a pain in the buttJoined Data to CSVCT to ContactFL to freelancePT to Part-Timelooking for missing numberssort by job titleCSV Reader String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation Number To String String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation Column Filter CSV Writer CSV Reader Column Filter Column Rename CSV Writer Joiner CSV Writer String Manipulation String Manipulation String Manipulation Missing Value Sorter

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-04-27
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!