Icon

day27 - 66 Days of Data

Module 1Importing the tracks from theSpotify dataset Attention:large file with more than580k line items import tracks.csvevaluate basicdescriptive statisticsall our 13 histogramsstandardizationand clean up ofrelease_datesplitid_artistsby ',' as listungroupid_artists_SplitResultListclean upid_artists_SplitResultListjoin tracks.csvwith artist infoincludingjoining id's andpopularitygroup by artistfor # of songs,popularity, 1st and last release daterenameaggregation columnsheadingsgroup by yearand artistfor number of tracksrenamd aggregation collumnsheadingsFile Reader Data Explorer Dataset Histograms DateStandardization Cell Splitter Ungroup String Manipulation Joiner Import artist files GroupBy Column Rename GroupBy Column Rename Module 1Importing the tracks from theSpotify dataset Attention:large file with more than580k line items import tracks.csvevaluate basicdescriptive statisticsall our 13 histogramsstandardizationand clean up ofrelease_datesplitid_artistsby ',' as listungroupid_artists_SplitResultListclean upid_artists_SplitResultListjoin tracks.csvwith artist infoincludingjoining id's andpopularitygroup by artistfor # of songs,popularity, 1st and last release daterenameaggregation columnsheadingsgroup by yearand artistfor number of tracksrenamd aggregation collumnsheadingsFile Reader Data Explorer Dataset Histograms DateStandardization Cell Splitter Ungroup String Manipulation Joiner Import artist files GroupBy Column Rename GroupBy Column Rename

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: philk
Created at: 2022-09-11
On NodePit since: 2022-10-05
Last update: 2024-12-17
Created with KNIME version: v4.6.3

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

Try NodePit Runner!