Instructors - Docenti:

• Dino Pedreschi
  • KDD Laboratory, Università di Pisa ed ISTI - CNR, Pisa
  • http://www-kdd.isti.cnr.it
  • dino [dot] pedreschi [at] unipi [dot] it

Instructors:

• Riccardo Guidotti
  • KDDLab, Università di Pisa, Pisa
  • https://kdd.isti.cnr.it/people/guidotti-riccardo
  • riccardo [dot] guidotti [at] di [dot] unipi [dot] it

Instructors:

• Dino Pedreschi, Anna Monreale
  • KDD Laboratory, Università di Pisa, Pisa
  • http://www-kdd.isti.cnr.it
  • dino [dot] pedreschi [at] unipi [dot] it
  • anna [dot] monreale [at] unipi [dot] it

• [04.07.2020] Third DM2 exams session from 17/07 to 29/07. Please register ( here) before 12/07 and select your slot at the agenda link that will be available from 12/07. We remind to submit the project one week before the exam. It is mandatory to submit the project before 15/07. Doodle will not be used for this session. Every slot can accept up to 4 students (in this case you have to register individually). Slots spans from 17/07 to 29/07 included.
• [21.06.2020] In order to help us in correcting the projects and organizing oral exams, everyone has to submit the project with the occupancy detection dataset before midnight of the 15th of July 2020. Another dataset for will be published after this deadline and submission after the 15th of July must use the new dataset. Remains valid the rule that the project must be submitted at least ONE WEEK before the oral exam.
• [12.06.2020] New Doodle is available for booking the DM2 exam here.
• [22.05.2020] In the section of this page: “Exam DM part I (DMF)” you can find the new rules for the exams of DM(9CU) of computer science and DM1(6CFU) of Data Science & BI and Digital Humanities.
• [14.04.2020] CAT4 for auto evaluation is available here (it will not be considered for final evaluation). Report your final mark here. It is recommended to do it before 18th May 2020. Solutions are available here.
• [06.05.2020] Submission Draft 2 deadline 25/05/2020. We expect to find Task 2 and 3 completed, and if you started to do something of Task 4 and 5 is well accepted. We do not care about forms and shape what matters now is the content and proof that you continued making analysis on the data as required.
• [01.05.2020] Keras Accuracy here.
• [30.04.2020] DM2 Exam Rules here.
• [14.04.2020] CAT3 for auto evaluation is available here (it will not be considered for final evaluation). Report your final mark here. It is recommended to do it before 9th Aprile 2020. Solutions are available here.
• [08.04.2020] Submission Draft 1 deadline 16/04/2020. We expect to find Task 1 completed, Task 2 at a good stage (let say 60/70%), and if you started to do something of Task 3 is well accepted. We do not care about forms and shape what matters now is the content and proof that you started making analysis on the data as required.
• [06.04.2020] Reading material available here.
• [18.03.2020] CAT2 for auto evaluation is available here (it will not be considered for final evaluation). Report your final mark here. It is recommended to do it before Sunday 22nd Marc 2020. Solutions available here.
• [05.03.2020] From Monday 9 we will have lectures online using Microsoft Teams. You can find here - ita, here - eng instructions to join the course. The code for joining the 420AA DATA MINING Team is rc6b0ko. The Microsoft Team will be used for replacing frontal lectures and office time. The material will be uploaded as usual on the DidaWiki web page.
• [04.03.2020] Frontal lectures and office times are suspended.
• [02.03.2020] CAT1 Results: CAT1
• [24.02.2020] Project Dataset Change: Occupancy Detection
• [17.01.2020] Declare Project Groups (max 3 people) by next Monday 24° February adding your information at link
• [12.01.2020] Project evaluation and Proposed final Mark Results
• [28.12.2019] Results of Midterm-Test December 2019: Results. Students that did not pass the midterm test can do the written exam during the winter sessions. When we will have the project mark we will compute the average between the written and project mark
• [06.12.2019] Exercises on Clustering: ex._clustering.pdf
• [04.11.2019] The lecture of Monday, November 4, terminates at 15:00 to allow for the participation to the Informatica 50 event “Ora che comanda lui, quando tutto è basato sul software” (in Italian), h 15:30 at Aula Magna Storica del Palazzo della Sapienza, UNIPI. Full information: sito web evento
• [03.10.2019] Please, fill the spreadsheet with name of the group (Group1, Group2, …), the list of students composing the group.
• [26.09.2019] Global Climate Strike: teachers of DM course tomorrow Friday September 27 will join the Global Climate strike, so tomorrow the lecture is suppressed.
• [18.09.2019] Event: “Privacy: limite o opportunità? Gli esempi delle Nuove Tecnologie e dei Dati Sanitari” Information here.

