In this assignment you will need write a Rscript using the datasets.

Background: Industrial construction is a construction method that involves large-scale use of offsite prefabrication and preassembly for building facilities, such as oil or gas production facilities and petroleum refineries. Pipe spool fabrication is crucial for the successful delivery of industrial projects. Pipe spool fabrication is heavily dependent on welding, which must be sampled and inspected to ensure that welding quality requirements are met. In practice, a pipe is generally specified by three parameters respectively: Nominal Pipe Size (NPS), Pipe Schedule, and Material. NPS defines a pipe's outside diameter, Pipe Schedule defines pipe wall thickness, and Materials are categorized into Material A - Plain Carbon Steel, Material B - Alloy Steel, Material C - Stainless Steel, and Material D - Others. Inspection results to welds are recorded as 0 - no inspection performed; 1- inspected and passed; and 2 - inspected and failed. Data Explanation In this assignment, three CSV files are provided to represent the design information, inspection information, and projects information, see Table A, B, and C below. In this assignment, you will learn how to manipulate these various data sources and how to derive the quality performance of each weld type to support prefabrication quality control processes. Tables