Icon

66daysofdata

1. Import Data:- artist.csv: contains data about music tracks andincludes a popularity metric for artists - artist-uris.csv: contains data about ~81k artists - tracks.csv: contains data about ~600k music tracksfor the years 1900–2021 #66daysofdata challenge 2. Descriptive Statistics: 3. Histograms: 4. Date Standardization: 5. Ungrouping and Aggregations: 6. Plots and Charts - Univariate Analysis 7. Plots and Charts - Multivariate Analysis 8. Plots and Charts -Time Plots 10. Covariance and Correlation 9. Plots and Charts - Control 11. Text Visualization read artists.csvread artist-uris.csvread tracks.csvoccurence counton quantilesoccurence counton fixed numbercreate histogramfor all attributessplit at ','remove 'spotify:artist:' from stringinner joininner joinremove [ ] '- nr. of tracks per artist- artist popularity- period of activitynr of tracks par artist & yearselect top 20with Refresh Buttons &Interactive Range Slidercalculatecovarianceflexible time perioddefine time period &nr. of artistsnormalizedatacalculatecovariance(optional)filter artistsplot data visualizationsColor by sentimentlabelread imdb.csvcleaning &standardizationtagging positive andnegative wordswith refresh buttons CSV Reader CSV Reader CSV Reader Correlations Rank Correlation Data Explorer Histogram Histogram Histograms DateStandardization Cell Splitter Ungroup String Manipulation Double To Int Joiner Joiner String Manipulation GroupBy GroupBy Column Rename Column Rename Top k Selector Compostive View Sampling Methods Scatter Plot Time Plots Linear Correlation GroupBy Sunburst Chart Heatmap ParallelCoordinates Plot Box Plots Time Plot View for the top10 most prolific artists Step 1 Normalizer GroupBy Step 2 Step 3 Color Manager CSV Reader Preprocessing word tagging Word Cloud ofselected text Word Cloudof dataset InteractiveRange Slider Data Plots Covariance Matrix Text to Document Bag Of WordsCreator 1. Import Data:- artist.csv: contains data about music tracks andincludes a popularity metric for artists - artist-uris.csv: contains data about ~81k artists - tracks.csv: contains data about ~600k music tracksfor the years 1900–2021 #66daysofdata challenge 2. Descriptive Statistics: 3. Histograms: 4. Date Standardization: 5. Ungrouping and Aggregations: 6. Plots and Charts - Univariate Analysis 7. Plots and Charts - Multivariate Analysis 8. Plots and Charts -Time Plots 10. Covariance and Correlation 9. Plots and Charts - Control 11. Text Visualization read artists.csvread artist-uris.csvread tracks.csvoccurence counton quantilesoccurence counton fixed numbercreate histogramfor all attributessplit at ','remove 'spotify:artist:' from stringinner joininner joinremove [ ] '- nr. of tracks per artist- artist popularity- period of activitynr of tracks par artist & yearselect top 20with Refresh Buttons &Interactive Range Slidercalculatecovarianceflexible time perioddefine time period &nr. of artistsnormalizedatacalculatecovariance(optional)filter artistsplot data visualizationsColor by sentimentlabelread imdb.csvcleaning &standardizationtagging positive andnegative wordswith refresh buttons CSV Reader CSV Reader CSV Reader Correlations Rank Correlation Data Explorer Histogram Histogram Histograms DateStandardization Cell Splitter Ungroup String Manipulation Double To Int Joiner Joiner String Manipulation GroupBy GroupBy Column Rename Column Rename Top k Selector Compostive View Sampling Methods Scatter Plot Time Plots Linear Correlation GroupBy Sunburst Chart Heatmap ParallelCoordinates Plot Box Plots Time Plot View for the top10 most prolific artists Step 1 Normalizer GroupBy Step 2 Step 3 Color Manager CSV Reader Preprocessing word tagging Word Cloud ofselected text Word Cloudof dataset InteractiveRange Slider Data Plots Covariance Matrix Text to Document Bag Of WordsCreator

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: elisabeth.richter
Created at: 2021-09-20
On NodePit since: 2021-10-13
Last update: 2024-04-26
Created with KNIME version: v4.4.2

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

Try NodePit Runner!