… a new kind of professional has emerged, the data scientist, who combines the skills of software programmer, statistician and storyteller/artist to extract the nuggets of gold hidden under mountains of data. Hal Varian, Google’s chief economist, predicts that the job of statistician will become the “sexiest” around. Data, he explains, are widely available; what is scarce is the ability to extract wisdom from them.

Data, data everywhere. The Economist, Special Report on Big Data, Feb. 2010.

La grande disponibilità di dati provenienti da database relazionali, dal web o da altre sorgenti motiva lo studio di tecniche di analisi dei dati che permettano una migliore comprensione ed un più facile utilizzo dei risultati nei processi decisionali. L'obiettivo del corso è quello di fornire un'introduzione ai concetti di base del processo di estrazione di conoscenza, alle principali tecniche di data mining ed ai relativi algoritmi. Particolare enfasi è dedicata agli aspetti metodologici presentati mediante alcune classi di applicazioni paradigmatiche quali il Basket Market Analysis, la segmentazione di mercato, il rilevamento di frodi. Infine il corso introduce gli aspetti di privacy ed etici inerenti all’utilizzo di tecniche inferenza sui dati e dei quali l’analista deve essere a conoscenza. Il corso consiste delle seguenti parti:

1. i concetti di base del processo di estrazione della conoscenza: studio e preparazione dei dati, forme dei dati, misure e similarità dei dati;
2. le principali tecniche di datamining (regole associative, classificazione e clustering). Di queste tecniche si studieranno gli aspetti formali e implementativi;
3. alcuni casi di studio nell’ambito del marketing e del supporto alla gestione clienti, del rilevamento di frodi e di studi epidemiologici.
4. l’ultima parte del corso ha l’obiettivo di introdurre gli aspetti di privacy ed etici inerenti all’utilizzo di tecniche inferenza sui dati e dei quali l’analista deve essere a conoscenza

• Data, data everywhere. The Economist, Feb. 2010 download
• Data scientist: The hot new gig in tech, CNN & Fortune, Sept. 2011 link
• Welcome to the yotta world. The Economist, Sept. 2011 download
• Data Scientist: The Sexiest Job of the 21st Century. Harvard Business Review, Sept 2012 link
• Il futuro è già scritto in Big Data. Il SOle 24 Ore, Sept 2012 link
• Special issue of Crossroads - The ACM Magazine for Students - on Big Data Analytics download
• Peter Sondergaard, Gartner, Says Big Data Creates Big Jobs. Oct 22, 2012: YouTube video

• Towards Effective Decision-Making Through Data Visualization: Six World-Class Enterprises Show The Way. White paper at FusionCharts.com. download

Classes - Lezioni

Office hours - Ricevimento:

• Prof. Pedreschi: Lunedì/Monday h 14:00 - 17:00, Dipartimento di Informatica
• Prof. Monreale: Lunedì/Monday h 09:00 - 11:00, Dipartimento di Informatica

Classes - Lezioni

Office hours - Ricevimento:

• Room 268 Dept. of Computer Science
• Thursday: 15-17, Room: 286
• Appointment by email

• Pang-Ning Tan, Michael Steinbach, Vipin Kumar. Introduction to Data Mining. Addison Wesley, ISBN 0-321-32136-7, 2006
  • http://www-users.cs.umn.edu/~kumar/dmbook/index.php
  • I capitoli 4, 6, 8 sono disponibili sul sito del publisher. – Chapters 4,6 and 8 are also available at the publisher's Web site.
