Analyze some Data

I am looking for help to analyse data according to CRISP-DM, data file is attached for analysis purposes and requriement of work is as follows: • Explore data – Examine central tendencies, distributions, ... – Report insights suggesting examination of particular data subsets (data selection) • Verify data quality (look up data quality dimensions) – Is the data complete? (missing values) – Is the data correct? (integrity constraints) – Is the data noisy or are there outliers? NB: this is an initial exploration – scouting the problem space. It helps you to understand what data is available and it helps to align your approach to the business objectives and the data available. At the same time – this phase can help to verify, whether the project is viable (feasibility) and refine the project scope, budget, resources etc. This phase is very different to a typical research prospective approach where you design the study in a way you always know what you are getting…). Data preparation Typically any data you get is not in the right format for analysis (it was collected for other purposes such as providing care or managing the practice) and needs to be pre-processed • Select data – Relevance to the data mining goals – Quality of data – Technical constraints, e.g. limits on data volume • Clean data – Raise data quality if possible – Selection of clean subsets – Insertion of defaults • Construct data – Derived attributes (e.g. age = NOW – DOB and possibly subsequent coding of age into buckets; duration of a process from timestamps etc.) • Integrate data – Merge data from different sources – Merge data within source (tuple merging) • Format data – Data must conform to requirements of initially selected mining tools (e.g. input data is different for Weka, and different to Disco). and steps of Modelling will follow. This project is not a real world project, it is only a sample project.