I then typed in KNIME which I use for data mining, data analysis and it came up with Orange as a free alternative. So I looked at some videos on it on YouTube
The point that drew my attention to the programme straight away was that it seems to have an SQL Database link (unfortunately I am having difficulty getting python pymssql to load which it needs) and also the quick visualisation with simple scatterplots and reviewing data quickly with datatables. The other nice thing is you can use Python Scripts.
I filtered data using Open Refine & Excel to simplify room data from a properties file, looking at room sizes for room types. The table is over 18000 rows long.
Item 1. Import CSV file
Item 2. Filter Rows for only displaying Floor Finishes (for getting floor area) and