Dataset: [ETF] PSZ - Discogs Albums Published In SR And YU

About this Dataset

[ETF] PSZ - Discogs Albums Published In SR And YU

About

Dataset was created as part of a school project for the PSZ (Pronalaženje Skrivenog Znanja, en. Data Mining and Semantic Web) course, which is part of the Master studies at the School of Electrical Engineering, University of Belgrade.

The dataset was created by crawling the discogs website in order to gather data for albums that were published in Serbia or Yugoslavia, along with the artists that published them and the songs they contained. After gathering it, the raw data (html pages) was preprocessed and stored in the .csv files present in this dataset.

Content

The dataset consists of the following files:

Serbia_albums_list.csv - contains a list with URLs to all the albums from discogs published in Serbia.
Yugoslavia_albums_list.csv - contains a list with URLs to all the albums from discogs published in Yugoslavia.
albums.csv - contains the scraped data from the webpages located in the URLs.
artists.csv - contains the scraped data for the artists that published the albums.
songs.csv - contains the scraped data for the songs that were part of the albums.

Tables

Albums

@kaggle.nikolapeja6_etf_psz_discogs_albums_published_in_sr_and_yu.albums

4.76 MB
64667 rows
9 columns


CREATE TABLE albums (
  "url" VARCHAR,
  "format" VARCHAR,
  "genre" VARCHAR,
  "label" VARCHAR,
  "style" VARCHAR,
  "title" VARCHAR,
  "artist" VARCHAR,
  "versions" BIGINT,
  "y" BIGINT
);

Artists

@kaggle.nikolapeja6_etf_psz_discogs_albums_published_in_sr_and_yu.artists

3.75 MB
85975 rows
18 columns


CREATE TABLE artists (
  "url" VARCHAR,
  "name" VARCHAR,
  "sites" VARCHAR,
  "arranged" DOUBLE,
  "credits" DOUBLE,
  "lyrics" DOUBLE,
  "music" DOUBLE,
  "vocals" DOUBLE,
  "arranged_cnt" DOUBLE,
  "credits_cnt" DOUBLE,
  "lyrics_cnt" DOUBLE,
  "music_cnt" DOUBLE,
  "vocals_cnt" DOUBLE,
  "arranged_songs" DOUBLE,
  "credits_songs" DOUBLE,
  "lyrics_songs" DOUBLE,
  "music_songs" DOUBLE,
  "vocal_songs" DOUBLE
);

Songs

@kaggle.nikolapeja6_etf_psz_discogs_albums_published_in_sr_and_yu.songs

28.99 MB
520518 rows
9 columns


CREATE TABLE songs (
  "album" VARCHAR,
  "country" VARCHAR,
  "duration" BIGINT,
  "format" VARCHAR,
  "genre" VARCHAR,
  "name" VARCHAR,
  "style" VARCHAR,
  "url" VARCHAR,
  "y" BIGINT
);