DataFrame and PowerQuery Tables

[dgorti]

I used PowerQuery quite a bit. What is awesome about PowerQuery is that it has a very rich API for Tables.
For example
Table.AddColumn(table, "name", Func) allows you to supply a function that generates values and add the column

Table.Pivot
Table.RenameColumns
Table.Distinct
Table.Group

allow you to manipulate tables in a very efficient and easy way.

I really would like to see a .NET version of PowerQuery or PowerQuery type API in DataFrame

[michaelgsharp]

@dakersnar for visibility.

I think this sounds like a good idea to add.