TL:DR - Do you know of good automated tools to explore a dataset?
Long version: I have a few different datasets to work with from most various areas of business. I wonder if there are good software/scrips that could automatically round up the following answers for me: Things I would be looking for:
- datatype of a column?
- dimension or measure?
- histogram or count of values in a column
- correlation between measures
- unique key auto-find
- import into a strongly typed data structure
Obviously I'm looking for something more than basic summary(cars). Something that goes through each column and spits out detailed analysis report