• Berthold, M.R., Borgelt, C., Höppner, F., Klawonn, F. GUIDE TO INTELLIGENT DATA ANALYSIS. Springer Verlag, 1st Edition., 2010. ISBN 978-1-84882-259-7
• Laura Igual et al. Introduction to Data Science: A Python Approach to Concepts, Techniques and Applications. 1st ed. 2017 Edition.
• Jake VanderPlas. Python Data Science Handbook: Essential Tools for Working with Data. 1st Edition.

• The slides used in the course will be inserted in the calendar after each class. Most of them are part of the the slides provided by the textbook's authors Slides per "Introduction to Data Mining".

* Exercises on Clustering: ex._clustering.pdf

* Some text of past exams on DM1 (6CFU):

• 2017-1-19.pdf, 2017-9-6.pdf, 2016-05-30-dm1-seconda.pdf

* Some solutions of past exams containing exercises on KNN and Naive Bayes classifiers DM1 (9CFU):

• dm2_exam.2017.06.13_solutions.pdf, dm2_exam.2017.07.04_solutions.pdf, dm2_mid-term_exam.2017.06.06_solutions.pdf

* Some exercises (partially with solutions) on sequential patterns and time series can be found in the following texts of exams from the last years:

• dm2_exam.2015.04.13.results.pdf, dm2_exam.2016.04.4_sol.pdf, dm2_exam.2016.04.5_sol.pdf, dm2_exam.2016.06.20_sol.pdf, dm2_exam.2016.07.08_sol.pdf

• Some very old exercises (part of them with solutions) are available here, most of them in Italian, not all of them on topics covered in this year program:
  • Verifica 2006, Verifica 2005 (con soluzioni), Verifica 2004
  • Verifica 5 giugno 2007, Verifica 26 giugno 2007, Verifica 24 luglio 2007 (e Soluzioni)
  • Verifica 3 aprile 2008 (e Soluzioni), Verifica 18 luglio 2008 - parte 1, Verifica 18 luglio 2008 - parte 2
  • Exam with solution 2010-06-01 Exam with solution 2010-06-22 Exam with solution 2010-09-09 Exam with solution 2010-07-13

• KNIME The Konstanz Information Miner. Download page
• Python - Anaconda (3.7 version!!!): Anaconda is the leading open data science platform powered by Python. Download page (the following libraries are already included)
• Scikit-learn: python library with tools for data mining and data analysis Documentation page
• Pandas: pandas is an open source, BSD-licensed library providing high-performance, easy-to-use data structures and data analysis tools for the Python programming language. Documentation page
• WEKA Data Mining Software in JAVA. University of Waikato, New Zealand Download page

RULES FOR EXAMS for COMPUTER SCIENCE - 9CFU: EXAM RULES Summer Session - 9 CFU

RULES FOR EXAMS for DATA SCIENCE & BI and DIGITAL HUMANITIES - DM1(6CFU): EXAM RULES Summer Session - DM1(6CFU)

The exam is composed of two parts:

• An oral exam , that includes: (1) discussing the project report; (2) discussing topics presented during the classes, including the theory of the practical parts. It is optional for students passing the written part by ONLY the mid-term test.

• A project consists in exercises that require the use of data mining tools for analysis of data. Exercises include: data understanding, clustering analysis, frequent pattern mining, and classification. The project has to be performed by min 3, max 4 people. It has to be performed by using Knime, Python or a combination of them. The results of the different tasks must reported in a unique paper. The total length of this paper must be max 20 pages of text including figures. The paper must emailed to datamining [dot] unipi [at] gmail [dot] com. Please, use “[DM 2019-2020] Project” in the subject.

Tasks of the project:

