rpivotTable is a great package by Enzo Martoglio that allows you to explore a small dataset using an HTML drag&drop interface that looks like the pivot interface from Google Sheet or Excel.
as usual the instruction are quite straightforward
#install package rpivottable to be done onceinstall.packages("rpivottable")# And loadingLibrary(rpivottable)
Imagine you want to explore a data frame called MERGED ( see how to create a data frame using a CSV file )
Its just one line of code
it will open this HTML and drag and dropping KPIs from the left column
You can also use the top dropdown list to make it display a plot instead of a table.
To easily sort
Here is a demo HTNL file to try it yourself.