R with the tidyverse package is amazing once you get over the learning curve. It’s so much easier to simply type a few lines of code then to fiddle with the Excel GUI, plus the ability to customize the plot is much, much better in R.

Yes making a simple plot in Excel is relatively easy, but try making something evening remotely complex and it’s terrible. A box plot is a great example of this, 2 lines of plotting code in R for a basic plot but an absolute nightmare to create in Excel.

As stated in the article, this isn’t a big problem for communities with centralized water treatment systems, rather for individual homes drinking well water which is contaminated by agriculture.

In a municipal treatment plant you have a few options for removing nitrates including reverse osmosis (membrane filters with very small pores, allowing them to reject very small molecules), ion exchange (swap nitrate with another, less harmful ion), or biological treatment (use microorganisms to turn nitrate into nitrogen gas).

In your home, reverse osmosis is really the only feasible option, which can be expensive to install and costly to maintain. Ideally, some sort of tax on fertilizer would be used to pay for these in house treatments, but that would increase the cost of food.

I’m a water engineer with a PhD, so not a tech nerd but definitely a nerd :) I came here mostly because I find the Reddit app annoying and the app I was using came here.

Water is disinfected with either chlorine, chloramine (ammonia + chlorine), ozone, or UV light. In North America chlorine is almost universal because it provides disinfection residual, which keeps water safe while it is travelling from the treatment plant to the consumer. Fluoride is added solely as a supplement to improve dental health.

Some facts I posted in another thread about this topic;

Background info.

• PFAS is a class of chemical substances with varying properties, but in general act as surfactants.

• PFAS are considered carcinogenic and impact birth weight.

• PFAS contain a carbon-fluorine bond, which is a very strong bond that does not naturally degrade.

• Some PFAS will naturally decrease concentration over time, but only to be transformed into other compounds that will not (often PFOS).

Regulation.

• The US EPA has taken the approach of regulating a select few PFAS, generally based on their known toxicity. PFOA and PFOS will essentially be limited to a concentration of zero.

• The US EPA has been working on this for years. Mr. Biden did not snap his fingers and make a regulation. These things move much slower than that, and the industry generally feels that this process moved too quickly because there is limited understanding of how much PFAS exists in drinking water.

• Health Canada has proposed a guideline which limits PFAS to 30 ng/L (ppt) as a total sum of all compounds that can be accurately measured. Currently their guidelines limit PFOA to 200 ng/L and PFOS to 600 ng/L. Health Canada does not regulate your water provider through, that is up to your provincial/territorial government, which may have different guidelines than this.

PFAS in the environment.

• PFAS is ubiquitous in the environment due to its travel through the water cycle. It exists in Antarctic ice and on top of Mount Everest.

• Usually the largest sources of PFAS in drinking water are firefighting training areas that used PFAS containing foams (airports and military bases), landfills, certain manufacturers (metal plating, paper, semiconductors), and municipal wastewater. There are many more sources than this though.

• Landfills and municipal wastewater tend to be the highest mass loading of PFAS because of the ubiquity of PFAS in consumer products.

Treatment.

• PFAS can be destroyed using electrochemical and thermal methods, but these are not feasible for drinking water treatment.

• The current approach for drinking water treatment is adsorption to either granular activated carbon (GAC) or ion exchange resin.

• Treating PFAS at the source is always the goal instead of treating it at a water treatment plant.

Feel free to ask questions, I will do my best to answer them!

Some facts:

Background info.

• PFAS is a class of chemical substances with varying properties, but in general act as surfactants.

• PFAS are considered carcinogenic and impact birth weight.

• PFAS contain a carbon-fluorine bond, which is a very strong bond that does not naturally degrade.

• Some PFAS will naturally decrease concentration over time, but only to be transformed into other compounds that will not (often PFOS).

Regulation.

• The US EPA has taken the approach of regulating a select few PFAS, generally based on their known toxicity. PFOA and PFOS will essentially be limited to a concentration of zero.

• The US EPA has been working on this for years. Mr. Biden did not snap his fingers and make a regulation. These things move much slower than that, and the industry generally feels that this process moved too quickly because there is limited understanding of how much PFAS exists in drinking water.

• Health Canada has proposed a guideline which limits PFAS to 30 ng/L (ppt) as a total sum of all compounds that can be accurately measured. Currently their guidelines limit PFOA to 200 ng/L and PFOS to 600 ng/L. Health Canada does not regulate your water provider through, that is up to your provincial/territorial government, which may have different guidelines than this.

PFAS in the environment.

• PFAS is ubiquitous in the environment due to its travel through the water cycle. It exists in Antarctic ice and on top of Mount Everest.

• Usually the largest sources of PFAS in drinking water are firefighting training areas that used PFAS containing foams (airports and military bases), landfills, certain manufacturers (metal plating, paper, semiconductors), and municipal wastewater. There are many more sources than this though.

• Landfills and municipal wastewater tend to be the highest mass loading of PFAS because of the ubiquity of PFAS in consumer products.

Treatment.

• PFAS can be destroyed using electrochemical and thermal methods, but these are not feasible for drinking water treatment.

• The current approach for drinking water treatment is adsorption to either granular activated carbon (GAC) or ion exchange resin.

• Treating PFAS at the source is always the goal instead of treating it at a water treatment plant.

Feel free to ask questions, I will do my best to answer them!

They have settled several lawsuits already and there are more to come. It will never be enough, but it is inaccurate to say that they haven’t paid.

Math using janky excel spreadsheets, tell drafters what we want drawings to look like, but mostly a lot of reading and writing. The secret to engineering (at least in my area) is that communication skills are just as important as technical understanding.