1. Data Understanding: Explore the dataset with the analytical tools studied and write a concise “data understanding” report describing data semantics, assessing data quality, the distribution of the variables and the pairwise correlations. (see Guidelines for details)
2. Clustering analysis: Explore the dataset using various clustering techniques. Carefully describe your's decisions for each algorithm and which are the advantages provided by the different approaches. (see Guidelines for details)
3. Classification: Explore the dataset using classification trees. Use them to predict the target variable. (see Guidelines for details)
4. Association Rules: Explore the dataset using frequent pattern mining and association rules extraction. Then use them to predict a variable either for replacing missing values or to predict target variable. (see Guidelines for details)
5. ADDITIONAL TASK for DM9 CFU (OPTIONAL): Students for computer science (DM9CFU) can decide to deliver an additional task for the project selected among the following for additional bonus of 3 points:
   1. Classification: Compare results of classification by decision tree with KNN, Naive Bayesian, analysing also the runtime at training and test phase.
   2. Clustering: Is it possible to apply EM clustering? Does the quality of the clustering result improve?

• Project 1
  1. Dataset: Carvana Data
  2. Assigned: 07/10/2019
  3. Deadline: 05/01/2020 08/01/2020
  4. Link: https://www.kaggle.com/t/712fc5e264e748afb0e0616f56f3c102

• Project 2
  1. Dataset: Bank Loan Status
  2. Assigned: 09/01/2020
  3. Deadline: 4 days before the oral exam
  4. This dataset will be used for all tasks. For the classification task, you have to split the dataset into train and test set and the class to predict is the variable “Loan Status”.
  5. This dataset will be valid for all the exam sessions until September.
  6. Download the dataset Bank Loan Status dataset (in CSV format, zipped)

Guidelines for the project are here.

The exam is composed of three parts:

• A written exam, with exercises and questions about methods and algorithms presented during the classes. It can be substituted with ongoing tests held during the course.

• A project, that consists in employing the methods and algorithms presented during the classes for solving exercises on a given dataset. The project has to be performed by max 3 people. It has to be performed by using Knime, Python, other software or a combination of them. The results of the different tasks must be reported in a unique paper. The total length of this paper must be max 30 pages (suggested 25) of text including figures + 1 cover page (minimum font 11, minimum interline 1). The project must be delivered at least 2 days before the oral exam.

• An oral exam, that includes: (1) discussing topics presented during the classes, including the theory of the parts already covered by the written exam; (2) discussing the project report with a group presentation.

• Dataset: the data is about Occupancy Detection and can be downloaded here: dataset. * Submission Draft 1: 16/04/2020 23:59 Italian Time * Submission Draft 2: 25/05/2020 23:59 Italian Time * Final Submission: one week before the oral exam.

• Dataset 2: the data is about Air Quality and can be downloaded here: dataset. The dataset has not a target variable for classification. Thus, define a target variable, for instance “is weekend” and set “true” for weekend days, and “false” for the others.
• Final Submission: one week before the oral exam or within 30/11/2020.

• Project Task 1 - Basic Classifiers and Evaluation
  1. Prepare the dataset in order to build several basic classifiers able to predict room occupancy from the available variables. You are welcome in creating new variables.
  2. Solve the classification task with k-NN (testing values of k), Naive Bayes, Logistic Regression, Decision Tree using cross-validation and/or random/grid search for parameter estimation.
  3. Evaluate each classifier using Accuracy, Precision, Recall, F1, ROC, AUC and Lift Chart.
  4. Try to reduce the dimensionality of the dataset using the methods studied (or new ones). Test PCA and try to solve the classification task in two dimensions. Plot the dataset in the two new dimensions and observe the decision boundary and the one of the trained algorithms.
  5. Analyze the value distribution of the class to predict and turn the dataset into an imbalanced version reaching a strong majority-minority distribution (e.g. 96%-4%). Then solve again the classification task adopting the various techniques studied (or new ones).
  6. Select two continuous attributes, define a regression problem and try to solve it using different techniques reporting various evaluation measures. Plot the two-dimensional dataset. Then generalize to multiple linear regression and observe how the performance varies.
  7. Draw your conclusions about the basic classifiers and techniques adopted in this analysis.

