Search code examples
pythonexcelorange

Orange data mining - not loading excel columns as numeric


I am currently working on a project about satellites and visualizing particular data about satellites from each country. For the data I am using Microsoft Excel. When loading the data from it, everything is fine, except the fact that 4 of my columns (which contain only numeric data) are loaded only as meta strings. I checked each cell of the columns to see if they contain any particular strings..but I couldn't find anything. Below are the columns that are not taken as numeric. Any solutions ?

enter image description here


Solution

  • Use Excel to re-save your data as comma-separated values file (CSV). Ensure that numeric fields use period instead of comma as decimals separator (e.g. your Inclination and Period columns) as some programs might have trouble with that. Ensure there are no spaces in numeric values (your Launch mass column) and don't use thousands separators.