Re:Ask HN: Ways to automatically make inferences from data?
by akudha on Sunday May 19, 2019 @05:12PM
(#19955549)
If I had a CSV, I can import it into a database and simply run queries, systematically, isn't it?
Re:Ask HN: Ways to automatically make inferences from data?
by JPLeRouzic on Monday May 20, 2019 @03:28PM
(#19964081)
You can alway do that, the question is (as the other comments told) "will your users get meaningful answers?"
You could simply use Excel (it has PCA) also to test your ideas. There are many resources on Internet.
My understanding is that it is possible to find the main components (items, regions, etc) in a dataset, for example with PCA [0]. However it will not name those components, but it might be quite easy to infer the name of each component. Once you know the data in one component, you can find their min/max. I guess there are several similar mathematical techniques to do the same job and there are also several user friendly Business Intelligence software.
[0] https://en.wikipedia.org/wiki/Principal_component_analysis