• Project Task 2 - Advanced Classifiers and Evaluation
  1. Using the dataset for classification prepared for Task 1 build several advanced classifiers able to predict room occupancy from the available variables. In particular, you are required to use SVM (linear and non-linear), NN (Single and Multilayer Perceptron), DNN (design at least two different architectures), Ensemble Classifier (RandomForest, AdaBoost and a Bagging technique in which you can select a base classifier of your choice with a justification).
  2. Evaluate each classifier using Accuracy, Precision, Recall, F1, ROC, etc; Draw your conclusion about the classifiers.
  3. Highlight in the report different aspects typical of each classifier. For instance for SVM: is a linear model the best way to shape the decision boundary? Or for NN: what are the parameter sets or the convergence criteria suggesting you are avoiding overfitting? How many iterations/base classifiers are needed to allow a good estimation using an ensemble method? Which is the feature importance for the Random Forest?
  4. You are NOT required to experiment also in the imbalanced case but if you do it is not considered a mistake.

• Project Task 3 - Time Series Analysis and Forecasting/Classification
  1. Exploit the temporal information of the dataset preparing it for a univariate framework of analysis, i.e. select a feature and use it as your time series. You are welcome in using more than one reliable temporal split to have more time series of the same feature. You are welcome in creating more than a dataset using more than a feature and report the result on the feature you prefer or more than one. Analyze such datasets for finding motifs and/or anomalies and shaplets. Visualize and discuss them and their relationship with the class of the time series.
  2. On the dataset(s) created, compute clustering based on Euclidean/Manhattan and DTW distances and compare the results. To perform the clustering you can choose among different similarity methods, i.e., shape-based, feature-based, approximation-based, compression-based, etc.. Finally, analyze the clusters and the clustering and highlight similarities and differences.
  3. Apply forecasting methods on the dataset(s) created. Make sure to preprocess adequately the time series according to the method used (e.g., an exponential smoothing or an autoregression), indeed checking stationarity and reducing trends and seasonality or with the help of a statistically significant test;
  4. Solve the classification task on the univariate dataset created using different approaches, i.e., traditional classification, shapelet-based, feature-based, etc.
  5. Solve the classification task considering the whole dataset as a multivariate dataset. Develop the classification process you prefer (e.g. exploiting shapelets, traditional classifiers, CNN, or RNN) to maximize accuracy and F1-score.

• Project Task 4 - Sequential Pattern Mining
  1. Convert the time series into a discrete format (e.g., SAX) in order to prepare the data for the task.
  2. Using different values of support, extract the most frequent sequential patterns (of at least length 3/4), then discuss the most interesting sequences.

• Project Task 5 - Outlier Detection and Explainability
  1. From the original dataset (i.e. not the time series built on Task 3 or sequences of Task 4, nor the preprocessed dataset used in Tasks 1 and 2), identify the top 1% outliers.
  2. Adopt at least three different methods belonging to different families (i.e. statistical/depth-based, distance-based, density-based, angle-based, …) and compare the results.
  3. (Optional) Try to use an explanation method to illustrate the reasons for the classification in one of the steps of the previous Tasks (if you want to try LORE please ask the code to [email protected]).

• Data Mining A.A. 2018/19
• Data Mining A.A. 2017/18
• Data Mining A.A. 2016/17
• Data Mining A.A. 2015/16
• Data Mining A.A. 2014/15
• Data Mining A.A. 2013/14
• Data Mining A.A. 2012/13
• Data Mining A.A. 2011/12
• Data Mining A.A. 2010/11
• Data Mining A.A. 2009/10
• Data Mining A.A. 2008/09
• Data Mining A.A. 2007/08
• Data Mining A.A. 2006/07
• PhD Workshop 2011
• Analisi delle Reti Sociali
• Social and Information Networks
• ICT for BI & CRM - Part III: Data Mining
• Data Mining for Customer Relationship Management 2015
• Data Mining for Customer Relationship Management 2016
• Data Mining for Customer Relationship Management 2017
• Data Mining for Customer Relationship Management 2018
• Data Mining and Machine Learning -- Master MAINS 2019
• Instructions for camera ready and copyright transfer
• Storie dell'Altro Mondo
• Master Industry 4.0