# Explore data with rPivotTable

[rpivotTable](https://cran.r-project.org/web/packages/rpivotTable/vignettes/rpivotTableIntroduction.html) 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.

## Install and load rPivotTable <a href="#id-4-explore-crawled-data-with-rpivottable" id="id-4-explore-crawled-data-with-rpivottable"></a>

as usual the instruction are quite straightforward

```r
#install package rpivottable to be done once
install.packages("rpivottable")
# And loading 
Library(rpivottable)
```

Imagine you want to explore a data frame called MERGED ( see [how to create a data frame using a CSV file](https://www.rforseo.com/export-data/send-and-read-seo-data-to-excel#read-your-data-from-a-csv) )

**Its just one line of code**

```r
# launch 
rpivotTable(MERGED)
```

it will open an HTML page, and you'll be able to drag and drop KPIs from the left column

![This create a drag & drop pivot explorer](https://www.gokam.co.uk/wp-content/uploads/2020/08/LgfVsFu6NL.gif)

You can also use the top dropdown list to make it display a plot instead of a table.

![It’s also possible make some quick data viz](https://www.gokam.co.uk/wp-content/uploads/2020/08/UmtYC25Kdh.gif)

To easily sort

![](https://2998538899-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MSXey8kI3RllV-BSG8m%2F-MZvmI6Sj7xv-91Vx3lT%2F-MZvmSpYC2Ao60vHrGmU%2Fsort.gif?alt=media\&token=fcb83a8d-ecdb-472e-8931-52e3fe600a9f)

and filter

![](https://2998538899-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MSXey8kI3RllV-BSG8m%2F-MZvmI6Sj7xv-91Vx3lT%2F-MZvmaGdTHANQKXQ5rKP%2Ffilter.gif?alt=media\&token=a5261295-974a-4351-9f0a-7aebece4af81)

[Here is a demo HTNL file ](https://www.gokam.co.uk/rpivottable.html)to try it yourself.