Mozart's Operas by Kaggle | Other

About this Dataset

Mozart's Operas

All Known Operas by Wolfgang Amadeus Mozart

About this dataset

This dataset contains information on all of Wolfgang Amadeus Mozart's known operas. The operas are grouped by the period in which they were composed, and each opera is also labeled with its genre, number of acts, libretto, premiere date, and Köchel number. With this dataset, you can explore how Mozart's operas reflect the trends of 18th century Italian and German opera

How to use the dataset

This dataset can be used to study the operas of Wolfgang Amadeus Mozart. The data includes information on the period in which each opera was composed, the genre, the number of acts, the libretto, the premiere date, and the Köchel number. This dataset can be used to answer questions such as: What is the most popular type of opera composed by Mozart? What is the average length of a Mozart opera? What is the earliest and latest date an opera by Mozart premiered?

Research Ideas

Using the data on the operas' genres, one could cluster the operas in order to analyze similarities and differences between them.

One could use the data on the premiere locations to study whether certain geographical areas were more receptive to Mozart's music than others.

By predicting which composers wrote each opera's libretto, one could study whether there are any predictable patterns in Mozart's collaborations

Acknowledgements

The dataset was compiled by scraping of Wikipedia

This dataset is released under the CC0 1.0 Universal (CC0 1.0) Public Domain Dedication license

License

> License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
> No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: df_1.csv

Column name	Description
Title	The title of the opera. (String)
Libretto	The libretto of the opera. (String)
Libretto.1	The libretto of the opera, in Italian. (String)

File: df_4.csv

Column name	Description
0
1

File: df_3.csv

Column name	Description
vteWolfgang Amadeus Mozart	A list of all of Mozart's known operas. (List)
vteWolfgang Amadeus Mozart.1	The period in which each of Mozart's operas were composed. (String)

File: df_2.csv

Tables

Df 1

@kaggle.thedevastator_mozart_s_operas_a_comprehensive_analysis.df_1

11.57 KB
25 rows
10 columns


CREATE TABLE df_1 (
  "unnamed_0" DOUBLE,
  "period_g" VARCHAR,
  "title" VARCHAR,
  "genre_and_acts_17" VARCHAR,
  "libretto" VARCHAR,
  "libretto_1" VARCHAR,
  "voice_parts_18" VARCHAR,
  "premiere_19" VARCHAR,
  "premiere_19_1" VARCHAR,
  "k_chel_no_h" VARCHAR
);

Df 3

@kaggle.thedevastator_mozart_s_operas_a_comprehensive_analysis.df_3

4.75 KB
7 rows
3 columns


CREATE TABLE df_3 (
  "unnamed_0" BIGINT,
  "vtewolfgang_amadeus_mozart" VARCHAR,
  "vtewolfgang_amadeus_mozart_1" VARCHAR
);