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
#install package rpivottable ONLY the first timeinstall.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.