Looks like I figured out the second part of my question (importing the CSV as an array). Posting example code below:
#let results = csv("sampleCSV.csv",
row-type: array)
#figure(
table(
// columns: 4,
table.header([Node], [Voltage Level $ k V^2 $]),
columns : 2,
fill: (_, y) => if y == 0 {
gray.lighten(75%)
},
// ..results.flatten(),
..for(node,_,pFaults,..) in results.slice(1){(node, pFaults)}) //this is where I am selective in picking the 1st column and 3rd column for view
)
,
caption: [Dummy results from a CSV file ],
) <results_A01>