Camila_Garnica

datosph <- readxl::read_excel("/cloud/project/1_CALIDAD_HIDRICA/calidad.xlsx","Sheet1")

library(highcharter)

## Registered S3 method overwritten by 'quantmod':
##   method            from
##   as.zoo.data.frame zoo

## Highcharts (www.highcharts.com) is a Highsoft software product which is

## not free for commercial and Governmental use

library(dplyr)

## 
## Attaching package: 'dplyr'

## The following objects are masked from 'package:stats':
## 
##     filter, lag

## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union

hchart(datosph, 'heatmap', hcaes(x= Codigo, y= Parametro, value= Clasificacion))%>%
  hc_colorAxis(stops=color_stops(5, rev(RColorBrewer::brewer.pal(5, "PRGn")))) %>%  
  hc_tooltip(shared= TRUE, borderColor = "black", valueDecimals=2) %>%   
  hc_exporting(enabled= TRUE, filename = "Clasificacion en base a parametros de pH, DQO y Fe")